What No One is Saying About GA4 and BigQuery

Подписаться 2,6 тыс.

Просмотров 2,8 тыс.

50% 1

Is BigQuery or Google Analytics 4 right for the work you are doing? I'll share some pros and cons from personal experience so you feel ready to make that choice.
0:00 - Intro
0:32 - Dashboard Cheat Sheet
0:54 - GA4 Quick Facts
2:45 - BigQuery Connection
3:47 - What's the Issue with BigQuery & GA4?
4:53 - Mediauthentic Examples
8:04 - Jumping into BigQuery
10:00 - Wrap-Up
👇 Grab The Dashboard Cheat Sheet 👇
datastudio.vip/youtube
👇Explain It Data Studio Visualization👇
datastudio.vip/youtube
Learn About What I Am Trying to do
👉 datastudio.vip/learn
Apply To Work With Us. (Done for you)
mediauthentic.com/youtube
Learn On Your Own!
datastudio.vip/learn

Опубликовано:

26 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 12

@EricPecharki Год назад

That was great! It helped me to understand a little more about the nested data in BigQuery. Quick question: The company I work for is a Global company with more than 68 different country websites, using basically the same hostname (the only difference is the subfolder: e.g.: /en for USA or /en-it and /it-it for Italy). I'm struggling to create a Country filter based in the "page_location" to get the "page_title" of the page.. It doesn't work.. Do you know a way to solve that? Thanks again!

@Vision-Labs Год назад

It should work. If you are using the default GA4 connector to test it out, then BQ to create a query where the page contains your string should work just fine. if you send us the query we might be able to point you in the right direction. -> Just join lookerstudio.vip/cheatsheet here and hit reply to any of the emails

@EricPecharki Год назад

@@Vision-Labs I'm using the BigQuery connector right now.. The GA4 connector worked fine, but with the Quota limits, I had to change to BigQuery. I'm going to send it by email for you guys! Thank you so much!

@hannahriibeiiro Год назад

Very useful this video. Could you please tell us what is the logic behind your queries in bigquery? Like, how did you achieve the session source? did you use the first value of the source of a specific session?

@Vision-Labs Год назад

Ohhhf that’s a touchy one to answer in a yt comment. We use the session if & the first know source of that information. Feel free to shoot me a message at hello@betterthandata.com for more info if. That works for you, -JJ

@solomonpaul-nn3hu 5 месяцев назад

Would unnesting all the column make it more expensive and would it have any chance of losing data if unnested please?

@Vision-Labs 5 месяцев назад

If you un nest it would make it more expensive. But no "lost data".

@peterheise6537 Год назад

So session source is not reliable but how about session medium?

@Vision-Labs Год назад

There are a ton of nuances to all attribution in BigQuery. Just keep that in mind in general that they won't line up exactly. - JJ PS, if you want to join BetterThanData.com/Join, we have an entire course where we use BigQuery & Analytics Canvas to get super close

@peterheise6537 Год назад

@@Vision-Labs thank you!

@yeti402 Год назад

Wow, BigQuery is a complete nightmare, congrats Google! If 'session source' is not viable, then what else is also not viable?! Starting to think BigQuery is a huge nothingburger.

@Vision-Labs Год назад

It really is just more complicated and inconsistent then it needs to be. -JJ