Forum Moderators: DixonJones

Message Too Old, No Replies

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

         

JS_Harris

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

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



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

Andy Langton

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

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



Do you use Excel? A Pivot table could handle this very easily.

JS_Harris

11:00 am on Feb 29, 2016 (gmt 0)

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



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.

Andy Langton

2:22 pm on Feb 29, 2016 (gmt 0)

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



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.

JS_Harris

3:23 am on Mar 1, 2016 (gmt 0)

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



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