Member-only story
Joining multiple data sources in Google Data Studio
Hey Data enthusiasts ! I am back again with a Google Data Studio article! I know that I have talked about Google Data Studio here about its comparison and also talked about why I don't like Google Data Studio.
Believe it or not BUT! Data Studio is powerful because you can bring in 400+ sources of data into a single report. Thanks to a new feature, blended sources, it just got even mightier.
The best way to think about blending data is JOIN in SQL . You have two data sets. Each data set has unique information .
But they have (at least) one data point in common.
This shared data point is known as a key. If your data sets do not have a key, they’re not blendable.
You blend your website behavior report from Google Analytics with your app usage report. This gives you all the records from the first report along with any matching ones from the second; or should I say that if a user has visited the site and used the app, they’ll be included. If they only used the app but didn’t visit the site, they will not be included in the new blended data.
