https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
g

gray-manchester-6518

03/11/2024, 10:28 AM
Hey! We are experiencing discrepencies between the number of Snowplow pageviews in BigQuery we have for a form submit, what we see in Hubspot and what is showing in Growthbook. 78 vs 235 (what is should be) - unique submissions, no duplicate users In fact the numbers in GrowthBook have decreased over time even so something is off. We have found no problems with the actual pageviews. It seems like the problem is in the GrowthBook setup itselt. Since there is no Snowplow documentation yet it is difficult to know exactly the correct way to set things up. We need support in order to troubleshoot this. Anything that looks wrong above? Any common problems that might be causing this that we can look into? Adding the code blocks as a thread to this message.
Fact table.sql
Metric definition.sql
GrowthBook metric query.sql
f

fresh-football-47124

03/12/2024, 6:57 AM
Hi Daniel - its hard for us to tell from here
we do some uniquing for users in an experiment, plus date range limits - are you seeing the difference in value from the metric page?
we do give you the full query with common table expressions, so you should be able to debug it
g

gray-manchester-6518

03/12/2024, 12:39 PM
@fresh-football-47124 "we do some uniquing for users in an experiment, plus date range limits - are you seeing the difference in value from the metric page?" Yes can you expand on this? Is there a timeline for when Snowplow documentation for GB will be released?
@fresh-football-47124
6 Views