star_border
Reply
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Printer Friendly Page
Singling out ad copies on excel
Visitor ✭ ✭ ✭
August 2015
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Abuse
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 ✭ ✭ ☆
August 2015
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Abuse
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
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