Email Open Logic Check | Community
Skip to main content
J
John1-2
Level 3
April 14, 2026
Solved

Email Open Logic Check

  • April 14, 2026
  • 3 replies
  • 75 views

Hello! 

 

I am trying to pull together a list of MQLs who have opened an email (excluding confirmation emails unless they’ve opened a marketing email) and I would like it if someone can double check/verify that the logic is sound!

 

(1 or (2 and 3))

 

  1. Open email is not <Confirmation Email 1,2,3, etc.> this year
  2. Open email is any this year
  3. Open email is <Confirmation Email 1,2,3, etc.> this year

We are trying to check and see how many MQLs this year have opened one of our emails this year so that we can report to leadership. My concern is that Open Email is Any would pull in people who have opened the confirmation emails only when what I am looking for are people who have opened a marketing email AND opened a confirmation email. 

Best answer by SanfordWhiteman

(2 and 3) is no different from just (3). By definition, If they match Opened Email is [set of emails] then they also match Opened Email [is any].

 

Not sure why you’d include confirmation emails at all. Isn’t the ask “MQLs who have an opened a non-confirmation email”? If so: why does it matter if they’ve opened a non-confirmation email as well as a confirmation email?

3 replies

J
John1-2Author
Level 3
April 14, 2026

Oh! And this is weird, I’m playing around with the logic and noticed that Marketo is pulling people even though this is the criteria

(1 and 2)

Open Email is Email 1 This Year

Open Email is not Email 1 This year

 

I’d thought it will return an error but I actually got some people in there, not sure why this is happening. If people have suggestions, please let me know!

SanfordWhiteman
SanfordWhiteman
Level 10
April 14, 2026

This condition means

 

Opened Email 1 this year

AND

Opened an email other than Email 1 this year

 

Why would you expect an error?

J
John1-2Author
Level 3
April 14, 2026

Ah! I was thinking that both of them will cancel out because it’s Open Email 1 this year and people have opened an email this year but it’s not email 1. Thank you so much, Sanford! If you have a moment, would you be able to help with the logic above? Really really appreciate it!

C
Community Advisor and Adobe Champion
ChristianeRo1Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
April 14, 2026

What is the rationale behind using opens as your success metric? Opens are typically incredibly unreliable thanks to MPP, outlook, and companies blocking third party pixels. You’re catching a lot of people who may not have really opened your email, and missing out on some people who may have opened, but the images are blocked. 

    J
    John1-2Author
    Level 3
    April 14, 2026

    Hi Christiane! This is a request from senior leadership and they want to know how much pipeline is influenced by marketing, one way that they want to gauge this is by the number of email opens and mqls for this year. While there are things that we can’t be 100% certain of, I think they just want to have at least something to report on for future funding.

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    Level 10
    April 14, 2026

    (2 and 3) is no different from just (3). By definition, If they match Opened Email is [set of emails] then they also match Opened Email [is any].

     

    Not sure why you’d include confirmation emails at all. Isn’t the ask “MQLs who have an opened a non-confirmation email”? If so: why does it matter if they’ve opened a non-confirmation email as well as a confirmation email?

    J
    John1-2Author
    Level 3
    April 14, 2026

    Thanks for your reply!

    We just want to see who has opened a marketing email and MQL’d but there can also be an instance where someone has opened a quote request confirmation email, and opened a marketing email. We don’t want to exclude the leads that opened the quote request confirmation emails entirely, we only want to exclude them if they have opened the email and have not opened any other marketing email.

     

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    April 14, 2026

     

     

    We just want to see who has opened a marketing email and MQL’d but there can also be an instance where someone has opened a quote request confirmation email, and opened a marketing email. 

    Isn’t that a subset of “people who opened a marketing email”?

     

    Sorry but still not seeing why you care about people who opened a confirmation email. Yes, the confirmation email must be excluded from your Opened Email filter, but why do you need to re-include it in any capacity?

    Terms & ConditionsAccessibility statement

    Loading footer...