Google Search Console

Section header image mobile

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, 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

Import from Scratch

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.

MenuIconUpdated.png

2. Select “Connected Sources”.

 

ConnectedSources.png

3. Select “Add Connection at the bottom and then “Connect” to Google Search Console.

ConnecttoGSC.png

4. “Authorize” Coefficient to connect to your Google Search Console account.

AuthToGSC.png

5. Choose the Google account you use for Google Search Console.

GSCSelectAccount.png

6. “Allow” access/permissions. If successful, you will be taken back to Google Sheets to start creating GSC imports. 🎉

GSCAllowAccess.png

Importing from Google Search Console

Import from Scratch

1. Open the Coefficient Sidebar and click on the “Import from…” button.

ImportFrom.png

2. Select “Google Search Console” from the list.

Screenshot 2023-10-12 at 8.03.44 PM.png

3. Select "Start from scratch"

Screenshot 2023-10-12 at 8.04.14 PM.png

4. Choose the site/property (example: coefficient.io) from your GSC account. Screenshot 2023-10-12 at 8.10.10 PM.png

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)

GSCImportPreview.png

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.Screenshot 2023-10-13 at 1.03.31 AM.png

7. Congratulations on your first Google Search Console import in Coefficient! 🎉
GSCImportSuccess.png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your ImportScheduled_Refreshes.png

2. Turn on SnapshotsSnapshot.png

3. Set Up Automations

AutomationswithGPT.png

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.

Was this article helpful? 0 out of 0 found this helpful