Skip to main content
Solved

Syncing Metrics infos to Google Sheet (or Shopify, or something else)

L
Active Contributor II
Forum|alt.badge.img+6
  • Laurent
  • Active Contributor II
  • 19 replies

Hi,

(I’ve been recommended to post this topic here, in the developer group)

 

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

Best answer by TimMartinHarvey

Hey there Laurent

Have you tried Zapier?

You should be able to see if you you can discover this metric in the Klaviyo Metrics that are pulled through.

Example of what i can see as my metrics below:


If you you can then set up a webhook that as soon as a user gets this metric its added to a GSheet.

Let me know if you can see that metric when you connect Zapier

Thanks

Tim

View original
    Did this topic or the replies in the thread help you find an answer to your question?

    2 replies

    TimMartinHarvey
    Problem Solver III
    Forum|alt.badge.img+5

    Hey there Laurent

    Have you tried Zapier?

    You should be able to see if you you can discover this metric in the Klaviyo Metrics that are pulled through.

    Example of what i can see as my metrics below:


    If you you can then set up a webhook that as soon as a user gets this metric its added to a GSheet.

    Let me know if you can see that metric when you connect Zapier

    Thanks

    Tim

    Tim Martin-Harvey | Head of E-Commerce | Digital Transformation Specialist | Multi-Brand E-Commerce Expert | 2024 Klaviyo Community Champion | Luminia Intelligence Top 10 Influential People in UK Wholesale E-Commerce
    chloe.strange
    retention
    L
    3 people like this
    • chloe.strange
      chloe.strange
    • retention
      retention
    • L
      Laurent
    L
    Active Contributor II
    Forum|alt.badge.img+6
    • Laurent
    • Author
    • Active Contributor II
    • 19 replies
    • August 21, 2024

    Thanks a lot, it worked perfectly fine.

     

    I did not know that Zapier could identify the info within a metric, but it simply does.

     

    Have a great day and thanks for your help.

    Reply


    Terms & Conditions

    Links & Resources

    Platforms

    Partners

    Useful Things

    About

    • Terms and Privacy |
      © 2024 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.