Connect Google Search Console to Google Data Studio
Directly connect Google Search Console to Google Data Studio, in minutes, and in an easy-to-use format.
Stream your marketing data from GSC to Google Data Studio
About Google Search Console
About Google Data Studio
Why integrate Google Search Console with Google Data Studio?
- Google Data Studio allows you to create interactive dashboards that can help you identify patterns and trends in your website’s search performance and understand which pages and keywords are most valuable to your business.
- Integrating Google Search Console with Google Data Studio allows you to combine data from multiple sources such as Google Analytics, and Google Ads that can help you track how your paid search campaigns are impacting your organic search traffic.
- Google Data Studio enables you to create customized reports to monitor your search performance and focus on the metrics that are most important to you, such as clicks, search impressions, and average position which helps you in determining the impact of your marketing efforts on website traffic and identifying areas for improvement.
- You can easily visualize your data in a variety of ways by connecting Google Search Console and Google Data Studio, allowing you to make informed decisions about how to best optimize your website to increase traffic and improve search engine rankings quickly and effectively.
- Google Data Studio enables you to share reports with others and access them from anywhere, which is useful for collaborating with team members or clients and assessing your SEO performance as a team.
About Google Search Console Google Data Studio Connector
The Google Search Console Google Data Studio Connector pulls Metrics and Dimensions for Google Search Console. The Insights are retrieved at a search query level.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A Google account that is linked to a Google Search Console Account. (Visit our privacy policy and terms of use)
- A Google account for Google Search Console to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect Google Search Console to Google Data Studio?
Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.
Go to “Select Destination” and choose Looker Studio.
Once done, select “connect” and authorize access to your data source.
Google Search Console metrics and dimensions available for streaming into Google Data Studio
| ID | Name | Description |
|---|---|---|
| Account ID | TEXT | The Site |
| Account Name | TEXT | The Site |
| Anchor | TEXT | Anchor of the Page, e.g. if site is https://abc.foo.bar/a.html#anchor1 then this is 'anchor1' |
| Branded vs Non-Branded | TEXT | The value is "branded" if the domain name is included in the search query, otherwise it's "nonbranded" |
| Clicks | NUMERIC | The Number of Clicks |
| Country Name | COUNTRY | Country Name |
| Country Name | TEXT | The Country Name |
| CTR | PERCENT | The Click Through Rate |
| Date | DATE | The Date |
| Device | TEXT | The Device Used for the Search |
| Errors | NUMERIC | Number of errors in the sitemap |
| Hostname | TEXT | The domain name of the Page |
| Impressions | NUMERIC | The Number of Impressions |
| Indexed | NUMERIC | The number of indexed URLs from the sitemap |
| Is sitemaps index | BOOLEAN | If true, the sitemap is a collection of sitemaps |
| Last downloaded | DATE | Date and time in which this sitemap was last downloaded |
| Last submitted | DATE | Date and time in which this sitemap was submitted |
| Page | TEXT | The Page |
| Page Path | TEXT | Full path of the Page, excluding the Protocol and Hostname |
| Path | TEXT | The url of the sitemap |
| pagePathlevel1 | TEXT | Top-level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel1 is 'a' |
| pagePathlevel2 | TEXT | 2nd level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel2 is 'a/b' |
| pagePathlevel3 | TEXT | 3rd level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel3 is 'a/b/c' |
| pagePathlevel4 | TEXT | 4th level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel4 is 'a/b/c' |
| Position | NUMERIC | The Average Position |
| Average SERP position | NUMERIC | The average page number in the Google search results |
| Protocol | TEXT | "http" or "https" |
| Search Query | TEXT | The Search Query |
| Query params | TEXT | Query parameters of the Page, e.g. if site is https://abc.foo.bar/a.html?a=b then this is 'a=b' |
| Search Appearance | TEXT | How the site appears in the search results |
| Search type | TEXT | news, image, video or web, fetching this field could impact the time needed to get response |
| Site | TEXT | The Site |
| Submitted | NUMERIC | The number of submitted URLs in the sitemap |
| Warnings | NUMERIC | Number of warnings for the sitemap |
| Words in Query | NUMERIC | The number of words in the query |
| Today | DATE | Today's date |
Easily connect Google Search Console to Google Data Studio
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.