- 4 Minutes to read
- DarkLight
Google Search Console
- 4 Minutes to read
- DarkLight
Google Search Console is a free web service that allows website owners and webmasters to monitor and manage how their site appears in Google search results. It provides valuable insights into search performance, indexing status, and helps identify and resolve issues that might affect a website's visibility in Google's search engine.
For all available datasets, metrics and attributes, please refer to our website.
All available endpoints from the Google Search Console API are listed here.
How to Create a New Google Search Console Source
- Under the Sources tab, click on the Create Source button and select the connector from the list.
- Select your dataset and click on Next to continue.DATADDO TIP
If you are not sure which dataset you need but know the metrics and attributes, use the Search by Name or Attribute function.
- From the drop-down menu, choose your account.Didn't find your account?
Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.
- Name your data source and select your metrics and attributes. Please keep in mind that metrics and attributes depend on the selected dataset.
- Configure your snapshotting preferences. Choose your sync frequency or the exact synchronization time under Show advanced settings.DATADDO TIP
If you need to load historical data, please refer to the Manual Data Load page.
- Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
- Click on Save and congratulations, your new data source is ready!
Connector Overview
Account Permissions
In order to extract your site insights, make sure the Google account you authorized in Dataddo has the permissions of a
- Site Owner, or
- Site Full User.
For more information, see Google's official documentation.
Limitations
Historical Data Load
You can load data up to 16 months back.
Troubleshooting
Data Preview Unavailable
If there is no data preview after clicking on Test Data, there might be a problem with your source configuration. The most common causes are:
- Date range: Try a smaller date range. You can load the rest of your data afterward through our manual data load function.
- Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
- Incompatible combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same source.
Aggregated Data by Property vs. by Page
When you aggregate data in Google Search Console, you have the option to do it either by property (all domains inside one URL) or by page.
Aggregation by Property
When you aggregate by property, all domains inside a specific URL will be combined under one entry. E.g. dataddo.com/connectors and dataddo.com/platform will both be counted under dataddo.com.
Aggregation by Page
When aggregating by page, each unique URL will be counted once, even if they are pointing to the same page.
While the numberw will match those in your GSC UI, aggregated totals by property and page will not match which may appear as data discrepancy.
Metric | Aggregation by Property | Aggregation by Page |
---|---|---|
CTR | 100% (clicks for the whole site ) | 33% (per URL if you have three pages) |
Impressions | 1 per property | 1 per page |
Average position | 1 (highest position from the site in the results) | 2 (for each URL (1 + 2 + 3) / 3 = 2) |
For more detailed information, please see Google's official documentation.
Aggregated Data Discrepancies
If you aggregate your impressions or clicks data by countries or devices, the data will not have any discrepancies.
Metrics combination | Number of rows per day |
---|---|
Date + country | Around 200 rows per day |
Date + device | Around 3 rows per day |
Date + country + device | [number of countries*number of devices] amount of rows, aka around 600 rows |
However, if you aggregate values by query and/or page, there will potentially be an infinite number of rows due to the very large or infinite number of search queries. This is where data sampling starts and while as much data as possible will be shown, it will not be all data (all search queries).
This means that while impressions or clicks per query will be the same, the aggregated values for data in your GSC and data extracted by Dataddo will be different. (Trends should be the same.) The exact same thing applies for the page dimension.
Solution
To avoid data discrepancies, use only date, country, or device dimensions or their combination for totals.
Also when selecting your dimensions, for less data discrepancies, use as few as possible.
Cannot Retrieve Fresh Data
Google takes between 24 – 72 hours to process data which is why it’s possible to get data only from 3 days ago or older.
For Google Analytics, YouTube, or Google My Business, change your date range expression to 3d3 or older.
For Google Search Console, change your date range expression to 4d4 or older.
You may get fresh data from Google Analytics 4 but keep in mind that it might not be the finalized version.
Related Articles
Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.