some-planet-4410410/11/2022, 1:31 PM
But what I’m trying to achieve is having conversion_start date to be different from the experiment exposure date. Namely, I want a delayed conversion start so that I can calculate retention (which is visiting the app 7 days after experiment exposure). So that the user is considered converted if they logged in on 7th day after the exposure.
Maybe there’s a more proper way to go about this?
CAST(e.timestamp as DATETIME) as conversion_start,
some-planet-4410410/11/2022, 1:35 PM