Welcome to WebmasterWorld Guest from 54.161.227.32

Forum Moderators: Robert Charlton & andy langton & goodroi

Featured Home Page Discussion

Google announces GSC and Google Data Studio connector

     
11:03 pm on Feb 8, 2017 (gmt 0)

Moderator This Forum from US 

WebmasterWorld Administrator robert_charlton is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Nov 11, 2000
posts:11768
votes: 274


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]

5:12 am on Feb 9, 2017 (gmt 0)

Moderator from US 

WebmasterWorld Administrator keyplyr is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Sept 26, 2001
posts:7750
votes: 262


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?
5:32 am on Feb 9, 2017 (gmt 0)

Moderator

WebmasterWorld Administrator ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Apr 25, 2002
posts:8438
votes: 210


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
6:16 am on Feb 9, 2017 (gmt 0)

Moderator from US 

WebmasterWorld Administrator keyplyr is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Sept 26, 2001
posts:7750
votes: 262


Excellent, thanks ergophobe.
3:20 pm on Feb 9, 2017 (gmt 0)

New User

joined:Sept 2, 2015
posts: 2
votes: 0


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?
5:32 pm on Feb 9, 2017 (gmt 0)

Moderator

WebmasterWorld Administrator ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Apr 25, 2002
posts:8438
votes: 210


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
11:57 am on Feb 13, 2017 (gmt 0)

New User

joined:Sept 16, 2015
posts:25
votes: 1


@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)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members