Singling out ad copies on excel

[#1]

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

[#2]

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