Use Google’s Search Console API & Pivot Tables To Supercharge Your Long-Tail SEO

  • Columnist Chris Liversidge explains how you can use the Search Analytics API to glean insights from your search query data in Google Search Console.


    Google’s recent changes to their Search Console API have allowed for interesting data analysis via Impressions and Clicks data. Leveraging the power of Excel and Pivot Tables, an unprecedented level of detail is available to fine-tune your search marketing campaign.

    Querying The Queries

    Google’s API documentation has excellent code samples and query structure guidance, and it should be considered essential reading for any SEO looking to push data to the fore in their SEO strategies.

    For today’s article, I’m going to cover the “Search Analytics: query” section, which explains how to use the Search Console API to query your search traffic.

    [Read the full article on Search Engine Land.]

    Some opinions expressed in this article may be those of a guest author and not necessarily Marketing Land. Staff authors are listed here.

    (Some images used under license from


    Marketing Land – Internet Marketing News, Strategies & Tips


    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.