Hello, We have access to Mixpanel raw data via Bi...
# questions
v
Hello, We have access to Mixpanel raw data via BigQuery and would like to replicate a couple of charts from Mixpanel UI with a SQL query so that we can automatically add them into our internal reporting. We need to count unique monthly users that triggered at least 1 session. If I run below query, the numbers I get are ~80% compared to the ones I see in Mixpanel UI How do we need to query raw data to get a closer number to the UI? PS: I've tried using distinct_id instead of mixpanel_user_id but the discrepancies are even higher