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
-
How do you analyze a traffic drop with no historic Google Analytics data?
A client of mine has a large website with multiple sections (shop, forums, articles, etc.) that apparently had a significant reduction in rankings, traffic, and sales in the past. However, historic Google Analytics data is not available for the site, and I'm having troubles identifying anything concrete about the traffic drop, such as when it happened, what pages/sections it happened to, etc. The shop traffic drives most of the revenue, but it's a small number compared to the forums traffic, so it's hard to pick anything out of top-line trends like SEMrush offers. What tools or strategies might help in this situation?
Reporting & Analytics | | AdamThompson0 -
Google Analytics reporting traffic for 404 pages
Hi guys, Unique issue with google analytics reporting for one of our sites. GA is reporting sessions for 404 pages (landing pages, organic traffic) e.g. for this page: http://www.milkandlove.com.au/breastfeeding-dresses/index.php the page is currently a 404 page but GA (see screenshot) is reporting organic traffic (to the landing page). Does anyone know any reasons why this is happening? Cheers. http://www.milkandlove.com.au/breastfeeding-dresses/index.php GK0zDzj.jpg
Reporting & Analytics | | jayoliverwright2 -
Tracking 301 redirect traffic in Google Analytics
if I 301 redirect www.mywebsite.com to go to www.yourwebsite.com, how can I track the traffic in Google Analytics that is coming from mywebsite.com?? I don't think that's a referral traffic, is it?
Reporting & Analytics | | Armen-SEO0 -
Direct Traffic has Drastically Increased
Hi, I have noticed in Google analytics that direct traffic of one of my website is increased drastically. I didn't participate in Email Marketing or any other paid campaigns however direct traffic is continuously increasing. I checked all sources, locations, browsers, filters etc but didn't get any findings. Please help.
Reporting & Analytics | | RuchiPardal0 -
Enchance Ecommerce Tag Fired on every page i visit why?
Hello Experts, I have added given below code (A) on my website and given below (B) setting in GTM. Now whenever i visit the site then two tags fired that is google analytic and enchance ecommerce. GA tag fired that is fine but why enhance ecommerce tag fired even if i visit any page? I think enhane ecommerce tag should be fired when i click on addtocart right?A)```
Reporting & Analytics | | bkmitesh
dataLayer.push({ 'event':'addToCart', 'ecommerce':{ 'currencyCode':'EUR', 'add':{ // 'add' actionFieldObject measures. 'products':[{ // adding a product to a shopping cart. 'name':'Triblend Android T-Shirt', 'id':'12345', 'price':'15.25', 'brand':'Google', 'category':'Apparel', 'variant':'Gray', 'quantity':1 }] } } }); Track type : Event Event Category: `Ecommerce` Event Action: `Add to Cart` Enable Enhanced Ecommerce Features: `true` Use Data Layer: `true` Basic Settings - Document Path: `{{url path}}` Firing Rule: `{{event}}` equals `addToCart``Thanks!`0 -
Local site rankings have dropped off first page but Universal went up.
My site was performing first page locally on 6 of 20 keywords, and universally on 3 of 20 keywords. We started a link building campaign and optimization about 3 weeks ago. When I looked at the rankings today I was happy to see that 16 of 20 keywords were in the top 20 rankings universally, but not happy to see that only 1 of the 25 words were ranking locally now. I lost my local ranking on 5 very important keywords. I realize that you can not rank first page for both local and organic but its as if I traded my first page local ranking for a universal ranking that appears lower on the page. Maybe someone could point me in the right direction.
Reporting & Analytics | | whmgatx0 -
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 -
Time on page: What happens when I open many tabs?
Hello everyone, I was studying Analytics, and checked that the time on page is calculated by the diference of the time you entered the page and when you click to go to another one. But how the time is calculated when I open several links using new tabs in different moments? Does Google counts the last tab? Just a guess... Thanks!
Reporting & Analytics | | seomasterbrasil0