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

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
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 1 month ago

  • 0
  • 1
Photo of Nate Gallagher

Nate Gallagher, Employee

  • 40 Posts
  • 5 Reply Likes

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