April 1, 2020
🔴 First Look: Data Blending in Google Data Studio

🔴 First Look: Data Blending in Google Data Studio

In this video, we’re going to take a first
look on the new data blending feature in Google Data Studio. All and more coming up. Hey there, welcome back to another video of
measureschool.com teaching you the data driven way of marketing. My name is Julian, and we are live right now talking about the new Data
Studio feature of Data Blending. Now, if you are aware of our other tutorials
we did on Data Studio, you might know that we took the work around at that time, at least
to pull in data to Google Sheets, blend it together and then importing it into our Data Studio
dashboard. This gave us a lot of flexibility. But at the same time was a little bit inconvenient. Now Google has done something about it, or
at least the Google Data Studio Team, because they have announced the community connectors
that actually let us pull in data from different data sources, then the Google products into
Google Data Studio. So we can now pull data through third party
connectors, like super metrics directly into Data Studio with these new functionalities
of these data connectors. And that is important for Facebook Ads. Now, what we are not what we were not able to do
is actually take that data and then blend it together with other data sources. What do I mean by blending? Well, if you wanted to have data from Facebook
Ads, and Google Analytics in one table or in one visualization, that was not possible to
do within Google Data Studio, you would still need to go back, for example, to a third party
system like Google Sheets, or a database blend the data there together and put it then into
Google Data Studio. This has now been fixed with a new feature
of data blending within Google Data Studio and
we’re going to take a first look. So without further ado, let’s dive right into
our little demo here. So I’m here at Data Studio, let’s just come
up with a completely new report. And at the beginning, we are asked to choose
our data sources. Now, I’ve already connected my facebook account
and my Google Analytics account, I actually want to just demo this. And let’s find out how many clicks we had
on our Facebook ads campaign. So I’m adding this to my report. And we get our familiar Canvas em, now I will
work with dates. So I’m going to just put this date picker
right here and select the range, let’s go to some old data we have in the system
from November, let’s go with the 15th year. Okay, so this is already pre put in here. Now, the next thing I want to do is actually
make a table. And in this table, I want to show my Facebook
ads not by campaign name, but actually by that date. So up here, we can choose our dimensions and
our metrics, what I want to do is choose the data dimension, so we have appear time and
this the super metrics connector to Google Data Studio, that you can then connect to
your Facebook ads account, I have done this in this case, we are simply go with the date
dimension. And as you might know, dates are in a in a
spreadsheet, they are really the columns that you put in here. Now for the rows, I actually want to not have
impressions here, I want to show the actual clicks that we had on our campaigns. So I’m going to go here to campaign and go
with the link clicks. And let’s get rid of, well, we can leave in
the impressions doesn’t really matter. Now, what I want to do is actually know how
many people converted. What I can do from my Google from my Facebook
data is, obviously if I use the conversion tracking of Facebook, I can put that in as
well. But Facebook will always give me different
data, maybe that will be a great thing to actually compare if I can find the right metric here. Because as you might be aware, the website
conversion value, Facebook API gives us a lot, a lot of data to look into. And I don’t, I’m not quite sure how I tag
this, if this is just a custom conversion. Let’s see if that does the trick. Yes, we have custom conversions here. So this is what Facebook actually records
from the facebook pixel. Now, I want to compare this with Google Analytics
data, right? Google Analytics has a different attribution
modeling going on. Because you might know that Facebook is really looking just at how many people come
to their website, click or come to the website, and then convert and
they look back, if there was any contact point with Facebook, it will be attributed to Facebook. And Facebook will show that Google Analytics
is different to that because its last click wins, or the last source that brought the
traffic to your website, and then converted how many people that and how does that compare
to Google Analytics. Now, I could do this in spreadsheets, obviously. But for demonstration here, we want to actually
blend this data with our Facebook Ads data. And there is this new functionality here in
the data sources where we see blend data. And I’m going to click this, this opens up this new menu down here, where
we have our data sources. And we can blend multiple data sources to
each other or into each other I guess. The data source that we are predominantly
using right here is Facebook ads, this will be our primary data set, I’m going to add
a data set to it. And available sources here, I’ve already connected
this is my Google Analytics account. So I’m going to add this to the report. Now, we have two reports in here. And we want to join this. Now, in order to join data with each other,
you will need to have a Join key. Join key and databases, they’re also called
primary keys are date metrics that you have in both data sources that are aligned to each
other. So in our case, it would be the date obviously,
the data is not is in Google Analytics and in Facebook ads, and it would match that up correctly. What you could also do, if you have tagged
your UTM parameters in your Facebook ads correctly so that through, for example, the source medium
or the landing page so, you need to have a join
key in order to align this to the data sources together. And we have date here so that is all fine. Now the last thing I want to do to make this
a little bit bigger is to actually add a metric to this, now that that data is aligned,
we can add the metric. And in our case, I want to just take a goal
completion on my case, it would be the email sign up, find the right one here. That is the goal completion. Yes. And we’ll just drag that in. Let’s save this and see what it does for our table. Now we have our email signups in here. Now, you might notice that this is kind of
screwed, because we have that many link clicks. And we have so many email signup. So it’s much higher than we would expect here. For the clicks that we are getting on this
day. Maybe it’s much higher, it’s actually a little bit beneath it. But what you always need to keep in mind is
that when you pull data from a second data source, that doesn’t mean that it’s automatically
filtered based on the data source that it’s connected to. So in our case, we actually would need to
say, or these email signups that we see right here are email signups that are originated
from maybe different sources that came into our Google Analytics account. These are the totals of all goal completions
on that day, just added to this, this table here. And therefore, we need to go in and actually
implement a filter. So we can add a filter here. And we’ll just call this Facebook traffic. We want to the data sources master and only
include we have here our dimensions, let’s go with the source medium and condition should contain Facebook.com. I think that’s what I entered as the as the UTM parameter so that should be correct. Let’s just save this, save this again. Now our data should be filtered down, or at
least that column of email signups to only the Facebook data. So here we go, we see that it’s much lower,
and the sources have been attributed differently. So we can look at what Facebook actually says
it generated 71. What Google Analytics says it generated from our
Facebook source quite interesting to see. Now if I would be honest, I would like to
know the conversion rates, right. So I would like to put in a another column
here saying what is the conversion rates between the link clicks and a website conversions. This is easily done for a native data source. So if we have Facebook ads, just as a data
source or just Google Analytics, we could build a custom metric or a custom calculated
metric from this. Unfortunately, this is not something you can easily do or
not something I found in the interface at least to be something that you can do in the
blender data form. So once you use blender data the custom metrics
out of the play you can’t know the you can’t calculate the link clicks, conversion rate
to the email signups of goal completion for. That said, probably something that they’re gonna fix
at some point. For now, if you really need to do this, I
guess you would need to go to something like Google Sheets Connector again, and do this
first and Google Sheets and then import the data. But overall, a pretty interesting feature
that they have added and it was something that people needed. It also just simply breaks up the whole data
silos, silos, right? You have data silos. Now you can import them into one dashboard. But they’re still silos in itself. But now you can blend them together and have
much more interesting insights, I think in terms of comparing data, putting it together from different
systems. That is really the power of building a custom
dashboard. Then just looking at a dashboard and Google
Analytics or on Facebook ads, this is something that we really needed and it’s now implemented
into Google Data Studio. Alright, that’s it for this little demo. If you have any more questions, then please
leave them in the comments below. We also have new videos coming out all the
time and live streams so be sure to subscribe to this channel and also check out this video. My name is Julian. Till next time.

18 thoughts on “🔴 First Look: Data Blending in Google Data Studio

  1. 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!

  2. Thanks, Julian. One other thing to keep in mind specifically when looking at Facebook Ads conversion data by date, is that by default, FB attributes the conversion to the date of the last ad click or ad interaction and NOT to the actual date that the conversion occurred. It’s possible to view the conversion by the actual conversion date by using the Facebook Ads Insights API but I’m not sure if the SuperMetrics community connector provides that functionality or not. Just something for folks to be mindful of if they are looking to blend FB Ads Conversion data with other data sources by date!

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

  4. Data studio is fucking garbage and so behind its competitors. It's hard to believe this product is affiliated with Google. You can blend data, but there is a limit on the number of KPMs you can include? You can auto aggregate formulas, but when you 'blend' the data to create a new table, your aggregation options then get limited to just sum, avg, min, and max? I can't even calculate a simple fucking percentage on a blended table. WTF is this 3rd world BS?

  5. 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?

  6. 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?

  7. 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.


  8. 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!

  9. How can i blending 3 nested tables?


  10. hello, whats the useful from blending the data ? and can you please give me a short explanation about the data in the table? thanks

Leave a Reply

Your email address will not be published. Required fields are marked *