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”

Google Ads Script Review – Quality Score Dashboard

Quality Score Dashboard

What it does:
This Google Ads script provides a dashboard that displays a Quality Score chart and summary.
It will show the ‘Share of impressions’ and ‘Share of keywords’ per Quality Score.
The dashboard lets you drill down to accounts, campaigns, and ad groups. The bar chart and summary will show the data for your selection.

Continue reading “Google Ads Script Review – Quality Score Dashboard”