I can click into the “Profiles” tab and view a specific customer’s predictive analytics / CLV. But how do I find an average and also filter it to those who purchased more than 2 times, 3 times, etc.
How do I find the average lifetime value of those who purchased more than 2 times in the past 1 year?
![Anniversary - 2 years Forum|alt.badge.img](https://uploads-us-west-2.insided.com/klaviyo-en/attachment/9c1854d8-7db8-4ea0-95f4-085af72d8496_thumb.png)
Best answer by alex.hong
Hi there
Thanks for posting to the Community! I hope to provide some info regarding our CLV analytics and how you can access averages!
I'd start by creating a Segment of the users you would to include. So if you're only interested in customers who've made a purchase, create a Segment for those who Placed Order at least once, adjusting the time frame to your needs - e.g. over all time or in the last 30 days.
Once you've built the Segment you'd like to view CLV for, you can export the segment to CSV and select "Historic Customer Lifetime Value" as a field for export. Then, you can view all of the historic CLVs in your CSV file and just work out the average of that spreadsheet column.
Historic CLV refers to a person's spend-to-date. The total CLV field in Klaviyo refers to the sum of someone's historic CLV + their predicted spend in the next 12 months. If you are also interested in that average, you can export total CLV as well!
This article could be useful as well: How to Segment by Customer Lifetime Value (CLV).
If you wanted to filter by the amount of times they placed an order, you would just need to add an additional filter your segment collection! For example: Has Placed Order → Is greater than 2 → Over X time.
Hope this helped!
Alex
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.