GA4 Tutorial: 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 for M...
And view our blog for written instructions & code snippets: https://twooctobers.com/blog/new-vs-r...
00:00 Introduction: The chart we’ll create
00:39 Scorecards for new users and returning users
01:23 Why this chart isn’t easy with GA4 data
02:00 Creating a data blend
04:22 Understanding full outer blend
07:13 Understanding COALESCE
10:43 What's the value of new vs. returning users?