purple-winter-48671
12/15/2023, 12:17 AMpurple-winter-48671
12/15/2023, 12:18 AMfresh-football-47124
purple-winter-48671
12/15/2023, 12:21 AMpurple-winter-48671
12/15/2023, 12:21 AMfresh-football-47124
purple-winter-48671
12/15/2023, 12:22 AMfresh-football-47124
fresh-football-47124
purple-winter-48671
12/15/2023, 12:24 AMfresh-football-47124
fresh-football-47124
purple-winter-48671
12/15/2023, 12:25 AMfresh-football-47124
fresh-football-47124
purple-winter-48671
12/15/2023, 12:27 AMpurple-winter-48671
12/15/2023, 12:28 AMfresh-football-47124
fresh-football-47124
fresh-football-47124
purple-winter-48671
12/15/2023, 12:30 AMpurple-winter-48671
12/15/2023, 12:31 AMfresh-football-47124
purple-winter-48671
12/15/2023, 12:33 AMfresh-football-47124
fresh-football-47124
purple-winter-48671
12/15/2023, 12:54 AMpurple-winter-48671
12/15/2023, 2:38 AMpurple-winter-48671
12/15/2023, 2:56 AMfresh-football-47124
purple-winter-48671
03/04/2024, 9:31 PMrhythmic-agent-34208
03/21/2024, 9:20 PMrhythmic-agent-34208
03/21/2024, 9:20 PMfresh-football-47124
fresh-football-47124
rhythmic-agent-34208
03/21/2024, 9:24 PMrhythmic-agent-34208
03/21/2024, 9:24 PMrhythmic-agent-34208
03/21/2024, 9:30 PMrhythmic-agent-34208
03/21/2024, 9:31 PMrhythmic-agent-34208
03/21/2024, 9:32 PMhelpful-application-7107
03/22/2024, 9:53 PMhelpful-application-7107
03/22/2024, 9:54 PMpurple-winter-48671
03/24/2024, 8:04 PMpurple-winter-48671
03/24/2024, 8:14 PMhelpful-application-7107
03/25/2024, 4:44 PMs.identity?.id
that you set as an attribute may not always be the same as what rudderTrack
is setting as the customer_id
. I wonder if there's a way to explicity add this s.identity?.id
to your ruddertrack to check if they every are different from the customer_id
.
This is almost always the reason for multiple exposures.purple-winter-48671
09/12/2024, 10:22 PMs.identity?.id
to our Ruddertrack call to ensure this is matching customer_id (and it is). We need assistance as to what else might be going wrong, as essentially we're unable to use Growthbook for experiments with this level of multiple exposures.purple-winter-48671
09/12/2024, 10:22 PMfresh-football-47124
purple-winter-48671
09/12/2024, 10:27 PMfresh-football-47124
fresh-football-47124
fresh-football-47124
purple-winter-48671
09/12/2024, 10:48 PMfresh-football-47124
purple-winter-48671
09/12/2024, 10:57 PMpurple-winter-48671
09/12/2024, 10:58 PMfresh-football-47124
purple-winter-48671
09/12/2024, 10:59 PMfresh-football-47124
fresh-football-47124
purple-winter-48671
09/12/2024, 11:01 PMfresh-football-47124
purple-winter-48671
09/12/2024, 11:24 PMpurple-winter-48671
09/12/2024, 11:24 PMpurple-winter-48671
09/15/2024, 9:53 PMflaky-noon-11399
09/18/2024, 8:59 AMhelpful-application-7107
09/18/2024, 12:13 PMpurple-winter-48671
09/18/2024, 8:31 PMSELECT customer_id
, abtest_experiment_received_at as timestamp
, experiment_name as experiment_id
, result_variation_id as variation_id
, (CASE WHEN device_type ILIKE 'Tablet' THEN 'Tablet/Desktop'
WHEN device_type ILIKE 'Desktop' THEN 'Tablet/Desktop'
ELSE device_type END
) AS device
, device_browser
, device_os AS os
FROM smarts.reporting.rpt_abtest_event
WHERE customer_id IS NOT NULL
Could the fact this query has device type/browser/OS mean it's not recognising that the customerID already has been assigned on another browser/OS?helpful-application-7107
09/18/2024, 8:38 PMpurple-winter-48671
09/18/2024, 8:40 PMhelpful-application-7107
09/18/2024, 8:45 PMhelpful-application-7107
09/18/2024, 8:49 PMs.identity.user?.id
directly to the tracking callback?helpful-application-7107
09/18/2024, 8:49 PMcustomer_id
?purple-winter-48671
09/18/2024, 8:58 PMhelpful-application-7107
09/18/2024, 9:07 PManonymous_id
column in that table? Can you create an Experiment Assignment Query for that id and analyze the experiment by that ID and see what happens then?helpful-application-7107
09/18/2024, 9:16 PMWITH exposures AS (
SELECT anonymous_id
, COUNT(DISTINCT result_variation_id) as n_variations
FROM smarts.reporting.rpt_abtest_event
WHERE customer_id IS NOT NULL AND experiment_name = 'shared-lunch-in-app'
GROUP BY anonymous_id
)
SELECT
CASE WHEN n_variations > 1 THEN 'multiple' ELSE 'single' END AS exposures
, COUNT(*)
FROM exposures
GROUP BY 1
To see how many multiple exposures there are according to anonymous_id
. You may want to add date filters or something if you know the range of this experiment, but it shouldn't be necessary if you only ran it once in one phase.purple-winter-48671
09/18/2024, 9:19 PMhelpful-application-7107
09/18/2024, 9:19 PMwe also have since added theto our Ruddertrack call to ensure this is matching customer_id (and it is)s.identity?.id
purple-winter-48671
09/18/2024, 9:20 PMpurple-winter-48671
09/18/2024, 9:20 PMpurple-winter-48671
09/18/2024, 9:20 PMhelpful-application-7107
09/18/2024, 9:21 PMpurple-winter-48671
09/18/2024, 9:21 PMhelpful-application-7107
09/18/2024, 9:21 PMhelpful-application-7107
09/18/2024, 9:21 PMhelpful-application-7107
09/18/2024, 9:21 PMpurple-winter-48671
09/18/2024, 9:22 PMhelpful-application-7107
09/18/2024, 9:23 PMpurple-winter-48671
09/18/2024, 9:23 PMhelpful-application-7107
09/18/2024, 9:25 PMhelpful-application-7107
09/18/2024, 9:25 PMsetAttributes
call somewhere in your codebase that could somehow be overwriting this one?purple-winter-48671
09/18/2024, 9:29 PMhelpful-application-7107
09/18/2024, 9:37 PMhelpful-application-7107
09/18/2024, 9:40 PMuseAppSelector
do something I should be aware of?helpful-application-7107
09/18/2024, 9:42 PMhelpful-application-7107
09/18/2024, 9:51 PMcustomer_id
is being set incorrectly in the growthbook
instance. Either because:
• s.identity.user?.id
is somehow falling back to anonymousId
in the useAppSelector
or something weird like that
• We are falling back to anonymousId
when it's missing for some reason, maybe a race condition, but this should only happen if you have sticky bucketing and a fallback attribute set up, which it doesn't look like you do.
• Somehow the attributes aren't being set correctly or are being overriden.helpful-application-7107
09/18/2024, 9:51 PMuseAppSelector
actually provides those ids.helpful-application-7107
09/18/2024, 9:52 PManonymous_id
experiments have any multiple exposures issues?helpful-application-7107
09/18/2024, 9:53 PMexperiment_name
that you know ran on anonymous_id
?helpful-application-7107
09/18/2024, 9:57 PMpurple-winter-48671
09/19/2024, 12:21 AMflaky-noon-11399
09/19/2024, 1:16 PMpurple-winter-48671
09/22/2024, 9:51 PMrhythmic-agent-34208
09/23/2024, 10:37 PMrhythmic-agent-34208
09/23/2024, 10:38 PMbrief-honey-45610
09/23/2024, 10:58 PM