curved-football-3891
07/07/2023, 4:11 PMfresh-football-47124
prehistoric-beard-84272
09/14/2023, 9:58 AMSELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
ecommerce.purchase_revenue_in_usd as value
FROM
table_here
WHERE
event_name = '{{eventName}}'
AND _TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}'
As denominator I use "count of purchases". This seems to work.
I tried something similar for EPC, using the same query and "page_view" (i.e. all users who triggered the page_view event at least once - this should give all active users during that time) as denominator, but the values are basically the same as AOV.
Could you give me a pointer where I'm going wrong?fresh-football-47124
prehistoric-beard-84272
09/18/2023, 10:49 AM