How do I create a segment based on opens across multiple emails?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I would like to create a segment of people how have opened at least three of the last four of my emails. The only option for creating segments is "AND" or "OR" for all emails but not three out of four. I am hoping someone might have a suggestion on how to do it. 
Photo of Eli Lipmen

Eli Lipmen

  • 2 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 0
  • 1
Photo of Maya Lochan

Maya Lochan, Customer Support Specialist

  • 179 Posts
  • 32 Reply Likes
Thanks for reaching out Eli! 

While there isn't a way to create a segment with that type of greater than or less than logic, I'm keen to know more about what you're looking to achieve here. Are you wanting to identify your active (or inactive) contacts or is there another end goal you have in mind?

I'll keep an eye out for your reply here!
(Edited)
Photo of Eli Lipmen

Eli Lipmen

  • 2 Posts
  • 0 Reply Likes
We want to target a segment of our audience that have expressed an interest in our content. We have sent four emails to the list and want to identify those who have opened three out of the four. Any recommendations on something similiar?
Photo of Maya Lochan

Maya Lochan, Customer Support Specialist

  • 179 Posts
  • 32 Reply Likes
Official Response
Thanks for that additional information Eli!

You can download a performance summary for all who have opened each of the four mailings in that campaign -- then, with a bit of sorting and Excel wizardry, you can identify who has opened at least three of the four mailings. We recently gave our compare mailings tool a facelift, so you can read more here about using that feature.

With that being said, I would definitely recommend looking at some of your other response metrics, like clicks, so you can paint a wider picture of engagement. This means that while you can analyze open rates, clicking on links in your mailing is also an important metric, as it shows a much stronger action. Feel free to take a look at this Resource Center article that has a great rundown of understanding your response numbers.

Just give me a shout if you have any follow-up questions on this!
(Edited)