thankful-oil-10632
09/25/2023, 8:47 PMfresh-football-47124
helpful-application-7107
09/25/2023, 11:45 PMNumber of Users who ever made a Purchase / Number of Sessions across all Users
?
If so, then yes, your setup is correct.thankful-oil-10632
09/26/2023, 3:05 AMhelpful-application-7107
09/26/2023, 2:59 PM1 as value
for each transaction.thankful-oil-10632
09/26/2023, 3:08 PMmy_table*
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"}}'))helpful-application-7107
09/26/2023, 3:09 PMthankful-oil-10632
09/26/2023, 3:10 PMhelpful-application-7107
09/26/2023, 3:26 PMsession_start
metric? It needs to be a count
metric in the same data source.thankful-oil-10632
09/26/2023, 3:27 PMhelpful-application-7107
09/26/2023, 3:28 PMthankful-oil-10632
09/26/2023, 3:29 PMhelpful-application-7107
09/26/2023, 4:10 PMso it should be purchase / count of session right ??Yes
how can i change them to percentage ?? (1%)This metric doesn't make sense as a percentage, because there's nothing guaranteeing that purchases < count of session.
thankful-oil-10632
09/26/2023, 4:12 PMhelpful-application-7107
09/27/2023, 6:32 PMthankful-oil-10632
09/27/2023, 6:55 PM