Updated July 27, 2017

If you’ve been following this blog, you’ve likely heard several references to the Google Analytics Keyword Sleuth that Michael Harrison wrote back in April of 2007. This is a tool that anyone in paid search should be using. Basically, it captures and displays an ongoing list of new keywords and phrases straight from your customer’s mind. We’re often advised to “imagine what your customers are typing before they see your ads, then bid on those keywords.” With the Keyword Sleuth in place, you don’t have to imagine anything. They’ve already told you.

For a long time, Google, Yahoo!, MSN and others would not reveal exact search queries, and still don’t for the most part. They’ll tell you the bid keyword, but not the exact search query. In May 2007, Google stepped up and created the Search Query Performance Report (SQPR), which now shows this data within the Adwords reporting tab. There was a wave of excitement when Google released the SQPR, and it’s become a popular report for Adwords users.

Both the Keyword Sleuth and the SQPR were developed to do essentially the same thing, but in reality, they can be worlds apart for the PPC manager. In explaining the Keyword Sleuth to other PPC professionals, I’m often asked how it’s different than the Adwords SQPR. There is a lot that is different. A side-by-side comparison between these two tools is long overdue.

First, I’ll run Google’s SQPR. When that’s done, I’ll retrieve the same data using Michael’s Exact Keyword Sleuth. In summary, I’m gathering the same data from the same Adwords campaign and the same time frame (one month), using two different methods. My teammate Matt will time it from the moment I touch the keyboard to the moment the report is viewable on screen.

The results…

Google’s SQPR:
6 minutes, 45 seconds
GA Keyword Sleuth:
40 secondsThe Results:

The Keyword Sleuth is 912.5% faster.

Speed is great, but it’s not everything. What about the actual data gathered and the usability of the reports? There are several similarities and differences in the reported data, so let’s compare that too.



Google’s Search Query Performance Report is a good report that can be very useful. But, having used both, it clearly pales in comparison to the convenience and the flexibility that the Keyword Sleuth offers. For me and my crew, viewing exact keyword queries within Analytics is faster, more thorough and will give you more insights into ways to optimize your campaigns.

If you’re not yet using the GA Keyword Sleuth, why not start now? Michael wrote some instructions on how to set it up here. It’s free, and set up is fast and easy. In fact, probably faster than the time it takes to run an Adwords Search Query Performance report for any one of your Adwords campaigns.

Several of our readers are currently using the Google Analytics Keyword Sleuth. We’d love to hear your feedback in the comments below.