Skip to main content
Solved

Last Purchase Date


Forum|alt.badge.img
  • Contributor I
  • 1 reply

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

@Ester, welcome to the community.

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!

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

5 replies

Timmy Solomon
Problem Solver III
Forum|alt.badge.img+5
  • Problem Solver III
  • 19 replies
  • January 13, 2025

Hi @Ester,

Yes, you can retrieve the last purchase date for each customer in Klaviyo and export it for analysis. Here’s how to do it:

1. Create a Segment with Last Purchase Date

  • Go to the Lists & Segments section in Klaviyo.
  • Click Create List/Segment and select Segment.
  • Set the conditions to identify customers with a purchase history:
    • Condition: What someone has done > Placed Order > at least once.

Klaviyo automatically tracks the "Last Active" or "Last Placed Order" property for profiles, which includes their last purchase date.

2. Export Customer Data

  • Once the segment is created, navigate to the Profiles tab.
  • Click the Manage Segment dropdown and choose Export Segment to CSV.
  • Include the following properties in your export:
    • Email Address
    • Last Placed Order Date
    • First Name (optional)
    • Other custom fields relevant to your analysis

3. Analyze the Data

  • Open the exported CSV file in your preferred tool (Excel, Google Sheets, etc.).
  • Sort or filter the data by the Last Placed Order Date to analyze purchase patterns.

Optional: Use Custom Properties

If your store uses custom properties to track additional data, include those fields in your export for more detailed insights.

Let me know if you need more help setting this up! 😊


Forum|alt.badge.img
  • Author
  • Contributor I
  • 1 reply
  • January 13, 2025

Hi ​@Timmy Solomon,
Thank you for your response!
Unfortunately, I’ve already tried that approach, but there’s no Last Placed Order Date property available. I can only see First Purchase Date and Last Active, which I assume doesn’t necessarily indicate that a purchase was made on that date.
Do you have any idea why I don’t have this field?

Thanks! :)


retention
Partner - Platinum
Forum|alt.badge.img+62
  • 2025 Champion
  • 918 replies
  • Answer
  • January 13, 2025

@Ester, welcome to the community.

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!


Timmy Solomon
Problem Solver III
Forum|alt.badge.img+5
  • Problem Solver III
  • 19 replies
  • January 13, 2025

Hi @Ester,

Thank you for your reply! 😊

If you don’t see the Last Placed Order Date property in Klaviyo, it’s possible that the specific tracking or integration settings for your store are affecting this. Here are a few steps you can take to troubleshoot and find a solution:

1. Check Integration Settings

Make sure your eCommerce platform (Shopify, WooCommerce, etc.) is fully integrated with Klaviyo. The "Last Placed Order Date" property is typically synced automatically when the integration is set up correctly.

2. Review Custom Properties

Sometimes, Klaviyo stores purchase data under custom properties, depending on your platform. Navigate to a customer's profile in Klaviyo and review all properties to see if a similar field exists (e.g., "Last Order Date" or "Most Recent Purchase").

3. Sync Historical Data

If the integration was set up recently, historical purchase data might not have been imported. You can manually sync your data from your eCommerce platform to Klaviyo to populate missing fields.

4. Utilize Klaviyo Support

If none of the above steps work, it’s a good idea to reach out to Klaviyo Support. They can help identify why the "Last Placed Order Date" field isn’t appearing and guide you on how to enable it.

Let me know if you need help exploring these options! I’d be happy to assist further. 😊

Best regards,
Timmy Solomon
WhatsApp: +234 7044075666


MANSIR2094
Problem Solver IV
Forum|alt.badge.img+12
  • Problem Solver IV
  • 164 replies
  • January 13, 2025

Hello ​@Ester 

To get the last purchase date for each customer in Klaviyo and download it as a CSV, you can do this by creating a segment and exporting the data:

  1. Log into your Klaviyo account and navigate to the Lists & Segments tab.
  2. Create a new segment with a condition like "Placed Order at least once over all time." This will include customers who have made a purchase.
  3. Once the segment is created, go to the Analytics tab within the segment to see the data.
  4. You’ll find columns, including "Last Order Date" for each customer.
  5. To export this data, click on the Export Segment to CSV option. This will allow you to download the file for your analysis.

If you need to analyze the data further, open the CSV in a tool like Excel or Google Sheets. This method is straightforward and will give you exactly what you're looking for. Let me know if you need additional help! 😊