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?