How to Run an Effective Ad Test Analysis

Next up in our Ad Words Reporting 101 series: How to Run an Effective Ad Test Analysis! This is an extremely useful report that will tell you a lot about general performance, but more importantly about the performance of individual headlines, descriptions, and their combinations. Let’s dive in!

Why?

INFORM. Keep clients up to date on how their ads are performing.

DECIDE. Make decisions about which ads are most successful and which ads are least successful and should be paused.

OPTIMIZE. Ultimately, as certain ads are paused, optimize account performance.

How?

1. Download an ad report off Google Ads

2. Create a pivot table that sums impressions, clicks, cost, and conversions by ad.

3. Calculate CTR, CPC, CVR, and CPA for each ad and conditionally format these fields

4. Identify best and worst performing ads

Skills

1. Excel concatenate function

2. Excel text to column feature

3. Excel calculation functions

4. Create a pivot table in Excel

5. Conditional and number formatting in excel

6. Find and replace tool in Excel

1. Download an ad report off Google Ads


In Google Ads, click under the account you are working with and then hit the “ads & extensions” tab in the left bar:

Recent Articles

How to Run a Device Analysis

Next up on our Ad Words Reporting 101 series: Device Analysis! These reports can be handy when...

How to Perform a Sitelinks Extension Analysis

Today we’re covering an important part of our Ad Words Reporting 101 series: How to Perform a...

How to Perform a Callout Extension Analysis

Today we’re covering an important part of our Ad Words Reporting 101 series: How to Perform a...