Connecting Looker Studio to Views in BigQuery

Stockton teaches you how to connect Looker Studio to BigQuery using views.

👇 Grab The Conversion Rate Cheat Sheet 👇
https://datastudio.vip/youtube

👇Start Exploring Your Marketing Teams Data👇
https://mediauthentic.com/youtube

Learn On Your Own!
https://datastudio.vip/learn

0:00 - Intro
0:30 - Grab The Conversion Rate CheatSheet
1:33 - Rebuilding GA4 Report in BigQuery
6:50 - Using Sub Queries
12:15 - Comparing BigQuery to GA4
15:27 - Saving the Query as a View
17:47 - Connecting to Looker Studio
19:55 - Wrap Up

Here's the query used:
SELECT
event_date,
(select value.string_value from unnest(event_params) where key = "page_location") as page_location,
event_name,
count( distinct user_pseudo_id) as users,
count( distinct concat(user_pseudo_id, (select value.int_value from unnest(event_params) where key = "ga_session_id"))) as sessions
FROM
`PROJECTID.DATASETID.events_*`
WHERE
_table_suffix between "20230216" and format_date('%Y%m%d',date_sub(current_date(), interval 1 day))
GROUP BY
event_date,
event_name,
page_location
ORDER BY
sessions desc