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
-
Redesign Just Starting - Should I Leave The Previous Incomplete Site or Setup A Temporary Holding Page and Redirect Previous URL'S?
Hi All I've picked up a new website project and wanted to ask about the best way to proceed with the current site during the development process. The current site is incomplete although it has been live for a while and has over 80 pages in the sitemap. Link to site https://tinyurl.com/ychwftup The business owner wants to take down the current site and simply add a landing page stating "new website coming soon". From an SEO perspective, am I better to keep the current site live until the new site is ready? Or would it not make any difference if I setup the landing page and add 301 redirects from each page in the sitemap to the landing page. Many Thanks In Advance For Any Assistance
Web Design | | ruislip180 -
My visibility went from 14% to 3.33% this week. HTTPS Change?
So I am trying to figure out how my google rankings dropped from 3 to 9 This past week. Could it be the new HTTPS security issue? My site was created in HTTP not HTTPS. Is this an easy fix? Can I hire someone on this site to fix this?
Web Design | | Boodreaux2 -
Shortened URL is breaking when URL is in Upper Case
Hi there, Currently I'm having some troubling mitigating an odd occurrence with some redirected shortened URLs being in upper case. Here is how they should be behaving - www.rhinosec.com/webapp -> https://rhinosecuritylabs.com/landing/sample-report-webapp-pentest/
Web Design | | BCaudill
www.rhinosec.com/network -> https://rhinosecuritylabs.com/landing/sample-report-network-pentest/
www.rhinosec.com/se -> https://rhinosecuritylabs.com/landing/social-engineering-example-report/ but when the /______ is capitalized - for example - WEBAPP, NETWORK, SE; WordPress either gives me a 404 or guesses the pages and lands on: NETWORK = https://rhinosecuritylabs.com/assessment-services/network-penetration-testing/
SE = https://rhinosecuritylabs.com/assessment-services/secure-code-review/
WEBAPP = 404 I was wondering if this discrepancy should be taken care of in the Htaccess file, Cloudflare, or WordPress redirect plug-in?0 -
Interlinking using Dynamic URLs Versus Static URLs
Hi Guys, Could you kindly help us in choosing best approach out of mentioned below 2 cases. Case. 1 -We are using: We interlink our static pages(www.abc.com/jobs-in-chennai) through footer, navigation & by showing related searches. Self referential Canonical tags have been implemented. Case. 2 -We plan to use: We interlink our Dynamic pages(www.abc.com/jobs-in-chennai?source=footer) through footer, navigation & by showing related searches. Canonical tags have been implemented on dynamic urls pointing to corresponding static urls Query 1. Which one is better & expected to improve rankings. Query 2. Will shifting to Case 2 negatively affect our existing rankings or traffic. Regards
Web Design | | vivekrathore0 -
SEO Consulting for HUGE Website. How Big Is TOO Big Of A Change?
SEO Consulting for a HUGE Website. Their h1 tags have instagram/twitter, h2 have their menu/what's trending and h3 is the article title. Here's what I want to do... MY MAIN QUESTION: This site has tens of thousands of pages, all articles beyond the few dozen category/tag pages they have. If I change the structure to the following, will it be too much of a system shock to Google? Will this actually HURT them? Currently on the site: - h1 tags point to Twitter/Instagram sidebar widgets
Web Design | | BrianGilmore
h2 tags point to the menu/what’s trending section (which is the same on every page)
h3 points to the Title of the Article I want to change it to this: - h1 tags should delineate the article's name. That's all they should really be used for.
h2-4 should be reserved for article subheadings to be used by the editorial staff. EDIT: 30% of their >11 million monthly uniques come from search. I don't want to eff with that, but the way that NONE of their pages have optimized words, they have no sitemap, webmaster tools and are still doing this well makes me think that even putting in minimal changes to tidy things up will help them bring it to 70% organic search.0 -
Existing URL structure and how to handle new pages before migration
Hi there! Currently, our site uses underscores "_" within the url structure. We are moving to Wordpress soon (the site is currently static html) but it will be a couple of months before the migration. Here is an example of the current structure: www.oldsitestructure.com/about_us/success_stories/custom_vinyl_banners When we do change, our url structure will have hyphen's "-" to separate terms, so the preferred new structure will be: www.oldsitestructure.com/about-us/success-stories/custom-vinyl-banners The entire site (with the exception of our Wordpress blog) currently uses the old structure. We have about 10 - 15 pages we will add before our migration, my question is: Should we use the preferred url structure starting NOW or stick with the old one? And set up 301 redirects are part of the migration process? Many thanks!
Web Design | | SEOSponge
Jon0 -
Can you use a base element and mod_rewrite to alleviate the need for absolute URLs?
This is a follow up question to Scott Parsons' question about using absolute versus relative URLs when linking internally. Andy King makes the statement that this can be done and that it saves additional space (which he claims then can improve page speed). Is this a true and accurate statement? Can using a base element and mod-rewrite alleviate the need for absolute URLs? I need to know before going off on a "change all of our relative URLs to absolutes" campaign. Thanks in advance! Dana
Web Design | | danatanseo0 -
Optimzing a new ecommerce site, Need help with URL
Hi We are putting up a new ecommerce website and for product description, our tech team indicates that they must have the skun numbers in the URL. Which one of the following URL structure do you find the most SEO freindly? 1. http://www.Site.com/SKUNumber/ProductDescription/ or 2. http://www.Site.com/ProductDescription/SKUNumber/ My personal opinion is that most relevant content should be on load page so I like option 1. Thanks
Web Design | | CookingCom0