Find Pages with 0 traffic

[driveawayholidays]

Hi,

We are trying to consolidate the amount of landing pages on our site, is there any way to find landing pages with a particular URL substring which have had 0 traffic?

The minimum which appears in google analytics is 1 visit.

[ecommercebc]

This is a really nice solution! Thanks for sharing. It's super quick as well, so a GA export and a few VLOOKUPs/pivots later and you're sorted - nice one!

[Devanur-Rafi]

No problem my friend : -))

[eugenecomputergeeks]

My bad. I misunderstood and misread.  Thanks for the update.

[Devanur-Rafi]

He is trying to consolidate or find the total number of landing pages that do not have any traffic at all. So, screaming frog seo spider can be used to crawl the entire website (with the substring in the URLs) and substitute the URLs that have driven at least 1 visitor. He is not trying to get a hold of his historic or old analytics data. The question is pretty straight forward unless I missed something.

[eugenecomputergeeks]

Yes, but how does that help him get the old data he needs? Crawlers shouldn't know your traffic unless you install the code they give you or verify some other way.  Find it to be a crawler causing the problem unlikely unless I misunderstood the problem/question.   I sure hope they have a Linux host (most are) and can just check the apache logs while Google Analytics takes a few days to update.

[eugenecomputergeeks]

What webhost are you using?  Most keep analytics software enabled by default or at least lets you turn it on.  (While you wait for Google.)  Analytics are a key part to SEO so I use awstats (free), and webalizer.  With most hosts if not enabled its as easy as clicking a button.

Depending on your host, you might be able to get the raw log info, but most hosts don't have this option unless you paid for a fancy account which allows root shell access, but maybe not it differs from site to site.

Google Analytics will only show 1 visit if you are the only visitor even if you refresh the page or come pack.  It saves your IP address and hardware profile most likely is the method they use. Make sure you change Google Analytics to display as far back as possible.

[Devanur-Rafi]

Hi, you can use a crawler like Screaming Frog SEO Spider to come up with total number of pages with some unique string in the URLs, substitute the URLs that have traffic from these and the rest will be ones with no traffic.

You will have to use the paid version of Screaming Frog SEO Spider if you want to crawl more than 500 pages and here is the section of the user guide that tells you how to do a regex crawl:

http://www.screamingfrog.co.uk/seo-spider/user-guide/configuration/#9

Best regards,

Devanur Rafi