Google Data Studio: How to join Google Search Console and Google Analytics data with the new data blending feature

Google Datastudio now offers the option to combine / join information from different data sources into one view.

Google Data Studio data blending

That’s great, but in some cases you need a workaround to make the data matchable.

URL and paths are different in Google Search Console and Google Analyitcs

Google Analyitcs Landing Page with just paths

Google Search Console with Landing Page full URLs

So the difference is the https://amp.blick.ch which is missing in Google Analyitcs’ data

How to create custom “join keys” for the Blend Data feature:

Use the “Create New Dimension” feature

Data Studio will help you to create a proper formula.

In this case I added to the landingpage in Google Analyitcs the prefix https://amp.blick.ch using:

CONCAT(‘https://amp.blick.ch',Landing Page)

Give the field a good name you will find later.

In the Blend Data view you can now join with this new dimension.

Results

e.g. one table with impressions from GSC and Bounce Rate from GA