Figure out if lead was sent only 1 email | Community
Skip to main content
Jennifer_Bisho1
Jennifer_Bisho1
Level 4
August 4, 2016
Solved

Figure out if lead was sent only 1 email

  • August 4, 2016
  • 1 reply
  • 1617 views

In trying to help clean up our hot mess of a database, we have over 80k leads that have not engaged in the past 6 months.  Is there a way I can figure out how many of these leads received ONLY 1 email?  I thought maybe adding the "Min. Number of Times" constraint on the "Was Sent Email" filter would be the answer but something tells me that may mean number of attempts any email was sent (such as if it bounced and it reattempted the send) as opposed to if the lead got more than one different email (such as a web seminar invite, and another for a promotion).

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Devraj_Grewal

Use two filters. "Was delivered email any: minimum number of times 1 & in timeframe last 6 months" & "Not was delivered email any: minimum number of times 2 & in timeframe last 6 months".

The resulting list will be all those delivered only one email in the last 6 months.

1 reply

Devraj_Grewal
Devraj_GrewalAccepted solution
Level 10
August 4, 2016

Use two filters. "Was delivered email any: minimum number of times 1 & in timeframe last 6 months" & "Not was delivered email any: minimum number of times 2 & in timeframe last 6 months".

The resulting list will be all those delivered only one email in the last 6 months.

Jennifer_Bisho1
Jennifer_Bisho1Author
Level 4
August 9, 2016

Genius.  Thank you!!

Terms & ConditionsAccessibility statement

Loading footer...