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?