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 redirecting the existing URLs in the website without reducing our current rankings? The new website runs on the bubble, so it seems there is no provisions to redirect the existing URLs to this platform?
Hi Moz Fans, There are some clarification needed in a website revamping and loosing of current website rank. Please go through the questions and would be great if you like to share some insights on it. 1. We would like to revamp our existing website by joining hands with the bubble visual programming platform. Thus, kindly let us know if there are provisions to redirect the existing URLs to this platform. We would also like to know if this kind of redirecting affects the current website ranking. If yes, how can we redirect the existing URLs in bubble without reducing our current rankings? 2. As a part of the revamping of our website, we would like to enquire about the possibilities of its relaunch via bubble. Does it cause any changes for the current rankings of our website if we redirect the existing URLs via bubble? If yes, is there any provision to redirect the URLs without affecting the current ranking of the website?
Web Design | | OceanAirTravels0 -
Changed url and now not listing
hi guys I had this page "https://www.stauntonrook.co.uk/marketing-services/offline/corporate-identity/" indexed in google at position 5 for a search term, after some research in the keyword planner I decided to change my url to https://www.stauntonrook.co.uk/marketing-services/offline/logo-design/ because I wanted the keyword in the url. I added a 301 redirect to the htaccess and removed the old page from google using webmaster tools fully expecting the new url to drop back in anytime hopefully in a better position than 5, now after a good week or so, still nothing 😞 also doesn't seem to be in any of the other search engines either I've updated the xml too any ideas?
Web Design | | Staunton_Rook0 -
Is it necessary to Remove 301 redirects from Wordpress after removing the 404 url from Google Webmaster?
There were many 404 urls in my site found by Google Webmaster. I've redirected these urls to the relevant urls with 301 redirect in wordpress. After that I removed these 404 urls from Google Index through Webmaster. "Should I cleanup these 301 redirects from Wordpress or not? ". Help Needed.
Web Design | | SangeetaC0 -
Major home page change!
Hi Mozzers, Making a major homepage change on my site Orangeoctop.us. I am going from featuring content to featuring products, similar to how moz and hubspot feature their content on the homepage. Just to give you some numbers, the homepage only sees 2.6% of the total traffic and of that traffic half is direct. The homepage is going to be changed to OrangeOctop.us/guides. My Question: Is there anything that should be added to the homepage to ensure that I keep the same domain authority/page authority?
Web Design | | orangeoctop.us0 -
Will changing content managment systems affect rankings?
We're considering changing our content management system. This would probably change our url structure (keep root domain name, but specific product pages and what not would have different full urls). Will our rankings be affected if we use different urls for current pages? I know we can do 401 redirects, but anything else I should consider? Thanks, Dan
Web Design | | dcostigan0 -
Changing template and loosing visits should I role back
Hi all I am working on the website which does not have a user-friendly template. I decided to change the templet and I was, so careful to have all the links and content exactly as before. Since 2 days a go website visis dropped completely it is zero visits per day compare to about 100 before! Should I roll back to the old template or does it happend because of the weekend ? Also I checked ranking it did not changed!!
Web Design | | hamidre130 -
The use of foreign characters and capital letters in URL's?
Hello all, We have 4 language domains for our website, and a number of our Spanish landing pages are written using Spanish characters - most notably: ñ and ó. We have done our research around the web and realised that many of the top competitors for keywords such as Diseño Web (web design) and Aplicaión iPhone (iphone application) DO NOT use these special chacracters in their URL structure. Here is an example of our URL's EX: http://www.twago.es/expert/Diseño-Web/Diseño-Web However when I simply copy paste a URL that contains a special character it is automatically translated and encoded. EX: http://www.twago.es/expert/Aplicación-iPhone/Aplicación-iPhone (When written out long had it appears: http://www.twago.es/expert/Aplicación-iPhone/Aplicación-iPhone My first question is, seeing how the overwhelming majority of website URL's DO NOT contain special characters (and even for Spanish/German characters these are simply written using the standard English latin alphabet) is there a negative effect on our SEO rankings/efforts because we are using special characters? When we write anchor text for backlinks to these pages we USE the special characteristics in the anchor text (so does most other competitors). Does the anchor text have to exactly I know most webbrowsers can understand the special characters, especially when returning search results to users that either type the special characters within their search query (or not). But we seem to think that if we were doing the right thing, then why does everyone else do it differently? My second question is the same, but focusing on the use of Capital letters in our URL structure. NOTE: When we do a broken link check with some link tools (such as xenu) the URL's that contain the special characters in Spanish are marked as "broken". Is this a related issue? Any help anyone could give us would be greatly appreciated! Thanks, David from twago
Web Design | | wdziedzic0 -
Changing a domain for local.
I have a client that currently is using a sub-domain site from our local news paper site. The domain authority looks huge, but it is not really their own domain. I know in the log run it best to change the domain name. I am afraid of a significant drop in Google Places traffic when I change to a new domain. Has anyone dealt with type of situation?
Web Design | | Joshen0