microscopic-article-59871
11/07/2023, 1:30 PMevent_value_in_usd as value
currently but when I try to pull through the value
event parameter from my data layer I get an error Unrecognized name: value
Any help would be really appreciated, thanks!rhythmic-agent-34208
11/07/2023, 1:30 PMbrief-honey-45610
11/07/2023, 2:20 PMmicroscopic-article-59871
11/07/2023, 2:34 PMecommerce.purchase_revenue
This now pulls through the value in GPB.
Still not sure how I can get a bounce rate percentage though.rhythmic-agent-34208
11/08/2023, 8:41 PMSELECT
user_id,
user_pseudo_id AS anonymous_id,
MIN(TIMESTAMP_MICROS(event_timestamp)) as timestamp,
concat(user_pseudo_id,(select <http://value.int|value.int>_value FROM unnest(event_params) WHERE key = 'ga_session_id')) as session_id,
countif(event_name = 'page_view') as views,
FROM
*** your table ***
WHERE
((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}')
OR (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
group by
user_id,
user_pseudo_id,
session_id
HAVING views = 1
Please note that you will need to provide the name of the table you're using in BigQuery on this line:
FROM
*** your table ***