Replies posted by blyw

4 Replies

B
Contributor II
blywContributor II
asked in Analytics and Deliverability

How do I find the average lifetime value of those who purchased more than 2 times in the past 1 year?

Hi @alex.hong, Thank you for your detailed reply! I did end up creating a segment for those who Placed Order greater than 2 times in the past 365 days. I combined them into one Definition instead of creating two definitions (1. Placed order greater than 2 times) and (2. Last 365 days). I hope the combined method still works. I didn’t realize that I could just simply get the average in the spreadsheet column through Excel so thanks for that! Simple solution but it completely slipped my mind, haha. On another note, I found a Klaviyo CLV Calculation Template tool online and followed the instructions to plug in all the data. I’m having difficulty understanding what the calculations mean, such as Bins and the many rows of data for Historic CLV, Predicted CLV, Threshold Groups, etc. I tried to search for explanations but couldn’t find any. Do you have any thoughts to share about this tool? Thank you so much!  

3
alex.hong
2 years ago
Julie Hayes
Julie HayesKlaviyo Alum
published in Lists, Segments, and Profiles

Engaged SegmentsTutorial

Hi @Maria.ramos-esperanza, I checked my segment of “Unengaged Customers - Received 10 Emails” and it went from 9k members to 0 overnight. Is it because they’ve all been transferred to the list of “Suppressed Profiles”? I assume I won’t have to add this exclusion group when creating campaigns because there’s no members..  When I create a new segment, do you recommend adding the definition, “If someone is not suppressed” to ensure that the segment does not include Suppressed Profiles? Or would it be redundant since Klaviyo automatically excludes those unengaged members? Do you have any other recommendations to increase open rates? A typical campaign sends to 10k recipients but only 1-2k recipients open emails. I’ve tried segmenting to only active members (those who clicked and opened our emails within 18 months), list cleaning and adding members to Suppressed Profiles.  Thank you! 

510522
David To
Klaviyo Employee
11 months ago
Julie Hayes
Julie HayesKlaviyo Alum
published in Lists, Segments, and Profiles

Engaged SegmentsTutorial

Hi @david.to, Thank you for your reply. I just completed a list cleaning and now have a segment of “Unengaged Customers - Received 10 Emails” of around 9k members. I also added them to my list of Suppressed Profiles. When I send out my weekly emails, do I have to exclude this segment of Unengaged Customers/Suppressed Profiles? Or, will Klaviyo automatically skip those 9k members and no further action is needed from me whenever I schedule emails? Thanks! 

510522
David To
Klaviyo Employee
11 months ago
Julie Hayes
Julie HayesKlaviyo Alum
published in Lists, Segments, and Profiles

Engaged SegmentsTutorial

Hi Julie, I know you mentioned segmenting into 30-, 60-, 90- day groups but that will significantly lower our subscriber list from 50k to around 1k.Right now we are segmenting based on those who clicked our email in the last 18 months since we still want to capture as many people as possible. What are your thoughts on this? Thank you! 

510522
David To
Klaviyo Employee
11 months ago

Most helpful members this week

Terms & ConditionsCookie settings

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.