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.