Hi,

My final objective :

• I would like to implement a cashback system on my Shopify website.
• Referrer would win 5% of what their referees are spending on the website

The tools I am using : 

• Loyoly : A referral app for my Shopify
• Klaviyo

Loyoly is sending to Klaviyo a metric with the email of every succesful referees.

I would like to create a database somewhere (in Sheet or maybe directly in shopify), where I could see all the referrers and their referees. 

So I’m looking for a way to extract the infos in this metrics.

Then (but I guess it won’t depend of Klaviyo), everytime a referee would make a purchase, I’ll look in that database to identify the referrer and credit his account.

Do you know how can i do it ?

Thanks a lot,

Laurent