Hello everyone, I am new to GrowthBook. Query 1 – I have a question about adding a metric. Is there a way to remove the required timestamp column? I have temporarily fixed this by setting the timestamp to the current year. Query 2 – Even after changing the query settings and removing

anonymous_id

and

user_id

, the changes are not reflected when I click "Run Analysis." However, I still get an error for not including these fields. Strangely, I am able to run the query and get results in "Test Query" mode. My Requirement – I am using BigQuery to retrieve data from GA4. From that data, I am extracting

experiment_id

and

variation_id

from the table. My goal is to count the number of people who received each variation, where the values are 0 and 1. I have attached a screen recording for your reference.

1. We do need a date/timestamp in order to make sure that the phases (which are date ranges) and the metric events (which need to happen after experiment exposure) work correctly. 2. There are two queries that are joined to make the experiment query - the assignment query, from the data source page, and the metric/fact table query. You can edit them there

@fresh-football-47124 I tried removing the identifier types from the data sources, but it still isn't working properly. I just need to determine how many people viewed the new UI versus the old UI. Additionally, I have some custom events, such as filter clicks, and I need to track how many users interacted with the filter on both the new and old UI. It’s also important for me to know how many users proceeded to checkout. I'm not sure if I'm doing something wrong—could you please help me clarify this?

GrowthBook will already show you the totals of users who saw an experiment