You’re Doing PPC Ad Tests Wrong – This Script Will Help

Ad trying out maybe a time-ingesting part of the PPC optimization manner, so it’s a great area to deal with a Google Ads script.

In this post, I’m sharing a script that allows with the tedious challenge of making quick facts about what historical advert texts have adequately worked and can be well worth deploying in other advert groups.

What is a PPC Landing Page? (With 4 AdWords Examples)

The script splits all commercials into their issue parts like headlines and descriptions and totals up the metrics across the account.

If this script’s idea sounds familiar, it’s because I’ve shared other iterations within the beyond; however, this one is exceptional.

I first created this script for Optmyzr’s scripts library and later shared a version of it referred to as the Ad Component Report on Github.

So what’s distinct now, and why is that this trendy model really worth a glance?

Well, I made a big trade to the code that addresses a problem I’ve started out listening to more about recently…
Why A/B Ad Testing Is Flawed

The problem with advert trying out is that advertisers may believe it’s within the advert that influences overall performance.

But as Martin Roettgerding lately mentioned, an A/B advert takes a look at won’t be dependable because the difference in textual content among advert variations is merely one of the many variable factors of an experiment.

The different component that’s changing is the auctions in which the ad is being proven. And in private sales, the users are individual, the time of day is distinct, the tool is one-of-a-kind, and so on.

In truth, there are so many variables in play that it’s no longer fair to point at advert textual content differences because of the specific motive why A/B ad exams produce winners and losers.

Mike Rhodes, the founder of AgencySavvy, recently informed me that approximately a shocking advert take a look at he ran. Rather than doing an A/B check with variations of an ad, he ran an A/An inspection in which two advertisements contained precisely the same text.

Logic would dictate that there ought to have been no winner and loser on this test, but he discovered that ad A received an advert A lost.

The exact identical ad each gained and lost the experiment!

There couldn’t be an additional clear instance to highlight that there’s extra than directly the ad textual content that influences how assessments move.
Segment Ad Data for Proper Experiments

The manner to solve this trouble is to cast off as many of the variables as possible when studying advert overall performance statistics.

By analyzing advertisements from one ad group at a time, or even one exact fit keyword at a time, you take away many of the variety associated with variations in queries.

By including segments for devices, days of the week, and ad slot, you can start to indeed get all the way down to specific eventualities where you’ve got as near as viable to an apples-to-apples comparison of the overall performance of different advert texts.

When exceptional advertisements are shown in scenarios that intently resemble one another, you can begin to factor in the posters as the primary driver of differences in overall performance.
Data Sparsity When Segmenting Ads Data

The more we section the facts, the greater granular the statistics become, and the harder it’s to discover a statistically sizable winner.

You can strive for one of the many statistical significance calculators to be had online (like this one) to look at how a lower metric makes it tougher to find a significant winner.

Trading Off Volume & Similarity of Data

So we ought to make tradeoffs and determine how to balance having sufficient statistics with having it come from comparable auctions. This is wherein the script is available.

Previous iterations of it did not note segments. While it would have plenty of data for metrics, that facts came from every viable situation in which the advert ran.

In other phrases, within the alternate-off I described, it preferred masses of information over getting information from comparable scenarios.

If you use this script, you could get more statistics using many campaigns while limiting the records to a chosen phase. Now with the output of the text, it’s possible to run a few interesting comparisons.

How to Use the Segmented Ad Component Report

Here’s an example of the way to use the report that the script generates.

Say that you locate there may be a huge difference in ad headline performance on mobile and desktop devices. That can be a sign that it may be really worth the attempt to break up up campaigns so you can run amazing ones for distinctive devices.

You ought to use device bid modifications, but that doesn’t have the funds for you a great deal of flexibility in various the message you display to particular users depending on their tool.

When searching at variations in performance, attention primarily on ratio metrics like CTR and conversion fee.

There may be considerable variations in effect ranges; however, that can be because of the reality that an extraordinary extent of searches shows up on exceptional gadgets or that Google is already doing an excellent activity displaying the right advertisements relying on the consumer’s tool.

What matters greater is that the ratio of clicks over impressions (CTR) is as high as viable regardless of the tool.

Again, Google might agree to a perfect activity showing the advert version with a higher chance of getting a good CTR on every tool. Still, if you discover that there are winners for unique gadgets, it can be time to mix things up with segmented campaigns.
The Script

This script has a handful of configurations:

Current setting.SpreadsheetUrl

Use this to enter the URL of the Google Sheet that must obtain the facts. Or add the textual content “NEW” to generate a new spreadsheet robotically whenever the script runs.


Enter the date range for the statistics, e.G., “LAST_30_DAYS”, “LAST_MONTH,” “20180101,20181231.”
Current setting.AccountManagers

A comma-separated listing of Google usernames of all the folks who must have permission to work with the document in Google Sheets.


A comma-separated listing of e-mail addresses which must get an e-mail when a brand new report is ready.

Enter a string of text that has to be the gift in the marketing campaign names whose facts need to be covered in the record.


This is the brand new placing that tells the script what extra columns of facts to add for special segments.

Choose from any section this is to be had for the AD_PERFORMANCE_REPORT from the Google Ads API, e.G., ”Device,” “DayOfWeek,” or “Slot.”


I have been working in the field of SEO and content marketing since 2014. I have worked with over 500 clients and more than 100 websites. I started blogging in 2012 and have now made my first steps into the world of freelancing. In my spare time, I like to read, cook or listen to music.