Hello. I'm comparing amplitude data we get in snowflake vs what we see in amplitude web funnel analysis and we have more count of events in Snowflake. Why is this and is it possible to get a perfect match to amplitude web? I'm holding session id constant and doing the same in snowflake SQL.
Page 1 / 1
Hey
I haven’t personally compared funnels conversion numbers between Snowflake and Amplitude yet, but here are a few of things I like to check when comparing my ingested data from Snowflake.
- Comparing between Uniques vs Totals
- Timezone in your Amplitude project vs Snowflake
- Number of dropped events while ingestion
From what I understand, getting a perfect match might not be realistic given that the funnel chart uses some custom parameters which could be tricky to replicate in Snowflake. But this could be a good learning exercise from my experience.
Hope this helps!
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.