Analytics year to year comparisons when Url extensions change?
-
We manage a website which we recently changed from Drupal to Word Press. In the change, we dropped a small part of the previous URLs - the end extension - .php For example /attractions-rates.php is now
/attractions-rates with no .php. We eliminated the .php to make the URL simpler.How is it possible (and easiest) to do a year to year comparison as Google sees the pages as different? They didn't for the first 8 days (we could see both) but now the pages with the .php extension shows zeros.
The content of the page is exactly the same only the .php is different. We know we can manually go back to last year's reports and do side by side but that is time consuming. Hoping there is a filter or process we can use to gen a report? Thanks, Jim
-
Hello Jim,
I understand that comparing these two data sets can be rather frustrating, especially when you're trying to do quick comparisons across multiple data sets.
Unfortunately, there is no way to retroactively filter this data within the Google Analytics reports. But you can create a filter to handle this issue moving forward.
To do this, go to the specific view that you wish to change this data in, select the 'Filters' option and then select 'Create new Filter'. Then after naming it as you please, choose 'Custom' as your Filter Type and then select the 'Search and Replace' radial option. Under the Filter Field drop-down, select 'Request URI' and in your Search String enter '.php$' and leave the Replace String section empty. (This is a regular expression; therefore, the beginning \ escapes the '.' variable & the '$' defines that this should only happen when the string ends in '.php')
Then at the bottom of the page you should see an option to verify this filter. Do so and ensure the change being made makes your desired effect. Be sure to check that no anomalies are created through this process.Now that you have created a filter to handle this issue moving forward, the best way to handle this is to manually export the data and sort the URLs by alphabetical order, unless you are fluent in using the Google Analytics API. Then you could use the API to pull this data into Google Sheets & have it automatically clean up the data, but I would not recommend this solution if you haven't previously used the Analytics API.
While I know this is not an ideal solution, this should handle the issue moving forward.
Let me know if you have any further questions!
Regards,
Trenton
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Does adding new pages, new slugs, new URLS in a site affects rankings and visibility?
hi reader, i have decided to add new pages to my site. if i add new urls, i feel like i have to submit the sitemap again. my question is, does submitting sitemap again with new slugs or urls affects visibility is serps, if yes, how do i minimize the impact?
Web Design | | SIMON-CULL0 -
Best URL when adding an SSL certificate . . .
Our (small) company is a little late to the party on this, and we've only just realised that we're better off with an SSL certificate for our website. (Yes I know, I know, but we dropped SEO some time ago after getting severely bitten by a certain Penguin, and are only just making tentative step back to it after those intervening years, so we're running to get back up to date with these things.) This has now been implemented, but our web guy has dropped the 'www' element during the process. Our http://domain.com address has always historically been redicrected to our main http://www.domain.com address. Now our web guy has implemented the SSL cert, our website URL is appearing as https://domain.com, and he has redirected the http://www.domain.com to that new URL. Obviously all our historic (and more recent) link building has been to the http://www.domain.com address. Is this an issue, should the new Https URL keep the 'www', or does it make no difference what so ever? Conversely could it actually be of benefit dropping the 'www.' because our keyword specific product URL's are now 4 characters closer to the http and 4 digits shorter? Finally, on the links we have control of (professional trade associations etc) do we need to ask them to change the links to the new Https address, or does the transition from Http to Https make no difference?
Web Design | | Wookii0 -
Is there a way to host my website.com/BLOG URL PATH from a different host than my main website.com host?
Is there a way to host my website.com/BLOG URL PATH from a different host than my main website.com host? Is it accomplish-able with DNS settings or are there other considerations that might lead to complications doing this? Specifically, we are investigating install WordPress on a dedicated host, JUST to power the blog for our main website, but our main website is on an internal proprietary hosting and CMS. So basically we're trying to host: website.com --> OFF OF CURRENT INTERNAL HOSTING website.com/blog/ --> OFF OF THIRD PARTY HOSTING (USING WORDPRESS) I know this is a technical question beyond the scope of SEO, but I'm figuring there are members of the community that may have tried this already so I'm floating it here. Many thanks! Cheers.
Web Design | | AlexVelazquez0 -
Website Home page suddenly disappeared after changing Hosting
HI All, My site was ranking very well and was in 1st page of google for most of my keywords. Last week we did some update to the site and moved it to new hosting and from then onwards I dont see my site home page in Google ranking . My Website Name is : royalevents.com.au. We used to be in 1st of Google for keywords like wedding Mandaps, Indian Wedding Mandaps etc, Would be great if some one helps us to figure out whats gone wrong .. I also did Webmaster Fetch as Google but nothing happened. Thanks
Web Design | | Verve-Innovation0 -
Should Blog Category Archive URLs be Set to "No-Index" in Wordpress?
It appears that Google Webmaster Tools is listing about 120 blog archives URLs in Google Index>Index Status that should not be listed. Our site map contains 650 pages, but Google shows 860. Pages like: <colgroup><col width="464"></colgroup>
Web Design | | Kingalan1
| http://www.nyc-officespace-leader.com/blog/category/manhattan-office-space | With Titles Like: <colgroup><col width="454"></colgroup>
| Manhattan Office Space Archives - Metro Manhattan Office Space | Are listed when in the Rogerbot crawl report for the site. How can we remove such pages from Google Webmaster Tools, Index Status? Our site map shows about 650 pages, yet Google show these extra pages. We would prefer that they not be indexed. Note that these pages do not appear when we run a site:www.nyc-officespace-leader.com search. The site has suffered a drop in ranking since May and we feel it prudent to keep Google from indexing useless URLs. Before May 650 pages showed on the Webmaster Tools Index status, and suddenly in early June when we upgraded the site the index grew by about 175 pages. I suspect the 120 blog archives URLs may have something to do with it. How can we get them removed? Can we set them to "No-Index", or should the robot text be used to remove them? Or can some type of removal request be made to Google? My developers have been struggling with this issue since early June. The bloat on the site is about 175 URLs not on the site map. Is there any go to authority on this issue (it is apparently rather complicated) that can provide a definitive answer? Thanks!!
Alan0 -
Major URL changes in new site launch
Hey Guys - we recently launched a new website for a client. Prior, all of their URLs were dynamic via an old-school Cold Fusion CMS. We basically had to rewrite 90% of the sites URLs (site is like 300 pages). The new URLs are SEO friendly and the on-page SEO is strong; but the page rank/authority is starting from scratch from these pages and placement has decreased more most of the new pages with competitive keywords. We set up all of the 301 redirects properly and are actively monitoring in Google Webmaster Tools. **Anything else I can do to lessen the pain and get these pages higher page rank/authority sooner rather than later?**Thanks for all of your help.
Web Design | | NobleStudios0 -
Changing URL's for a website redesign
Hi folks, We're redesigning our website and looking for some advice on how changing our URL's would affected our rankings. If the page URLs are changing how can we carry out redirects to avoid losing any SEO rank? Thanks, Ross
Web Design | | Will_Craig0 -
E Commerce Product URL SEO
Hi, first question here. In response to Paddy's wonderful article and Rand's related article from 09 I've found myself asking this question. "www.home.co.uk/product" or "www.home.co.uk/category/product" As I'm currently reviewing the structure for so many of our e com sites the article comes at a great time. I'm going for home/category/product so I can optimise for a category, as category based searches are quite high and competitive. Yes some products can appear in 2 categories but I'm combating it with 301's or image based links. What are your thoughts.
Web Design | | PASSLtd0