Skip to main content
Heather_Correa
Heather_Correa
Level 3
February 26, 2019
Solved

Find users exactly 90 days ago

I want to automatically remove users that have been on a list for exactly 90 days and have not changed their email address during that time period. Would this smart list work?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Mark_PriceAccepted solution
Level 6
February 26, 2019

If you have the date in a field like Sanford says (recommended), you can use 2 filters to get the data.

The first one grabs everyone in the last 90 days and the second one ensures you are including records with a date that was 89 days ago- giving you only the 90th. Without that, it would include yesterday, 2 days ago etc. (hope that makes sense)

The 'in past before' is a headache to work out, but should work once you dial it in.

View in thread

7 replies

SanfordWhiteman
SanfordWhiteman
Level 10
February 26, 2019

No, that trigger will only fire when they are added to the list. The Date-of-Activity constraint on triggers like this is only meaningful if you also use a Number-of-Times constraint.

In theory, you need to run a batch that filters by the 90th day (Was Added/Not Was Added). However, I'd be extraordinarily wary of trying to do Activity Log filtering at the 90-day mark, the exact age when activities begin to be purged from the system. Don't do it like that, instead stamp a Date field -- which will never be aged out -- and filter on that.

Translate
    Denise_Greenb12
    Denise_Greenb12
    Level 6
    February 26, 2019

    Adding to what Sandy said - filters and triggers that say "in past 90 days" include in past 1 day, 2 days, 3 days, etc. all the way up to past 90 days whereas you want people add exactly 90 days ago.

    Translate
      Mark_PriceAccepted solution
      Level 6
      February 26, 2019

      If you have the date in a field like Sanford says (recommended), you can use 2 filters to get the data.

      The first one grabs everyone in the last 90 days and the second one ensures you are including records with a date that was 89 days ago- giving you only the 90th. Without that, it would include yesterday, 2 days ago etc. (hope that makes sense)

      The 'in past before' is a headache to work out, but should work once you dial it in.

      Translate
        Heather_Correa
        Heather_CorreaAuthor
        Level 3
        February 27, 2019

        So what I'm hearing is, there's no way around filtering users added to a list exactly X days ago without a date field? It's just that we have a ton of fields right now and we're actually in the process of cleaning them up so if at all possible I'd rather not create another new field.

        Translate
        Denise_Greenb12
        Denise_Greenb12
        Level 6
        February 27, 2019

        Hi Heather,

        You could have the campaign that adds people to the list wait 90 days and then send the email.I.e., your flow would be:

        1) Add to List

        2) Wait 90 days

        3) Send email

        However, I agree with Sandy that the 90 day time period is potentially problematic because that's when the Added to List activity would get removed from the activity log. This would have no affect on the above solution - but it could present an obstacle to effective troubleshooting if you were trying to figure out why someone didn't receive an email.

        Denise

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...