Skip to main content
Solved

Inserting custom $ value into email based on Fulfilled order value

  • February 1, 2021
  • 2 replies
  • 278 views

Forum|alt.badge.img+2

Hi All,

 

I’m sending out a loyalty email campaign to all profiles who have reached a certain fulfilled order value and the customer would like some text to inform the recipient how much more they would have to spend to reach the next threshold. 

Example: Your current spend: $30 spend an extra $270 to reach the next value.

 

Is there a way to do this so that each email recipient gets a unique $value until the next teir?

Thanks!

Best answer by retention

@Prosper - Are you trying to use the last (most recent) Fulfilled Order value or all time?  For example, if a user spent $30 two years ago, do they qualify for the next threshold?

If you’re using all time purchases, you can instead use the “Customer Lifetime Value” and export that from a Segment, calculate the difference, and import the difference into your own custom property that you can use to lookup to use in your template. 

To use a custom property, is similar to using any other Profile Property via template variable tags.  See this guide for more explanation: Template Tags and Variable Syntax - Custom Properties

Which loyalty platform are you using?  There might be an easier way depending on what data your loyalty platform provides to Klaviyo.

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

2 replies

retention
Partner - Platinum
Forum|alt.badge.img+62
  • 2025 Champion
  • 932 replies
  • Answer
  • February 1, 2021

@Prosper - Are you trying to use the last (most recent) Fulfilled Order value or all time?  For example, if a user spent $30 two years ago, do they qualify for the next threshold?

If you’re using all time purchases, you can instead use the “Customer Lifetime Value” and export that from a Segment, calculate the difference, and import the difference into your own custom property that you can use to lookup to use in your template. 

To use a custom property, is similar to using any other Profile Property via template variable tags.  See this guide for more explanation: Template Tags and Variable Syntax - Custom Properties

Which loyalty platform are you using?  There might be an easier way depending on what data your loyalty platform provides to Klaviyo.


Forum|alt.badge.img+2
  • Author
  • Contributor I
  • 1 reply
  • February 4, 2021

Thanks Joseph!

We’re using the all time value, so if we export the value, then in a spreadsheet calculate the difference, we can upload that number to a custom property. But we would need to do that constantly as this is a flow is that correct?

The customer is using Pronto, I might have a look into how that integrates.