Open source feature flagging and experimentation platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

image.png

What is the reason for the value_param.key part?

are there more than one kind of purchase events?

I fixed the erro, thanks.

Other question, about the metric when user is visited a page location.
The return should be as 1 ?
Do you have some example for page_view metric ?

```SELECT
  user_id,
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  event_params.value.string_value AS page_location,
  1 as value
FROM
  `azos-data`.`analytics_262365471`.`events_*`,
  UNNEST(event_params) AS event_params
WHERE
  event_name = 'page_view'
  AND event_params.key = 'page_location'
  AND event_params.value.string_value LIKE '%GOOGLE.com%'
  AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'```

This code is the best way to create page_view metric?

This SQL code will keep counting the view while browsing, right? How do I set it up to collect once?