Identify email subscriber & calculate historic CLV

Hi @Sunny,

Thank you for sharing this question with our community.

Initial Source tracks how a profile navigated to your website. This shows you the initial point of acquisition when a person first comes into contact with your brand. This will tell you whether the acquisition source was direct, referral or organic. For more information on the information section of the profile, see our article here.

In terms of tracking this property in Klaviyo, the easiest way to grab these users is to create a segment using Initial Source. That would look like the following:

You can create separate segments for each acquisition source or connect multiple acquisition sources using an “OR” separator between criteria in the segment. For more on “AND” vs “OR”, I recommend seeing our guide here.

In terms of calculating average spend per customer, I'd start by creating a segment of the users you would to include. 

Once you've built the segment you want to view CLV for, you can export the segment to .csv file and select "Historic Customer Lifetime Value" as a field for export.

Please note that you will only be able to see Predictive Analytics (which includes historical lifetime value) if you meet the following conditions:

• At least 500 customers have placed an order.
  This does not refer to Active Profiles, but rather the number of people who have actually made an order with your business. If this section is on a profile but is blank, this means we don't have enough data on that individual to make a prediction.
• You have an ecommerce integration (e.g., Shopify, BigCommerce, Magento) or use our API to send placed orders.
• You have at least 180 days of order history and have orders within the last 30 days.
• You have at least some customers who have placed 3 or more orders.

Assuming you meet all of these conditions, you can then view all of the historic CLV values for these customers in the export and just take the average of that spreadsheet column. 

Historic CLV refers to a person's spend-to-date. There’s also an option to export the CLV field in Klaviyo which 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.

In terms of the analytics dashboard, that’s not a bad way to get an overview of the users by acquisition source, however, it won’t yield the discrete emails (like the segment will do) which may be helpful for you.

In terms of the average first order value, you can create a segment “what somebody has done > placed order > equals 1” over all time and export them. Again, selecting the Historic CLV in the export, that segment will yield all of the users who have made just one purchase and you can take the average value from the spreadsheet. I’m afraid we don’t have a better way to isolate just first time purchasers value if they’ve purchased multiple times but this will capture all single time purchasers.

I hope that is helpful.