👋 Not sure if this is a bug. We tried changing the conversion window value, but it doesn't apply the change to the query. Any thoughts on why this is happening?
f
future-teacher-7046
02/15/2022, 4:14 PM
I think it's working correctly, although the SQL is a little confusing.
Instead of checking if
metricDate - 168 hours < experimentDate
, we check if
metricDate < experimentDate + 168 hours
future-teacher-7046
02/15/2022, 4:15 PM
That 2nd
72
in the query isn't actually used for anything, it's just an artifact of how we generate the SQL
future-teacher-7046
02/15/2022, 4:16 PM
We also released some updates a few days ago around conversion windows that simplifies the SQL a bit
b
busy-secretary-78039
02/15/2022, 5:09 PM
Thank you, @future-teacher-7046. I will check it out and update.