Hi there! I am trying to get a report completed of every individual account and the last time they opened an email. I know you can click on each individual account to see this information, but with 140,000+ accounts that is nearly impossible!! Please let me know if anyone has any suggestions or knows how to go about this.
Customer Report of Last Email Opened
Best answer by AlexandraPalau
Hello
I think the easiest way is it to create a segment of all active profiles (subscribed, as shown below).
![](https://uploads-us-west-2.insided.com/klaviyo-en/attachment/1adb606a-d44e-4bf8-8148-1f5eac68ba50.png)
Once the segment is created, click the Manage Segment > Export Segment to CSV option.
Select the profile properties you want to include in the export. To get the "last open" data, include:
-
Email Address
-
Last Open
![](https://uploads-us-west-2.insided.com/klaviyo-en/attachment/dc12ec1b-5768-470b-b3be-1d04f88a3370.png)
You should then see the last opened date for each profile.
I hope that answered your question! If you need further assistance or have additional questions, please reach out.
Thank you for being part of our community!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.