How to Show “Only X Points Away” From loyalty reward in Email When Using Custom Property?

Thanks for reaching out to the community for help.

Try something like the following - you’ll need to update the code to match your custom profile properties:

{% set points_needed = 2500 - person|lookup:'Joy Loyalty Points' %}
You need {{ points_needed }} more points to reach 2500.

Let me know if that works for you!

Thank you for your prompt reply but it didn’t work. It says message displayed without tags or variables. Sorry I’m very new to all this

I’ve been experimenting to try and come up with an answer and haven’t been able to come up with a solution. There are a few posts on the forum that imply this would be possible, but none are working for me when I test:

I tried:

{{ "2500"|floatsub:"500"}}

Which does work, but:

{{ "2500"|floatsub:person|lookup’Joy Loyalty Points”}}

does not.

I’m hoping someone else within the community can point us in the right direction.

Hi ​@Ai MK ,

Thank you for sharing your query with the community! There have already been some good suggestions shared. Adding to those, here’s one possible solution from my side, hope it helps!

1. Ensure Loyalty Points Are Stored as a Custom Property

First, confirm that each customer's current loyalty points are stored in a custom profile property, such as loyalty_points. This can be achieved through:

• Manual Updates: Editing individual profiles to add the loyalty_points property.

• CSV Imports: Uploading a CSV file with the loyalty_points column.

• Integrations: Using loyalty platforms like Smile.io or LoyaltyLion to sync points automatically.

• API Calls: Utilizing Klaviyo’s Identify or Profiles API to update properties in real-time.
   

2. Determine the Reward Threshold

Decide the number of points required to unlock the next reward. For example, if a $10 discount requires 500 points, then:

{% assign reward_threshold = 500 %}

3. Calculate Points Needed

Subtract the customer's current points from the reward threshold:

{% assign current_points = person|lookup:'loyalty_points' | default: 0 %}

{% assign points_needed = reward_threshold | minus: current_points %}

4. Display the Message Conditionally in Email

Use conditional logic to display the appropriate message:

{% if points_needed > 0 %}

  Only {{ points_needed }} points away from unlocking your next reward!

{% else %}

  You've unlocked a reward! Redeem it now.

{% endif %}

This ensures that customers who have met or exceeded the threshold see a different message than those who haven't.