Collect Historical Data for Google Search Console
Google Search Console collects live data only. Backfilling and data warehousing are not available for this connector, and Google's API provides only the most recent 16 months of historical data. We recommend the following alternative solutions for ongoing collection of historical data beyond the most recent 16 months.
Export to BigQuery or MySQL
Our Enterprise plan offers the ability to export data to BigQuery and MySQL.
- Follow the instructions in How to Export to BigQuery or How to Export to MySQL to set up an initial backfill of your historic Google Search Console data, followed by a regularly scheduled rolling update with the latest data.
- This scheduled export will append the newest data to the historic data on an ongoing basis, allowing you to collect data beyond 16 months.
Use the Spreadsheets Add-on
With our Spreadsheets add-on, you can use Google Sheets as a destination for your Google Search Console data. To store historic data as well as the latest data, create a new Google Sheets spreadsheet and enable the Power My Analytics Spreadsheets add-on.
- In the first sheet of the spreadsheet (Sheet1), create a report with a date range of the last 16 months. Make sure to give this report a distinct name like "Historic data".
- Create a new sheet (Sheet2) in the spreadsheet.
- Create a new report. Make sure to give your report a distinct name like "Current data".
- Set the date range to Custom start to date and set the start date to today's date.
- Go to the Sheets sidebar and delete the "Historic data" report. The first sheet of your spreadsheet will still contain the data, but it will no longer be updated. This is necessary to avoid data loss: scheduling a refresh in the Sheets sidebar will cause all reports to refresh, and refreshing the "Historic data" report would cause the loss of any data older than 16 months.
- Click on the alarm clock icon to create a scheduled refresh of your current data. You can select a monthly, weekly, or daily refresh (hourly refresh is only available to Enterprise users).
- Select a refresh time, then click Save.
You will need to repeat this process every 16 months in order to avoid gaps in data.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Google Search Console Data Connector User Guide
Google Search Console provides valuable insights into your website's search performance and visibility in Google Search results. This guide will walk you through connecting Google Search Console to Power My Analytics, creating reports, and ...Error: Missing Google Search Console Scopes
When creating a report using your Google Search Console account in Power My Analytics, you may encounter an error message stating "Missing Google Search Console Scopes." This guide will help you understand the cause of this error and provide ...Use the GA4 Exports Template in Data Explorer
Power My Analytics offers pre-made report templates in our Data Explorer for use with your Google Analytics 4 data. By using our GA4 report templates, you can configure your reports in just a few minutes and prepare your data for export to ...Report a Different Time Zone in Spreadsheets
When reporting your data with our spreadsheets addon, you may want to adjust the date and time reported to account for a timezone offset. This article will show you how to use a formula to adjust the reported date and time in Sheets. Some connectors ...Google Sheets Data Integration Guide
Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...