I’ve twice addressed my fondness for Google Advertisements scripts for automating on a regular basis duties. Scripts are code snippets that work behind the scenes for features similar to:
- Figuring out URL errors,
- Discovering destructive key phrase conflicts,
- Notifying when an account receives no impressions in a sure interval.
Scripts liberate time for account technique and important optimizations. Listed below are 4 extra of my go-to scripts.
Change Historical past Alerts
What it does. Regularly a number of customers have entry to a single Google Advertisements account. It’s straightforward for one person to overlook tweaks by one other, requiring fixed critiques 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 person. I run the script day by 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 record makes a change.
- EMAIL_SUBJECT. Hold the default topic line within the notification or replace it.
- EMAIL_BODY. Hold the default physique message within the notification or replace it.
- PERIOD. The default setting is “yesterday” for day by 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 adverts in Efficiency Max campaigns. It does now however requires customers to dig by way of the Insights report. “Efficiency Max Search Phrases and Classes” gives this data in an easy-to-read Google Sheet to then phase, filter, and format. Add queries that convert properly as key phrases in search campaigns. Request as destructive 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 a better 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 info 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 gives probably the most complete Efficiency Max information, exhibiting:
- Share of spend by channel (Buying, Video, Show, and Search/Different),
- Price and conversion metrics by marketing campaign and community,
- Efficiency by asset group.
Efficiency Max Insights experiences the spend proportion by Buying, Video, Show, and Search/Different. Click on picture to enlarge.
Efficiency Max advertisers have little management over the place adverts seem and the included merchandise, however this script gives transparency. For instance, a retailer with a product feed ought to count on extra Buying adverts. If the spend proportion for Buying 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 lively responsive search adverts. Google classifies all newly created adverts as RSAs. This script was extra impactful throughout the transition of expanded textual content adverts 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 will even alert if no RSA is current on account of Google rejecting an advert.
What to customise.
- CHECKPAUSEDCAMPAIGNS. Set to “true” to examine paused campaigns for RSAs.
- CHECKPAUSEDADGROUPS. Set to “true” to examine paused advert teams for RSAs.
- CHECKPAUSEDADS. Set to “true” to examine paused adverts 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.
