I have a question about funnel metrics. Just want to make sure I'm doing this correct. My query:

SELECT
  user_id,
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
  `database`.`analytics_12345`.`events_*`
WHERE
  event_name = 'purchase'
  AND ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
       (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))

Then I have

view_cart

as my denominator. This is trying to setup the one in the docs,

% checkout / % viewed cart

. We use GA4/BigQuery as our data source. Is this correct?

@blue-sundown-32899 has marked the issue as closed. Reopen Issue button

Hi Erik, thanks for reaching out! I'll look into this for you and reply here with an update as soon as I can 🙂

Thanks @brief-honey-45610

Hi Erik, this looks correct to me based on what I see in the docs: https://docs.growthbook.io/app/metrics#funnel-metrics One thing to note, which you probably already know but I want to be thorough, is that the syntax you see like ​`{{date startDateISO "yyyyMMdd"}}`​ in the query you shared is just a placeholder, and you'll need to replace that with your own datetime values. 🙂

Ahh, I guess I didn't realize that. Are the dates necessary?

Hey Erik, let me confirm both of these points with our data scientist and I'll follow up once I have more info!

Thanks again!

Hey Erik, I'm afraid I gave you incorrect information earlier and I apologize! I'm fairly new to the GrowthBook team and still learning about our tooling. The syntax you see like ​​`{{date startDateISO "yyyyMMdd"}}`​​ in the query is SQL templating and ​*should remain as-is*​. You do not need to change this; we detect the dates based on your data and configurations.

No worries! That clears some stuff up and I'll go from there. Thanks!

Hi Erik, you're welcome. 🙂