<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=31884&amp;fmt=gif">

Request a call

or call us at 801.341.1986

Account Anomaly Detector Just Got Better with Conversions

The AdWords Account Anomaly Detector is one of the most useful pre-written scripts AdWords has to offer. Now, it just got more useful with conversions.

Like many of you, we have found scripts to be very helpful. Scripts automate processes in AdWords using JavaScript code. If coded right, you can automate any manual task using scripts. This is particularly useful for tedious tasks like bidding, labeling, or adjusting budgets.

The biggest barrier to using scripts is the coding knowledge to build and customize them to your needs. Fortunately for those non-coders out there, AdWords has created a series of prebuilt ready-to-use scripts. One of our favorites is the Account Anomaly Detector.

What is the Account Anomaly Detector?

Account Anomaly Detector alerts the advertiser whenever an AdWords account is suddenly behaving too differently from what's historically observed.

This script will look at historical data by day to determine if your account is behaving differently than the current day. If your account exceeds a predetermined threshold that you set, it will alert you via email. You are able to set the alert threshold for each metric, the weeks of historical data the script will observe, and how often the script will run. This script is only set up to compare impressions, clicks, and cost. We decided to add conversions and here’s why.

Why Should We Include Conversions?

This should be a no-brainer. Most likely conversions are the biggest indicator of your success and are probably the biggest reasons you are using AdWords anyway. But, you might say, “Conversions correlate to impressions, clicks, and cost. If one of these metrics goes crazy, I’ll get an alert and fix it. Conversions are safe when I know these metrics are on par.” Wrong!

We have a client whose campaign was running beautifully. No problems, no alerts. Then one day we realized conversions were flatlining. There was no pulse. Yet, everything else was running just fine including impressions, clicks, and spend. Turns out their developer removed the conversion tracking pixel unknowingly. Conversions stopped dead.

This led us to rethink this script. Crazy things can happen when you are running CPA or ROAS bid strategies when conversions aren’t tracking. Luckily we caught it early enough, but we wish we could have caught it right away.





So Here It Is

Account Anomaly Detector with Conversions template spreadsheet and script.

  • Copy this spreadsheet into your AdWords linked Google Drive account
  • Don’t forget to update the SPREADSHEET_URL in code – highlighted in green
  • We schedule our script to run daily
  • We also didn’t like how the script used the account ID as the name for the email alert (no one memorizes this) – so in the script we highlighted this section in green if you would like to change it
  • For your convenience and learning we also highlighted the conversions details in yellow
  • Don’t forget to delete the alerting cell after you receive an alert… or else you won’t get another one for that metric

For more information about this script’s features and how to implement it, see AdWord’s Account Anomaly Detector.


Scripts are a fantastic way to help you automate your account. They can remove tedious tasks, send you reports, or alert you when something goes wrong. The Account Anomaly Detector script by AdWords is a great pre-written alert tool, but with a little customization we have made it even better by including conversions.

Tyler Girsberger

Tyler is a PPC Specialist at 97th Floor.

You might also be interested in

Choosing The Right Paid Media Mix in a Digital World

read more

Retargeting Based on Intent

read more

Saying Goodbye to Google AdWords and Saying Hello to Five of Google Ads Best New Features

read more

Mastermind Conference

Watch the full 2019 Mastermind conference.

watch the keynotes