Cohort with two time slots – calculating Viral K

  • 20 November 2023
  • 0 replies

I am in the process of building a Viral K table


I have an event referralShared that triggers when a new unique URL is created for sharing invites.


Another one referralSuccessfulAccept whenever an install happens post clicking a referralShared URL.


To calculate Viral K, the referralSuccessfulAccept should be a week delayed from the referralShared creation. i.e., if I were to look at the Viral K for this week, it should only show last week’s referralShared and this week’s referralShared and compute. It should REMOVE all referralShared for this week.


How do I achieve this?

0 replies

Be the first to reply!