calm-balloon-91650
12/12/2024, 5:51 PMtrackingCallback
. This timing causes GrowthBook to filter out these users from the experiment analysis because the activation event precedes the assignment.
Is there a recommended way to handle this scenario so that users are accurately included in the experiment data, even if the activation event occurs before assignment? Any guidance on adjusting the timing or configuring the SDK to assign users earlier would be greatly appreciated.
Thank you for your assistance!late-dentist-52023
12/12/2024, 5:59 PMhelpful-application-7107
12/12/2024, 6:42 PMplain-pharmacist-9564
12/16/2024, 1:11 PM...
__experimentUnits AS (
-- One row per user
SELECT
e.userid AS userid
, (CASE WHEN count(distinct e.variation) > 1 THEN '__multiple__' ELSE max(e.variation) END) AS variation
, MIN(e.timestamp) AS first_exposure_timestamp
, MIN((CASE WHEN a.timestamp >= e.timestamp - INTERVAL '8' minute
AND a.timestamp <= from_iso8601_timestamp('2024-12-16T12:25:53.665Z') THEN a.timestamp ELSE NULL END)) AS first_activation_timestamp
FROM
__experimentExposures e
LEFT JOIN __activationMetric a ON (a.userid = e.userid)
GROUP BY
e.userid
)
helpful-application-7107
12/16/2024, 3:47 PMhelpful-application-7107
12/16/2024, 4:41 PMplain-pharmacist-9564
12/16/2024, 4:50 PM