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
-
Over the last few months i have seen a huge spike in traffic from foreign countries
In GA i have seen a huge spike in traffic from foreign countries like japan, china, brazil, germany. the bounce rates are almost all 100%. any ideas why this is occurring?
Reporting & Analytics | | dhanson240 -
How to get a specific keyword count from a particular country to a particular page in google analytics
We are trying to get the keyword count of a particular keyword from a particular country to a particular page. eg: (keyword)Green shoes from (country)United states on (particular page)one of our blog posts page Any help will be really appreciated
Reporting & Analytics | | Nobody15870501745820 -
Re-Launched Website: Developer Fogot to Remove noindex tags.
Our company's website has maintained decent rankings for the last 12 years we've been in business for our primary keywords. We recently had our website rebuilt from the ground up, and the developers left the noindex tags on all of our 400+ pages when we launched it. I didn't catch the error for 6 days. During which time, I used the Fetch feature in Google, submitting a site-wide fetch, as well as manual submissions for our top 100 URLs . In addition, every page that was indexed previously had a 301 set up for it, which was pointing to a destination with a noindex.
Reporting & Analytics | | yogitrout1
I caught the error today, and the developer removed the tags. Does anyone have any experience with a situation similar to this? In the SERPs, we are still ranking at this moment, and it's displaying our old URLs, and they are 301 redirecting just fine. But, what happens now? For 6 full days, we told Google not to index any of our pages, while also using the Fetch feature, contradicting ourselves.
Any words of wisdom or advice as to what I can do at this point to avoid potential fall out? Thanks0 -
Why would a website rank lower than weaker site?
Hi, Today I noticed that my website is ranking one place lower than a competitor in Google UK ,despite my site having a stronger domain authority and page authority. Is there a plausible reason for this, i'm slightly confused? Thanks,
Reporting & Analytics | | Benjamin3790 -
Amazon.com inc.increase in direct traffic
Hi All, I have seen a increase of direct traffic from hostname amazon.com inc. This only happened on one day. Any ideas what/why it is? Thanks
Reporting & Analytics | | Sayers0 -
Magic UVs - PPC landing pages delivering organic traffic by magic...
I have checked and double checked this. GA is showing over the last couple of weeks mysite.com/ppc/landingpage1 as a landing page for organic traffic, where it shouldn't. Main facts: The entire /ppc/ folder is blocked from the googlebot, and doesn't appear on any internal site maps. As far as I can tell, these pages have never been cached for the main index. I cannot recreate any of the organic searches myself (i.e. typing in keywords that triggered the traffic, even the almost unique long-tail ones). We just don't appear in the organic listings with these pages. The analytics and adwords accounts are linked. We are not paying for this mystery traffic through our PPC - these keywords are not appearing in our AdWords account (though other keywords / traffic are). The traffic is real - we have received phone calls from these pages, tracked to the visits recorded as organic These pages should only receive PPC traffic. They are receiving organic traffic also, but I can't recreate it. Can anyone suggest what's going on? I'm concerned about duplicate content issues and also skewing the analysis of the PPC campaign. Thanks
Reporting & Analytics | | RobPell0 -
Did I get penalized by Panda 3.9?
Hey guys, So I have been on Google analytics and I looked at Traffic Sources > Search Engine Optimization > Queries & Landing Pages From Tuesday until today I am showing 0 impressions for top queries when we usually average around 9000 impressions daily, I am seeing the same for landing pages. When I go into google webmaster tools I am seeing 0 data from tues-today. It doesnt say that I have 0 impressions, it is just not showing me those dates, almost like I am unable to see data that is so close to today. The weird thing is that traffic to the sites in question is higher or normal to what it has been the whole month which makes me think that this is some sort of glitch. If we are being penalized and indeed have 0 impressions via search then our traffic would drop tremendously. When I sign out of google and search for our search terms, I am seeing our site pop up right where they should be. When I use the Page Rank tool I am also seeing us in the SERPS where we should be. Wed morning when I came into work after SEOmoz had an updated keyword rank report, I saw some great gains for a lot of our keywords. I am super confused and hoping that I was not part of the 1% affected. There is no reason for our sites to be penalized, they have great authority, healthy traffic, and go by SEO best practices. We have great content! Has anybody ever ran into this problem? Could use some guidance!
Reporting & Analytics | | PatBausemer0 -
What to get from google Webmaster tools?
Hi everyone, I've been doing optimization for our websites and tracking the results regularly but don't really know what the results actually mean. I heard that I need to check the traffic and organic results from Google analytics and Google webmaster tools. Everybody says something and not sure what to do? Is there anyone clarify the SEO process for me - when to do what and why in simplest way? Thanks in advance,
Reporting & Analytics | | WTGEvents0