GA4: Reporting on New vs. Returning Users in Looker Studio

Learn how to create a pie chart that shows new vs. returning users using ninja Looker Studio techniques including custom fields, blending data with a full outer join and the mysterious COALESCE function.
Find an introduction to blending data in Looker Studio here:    • Mastering Data Blends: Looker Studio ...  
And view our blog for written instructions & code snippets: https://twooctobers.com/blog/new-vs-r...

00:00 Intro
01:48 The problem with GA4's returning users metric
05;15 A donut chart using Google's metrics
06:47 A different way of calculating returning users
08:07 Creating a new & returning users blend
09:40 A donut chart using our new metrics
11:33 The magic of a full-outer join + COALESCE()