🔴 First Look: Data Blending in Google Data Studio

Google Data Studio Data Blending lets you combine data sources in one visualization. Let’s take a look at the new Data Blender together and see how the new feature works.

OUTLINE:
0:00 - Introduction
1:28 - What is Data Blending in Google Data Studio?
1:45 - Why is Data Blending Important?
2:28 - Setting Up a Table Without Data Blending
4:28 - Blend Facebook and Google Analytics Data in a Single Table
6:05 - Blending Your Data Sources
6:45 - Choose a Joining Key
7:40 - Adding Metrics to Your Table
10:35 - Custom Metrics with Blended Data

#DataVisualization
#GoogleDataStudio
#Dashboard

🔗 Links:





👍 FOLLOW US

[MeasureSchool]

0:00 - Introduction
1:28 - What is Data Blending in Google Data Studio?
1:45 - Why is Data Blending Important?
2:28 - Setting Up a Table Without Data Blending
4:28 - Blend Facebook and Google Analytics Data in a Single Table
6:05 - Blending Your Data Sources
6:45 - Choose a Joining Key
7:40 - Adding Metrics to Your Table
10:35 - Custom Metrics with Blended Data

[spurinteractiv]

Hi Julien, Great video. Can you tell us if we can join two data sources using campaign join key? There is a possiblity that campaigns in 2 data sources were running at different time periods. Is it possible to combine them using campaign joint key? Will wait for your answer. Thanks!

[derekswitzer]

hello! great video!! it looks like this is something that can only be utilized/used for table sections of your DS report? if you have 2 big query tables/views that you want to segment using a dropdown, what would the process be for that? would you just add all fields from both datasources that you are blending so they would all be available to the whole report? thx again!

[ramesh]

Hi Julian, I have two questions. 1. If I want to show say each campaign metrics and all campaigns metrics for that account, separately how to do that?. 2. If I want to show say CTR for the last 12 months, month by month either in a tabular form or chart form, how to do that?

[leehurst]

Another great candid walkthrough! Question: I know you can't create a new field for the blended data resource for conversion rate comparing the two base sources (yet), but couldn't you create calculated fields for each source and put them on the joined table? Always limitations, but it really opens new possibilities! Adding to the Google Data Studio Resource finder with 5 stars!

[andysimpson]

Great video, it's made me start thinking of what data I can blend from GA and GSC...any thoughts?

[sonelalsingh]

Nice Video. Can we blend the data from the single source(combining the multiple, not relevant table data)?

[shellomaticbi]

My question is the join between 4 tables, what should I put in the multiple keys.

[DutchMediaTV]

I work for a small ad agency and am looking for a way to combine some top line digital and traditional media reporting (eg TV/radio) within data studio. Given the different media outlets typically have completely different post reporting formats, thinking the best way to combine will be via Google Sheets and importing these into DS. Hoping to be able to blend these with some other digital connectors so just unsure of the best way to setup . Presuming the best way would be to blend daily or weekly spend, or even reach by media over a set time period, and then compare the impact of these with website activity?

[jordcodes]

Great vid! Really enjoyed it. Do you know if google fixed the issue of using custom calculated fields / metrics with blended data?

[AbdulRashid-zmxq]

Hi measeureSchool, i try to connect google analytics and google ads, Facebook ads for Blending data its showing error message, User Configuration Error
month, how

[smartup_automation]

Thanks, great video! is it possible to create a field using 2 data sources? I want to create a ROI: as spent from FB and sales from CRM, how I create this field? via blend data?

[marco_]

Hello Julian,
thanks for this very useful tutorial! I've a question about using dimension on blended sources.

I've create a dashboard blended datas from two Google Search Console sources (HTTP and HTTPs property) then I put my data on a time series showing clicks from the two HTTP and HTTPs properties.

On the same graph I put the impressions metric too.

Now, I would like to insert a filter (dimension) allowing me to show both clicks and impression or only clicks or impressions. Is it possible? The source is a blend source and dimensions available refers to the single source.

Thanks!

[nachotortosa]

Thanks for sharing this !!! You are the best !!!

[sonusaha]

In PHP website How to Embed the Data Layer code on my Website?

[idand]

There is no option for calculated field on blended data, right? for example - sum the same metric from 4 data sources...

[pieterprincee]

Can you blend two google analytics account in one graphic on data studio?

[ianmonat]

Sept 2020 and you still can't build a custom field in a blended data table =(

[jahangeer.ansari]

How do I to join Google Analytics and Google Ads? I can’t find a join key that matches.

[nandinibansal]

How can we blend 2 Google Ads account in Data studio