Tracking Unengaged Leads
Hello,
I'm trying to track unengaged leads which are basically anyone who doesn't open/click marketing or sales emails AND doesn't submit any form for over 52 weeks. (any open/click in marketing/sales emails or any form submission within 52 weeks would make the lead engaged).
I built below custom fields to help through the process preparing for the logic build in the smart campaign:
- Last Marketing Email Engagement Date (created this custom field to capture the latest of the 2 dates, last click or last open)
- Last Sales Email Engagement Date (passed from Salesforce)
- Last Form Submitted Date (created this custom field to keep track of the date when a form is submitted most recently)
- Unengaged: is a custom Boolean field created to be ticked only if a lead is deemed unengaged.
The logic is:
- Each one of the 3 elements should be checked and if there's a date (not empty) they'll be included in next step otherwise they won't. The challenge is I can't do multiple IF-Then inside one Smart Campaign or Flow.
- For those that are NOT empty, if the date is older than 52 weeks in all of them then change Unengaged to True.
You can put it in a different way and say if any of the dates are not empty AND date is in past 52 weeks then change Unengaged to False. But how do we add the AND to multiple conditions? This is a screenshot of where I reached so far (and I only included Marketing Email Engagement and Form submission and it already looks too complicated and not scalable)


This is the advanced filters I added: ((1 and 2 and 3 and 4) or (5 and 6 and 7) or (8 and 9 and 10)) and (11 or 12)
Can someone help me make this much simpler and more scalable please?
Cheers,
Maen