facebookIcon tracking


AdWords for Video Workaround – How to Analyze Targeting

Published: January 10, 2014

Author: Vim Chand

In AdWords for Video campaigns, there is a lot of data to look through: impressions, clicks, video played-through rates, etc.  There are also a few ways to segment: format, network, targeting, etc. It’s fine looking at all this data in the UI, but it doesn’t really do much good until you can make sense of it.
So what’s the easiest way to do this? Excel and Pivot Tables! However, we run into an issue of blank cells when we download it as a segmented report.  Located below are 2 report examples and what they look like in the UI. (It takes two seconds to see that it’s very hard to analyze targeting.)
UI (Non-Segmented):

 UI (Non-Segmented)

Data (Non-Segmented – Can easily be put in pivot table and analyzed):

Data (Non-Segmented)

UI (Segmented):
UI Segmented
Data (Segmented Report – When you Pivot it by video, you can’t see targeting because it’s all blank!):
Data (Segmented Report)

Blank Rows for Targeting!!

Pivot Table (which video did the targets go with?):
Pivot Table
Okay, we’ve identified a gap here. So what can you do if you need to see which targeting was most effective for a particular video ad? I’ll show you my method for manipulating the data.
After downloading data, select your data set, press F5, click “Special”, select “Blanks”, hit “OK”, press “=”, select the row above and then press “CTRL + Enter”. This will populate the blank rows with data directly above it.  (A much more detailed walkthrough can be found here.)
Visualization of steps:
Select Data
Select Data
Press F5 and click “Special”
Select “Blanks” and click “OK”
“=” and select cell above
cell above
Then “CTRL + Enter”.  Your rows are now populated and can be pivoted!
Populated rows
I like to copy all the cells, then paste as values just because I don’t want the data to change for unexpected reasons.  It’s entirely optional though.
Afterwards you can pivot your data and actually see how certain videos performed in different targets.
Video Performance
Although this works great, there are a couple of drawbacks.  Because the “Ad” column contains both the ad name as well as the targeting, both will show up in your pivot table.  You’ll need to hide the “ad name” so that you aren’t double-counting.  Additionally, AdWords doesn’t give the “Unique Views” metric at the target level.  If you need “Unique Views,” then you can only have it with the ad name and with the targets hidden.
Double CountingBut other than those 2 drawbacks, this method works pretty well.
Have you discovered any other workarounds for AdWords for Video reporting?

1 S Wacker Drive
Suite 2250

Chicago, IL 60606(650) 539-4124


Want to become a client?

Contact Us decorative arrow

Want to join the team?

View Our Openings decorative arrow

Find us on social media.

Press inquiries.

Email Us decorative arrow

Expert insights for your inbox. Subscribe to our content.

Accept No Limits.