Google Ads Script – Lin Rodnitzky Ratio

“Is my account spending its budget efficiently?”

It’s a question every Google Ads advertiser should be asking every month if not every week.

Yet…answering this question is hard!

How do you know?

You could look at all the individual search terms and decide if their clicks are worth the money.

With THOUSANDS of search terms in your account, this could easily take days!

But, what if you could quickly calculate the efficiency of your Google Ads account, and summarize it in a single score?

Turns out, YOU CAN!

Just Script It!

Introducing …

GOOGLE ADS SCRIPT: Lin Rodnitzky Ratio

Continue reading “Google Ads Script – Lin Rodnitzky Ratio”

Google Ads Script – Negative Keyword Suggestions

Are you tired of endlessly sifting through your search term reports?

With Google pushing broad match like a fitness coach demanding “just one more rep”,
and match types becoming more fuzzy than my memory of high school Greek,
we are all forced to monitor our search terms like a hawk, 24/7,
and negate all those completely irrelevant keyword matches that Google throws at us.

Not doing so inevitably brings unnecessary costs and low-quality clicks.

BUT, the amount of time needed to spend on Negative Keywords these days, just to block irrelevant searches is simply ridiculous.

It can easily take HOURS per week!

Before you know it, you’re turning into a full-time bouncer for irrelevant search traffic.

Not my ideal job (especially since I hardly reach 5’8″ / 1.76m);
I needed something that could punch above my own weight to fight all that off-target traffic.

So, how about we automate this monotony marathon of discovering search terms that waste our budget?

That’s exactly what I thought when I created this script:

Continue reading “Google Ads Script – Negative Keyword Suggestions”

Google Ads Monthly Reporting Script – My Very Basic Version

I don’t do fancy reporting.

In the end, there are only 4 numbers that really matter:
1. Google Ad Spend
2. Gross Profit (from Google Ad Spend)
3. my Google Ads Management Fee
4. your Net Result ( ‘net result’ = ‘profit’ – ‘ad spend’ – ‘management fee’)

Here’s what that looks like:

And here’s how I automate that via Google Ads Scripts:

Continue reading “Google Ads Monthly Reporting Script – My Very Basic Version”

Google Ads Script Review – PMax Shopping Spend Drop Alert

What it does:
This script monitors Performance Max campaigns across multiple Google Ads accounts under an MCC. It checks if these campaigns served in Google Shopping the previous day and checks if their spend meets a specified threshold. If any campaigns do not meet these criteria, the script sends a warning via email.


Why you care:
For most advertisers running PMax campaigns, clicks from the Shopping PLAs are the main revenue driver. Spending the budget on other channels like Display and YouTube mostly tanks results. If, for some reason (*), PMax stops generating clicks from Shopping and/or starts spending much more on Display or YouTube, you want to be in the know.

(*): potential reasons for PMax dramatically shifting spend to non-Shopping channels:

Continue reading “Google Ads Script Review – PMax Shopping Spend Drop Alert”