SOLVED

Re: Figure out if lead was sent only 1 email

Go to solution
Jennifer_Bisho1
Level 4

Figure out if lead was sent only 1 email

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

1 ACCEPTED SOLUTION

Accepted Solutions
Devraj_Grewal
Level 10 - Champion Alumni

Re: Figure out if lead was sent only 1 email

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.

View solution in original post

2 REPLIES 2
Devraj_Grewal
Level 10 - Champion Alumni

Re: Figure out if lead was sent only 1 email

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
Level 4

Re: Figure out if lead was sent only 1 email

Genius.  Thank you!!