Hi everyone!
I need to get the last purchase date for each customer in Klaviyo. Is there a way to do this? I’d like to download the data in CSV format for further analysis.
Thanks in advance! 😊
Hi everyone!
I need to get the last purchase date for each customer in Klaviyo. Is there a way to do this? I’d like to download the data in CSV format for further analysis.
Thanks in advance! 😊
Best answer by retention
As far as I know, Klaviyo doesn’t automatically include the Last Purchase Date, only the First Purchase Date as you indicated. If you want to do this, you can create a “Update Profile Action” on any existing “Placed Order” triggered Flow or create a new Flow to do just this. Then add the current date to a Customer Property field that you can choose your own field name such as “Last Purchase Date.”
However, this will only work going forwards as it will add dates to orders going forward only. To do this going backwards, the best way I know how to do this is to export your order history from your ecommerce platform sorted by reverse chronologically and import it back into Klaviyo (with the Last Purchase Date mapped to your custom property). I’m not totally sure, but I think Klaviyo will pick the first email address with an order and skip the subsequent ones since they are duplicated. Since you have it reversed chronologically sorted, the most recent email will always be the most recent purchase date, and the ones it skips because they are duplicate will be the prior orders. If this doesn’t work, then you need to cleanup the order history to remove the duplicates yourself and only include the most recent one.
Give this a try and let us know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.