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 corresponding to:
- Figuring out URL errors,
- Discovering destructive key phrase conflicts,
- Notifying when an account receives no impressions in a sure interval.
Scripts release time for account technique and significant 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 simple for one consumer 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 entire 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 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 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 adverts in Efficiency Max campaigns. It does now however requires customers to dig by means of the Insights report. “Efficiency Max Search Phrases and Classes” supplies this information 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 go away the sector 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 supplies essentially the most complete Efficiency Max information, exhibiting:
- Proportion 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 Insights studies the spend proportion by Purchasing, 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 supplies transparency. For instance, a retailer with a product feed ought to count on extra Purchasing adverts. If the spend proportion for Purchasing is excessive, the marketing campaign works as meant. 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 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 can even alert if no RSA is current as a consequence of Google rejecting an advert.
What to customise.
- CHECKPAUSEDCAMPAIGNS. Set to “true” to verify paused campaigns for RSAs.
- CHECKPAUSEDADGROUPS. Set to “true” to verify paused advert teams for RSAs.
- CHECKPAUSEDADS. Set to “true” to verify 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.