Skip to main content
Solved

Export CSV order value

  • January 11, 2021
  • 4 replies
  • 541 views

Forum|alt.badge.img+2

Hi, 

 

How can I export a list CSV with this information: Order value 

 

It allows me to export First name, last name, city etc.. but not order value. 

 

Hope to hear soon from you, 

 

Regards

Best answer by retention

@jorgehostalet Hi!

In the exporting process, among the parameters you mentioned above (First Name, Last Name, City, etc..), you should have a parameter called “Historic Customer Lifetime Value”. This parameter contains the total value of ordered products for each of your subscribers.

Hope this helps!

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

4 replies

retention
Partner - Platinum
Forum|alt.badge.img+62
  • 2025 Champion
  • 920 replies
  • Answer
  • January 11, 2021

@jorgehostalet Hi!

In the exporting process, among the parameters you mentioned above (First Name, Last Name, City, etc..), you should have a parameter called “Historic Customer Lifetime Value”. This parameter contains the total value of ordered products for each of your subscribers.

Hope this helps!


Omar
Partner - Platinum
Forum|alt.badge.img+46
  • 2025 Champion
  • 494 replies
  • January 11, 2021

This might also be handy: https://www.klaviyo.com/blog/export-customer-lifetime-value-information 

The klaviyo site has some good docs on this as well.


Forum|alt.badge.img+2
  • Contributor III
  • 5 replies
  • April 10, 2021

Hi! 

On my side, when I try to export a segment these parameters (“historic customers..”, “historic orders..”) do not appear. 

Maybe you would have an answer..

Thanks a lot! 


marissanunez
Forum|alt.badge.img+6
  • Klaviyo Alum
  • 48 replies
  • April 11, 2021

Hi @audette 

 

Thanks for sharing your question with the Klaviyo Community! Happy to help here.

 

Predictive Analytics in Klaviyo can help provide insight in to your audience and their prior and even expected activity. Predictive Analytics include: Historic CLV, Predicted, CLV, Total CLV as well as others.

 

Something to keep in mind with these analytics, you will only see this section on profiles if you meet the following conditions:

  • At least 500 customers have placed an order. 
  • 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.

Here is an extremely useful article that gives a more in depth overview of these analytics.

 

Now, granted you meet the above criteria, I have some suggestions around how to export this data.

 

If you create a segment including a Placed Order metric, for example:

  • what someone has/has not done: Placed an Order at least once over all time

 

Then export this segment. You will be directed to a screen that allows you to select which fields you would like to include in the export. On the second and third pages of fields available, you should see the following:

 

From here you can select the fields you’d like to export to a CSV file.

 

I hope this helps!

Marissa