Welcome to WebmasterWorld Guest from 18.205.246.238

Forum Moderators: DixonJones & mademetop

Message Too Old, No Replies

I need some help with an analytics keyword/landing page report

     
9:31 am on Feb 29, 2016 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:July 29, 2007
posts:1823
votes: 107


Hi everyone,

I'm working on a project that includes reviving a Pandalized site and the changes are extensive enough that I suspect keywords might 'wander' from one page url to another in the process. ie: Pages that used to get traffic for a specific keyword will be replaced by other pages for that keyword. I need a report that will pull those out for me quickly but am not sure how to set it up.

What I need
- Organic/Google traffic only (I'll set up my own for other engines)
- Report by keyword
- Only keywords that have driven traffic to more than 1 page need appear
- Clicking on the keyword will display a list of pages that have received traffic for it
- Obviously all (not provided) needs to be removed

I'm able to set up most of that but not aggregate multiple pages into 1 keyword result, I end up seeing the keyword repeated each time it drives traffic to a new url. Any help in showing only keywords that have driven traffic to more than one page would be appreciated, If you can figure out how to aggregate the results so that the keyword view doesn't repeat keywords I'd be most greatfull.

P.S. This data is already available in GWT, in fact it's available there for impressions as well even if it doesn't actually result in a click from search, but having this report quickly show me where keywords are overlapping will let me know if I'm getting the results I want or if I'm messing things up.

I don't track results by keyword anymore since a page receives traffic for many but I do want to spot competing pages more quickly to make sure the right one is featured. I also want to monitor what Google considers 'related keywords' more closely moving forward.

Thanks
10:12 am on Feb 29, 2016 (gmt 0)

Senior Member from GB 

WebmasterWorld Senior Member andy_langton is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Jan 27, 2003
posts:3332
votes: 140


Do you use Excel? A Pivot table could handle this very easily.
11:00 am on Feb 29, 2016 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:July 29, 2007
posts:1823
votes: 107


No, I don't. As I said I've moved away from watching keywords on such a granular level in favor of just producing good content. I do however know that Google assigns pages to each search term and so I need to spot the search term duplicates, so to speak. I'd prefer to leave it in Analytics if possible.

- widgets - example.com/widgets
- big widgets - example.com/big-widgets
- widgets - example.com/blue-widgets

needs to become
- widgets - example.com/widgets + example.com/blue-widgets

where the keyword not appearing for more than one url is ignored and the keyword(s) that have sent traffic to more than one page have each page displayed under the one keyword. Can this be done inside analytics? It's the type of report that, hopefully, produces zero results over time which is why I don't want to be exporting anything for manual verification. I just need a heads up if keywords begin wandering.
2:22 pm on Feb 29, 2016 (gmt 0)

Senior Member from GB 

WebmasterWorld Senior Member andy_langton is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Jan 27, 2003
posts:3332
votes: 140


You won't be able to do this purely with the Google interface - it's just not the way the dimension reports are displayed. Your options are to export/process the data, or use the Analytics API to build your own report.
3:23 am on Mar 1, 2016 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:July 29, 2007
posts:1823
votes: 107


... which explains why I could only *almost* get what I wanted(couldn't make it merge into one keyword). Thanks for the confirmation.