Mini Checker Script

Everyone makes mistakes! With the average Google Ads account typically containing tens of thousands of keywords and an assortment of settings applied at multiple levels, there’s always a possibility that you’ve overlooked something small… or something big.

Whether it’s pushing bids too far, being overly eager in your device modifiers, or forgetting to apply location targeting, mistakes can be pretty expensive. Worldwide targeting, for one, can quickly sap your budget as you serve ads in territories of no benefit to you.

Thats why when it comes to checking your accounts for errors it’s better leaving it to the robots, or in this case, the Mini Checker script. Plug in your upper limits and tell it where you’d like it to look, and it will email you a report detailing anything in your account that isn’t right.

What’s included?

How does the script work?

The script checks user-specified settings in your account, making sure you’ve not pushed any settings further than you would like.

It runs three separate checks:

  1. Worldwide Targeting Checker: the script will flag any campaigns that don’t have any location targeting applied.
  2. Keyword Bid Upper Limit Checker: specify a max CPC limit, and the script will report any keywords which have bids set higher than that CPC.
  3. Bid Modifier Upper Limit Checker: this will check for any troublesome bid modifiers for location, device, and ad scheduling to ensure you are not pushing bids too high.

These ensure that you have a quick and easy way to root out any mistakes or oversights leading to inefficiency, over-aggressive bidding, and ultimately to budget wastage.

It can perform these checks within your entire account or specific campaigns (e.g. checking Brand campaigns only). You can also include or exclude paused campaigns and keywords as required.

Once the script has run, it will email you an HTML table report, flagging anything which violates the rules you have fed it.

How do I use it?

You can paste the code below directly into the Google Ads interface to be run on an ad hoc basis.

In the Google Ads account where you’d like the script to run, go to Tools & Settings > Bulk Actions > Scripts. Create a new script by pressing the blue plus button.

Once you’ve given the script authorization to read your account, copy and paste all of the code below into the input box. You will then need to modify the code by adding your specific criteria.

First, ensure you have added the email you would like the report to be sent to in the EMAIL_ADDRESS variable.

If you’re worried about excessive bids, ensure you set your max CPC by modifying the BID_UPPER_LIMIT. Keywords with a higher CPC than that figure will then be listed in the report.

You can also set your bid modifier limits. If, for example, you would like to be notified of any bid modifiers over 150%, you would set it to 1.5. This should be in the range of 0.1 (-90%) to 9.0 (+900%). These limits can be set for device, ad scheduling and location separately.

Use CAMPAIGN_NAME_DOES_NOT_CONTAINCAMPAIGN_NAME_CONTAIN, and IGNORE_PAUSED_CAMPAIGNS to specify which campaigns you would like to investigate. Depending on the size (and state!) of your account, you will need to be selective with the criteria you choose. If you were to request a report on all keywords with a Max CPC of more than 10p, for example, you’d probably be pulling your entire account. While the script will run in such cases, you may not be able to receive email reports for such an enormous quantity of data.

Once you have pasted the code and set your criteria, save and run the script. Note: at this point you may need to scroll to the bottom of the page and reauthorize email permissions.

And, you’re set! Your report will arrive as an HTML table via email. From there you can troubleshoot any bids, modifiers, or targeting that looks inappropriate for your account.

The Mini Checker Script code