https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
p

proud-branch-6232

02/19/2024, 4:21 AM
Hey team, we have an issue with receiving data from a GB experiment • In our project we use GTM, GTM connected to GA4, GA4 connected to BigQuery using BigQuery Links • Some events are passed using datalayer.push(data) • In GB we added GA4 as a data source (we can see GA4 metircs) and in the Metrics and Data => Metrics section we see how data changes • In the project also added Feature Function (boolean) GB experiment is launched, but we see next messages: ◦ No data yet. Click the “Update” button above. ◦ Error: Error Processing Query Results ◦ Failed to run a majority of the database queries ◦ pop-up shows SQL error: Unrecognized name: user_id Any ideas where to dig? 🙂
b

billowy-lizard-55653

02/19/2024, 2:01 PM
Can you see the user_id column in BigQuery?
p

proud-branch-6232

02/19/2024, 2:47 PM
This one?
b

billowy-lizard-55653

02/20/2024, 10:10 AM
That's the one. I'm quite new to this too, but check that the identifier type you have under the metric is the same as (or one of) the identifier types you have under the experiment. Under Results, click analysis settings and then look at identifier types. This may be what you need.
🙌 1
p

proud-branch-6232

02/20/2024, 11:51 AM
I think problem is that user_id is null We changed SQL query • added user_id (it was missing 🙂) • removed
value_param.key = 'value'
because it triggered another error Now we don’t have errors, but still don’t have user_id Any ideas why user_id NULL in bigquery?
b

billowy-lizard-55653

02/20/2024, 12:15 PM
i believe user_id is intended as an identifier for logged in user, so if you don't have such an id or do but don't send it to GA, it will be null. if user_pseudo_id suffices, it may be easier to ignore user_id completely - don't have it as an identifier type, or in the query at all. just make sure metrics are using the same identifier.
p

proud-branch-6232

02/22/2024, 2:14 AM
We found a problem in the GTM, it seems we didn’t add at the moment Event Setting tag (with user_id parameter) to all events
10 Views