Skip to main content

I’m trying to do a “time to convert” funnel analysis which looks at the duration between the first instance of an event and the last instance of an event. 

This is kind of a proxy for session duration, or dwell time, but it’s more flexible for our use case because it can span multiple sessions (as they’re defined by Amplitude). 

When I try to do this as a funnel showing time to convert, it just gives me the time to convert between the First event and the next instance of that event. 

How can I calculate the time between the First and Last occurrence of that event, with an unknown number of other events (including that same event) happening between those two bookends? 
 

 

More examples: 

First event occurrence found (none prior to this in the timeslice)

 

Here, in between the first and last event, any number of events could happen, including more of the same, for an undetermined amount of time. 

 

last event instance found (none after this in the timeslice)

For this case, the correct answer to “time to convert” should be roughly 2 hours 16 minutes (not 2 minutes, because that is the next instance of this event. 

Hi Bneil,

The use case you have presented here is partially achievable in Amplitude. For example, to look at the 1st performance of an event you can use the Historical Count filter to look at up to a user's 5th performance of an event. So if you want to identify the user's first performance of the _Psychic sensor collection unlocked_ event you can use the Historical Count= 1 as a filter on the first step in your funnel.

Unfortunately, there isn't a direct way to attribute a conversion to the most recent/last event in a funnel in Amplitude. This is because in Amplitude when a funnel is measured by uniques, it only considers the earliest and most completed conversion per user. This means that if a user converted through a funnel multiple times, it only counts the earliest conversion. This is due to the logic of the earliest conversion, which takes into consideration the earliest event within the conversion window.

We take customer feedback seriously and appreciate you taking the time to let us know how we can improve the Amplitude experience for you. I can see why this feature would be useful and would solve a lot of customer pain for you, and so I have passed along your use case to our Product Development team.

One possible solution would be to track a property on the _Psychic sensor collection unlocked_ event that you can filter for on the funnel to identify the last/most recent _Psychic sensor collection unlocked_ event. For example, a _Latest Performance_ property where the value is 'true' or 'false'. However, please note this is a topic you would need to discuss and implement with the help of your development team.

Thanks for bringing this to our attention, and let me know if there's anything else I can do to help!

Best regards,

Jacenda


P.S. Checkout upcoming events and user meetups on our events page.
Terms & ConditionsCookie settingsAccessibility statement