numerous-tailor-14019
06/27/2023, 2:49 PManonymous_id
. How to use it correctly?
• For example, if I have an orders
table and I build metrics based on it.
• Do I need to store both anonymous_id
and user_id
in orders
and the same fields in viewed_experiments
?
• Then add anonymous_id
as Identifier in GB and select ananoymous_id
from orders
table in my sql metric?
• And if the anonymous_id
from orders
and viewed_experiments
match, then I will get a conversion, right?
• What if a user from the orders table was previously assigned to a different option?
For example, if I have this records in my database:
ORDERS TABLE (id, user_id, anonymous_id, timestamp)
1, 1, anon1, 2023-01-01 (the user id was known at the time of creation)
2, 1, anon2, 2023-01-04 (user ID added to the order after user authorization)
VIEWED_EXPERIMENTS TABLE (user_id, anonymous_id, experiment_id, variation_id, timestamp)
1, anon1, experiment1, 0, 2023-01-01 (the user created the order authorized)
null, anon2, experiment1, 1, 2023-01-04 (the user created an order as an unauthorized user and ended up in another group)
What is correct way to analyze experiment in such situation?helpful-application-7107
06/28/2023, 5:30 PM