Average Time Between Two Events

Use this query to select the average time (in milliseconds), between two user events. You can use this, for example, to compare how much time elapsed between registration and a purchase for users in two different countries.

Syntax:

select avg(time_between("updated successfully","open help center frame"))
from cooladata
where date_range(doc.date_range)

screen2

Tips/Best Practices:

  • Use this function together with any interesting segment or dimension (for example, country, browser, etc.), to learn more about the difference in how long it takes for different groups to complete target events.