Use Google Data Studio to blend multiple data sources without needing a third-party tool. Before you get too far, make sure you know what is happening within your data sources & reports.
✅ Days In System from CRM & Payment Processor
✅ Total Spend in your organization
✅ How to just show the matching criteria
✅ Me out of breath while hiking?
👇 FREE GDS Cheatsheet & other FREE GDS goodies👇
https://datastudio.vip/youtube
Timestamps:
0:00 - Welcome
0:30 - Introduction
1:36 - Blending & Joining Analogy
2:50 - Left Outer Join
5:51 - Full Outer Join
7:25 - Inner Join
10:07 - Creating Clean Data Sets
10:27 - Creating Fun Facebook Ads for Spend Reporting
11:35 - Explaining Clean Join Keys
15:12 - Building a Left Join
35:00 - Building an Outer Join
41:50 - Building an Inner Join