I’ve twice addressed my fondness for Google Adverts scripts for automating on a regular basis duties. Scripts are code snippets that work behind the scenes for features equivalent to:
- Figuring out URL errors,
- Discovering damaging key phrase conflicts,
- Notifying when an account receives no impressions in a sure interval.
Scripts liberate time for account technique and significant optimizations. Listed here are 4 extra of my go-to scripts.
Change Historical past Alerts
What it does. Incessantly a number of customers have entry to a single Google Adverts account. It’s straightforward for one consumer to overlook tweaks by one other, requiring fixed evaluations of change historical past. For instance, somebody might alter a setting or pause a key phrase, affecting your complete account. “Change Historical past Alerts” exhibits the change, the date, and the consumer. I run the script each day.
What to customise.
- SPREADSHEET_URL. Create a Google Sheet and paste its URL.
- EMAIL_ADDRESSES. Add the e-mail addresses (comma separated) of the report recipients.
- IGNORE_USERS. Add the e-mail addresses of customers whose adjustments don’t require reporting.
- SEND_EMAIL. Set as “true” to obtain an alert when somebody not on the ignored customers checklist makes a change.
- EMAIL_SUBJECT. Preserve the default topic line within the notification or replace it.
- EMAIL_BODY. Preserve the default physique message within the notification or replace it.
- PERIOD. The default setting is “yesterday” for each day runs. Change it as wanted.
The script. Copy the “Change Historical past Alerts” script.
—
Efficiency Max Search Phrases and Classes
What it does. For years Google didn’t share search queries that triggered advertisements in Efficiency Max campaigns. It does now however requires customers to dig by the Insights report. “Efficiency Max Search Phrases and Classes” offers this data in an easy-to-read Google Sheet to then section, filter, and format. Add queries that convert effectively as key phrases in search campaigns. Request as damaging key phrases queries with many clicks however few conversions.
What to customise.
- MINIMP. The minimal impressions for together with a search time period or class. Bigger accounts require the next threshold to keep away from entities with little exercise. The script defaults to 10 impressions.
- SPREADSHEET_URL. Create a Google Sheet and paste its URL, or depart the sphere clean and the script will generate a brand new spreadsheet each time it runs.
- REPORTLASTNDAYS. The information lookback window. The default is 30 days.
The script. Copy the “Pmax Search Phrases and Classes” script.
—
Efficiency Max Insights
What it does. This script offers essentially the most complete Efficiency Max information, displaying:
- Share of spend by channel (Purchasing, Video, Show, and Search/Different),
- Price and conversion metrics by marketing campaign and community,
- Efficiency by asset group.
Efficiency Max advertisers have little management over the place advertisements seem and the included merchandise, however this script offers transparency. For instance, a retailer with a product feed ought to anticipate extra Purchasing advertisements. If the spend share for Purchasing is excessive, the marketing campaign works as supposed. If half goes to Show and isn’t changing, advertisers ought to reevaluate Efficiency Max.
What to customise.
The script default to the final 30 days. The paid model permits for longer date ranges.
The script. Obtain the “Efficiency Max insights” script.
—
RSA Checker
What it does. “RSA Checker” finds advert teams with out energetic responsive search advertisements. Google classifies all newly created advertisements as RSAs. This script was extra impactful throughout the transition of expanded textual content advertisements to RSAs, but it nonetheless has worth. I’ll run this script weekly on new accounts to determine advert teams that haven’t transitioned to RSAs. The script can even alert if no RSA is current attributable to Google rejecting an advert.
What to customise.
- CHECKPAUSEDCAMPAIGNS. Set to “true” to test paused campaigns for RSAs.
- CHECKPAUSEDADGROUPS. Set to “true” to test paused advert teams for RSAs.
- CHECKPAUSEDADS. Set to “true” to test paused advertisements for RSAs.
- ALERTONNEWENTITIESONLY. Set to “false” to obtain emails solely when new advert teams haven’t any RSAs.
- RECIPIENTEMAILS. Add the e-mail deal with(es) of recipients.
- LABELNAME. The label assigned to advert teams with out RSAs. The default is “no_rsa_present.”
The script. Get the “RSA Checker” script.