Search Engine Land
  • SEO
    • > All SEO
    • > What Is SEO?
    • > SEO Periodic Table
    • > Google: SEO
    • > Bing SEO
    • > Google Algorithm Updates
  • PPC
    • > All PPC
    • > What is PPC?
    • > Google Ads
    • > Microsoft Ads
    • > The Periodic Tables of PPC
  • Focuses
    • > Local
    • > Commerce
    • > Shopify SEO Guide
    • > Content
    • > Email Marketing Periodic Table
    • > Social Media Marketing
    • > Analytics
    • > Search Engine Land Awards
    • > All Focuses
  • SMX
  • Webinars
  • Intelligence Reports
  • White Papers
  • About
    • > About Search Engine Land
    • > Newsletter
    • > Third Door Media
    • > Advertise

Processing...Please wait.

Search Engine Land » Google » Google Ads » Track your ad tests at scale with this advanced AdWords script

Track your ad tests at scale with this advanced AdWords script

Here's a script to allow you to quickly see a topline summary of all split tests running within your account.

Wesley Parker on June 5, 2019 at 2:24 pm

Keeping track of when your ad tests have enough data to be concluded can be a real challenge when you may have dozens of different ad tests running within an account.

The most common way to split test revolves around labeling sets of ad copies “Ad copy 1” and “Ad copy 2” and using the dimensions tab to see the aggregate performance of each set of ads.

The problem here is that you have to check your dimensions tab regularly to see when a test has enough data to conclude.

It’s also easy to lose track of which labels are being tested against each other. You’ll sometimes find yourself wondering whether ad copy 50 is being tested against ad copy 49 or 51?

So the developers at my agency have built this script to allow you to see quickly a top line summary of all of the split tests that are running within your account.

It also allows you to quickly determine when an ad test has finished, even if you’re running hundreds of tests at a time.

Better still, it will notify you of the completion, so you can go into your account and create a new ad copy.

How the script works

The script works by users designing experiments within an input sheet on Google Sheets.

Here you tell the program when the test will start and which labels will be compared. For example, “Ad copy 1” and “Ad copy 2.”

The script will then pull the data for the labels that you have selected for that time range and will then show you how the ad test is performing as you will see below. This is pulled into an output sheet on the same Google Sheets document.

It will also run daily and email you once a test has enough data to conclude a test.

Setting up the script

To get the script to run, there are a few things that you need to do first:

  1. Go to this link here and create a copy of my experiments studio dashboard sheet.
  2. Paste the link to the dashboard into line 17 of the script.
  3. On line 20, select the metric which you want to split test by. This can take either CTR, CvR or CvR*.
  4. On line 23, select the statistical significance threshold that you want to test towards. This can take the following values (0.90, 0.95 or 0.99).
  5. On line 27, enter the currency that your account runs in (e.g., “£”)
  6. On line 31, enter the email address that you want to receive notifications daily to tell you which ad tests have finished.

Setting up the studio sheet

Once you have set up the script within Google Ads, you will need to configure the studio Google Sheet. Here is what you need to do to create a new experiment.

  1. Within the input tab give your experiment a name, for example “CTA test.”
  2. Set the start date for each experiment to the day that the experiment started on.
  3. In the compare labels column, select two labels that you want to compare with a comma between them (e.g. “label 1,label2”).
  4. Name the sheet that you want your tests to be displayed on. The script will then automatically generate these tabs.
  5. If you only want to include certain conversions you can use the custom conversions tab to select the conversions that you want to include.
  6. In the output template, you can select which metrics you want to either include or exclude. If you change these you will need to delete the tabs with the experiments in and then re-run the script within Google Ads.
  7. You should then set the script to run daily so it can work out when the test has been completed.

Script


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


New on Search Engine Land

    The latest jobs in search marketing
    3 content marketing strategies to support SEO success
    Google Analytics 4 guide for PPC
    SEO reporting to impress: How to successfully report your SEO process, efforts and result
    9 ways to become an SEO problem-solver

About The Author

Wesley Parker
Wesley is managing director at Clicteq. He currently manages a $4M-plus Google Ads portfolio across a range of different sectors. He regularly writes in leading marketing publications such as Econsultancy and Campaign Magazine.

Related Topics

Google AdsPPC

Get the daily newsletter search marketers rely on.

Processing...Please wait.

See terms.

ATTEND OUR EVENTS The SMX Conference logo.

Learn actionable search marketing tactics that can help you drive more traffic, leads, and revenue.

March 8-9, 2022: Master Classes (virtual)

June 14-15, 2022: SMX Advanced (virtual)

November 15-16, 2022: SMX Next (virtual)

Learn More About Our SMX Events

The MarTech Conference logo.

Discover time-saving technologies and actionable tactics that can help you overcome crucial marketing challenges.

Start Discovering Now: Spring (virtual)

September 28-29, 2022: Fall (virtual)

Learn More About Our MarTech Events
Webinars

Benchmark Your Social Media Performance For a Competitive Edge

Take a Crawl, Walk, Run Approach to Multi-Channel ABM

Content Comes First: Transform Your Operations With DAM

See More Webinars
Intelligence Reports

Enterprise SEO Platforms: A Marketer’s Guide

Enterprise Identity Resolution Platforms

Email Marketing Platforms: A Marketer’s Guide

Enterprise Sales Enablement Platforms: A Marketer’s Guide

Enterprise Digital Experience Platforms: A Marketer’s Guide

Enterprise Call Analytics Platforms: A Marketer’s Guide

See More Intelligence Reports
White Papers

How to use AI to make your PR more human

The State of Influencer Pricing

How to Measure Influencer Performance

Reputation Management For Healthcare Organizations

Unlock the App Marketing Potential of QR Codes

See More Whitepapers

Receive daily search news and analysis.

Processing...Please wait.

Topics

  • SEO
  • PPC

Our Events

  • Search Marketing Expo - SMX
  • MarTech

About

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

Follow Us

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

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