Google announces GSC and Google Data Studio connector

[Robert Charlton]

Google has announced tools for accessing some of that fabled "not provided" information, which up until now has required outside tools and some fairly elaborate reverse engineering to turn Google Search Console information into useful keyword reports...

Data Studio: Search Console Connector
February 8, 2017
[analytics.googleblog.com...]

....Search Console’s Search Analytics feature shows webmasters how often their site appears in Google search results for various keywords. This data is extremely powerful but currently lives in Search Console’s Search Analytics Report and is hard to combine with other data sources. Today we are announcing a new Data Studio connector for Search Console. With this launch users can pull their data into Data Studio to build reports that include impressions, clicks, and average position broken out by keyword, date, country, and device.

Today we are announcing a new Data Studio connector for Search Console. With this launch users can pull their data into Data Studio to build reports that include impressions, clicks, and average position broken out by keyword, date, country, and device.

Thanks to Pete Prestipino of Website Magazine for this alert [websitemagazine.com...]

Previous discussion about Google Data Studio on WebmasterWorld has been limited at best...

Google Analytics Rolls Out a Number of New Features
Apr 15, 2016
https://www.webmasterworld.com/analytics/4800736.htm [webmasterworld.com]

[keyplyr]

This is significant, and should greatly benefit site owners.

I looked around GSC but could find where the Data Studio connector for Search Console is. Not live yet?

[ergophobe]

The connector isn't in GSC. You have to add it as a data source.

The thing is, you've been able to do this roughly ever since Data Studio launched, but it took an intermediate step - in the past, you needed to pull search console data into a Sheet, and since you can pull Sheet data into DS....

This just makes it easier, but it's not like some huge new data source became available.

This is how you get Sheet data into DS
[support.google.com...]

And this pulls Search Analytics into Sheets
[searchanalyticsforsheets.com...]

So now it's one step instead of two

[keyplyr]

Excellent, thanks ergophobe.

[jamiewhite]

Just been playing about with this - looks really neat. One annoyance though, when adding Avg Position onto a chart along with a different metric such as Impressions, the Avg Position axis counts up (and therefore shows better positions lower down), unlike in GSC. Unless anyone has figured out how to reverse the axes?

[ergophobe]

By the way, Google has been steadily adding connectors, the current list is here

As of today it includes
BTW, they are always adding to DS. Possibly bigger news is that they added Firebase a bit ago so you can now use DS for app analytics. They also recently added PostgreSQL

Here's the list Google updates
[support.google.com...]

As of today, it includes:

AdWords connector
Attribution 360 connector
BigQuery connector
DoubleClick Campaign Manager (DCM) connector
Firebase (via BigQuery)
Google Analytics connector
Google Cloud SQL connector
Google Sheets connector
MySQL connector
PostgreSQL connector
Search Console connector
YouTube Analytics connector

[sench]

@jamiewhite - had the same issue, so I just used left vertical axis for impressions/clicks, and right vertical axis for position/CTR, since sadly there's no way (afaik) to reverse the vertical axis. this turned out to look pretty good on a compound graph (even with auto limits)