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.

Google Analyitcs Landing Page with just paths

Google Search Console with Landing Page full URLs

So the difference is the which is missing in Google Analyitcs’ data

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 using:

CONCAT(‘',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.

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

Head of #SEO at