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.
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:
Give the field a good name you will find later.
In the Blend Data view you can now join with this new dimension.
e.g. one table with impressions from GSC and Bounce Rate from GA