[Sofia]

Yes, your understanding is correct. You’re trying to use a multi-condition CASE statement in BigQuery to categorize traffic sources for your GA4 data. In specific scenarios where utm tags aren’t present, you’re looking to designate the utm_medium as ‘organic’ and the utm_source as the referral site. You’re curious if this CASE statement approach can be executed in BigQuery.

[Sofia]

Sure, so essentially the error you’re seeing is because the ID you’re getting from Firebase isn’t in the right format. The ID should be a 32-digit hex number, but the one you have is only 22 digits.

So, what you can do is firstly, in Firebase, allow streaming into BigQuery tables. Find the app_instance_id or client_id there – they’re under labels that say ‘user_pseudo_id’ and ‘user_id’ respectively.

If that doesn’t work, you could use a proxy, like Charles or mitm, to get the exact logs from your app and find the ids there.

A third option is to use Android’s ‘adb’ tool. This lets you dig into logs while your device is connected to your PC. You can search the logs there to find the correct ids.

Basically, there are multiple ways to get these IDs – you just need to figure out which one works best for you.

[Sofia]

I completely understand your concern. The behavior you’ve described does indeed seem strange, especially given the wording on the Insights creation page. While ensuring every team member has the “Viewer” permission at property level might work, it’s not the most scalable solution. The symptoms do point towards ‘inheritance’ permissions possibly not working as intended for Insights. In this case, contacting Google’s support team to report what you’ve found might be the best course of action. This could be a case of an oversight in Google’s systems or simply a lack of clarity in their instructions. Either way, getting clarification directly from the source should provide the correct course of action.

[Sofia]

It turns out that patience was key here—two days later, BigQuery finally decided to connect to GA4 without any additional changes on my end. It seems that the setup process can take a few days and unfortunately, there’s no feedback mechanism in place to keep you informed while you wait.