Question

Cohort with two time slots – calculating Viral K

  • 20 November 2023
  • 0 replies
  • 80 views

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!

Reply