Is there an automated way to determine which pages of your website are getting 0 traffic?
-
I'm doing a content audit on my company website and want to identify pages with zero traffic. I can use GA for low traffic, but not zero traffic. I can do this manually, but it would take a long time. Are there any tools to help me determine these pages?
-
Keri - Thanks for that link. That was very helpful:). I tried playing around with the VLookup, but I liked this step by step process.
-
And there's a YouMoz explaining how to do this in detail at http://moz.com/blog/how-to-combine-screaming-frog-data-with-google-analytics-data.
-
Hi Kfeichtner,
One way would be the following:
-
Go to Google Analytics and export the Behavior > Site Content > All Pages report
-
Or, if you're looking for Landing Pages then export that appropriate report
-
Use Screaming Frog SEO Spider to crawl your website and get a full list of pages/urls
-
Add both reports into Microsoft Excel
-
Use a VLookup formula to add the traffic to the appropriate URLs
-
Filter the list to show the pages that did not receive any traffic
Google Analytics Data + Screaming Frog Data = All site pages and associated traffic
-
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
-
Google Webmaster Tools, about multiple entries for your website
Hi I have a doubt about Google Webmaster Tools or Central as it is call today. I remember that google recommended to have one profile of your website for each domain structure. Let me try to be more clear one profile for http://www.yoursite.com, an other for http://yoursite.com, an other for https://www.yoursite.com, etc. Then in each of them we uploaded our sitemaps and cross our fingers. Now from my experience always the complete url have better index status from the sitemap. Now my question is, today as Google requested all our websites run under https, so conserving the other profiles is affecting how google index our pages? shall we have to delete the old profiles or is better to maintain them? Thanks. Pablo
Reporting & Analytics | | FWC_SEO0 -
Google traffic plummeted on Sunday - what can I do?
On Sunday, my google traffic plummeted. I was getting 320 hits a day from Google on my best days - my site is just about to turn 3 months old so I was thrilled with that. On Sunday it was 110 and I think it is getting worse. Edit: Yep, yesterday was 65. Google Webmasters shows the drop today. One day, my impressions were 5,500 and the next just 1,000. Yikes. My traffic is so depressing now after so much hard work. Is this Google Panda? What can I do? I have no idea why this happened. I am getting several quality backlinks a week, sometimes a day.
Reporting & Analytics | | 2bloggers0 -
How does Google sort multiple websites in one GWT account?
Today I noticed one of our sub-domains listed in our Google Webmaster Tools Account moved from the 6th position to the 2nd position. Is there a reason for this (perhaps urls/sites listed at the top require the most attention)?
Reporting & Analytics | | Prospector-Plastics0 -
Why such a high page rank with so low metrics in OSE
Hi,
Reporting & Analytics | | sebastiankoch
The website is:
www.s123parka123ble.com (remove the 123) All websites I have ever seen with similar metrics in OSE have normally a PR of 2 or 3 or max 4. This one is PR 5 and I would like to know why. I also noticed that they do not redirect the urls without www. to www. Which is normally bad ... can it be good for some reason in this case? It is PR 5 since a long time I just can´t get why it is PR 5. Please have a look. Thanks!0 -
Site Crash Effect On Traffic
All, I manage a site that unfortunately crashed due to a server issue in late October for about 3 hours. Prior to the crash, traffic was the best it had ever been in the 3+ year history of the site. As you might expect, since the crash traffic has gone gradually down and is now about 15% off pre-crash numbers. I understand that when a site crashes, it disrupts the crawling process and can disrupt traffic (in my case rich snippets were thrown off for days) but would love to hear experiences any of you have had in similar situations. How much did traffic drop after a crash? When did it recover? Other thoughts? Thanks, John
Reporting & Analytics | | JSOC0 -
Page Views Plummeted
Since using SEOMoz to diagnose and address issues with my site www.esecaucus.com, my page views have plummeted while my number of visits and unique visitors has remained intact. Does this mean that previously the amount of page views were artificially inflated by some kind of technical error in the site?
Reporting & Analytics | | Nobody15330770827560 -
SEO traffic had significantly dropped
I know this question has been asked before, but I'm hoping someone can address my specific issue. We recently did a complete redesign of our site and moved it over to a new server. The site was even "down" for about a week, where we had a static splash page. However since relaunching (it's not been over two weeks) we've seen a significant drop in search engine traffic. We are using Yoast for Wordpress. The site is The Tech Block. Could anyone see if there is something we're doing wrong? Thanks
Reporting & Analytics | | ttb0 -
Automatic Checking indexation of websites
Hi Guys, do you know a tool that can check al list of websites (directorys) wich automatically checks if the website are indexed in Google. The list is very long and I would like to have a tool wich checks them all with only CnP them once. thankx a lot der.rabauke
Reporting & Analytics | | Lincus0