AdWords
5.3K members online now
5.3K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me
star_border
Reply

Singling out ad copies on excel

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

I am working with a large list of Ad copies.  Right now I am trying to figure out the specific average of conversion rates that follow the following structure;

 

Headline

[brand_xyz]® Shop

Description Line 1

Get low prices now

Description Line 2

Great Selection and low costs

Display Url

www.[brand_display_url_lowercase].xyz.com

 

The content changes within the ads, however, the above stays the same.  How can I single out these particular elements within an entire sheet of ad copies?

 

Thanks,

 

Ian

Re: Singling out ad copies on excel

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆
Hi Ian,

You should create pivot tables to look at different elements of the ad. Pivot tables will summarize all of the data for a particular element in your Excel spreadsheet. They are really easy once you get the hang of it. Check out this article for some specific how-to's including a video tutorial. Hope it helps! http://www.stateofdigital.com/introduction-pivot-tables-data-analysis/

Best,
Amy