Is there an automated way to determine which pages of your website are getting 0 traffic?

[Ksink]

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?

[Ksink]

Keri - Thanks for that link. That was very helpful:). I tried playing around with the VLookup, but I liked this step by step process.

[KeriMorgret]

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.

[Ray-pp]

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