CAD - Campaign Anomaly Detector

A simple ad script solution that monitors accounts and campaigns for anomalies in various metrics. An anomaly is a significant increase/decrease between past and current time lengths. CAD can be scheduled to run recurringly and automatically. It will send the users emails when anomalies are caught.

The user guide contains the link to the latest spreadsheet to use!

Project owners

• [email protected]
• [email protected]
• [email protected]
• Dev:
• [email protected]

Key Components

The solution is comprised of:

1. A spreadsheet with 3 tabs:

• Welcome tab: A disclaimer, a link to the latest user guide and release notes.

2. An Ad Script - to call the google-Ads API.

CAD versions

CAD v2 (August 2023)

• Tutorial video
• Copy the spreadsheet from within the user guide.

Features

• Simplified and more interactive UI
• Three new built-in time-length comparisons:
  
  • Within Today: comparing last-hour (with data) vs. hourly average of all the hours today before it.
  
  * `Today vs. Yesterday`: Since today data is not finished, the comparison would be midnight till last data hour for both days.
  * `Today vs. daily average of past instances of same weekday as today`: Since today data is not finished, the comparison would be midnight till last data hour for every past same weekday.

• Tip: You can click on "logs" tab in G-Ads script UI. Search for the text current query and past query to see what queries were sent to the Google Ads API. In the same way you can see current results and past results for the raw responses from Google Ads API.

Differences between CAD1 and CAD2

• Interactive dropdown with pre-built options.
• Ability to monitor today (not a full day) against a few past options.
• More metrics to monitor.
• New texts and tooltips.
• Email coloring.

CAD v1 (2021) -Not supported anymore

• Tutorial video
• Copy this spreadsheet.

Features

• Allows comparing custom past and current time lengths.
• Monitor account level and/or campaign level.
• Can filter out metrics with too low (insignificant) absolute numbers.
• Various metrics.
• Define upper and lower change threshold as anomalies.

Run

1. Make a copy of the relevant spreadsheet.

• Tip: For the first few runs, try to monitor only a few entities.

  • This is for you to try out the tool.

  • The script has a 30-minute timeout, so it's better not to monitor all the entities using the same script+sheet instance.

  • Load balance it with a few script+sheet instances.

5. Open your MCC in G-Ads UI website.

• Tip: The script runs from an MCC to be able to monitor all its children. But it can monitor only non-MCC accounts and their campaigns.
  

6. Create a new script. Name it.

License

Apache Version 2.0 See LICENSE

Disclaimer

This is not an officially supported Google product. Copyright 2021 Google LLC. This solution, including any related sample code or data, is made available on an “as is,” “as available,” and “with all faults” basis, solely for illustrative purposes, and without warranty or representation of any kind. This solution is experimental, unsupported and provided solely for your convenience. Your use of it is subject to your agreements with Google, as applicable, and may constitute a beta feature as defined under those agreements. To the extent that you make any data available to Google in connection with your use of the solution, you represent and warrant that you have all necessary and appropriate rights, consents and permissions to permit Google to use and process that data. By using any portion of this solution, you acknowledge, assume and accept all risks, known and unknown, associated with its usage, including with respect to your deployment of any portion of this solution in your systems, or usage in connection with your business, if at all.