Hi everyone! We need your help with metrics:
What the problem: when we created new metrics, that take data from a custom data source (this datasource was founded on Amazon Athena) we see the results, who have the biggest difference with a true result (when we used SQL script for calculated some metrics directly in AWS)
For example:
• count distinct bets: in datasource, whose connected in Growthbook and have 100% info about exp(2000000 bets for every exp_group, calculated metrics GB give us 25-30% (500000 max for every exp_group)
• turnover has the same situation
We researched GB SQL query for every metric, but didn’t find the problem - changing conversion params on page “Behavior” didn’t help
Maybe someone has a similar case and can help us?