Google Adverts scripts automate routine duties. Final fall, I shared three such scripts which are useful to me.
- Hyperlink Checker scans all account URLs and sends alerts for errors, corresponding to 404 page-not-found or 301 redirects.
- Unfavourable Key phrase Conflicts evaluations all account key phrases to detect if a unfavorable key phrase is obstructing a optimistic one. Say I bid on the precise match key phrase “free undertaking administration options,” however I’ve “free” as a unfavorable key phrase. The script will inform me that I’m not exhibiting advertisements for my optimistic key phrase.
- Overdelivery. Typically Google will spend past your day by day funds. This script pauses particular person campaigns if they’re over funds and mechanically resumes them the subsequent day.
On this put up, I’ll handle 4 further Google Adverts scripts that automate duties and save time. (All Google Adverts scripts, by the way, are written in JavaScript.)
Disapproved Adverts Alerts
What it does. No account is ideal. Typically Google will disapprove advertisements. As a substitute of manually checking every advert group or working a filter to view all disapproved advertisements, you’ll be able to arrange “Disapproved Adverts Alerts” to inform. The script, from developer-consultant Nils Rooijmans, offers an output in Google Sheets with the disapproved advertisements, together with their campaigns and advert teams, and the explanation for disapproval. I usually run the script day by day.
What to customise. This script requires solely two updates.
- SPREADSHEET_URL. Create a Google Sheet and paste its URL.
- EMAIL. Add the e-mail handle(es) of whoever ought to obtain the report. A number of emails are comma-separated.
The script. Copy the “Disapproved Adverts Alerts” script.
—
Account Down
What it does. Adverts can cease exhibiting for a number of causes, together with account suspension and invalid cost strategies. Nonetheless, accounts may be energetic with no exercise attributable to disapproved advertisements, unfavorable key phrases that block optimistic ones, incorrect dayparting settings, and extra. It’s important to know if an account has no exercise, whether or not its impressions, clicks, or price. Regardless of the metric, the “Account Down” script from Optmyzr runs hourly and sends a notification if there was no exercise throughout a delegated variety of hours.
What to customise. This script requires three updates.
- EMAIL_ADDRESS_TO_NOTIFY. Add the e-mail handle(es) of who receives the notification.
- NUM_HOURS_TO_CHECK. The variety of hours of account inactivity earlier than sending a notification. For dayparting, the worth must be increased than the chronological variety of hours. For instance, when you’ve set your advertisements to be inactive for 5 hours, this subject must be not less than six.
- METRIC_TO_CHECK. Impressions is the beneficial metric. If the account hasn’t seen any impressions within the designated variety of hours, one thing is probably going unsuitable.
The script. Obtain the “Account Down” script.
—
Trending Search Phrases
What it does. A Google Adverts account may have hundreds of recent search phrases each week. Every time period has optimization settings, corresponding to:
- Including unfavorable key phrases for irrelevant queries.
- Implementing new key phrases.
- Creating new campaigns or advert teams to assign extra funds to worthwhile phrases.
- Writing new advertisements.
The “Trending Search Phrases” script, additionally by Nils Rooijmans, identifies search phrases with not less than 50 increased or decrease impressions. Trending Search Phrases offers insights into searchers’ priorities.
What to customise.
- SPREADSHEET_URL. Create a Google Sheet and paste its URL.
- EMAIL_ADDRESSES. Add the e-mail handle(es) of who receives the notification.
- EMAIL_SUBJECT. The topic line of the e-mail that comprises the report, corresponding to “Search Phrases Tendencies for Account [X].”
The script. Copy the “Trending Search Phrases” script.
—
Geo Anomaly Detector
What it does. This day by day script, additionally from Optmyzr, compares the averages of assorted metrics — clicks, impressions, price, conversions — throughout all focused places, after which sends alerts for uncommon variances. The Google Sheets output appears to be like on the metrics for at some point and compares them to the typical of a earlier, designated variety of weeks, which customers can customise. The script may report how the metrics for yesterday (a Tuesday, say) in comparison with the earlier eight Tuesdays for a given location. The variety of weeks, the metric, and the edge may be custom-made within the script.
For instance, say Boston usually has 100 conversions on Thursdays, however the newest Thursday had solely 25. The Geo Anomaly Detector script may ship a notification of the change. Potential causes embrace a decrease funds, a brand new bidding technique, and even an exterior issue, corresponding to a vacation.
What to customise.
- LAST_N_WEEKS. The variety of earlier weeks to evaluation.
- EMAILS. The e-mail handle(es) of who ought to obtain the notification.
- MIN_CLICKS_PER_DAY. The minimal variety of day by day clicks to set off an alert.
- INC_PCT. The share change within the metric that may set off a notification.
- INC_ABS. The mixed proportion and absolute adjustments within the metric that may set off a notification.
The script. Obtain the “Geo Anomaly Detector” script.
