Hello GrowthBook! Can you help me to understand w...
# ask-questions
m
Hello GrowthBook! Can you help me to understand what am I need to do, to see some metrics in your dashboard? My app uses Next.js. I integrated your service on front-end part via "@growthbook/growthbook-react" Created experiment in dashbord. Created DataBase in BigQuery. In 'Data Sources' connected to BigQuery -> GA4. But when I tried to 'Run Analysis' in 'Metrics' I have error: "Error Processing Query Results Failed to run a majority of the database queries" What should I do? Am I need to create tables in DB by myself?
s
There's a lot to unpack here. Here's where I'd start: • Do you see data from your Next app in GA4? • Do you see that data in BigQuery? • If that's there, then you'll need to check the DB connection in GrowthBook to ensure the query is returning data.
m
• I see my custom event in GTM which I created with trackingCallback (https://prnt.sc/JI5OHEQ6WfeN) due to your docs here - https://docs.growthbook.io/kb/google-analytics/google-analytics-ga4-troubleshooting • Today I see new table 'analitics_{numbers}', which I didn't created myself in BigQuery • For checking connection, I got to 'Data Sources' -> needed project and I see 'Connected' (https://prnt.sc/HtIkHB1Bb99K), am I wright? But when I go to 'Metrics' I see error (https://prnt.sc/vetftvaXD7Oy) Maybe I'm doing something wrong, and watching in wrong places? But did all like in docs.
e
@strong-mouse-55694
s
It looks like the data is there, but the query/metric isn't right. If you go to SQL Explorer, you should be able to explore the data. You can first confirm the values are there. Then, on the metric analysis section, click the three dots next to Run Analysis. That'll let you see what the actual query is and you can compare it to how your data looks in BigQuery
m
@strong-mouse-55694 I have an issue. In 'Metrics' I have error, cause it tried to get wrong table with name 'analytics_growthbook' , but I don't know where it get such name. If I'm trying to create SQL Query in SQL Explorer, it return to me some data. Maybe this why I don't see any metrics? And second question, where can I change this table name for queries in metrics? (https://prnt.sc/CkO_v3lDROcw)
s
Possibly. I'd first check your data source and make sure it's configured correctly.
e
@strong-mouse-55694 is there a standard set of table names? Regarding the configuration for big query is there documentation we could refer to to confirm the correct configuration?
s
Are you using GA 4 to send events to BigQuery?
e
@strong-mouse-55694 Yes
s
When you connected the data source, if you selected GA 4 for your events, it should map pretty well out of the box. If you go to data sources, select your data source, and click the three dots in the top right, you'll see an option to Test Connection. That should pull in your default data source.
e
@strong-mouse-55694 we use segment does that make a difference?
s
Yes! It's likely trying to parse your data as if it were coming from GA. For testing, try re-adding your data source, making sure you select BigQuery and then Segment. With that set up, see if it pulls in the data correctly or not.
m
@strong-mouse-55694 Sorry, we are trying to parse data not from Segment, we trying to do it from GA4. We tried for test connect BighQuery and Segment, but then returned to BigQuery and GA4. I think @echoing-activity-788 saw that in Data Sources there were two items, and second was Segment, but we didn't use it. Up to your previous message I selected GA4 data source, clicked on three dots: https://prnt.sc/ceIbwQNUs-r_ Then clicked *Edit Connection Inf*o, and Test Connection. It say that Connected Successfully: https://prnt.sc/ppQVN2P6NElP But still nothing in Metrics. Maybe I should remove this connection and try to do it again? But we did it few time, already.
s
It shows your default data set there, "analytics...", is that what you expect? It looks like there may be different options. The key here will be to ensure that your queries match what's included in BigQuery. In the app, you'll be able to see what the queries are, you can then copy the query from GrowthBook and then run it in BigQuery to help troubleshoot. While we try to get it working out of the box, there can be differences in the data schema that don't make this possible.
e
@strong-mouse-55694 we have a small number of users (3-5) on our "test" site where this installation is. How likely is the no data received status we're getting related to the number of users?
s
If you only have 3-5 users, that definitely could be causing issues. Do you see data in BigQuery? GrowthBook has thresholds that need to be met before it shows results.
m
@strong-mouse-55694 Yeah, I see three items
s
Does one align better with what's in your dataset?
e
@magnificent-umbrella-30985
m
@strong-mouse-55694 Not exact
s
So, those options are pulled directly from the BigQuery, so they should match exactly. This is just giving you the option to choose which one to use as the default. If you're not seeing what you expect, then that points to a larger issue with your data source, like it not being the right one.