Skip to content

Allow us to record conversion events for experiment participants

Adding on to the basic concept outlined in #255615 (closed) of knowing if a user has performed the desired conversion action for an experiment or not, we would also like to know when the user performed that action (especially as it relates to when they first joined the experiment).

To keep track of this historical data, we will add a converted_at timestamp column (e.g. 2020-09-25 17:11:42 +0000) to the experiment_users database table. Before the conversion event the value would simply be NULL (and the corresponding value in the converted boolean column would be false). After they perform the conversion event, the value of the converted_at column will be stamped with the time of the conversion event (and the corresponding value in the converted boolean column would get updated to true). Then we can do comparisons with the already-present created_at timestamp column in the experiment_users table to see how long it took from when the user initially joined the experiment to when they performed the desired conversion event.

Edited by Dallas Reedy