• Search Engine Land
  • Sections
    • SEO
    • SEM
    • Local
    • Retail
    • Google
    • Bing
    • Social
    • Resources
    • More
    • Home
  • Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • Live
  • More
  • Events
  • SUBSCRIBE

Search Engine Land

Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • More
  • Newsletters
  • Home
SEM

Are small errors like worldwide targeting draining your budget? This Google Ads script can help

The script emails you a customized report to flag issues with your chosen account settings, preventing potential Google Ads catastrophes.

Daniel Gilbert on October 11, 2019 at 12:13 pm
  • More

Human beings aren’t robots. With thousands upon thousands of keywords to keep track of and an assortment of settings to apply on multiple levels of your account, 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.

But manually checking these settings can be incredibly time-consuming. What do we say to all things tedious? The answer is always scripts.

This one will do all the legwork for you. 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. Perhaps you’ve not applied location targeting to a certain campaign? Or you’re bidding way above what you’d like for a selection of your keywords?

It’s great to run for general upkeep, but is especially helpful after a big campaign build or when you’ve made sweeping changes in your account and need some extra peace of mind.

What does it do?

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 to use this script

You can paste the script 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_CONTAIN, CAMPAIGN_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.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.



About The Author

Daniel Gilbert
Daniel Gilbert is the CEO at Brainlabs, the best paid media agency in the world (self-declared). He has started and invested in a number of big data and technology startups since leaving Google in 2010.

Related Topics

Channel: SEMGoogle: Ads ScriptsPaid Search Column

We're listening.

Have something to say about this article? Share it with us on Facebook, Twitter or our LinkedIn Group.

Get the daily newsletter search marketers rely on.

Processing...Please wait.

See terms.

ATTEND OUR EVENTS

Lorem ipsum doler this is promo text about SMX events.

April 13, 2021: SMX Create

May 18-19, 2021: SMX London

June 8-9, 2021: SMX Paris

June 15-16, 2021: SMX Advanced

June 21-22, 2021: SMX Advanced Europe

August 17, 2021: SMX Convert

November 9-10, 2021: SMX Next

December 14, 2021: SMX Code

Available On-Demand: SMX

Available On-Demand: SMX Report

×


Learn More About Our SMX Events

Discover actionable tactics that can help you overcome crucial marketing challenges. Our next conference will be held:

Next Event: Sept. 14-15, 2021

Available On-Demand: March 2021

Available On-Demand: October 2020

×

Attend MarTech - Click Here


Learn More About Our MarTech Events

White Papers

  • Nielsen Annual Marketing Report: Era of Adaptation
  • Global Social Media Advertising Trends Among Retailers in 2021
  • 2020 Hispanic Market Report
  • Delivering Audio Success: Industry Trends in Streaming Audio & Podcast Performance
  • Ten Tips for Acquisition Email Success
See More Whitepapers

Webinars

  • Drive Customer Engagement with the Power of Personalization
  • 7 Use Cases That Prove Why You Should Implement DAM
  • Accelerate Your SEO & Content Marketing Program with 4 Key Milestones
See More Webinars

Research Reports

  • Local Marketing Solutions for Multi-Location Businesses
  • Enterprise Digital Asset Management Platforms
  • Identity Resolution Platforms
  • Customer Data Platforms
  • B2B Marketing Automation Platforms
  • Call Analytics Platforms
See More Research

Attend SMX For Only $149

h
Receive daily search news and analysis.

Channels

  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social

Our Events

  • SMX
  • MarTech

Resources

  • White Papers
  • Research
  • Webinars

About

  • About Us
  • Contact
  • Privacy
  • Marketing Opportunities
  • Staff

Follow Us

  • Facebook
  • Twitter
  • LinkedIn
  • Newsletters
  • RSS
  • Youtube

© 2021 Third Door Media, Inc. All rights reserved.

Your privacy means the world to us. We share your personal information only when you give us explicit permission to do so, and confirm we have your permission each time. Learn more by viewing our privacy policy.Ok