Whats the Best Tool for Bulk SERPS Checking?

[Zippy-Bungle]

To get round the 'not provided' issue I've just generated a list of the 5000+ keywords that people have used to visit my site over the last 7+ years.

I want to do a one off SERPS check for all these keywords and export into excel where I'll tie it up with lots of analytics and moz based data

I was going to use the queries report on analytics but my data only goes back as far as May this year, so I'll use that if I have to (and probably will anyway for the impressions and CTR) but I'd prefer to cover everything so I can see any opportunities in my very long tail

[Zippy-Bungle]

Thanks for that.

Really i I just want to do it once to cover off any unlimited opportunities. Basically I'll do a quick heat map matching SERPS to monthly search volumes  and use that to come up with a list of keywords to focus on.

What's clear from the work that I have done already is that there  is a big misalignment, in my particular sector, between where people spend their ad dollars  and what keywords drive visits.   It's based too much on 'experience' of managers and not enough on data.

because the industry changes slowly, the last major innovation was in the early 90's the historical data is good enough for my purposes as is a SERPS snapshot on an annual basis.  It's my workaround to the not provided problem.

[GPainter]

Hi there,

There a few checkers so its really preference i like www.serpbook.com

there is also http://www.serplab.co.uk/

and hundreds more, not forgetting the fact Moz tracks some too.  Importing 5000+ keywords is a bit of a time waste & money burner though have you also tried looking into some of the moz blogs for not provided -

http://moz.com/blog/100-percent-keyword-not-provided-whiteboard-tuesday

http://moz.com/blog/easing-the-pain-of-google-keyword-not-provided

http://moz.com/blog/what-is-seo-now

http://moz.com/blog/proving-seo-value-in-google-analytics

http://moz.com/ugc/how-to-analyze-google-analytics-not-provided-data

http://moz.com/ugc/overwriting-not-provided-keywords-with-inferred-keywords-in-google-analytics

as you can see there are loads of topic on the matter which might help future proof your self as more sites are going secure your only going to be fighting an uphill battle to try and track that metric.

Good luck.