Chris,
I did something like this recently. The best way was to think of this as a rigid flag system:
-1: unsubscribed
0: nothing or visited over 30 days ago
1: visited in past 30 days
2: did not visit in past 24 hours
3: visited in past 24 hours
the smart lists were the hardest part because you have to do the mutually exclusive thing carefully. I forget the exact items, but it went something like:
- =3 if you visit in past 24 hours AND your score is NOT -1 (now it turns out Marketo has an issue with -1, so there are ways around that).
- =2 if you were 3 AND have NOT Visited in Past 24 hours
- =1 if you were 2 and have NOT visited in past 30 days. I think there was something else to do this.
- =0 if you were 1 and did not visit in over 30 days (this one was tricky)