Coefficient's Google Search Console connector allows you to effortlessly integrate and retrieve data from your GSC account. This tool enables you to generate reports in Google Sheets/Excel, allowing you to build insightful dashboards for analyzing the performance of your website in Google Search results.
Connecting to Google Search Console
Importing from Google Search Console
Schedule your Import, Snapshots, and Add Automations
FAQs for Google Search Console Integration
Connecting to Google Search Console
When you begin a Google Search Console import for the first time, you will need to connect/authorize Coefficient to access your GSC data.
|
1. Open the Coefficient Sidebar and click Menu. |
2. Select “Connected Sources”.
|
3. Select “Add Connection” at the bottom and then “Connect” to Google Search Console. |
|
4. “Authorize” Coefficient to connect to your Google Search Console account. |
5. Choose the Google account you use for Google Search Console. |
6. “Allow” access/permissions. If successful, you will be taken back to Google Sheets/Excel to start creating GSC imports. 🎉 |
Importing from Google Search Console
Import from Scratch
|
1. Open the Coefficient Sidebar and click on the “Import from…” button. |
2. Select “Google Search Console” from the list. |
3. Select "Start from scratch" |
4. Choose the site/property (example: coefficient.io) from your GSC account.
5. Enter the Dimensions, Metrics, and Search Type needed for your import. Click inside the white box area for each section to search for the fields you need. The data previewer shows a sample of the data from the fields you select.
ℹ️ NOTE: Leave the “Include Fresh Data” box checked if you need to see the latest data and not just include the finalized data (deemed by Google). (See FAQs (below) for more information about finalized data)
6. Customize your import by adding filters and row limits as needed. Click the “Refresh Preview” option to update the sample data based on what customizations are added then hit “Import”.
ℹ️ NOTE: Google Search Console API does not support sorting, see the FAQ (below) for more information.
7. Congratulations on your first Google Search Console import in Coefficient! 🎉
Schedule your Import, Snapshots, and Add Automations
Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:
|
|
FAQs for Google Search Console Integration
Do you support data sorting with Google Search Console?
Due to Google Search Console API limitations, sorting isn’t supported in Coefficient at this time. If the date field is the only dimension added, the results are presented in chronologically ascending order. When there are multiple dimensions, results are sorted by click count, in descending order.
What are the differences between “Fresh Data” and “Final Data”?
With the fresh data, Google Search Console (GSC) users can see data as recent as less than a day old—a significant improvement compared to the previous few days. This should help you better monitor your site's performance and identify trends, patterns, and interesting changes much closer to when they happen.
ℹ️ NOTE: Data points are designated initially as “fresh”, then after a few days (2-3), Google will label those data points as “final”. It is expected that the “fresh” data points may be updated several times before becoming finalized by Google.
I am trying to filter my import with multiple values using "OR" logic. How can I do that?
Due to limitations of the Google Search Console API, only “AND” filter logic is supported at this time. If you need to filter by multiple values using “OR” logic please reach out to our support team (support@coefficient.io) and we will be happy to log this request if the API changes in the future and supports this function.