https://www.growthbook.io/
Join Slack
Hi team, we are using big query data source. I found that when I add a boolean denominator to a metr...
# announcements
s
Hi team, we are using big query data source. I found that when I add a boolean denominator to a metric, it would cause the experiment display no data. Also, when I added activation metric to the experiment, it would said no data too. Could anyone help on troubleshoot that?
https://app.growthbook.io/experiment/exp_19g61oleg1il07
Copy code
-- revenue metric
SELECT session_id, timestamp, value
FROM `analytics_table`
WHERE
  DATE(timestamp) >= '{{ startYear }}-{{ startMonth }}-{{ startDay }}' AND
  DATE(timestamp) < '{{ endYear }}-{{ endMonth }}-{{ endDay }}' AND
  event_type = "measure.performance";

-- result
session_id, timestamp, value
04109507985808136, 2023-02-22 04:08:12.968000 UTC, 100
15543816462148774, 2023-02-22 18:47:04.647000 UTC, 100
3077078075067108, 2023-02-22 19:17:07.746000 UTC, 80

-- boolean metric
SELECT session_id, timestamp
FROM `analytics_table`
WHERE
  DATE(timestamp) >= '{{ startYear }}-{{ startMonth }}-{{ startDay }}' AND
  DATE(timestamp) < '{{ endYear }}-{{ endMonth }}-{{ endDay }}' AND
  event_type = "event.user_login";

-- result
session_id, timestamp
09394803480633995, 2023-02-16 05:21:27.067000 UTC
04109507985808136, 2023-02-22 04:08:12.971000 UTC
584359669554074, 2023-02-22 18:44:43.114000 UTC
8744928360643573, 2023-02-22 18:45:59.913000 UTC
15543816462148774, 2023-02-22 18:47:04.649000 UTC
024268435383898,  2023-02-22 18:49:12.402000 UTC
957748078153098, 2023-02-22 18:50:27.199000 UTC
3077078075067108, 2023-02-22 19:17:07.751000 UTC
cc: @fresh-football-47124 @future-teacher-7046
f
Hi Franky
s
Hi Graham, I don't know why I can see a chart with some data in metrics tab, but it would show no data in experiments tab. Also, as the data I captured above, we can find some session_id exists on both SQL
f
the metric page will show an overview from all your data, not specific to any experiment
on the experiment page, we join that data to the experiment exposure query using whatever user attribute you defined - typically user id
typically the conversion window is what causes the problem with 0 data showing up in this case
s
What's that means? I'm selecting data from Jan 01, and those data was just created this morning
some metric with very similar SQL can show the result, but the one had denominator can't
f
are you able to run the full query SQL directly and remove the denominator part ?
s
If I remove the demoninator, the experiment works
f
from the UI or from the query? perhaps you can DM me the two queries and we can try to debug what’s happening?
s
I'd sent that yesterday in DM
Anyone else can follow up on this?
f
Hi @square-book-75964 - Sorry for the delay
let me take a look at the raw sql
s
thank you so much 🙏
81 Views
Open in Slack
PreviousNext
Powered by

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.

Powered by