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!
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.