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 -
Changing Page Extenstions
Hi all, I have a 10 year old website done in Classic ASP, which is fast becoming outdated and we are going to convert it to PHP so all of our pages would be changed from a '/page.asp' extension to a '/page.php' extension. I am familiar with the need to setup 301 redirects for this and I understand there will probably be a short term drop in our Google rankings. Naturally, I don't want to have to go through this again in the future so here is my question. Is having NO page extension, like '/aboutus/history' the wave of the future? Does having no page extension effect SEO at all? I have seen more websites using this technique in 2013 goes on so I am thinking this is the way we should plan our site update. I haven't looked into how to actually do this yet, but it would seem to make sense to me so that if we needed to change from PHP to say .NET or something else later on, we would not have to do 301 redirects again or have another drop in our rankings. Do any of you have an opinion or experience with this?
Web Design | | jacksghost0 -
How to change the entire contents and design in my site without getting troubles with google?
Hello everyone This is my first post over here. In the next few weeks we going to change the entire content and design in our site. The site has 240 pages with poor contents and design. Except 301 redirects for all the old url’s I wanted to consult with you what is the right way to do it without harm my organic traffic that come from google? How google refers to this kind of changes? Which steps should I need to take to do it properly? Hope to get your help in the issue. Tahnks in advance.
Web Design | | JonsonSwartz0 -
Best way to add Google Analytics to a Joomla!
I am having difficulties installing (and getting it to work) google analytics to Joomla! 2.5.8 site. I have it working on some sites but then not on others even though I have installed it the same. Is there a recommended or easy way to do this that works?
Web Design | | Atlanta-SMO1 -
Changing Links that Show Up when I Google Brand (Site) Name
Hi SEOmoz Community, A quick question for you all. I've added an attachment for reference. When I google my brand name, say for example, Applied StemCell, I see six links as well below the description. Oddly though, these links seem to be chosen at random, or at least I'm not sure how Google decides on them. When I click on one of the links that is the company's name, Applied StemCell it brings me to a PDF document! Is there any way I can choose which ones to display there? Thanks! OF2oVVN.png
Web Design | | swzhai0 -
Google fails to pick out the correct URL of the story
Hi , I have a page with many news storeys on it. Google craws the page but it picks up a more general url even though I've embedded the direct URL within anchor tags around the headline . The snippet below got linked by Google to http://www.irishnews.com/ Any idea how i can get Google to pick-up http://www.irishnews.com/news.aspx?storyId=1180708 would be very welcome Peter Quinn: Family made scapegoats of financial crisis News Peter Quinn: Family made scapegoats of financial crisis THE Quinn family have been made scapegoats of the financial crisis surrounding the former Anglo Irish Bank, tycoon Sean Quinn's brother Peter claimed yesterday.Peter Quinn, a former president of the GAA, said hi read more»
Web Design | | Liammcmullen0 -
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 -
Two URLs with same content
We recently had a client who own multiple brands switch from having multiple urls to having a single domain with multiple sub domains. I've posted an example below to better explain. My question is the original url is still functional, so there are two urls with identical content, yet I haven't been getting a duplicate content error. Also, would a rel canonical link be beneficial in this case since the duplicate content is on two separate domains? My thoughts were to put a 301 redirect on the original pages so they permanently forward to the new sub-domain format. Is this the best course of action? If not, what would you recommend? Example: Original URLs
Web Design | | BluespaceCreative
www.example1.com
www.example2.com
www.example3.com
www.parentcompany.com New URLs
example1.parentcompany.com
example2.parentcompany.com
example3.parentcompany.com
www.parentcompany.com Let me know if this I need to clarify anything in better detail.
Thanks in advance!0