I am trying to compile all the "opens" from various emails into one Excel document

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: EOL CLEANUP

Hi, I have sent out 8 emails to various lists - would like to take all the "opens" from each of the 8 and combine into one new group and export into Excel but I get a corrupted file message each time. Can someone list the steps to do this please - I must be doing something wrong!
Photo of Atlantic Conferences Inc.

Atlantic Conferences Inc.

  • 3 Posts
  • 0 Reply Likes

Posted 3 months ago

  • 0
  • 1
Photo of Nate Gallagher

Nate Gallagher, Employee

  • 41 Posts
  • 5 Reply Likes
Hello, 

Thanks so much for reaching out to Emma Support! 

You can compile all of the opens from various emails into an Excel document in a few different ways. The easiest would be to build a segment based on contacts' Response history: 

- Select the Segments tab from your Audience page
- Click the Create a new segment button 
- Name your new segment 
- From the Find contacts based on dropdown menu select Response history 
- Change Received to Opened 
- Select one of the eight mailings for which you'd like to capture the opens 
- Click Add
- Repeat the above steps for a second mailing, hit add, and notice the Match menu that now appears 
- From the Match dropdown menu, change All to Any
- Repeating the steps above continue to add the final six mailings and select Save to create the segment
- Navigate back to the Segments tab on the Audience page, open your newly created segment, and click the Export segment button 
- If you're unable to export the segment, trying copying the segment into a new group and exporting the group 

I've created a sample segment for you using these steps and your eight most recent mailings. You'll find it in your account under the name Nate's Support Segment. 

I hope this helps! Please let me know if you have any questions. 

- Nate