damp-printer-48360
03/01/2023, 1:44 PMuser_id
and a `date`: could you explain what the date is for?
I could not find any documentation on it. From the FAQ I understand that this is mostly used to correct/filter experiments and limit them to a subset of user_id
, but I cannot understand the role of the date
column.fresh-football-47124
damp-printer-48360
03/02/2023, 8:58 PMdate
must occur before the experiment timestamp
for users in this query to be included in the experiment results for the segment. Is that correct?
If we go back to the premium users example from the FAQ. What would the date be then? Would it be the moment that they joined premium?
SELECT
user_id
joined_premium_date AS date
FROM
my_user_table
WHERE
account_type = 'premium'
If so, what if they turned off premium since then? Shouldnât this type of condition require a start and end date (user X had a premium account between date Y and Z)?fresh-football-47124
damp-printer-48360
03/02/2023, 9:00 PMambitious-apartment-58735
03/16/2023, 3:53 PMdate
must occur before the experiment timestamp
for users in this query to be included in the experiment results for the segment.â Which timestamp
is the date
being compared to/how are they being compared? How does the conversion window (and maybe attribution model) play in?damp-printer-48360
03/16/2023, 8:04 PMdate
in the definition of the segment (a segment query must provide a user_id
and a date
) and to the timestamp in the definition of the experiment (an experiment must provide a user_id
, a timestamp
, an experiment_id
and a variation_id
). According to my test, the date
from the segment must occur before the timestamp
for a user_id
to be included in the experiment with the segment.ambitious-apartment-58735
03/16/2023, 8:52 PMdate
and timestamp
per user_id?