We are unable to get any result for our experiments. We've written the queries as mentioned in documentation. The individual metrics are showing data but from experiments, we can't see any data. Can anybody from the team help debug this issue?

Hey there! Are you able to see the experiment exposure data in your database?

Yes. All the data is present in bigQuery

Great. If you see the data in BigQuery that likely means there's something not configured correctly in the assignment table. Go to Data Sources and select your BigQuery database. You'll want to ensure that the Experiment Assignment Query for your Logged-in Users lines up with what's actually in your database. This is what GrowthBook uses to populate the experiment data.

We did try our level actually but I guess we are making some small mistake. Is there any possibility of getting any help in debugging?

Check these troubleshooting docs: https://docs.growthbook.io/kb/google-analytics/google-big-query-bq-troubleshooting If you go to your Experiment Assignment Queries for your BigQuery data source, you'll see the query for Logged-in Users. You should be able to take that query and check it in BigQuery to see if it returns data properly. If it doesn't, then that means you either need to adjust the query in GrowthBook to get the data or the particular experiment exposure data isn't present.

Hi @strong-mouse-55694, followed the instructions but still the experiments does not show any results. But when I check the queries, there are results

That looks like there's no experiment data, as the variation column is empty. Are you able to show the bigquery data, where the variation (experiment exposure) is logged.

@strong-mouse-55694, I think I got the actual issue. You can see that I wrote

variation_id_param.value.string_value AS variation_id,

in the metric SQL & getting proper results. But when I'm running the same metric form an experiment, it's automatically changing the query to

variation_id_param.value.int_value AS variation_id,

"string_value" is being changed to "int_value" & that's why the results are not showing up. Can you help me figure this out?

You can update the experiment query in your data source settings (Metrics and Data → Data Source → (BigQuery) → Experiment Assignment Queries). What are you using for event tracking? Generally, when using BigQuery, this should work without having to alter that query.

I've followed your instructions & it's working on the experiments which has 1 Control & 2 variations. It's not showing any results in the experiments where there's 1 control & one variation. We're using Google Analytics & Bigquery

You need to go to your Data Sources page and make sure all experiment assignment queries are using

string_value

for your variation IDs.

Things are working fine. Thanks a lot for the help