Hi all. Currently running a test just to make sure the connection works between our data warehouse and Growthbook, and it's been running for a few hours and there have definitely been several thousand "Experiment Viewed" events sent, but in the report of the experiment it only shows 5 users 😂 Trying to figure out why it's not showing more info?

After clicking on

update

also?

Yep, updated after 1 and 3 hours, says the same thing.

Did you already click the dots in the upper right corner > view queries > copy & execute these queries on your data warehouse to verify you get the same results? That should be the case & explain where it’s going wrong.

Koen's advice is spot on. Some potential issues: • Experiment assignment query (EAQ) is misconfigured in growthbook, you'll see this near the very top of the queries we run for your experiment. Your EAQs are defined in your Datasource. • Date ranges are off for some reason, check the dates we're using in the SQL • Make sure the id we are using for your anonymous_id are the right ones given what you're using for your IDs in segment

Something's a bit weird with the query. Running it by the data team.

Update on this? I am having the same issue

I didn't have my Data Source or Fact Tables set up correctly. Here's a generalized version: • Configured Segment as our data source using our Postgres replica configuration. There wasn't too much documentation for this but we set up a secure account and used that to connect properly to Postgres from Growthbook. • Set up Fact Tables with proper SQL targeting the specific Postgres tables, both from our marketing site and from the app. ◦ We also had to make sure we were indexing properly as non-indexed tables can take a really long time to run analysis on. • Set up Metrics based on those fact tables