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’ and other metrics 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”

Google Ads Script – Automated GPT Keyword Suggestions

Script : Automated GPT Keyword Suggestions

What it does:
The script automates Keyword Research for your account.
It prompts Chat GPT to suggest new relevant keywords based on the top converting keywords in your account.
It will only suggest keywords that are not already in your account and adds them to a Google Sheet. The link to sheet is sent to your email.

The output will look something like this:

Google Ads Script - Automated KWR via GPT

Why you care:
Adding new relevant keywords to your account is one of the best ways to grow performance. Thorough keyword research will give you these keywords, BUT it is very time-consuming and  feels like being in a desert, with your motivation evaporating under the scorching sun.  Having this task automated for you is like a thirst-quenching oasis.

Happy scripting!

WANT TO AUTOMATICALLY GET NEW & RELEVANT KEYWORDS IN YOUR INBOX?

👉👉 Click here to get early bird access to the script!