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
-
What does 'Safari (in-app)' mean in Google Analytics browser traffic?
Hi, can anyone explain what 'Safari (in-app)' refers to in my browser sources? Also, it has a very high bounce rate - any ideas why?
Reporting & Analytics | | b4cab1 -
Does "not provided" affect the referral traffic data?
There is a discrepancy between what an referring site is showing as clicks back to my site versus what Google Analytics is showing. For example - They are stating that their site sent 100 clicks to my site. The GA data shows 25 referred clicks from that site. Could this be due to the "not provided" that hides most of the keyword data?
Reporting & Analytics | | devonkrusich0 -
Thankyou page tag configuration while implementing enhance ecommmerce
Hello guys, Currently i am tracking conversion in google analytic via google tag manager by doing following configuration in tag manager :- "Page URL Contains thankyoupage.html" But now i am implementing Enhance Ecommerce with tag manager with following configuration : - Custom event - "Event equals Transaction" So i want to ask if i configure "Event equals Transaction" while implementing enhance ecommerce do i have to delete this configuration "Page URL Contains thankyoupage.html" which i am using currently? Thanks! Dev
Reporting & Analytics | | devdan0 -
Getting Traffic for an Unranked Phrase
Over the last month, 40% of a client's search traffic as resulted from a phrase that they are not even ranking for in the top 100; nor are they popping up on PPC ads for it. How is this happening? I feel like I am missing something very obvious.
Reporting & Analytics | | ScriptiLabs0 -
Implications of Google discontinuing Website Optimizer
Hi Guys, As most of you probably know, Google is discontinuing Website Optimizer and introducing Experiments within Google Analytics. However, doesn't this mean that now, every site you want to run an experiment for has to be using Google Analytics? This is possibly one of the motivations for them making the change I guess? I also find it inconvenient that every 'experiment' now has to be based on improving a pre-defined goal in Google Analytics. This means that for a lot of situations we'll be creating goals just for the experiment and the clients actual goal conversions will appear quite inflated. I guess we'll just have to filter the new 'goals' out from the actual goals.
Reporting & Analytics | | David_ODonnell1 -
Traffic Down for Most Referrers - not just Google
Our traffic has taken a severe hit, over the past 3 weeks - down about 60%, which I had assumed was caused by the Penguin update. However on closer inspection of our analytics, our traffic is is down by between 30 and 50% for nearly all our referrers - including Bing and other search engines, referring sites, and even direct traffic! Google provides the vast majority of our traffic, so in terms of the absolute visitor count, the drop in Google traffic has the biggest effect - by some distance. But the fact that traffic is down by similar percentages suggest that Penguin isn't the cause of our troubles at all. We sell garden products in the UK, and it's just coming into peak season. Last year, May was one of our top months, External conditions - such as the very wet weather over the past month, economic gloom and doom - don't begin to explain this sudden and dramatic drop in traffic. We are very perplexed. If anyone has any bright ideas, I'd be interested to hear them. Ben
Reporting & Analytics | | atticus70 -
Is there a tool to automatically gather website SEO data?
I am looking for a tool that will crawl a website and create a spreadsheet listing out all key data such as title, meta description, etc. Anyone know of an available tool to do that?
Reporting & Analytics | | jfeitlinger0 -
Duicated page error
Hi, I am trying to figure out how to fix duplicated error Most of them are from wordpress "feed" Does anyone know how to fix this problem? | Wedding Photographer San Antonio | Soobumim Photography 210-863-9878 begin_of_the_skype_highlighting 210-863-9878 end_of_the_skype_highlighting http://www.soobumimphotography.com/feed/?paged=11 21 1 0 Wedding Photographer San Antonio | Soobumim Photography 210-863-9878 begin_of_the_skype_highlighting 210-863-9878 end_of_the_skype_highlighting http://www.soobumimphotography.com/feed/?paged=12 21 1 0 Wedding Photographer San Antonio | Soobumim Photography 210-863-9878 begin_of_the_skype_highlighting 210-863-9878 end_of_the_skype_highlighting http://www.soobumimphotography.com/feed/?paged=13 |
Reporting & Analytics | | BistosAmerica0