Supermetrics Support Forum


Google Sheets: Google Search Console API Date Range


Can Supermetrics For Google Sheets pull 16 months of data from the Search Console Search Analytics API?

Per this 18 Jun 2018 tweet from Google, this is now possible:

"If you're using the Search Console Search Analytics #API, you now have access to all 16 months of data provided in the UI!"

However, the Supermetrics For Google Sheets resources I am finding on the web are unclear to me on the subject.


From this Supermetrics resource "What does the "Combine new results with old" setting do?":

"Google Search Console only lets you fetch data on the last 90 days."

Another Supermetrics resource "How Do I Use the "Combine new results with old" Setting?"

"As noted in the article What does the "Combine new results with old" setting do?, this feature can be used to overcome shortcomings of the data source API not being able to pull older periods of historical data or to help quicken the loading or larger data sets"

Another Supermetrics resource "Discrepancies in Google Search Console results"

"- Technical differences between tools. We are using the Search Console API which processes data differently from the Search Console UI."

Thanks for any clarity you can provide.

  • Hi Paul,

    Yes we can pull up to 16 months now.

    -Thank you
    Supermetrics team

    1 person likes this
  • Thanks for the clarity. What is the methodology used to calculate the appropriate date range? I have read that the GSC API permits a 486 day date range, but am still unclear how this factors into the Supermetrics UI.
  • Hi Paul,

    You put the data range you want into the UI and we attempt to pull that data for that period by building the appropriate API request. If you request too far into the past, you will get an error and it won't run.

    -Thank you

    Supermetrics Team

Login to post a comment