SOLVED

Go to solution
Level 2

## Smart list for zero score change in time period

I want to marketing disqualify any leads whose person score has remained at zero for 180 days, will the below smart list work?

1 ACCEPTED SOLUTION

Accepted Solutions
Level 9

## Re: Smart list for zero score change in time period

No.

Let's look at score first. You're looking for persons whose score is 0 and wasn't changed in 180 days. That would be this:

Now, they also need to be at least 180 days old, right? Acquisition Date "in future" or "in future after" is looking into the wrong direction. You need to look into the past.

"In past before" is tricky as it also finds persons whose "created at" date is empty, but I guess that case cannot exist.

6 REPLIES 6
Level 9

## Re: Smart list for zero score change in time period

No.

Let's look at score first. You're looking for persons whose score is 0 and wasn't changed in 180 days. That would be this:

Now, they also need to be at least 180 days old, right? Acquisition Date "in future" or "in future after" is looking into the wrong direction. You need to look into the past.

"In past before" is tricky as it also finds persons whose "created at" date is empty, but I guess that case cannot exist.

Level 2

## Re: Smart list for zero score change in time period

Thanks so much for your help with this Michael, much appreciated.

Level 8

## Re: Smart list for zero score change in time period

In addition to @Michael_Florin 's comments which are totally on point, please bear in mind the retention period for the Change Score activity is 90 days, so you cannot look back that far to achieve what you want.

A reliable way to achieve what you want is to create a last score change date or datetime field that you stamp with every score change. Based on this date you could reference your 180 days.

Level 9

## Re: Smart list for zero score change in time period

Thanks for the addition, Katja, and you're certainly right.

But to be honest, I haven't really understood how this retention restriction was executed. I am still seeing data value changes  and scoring changes that are beyond the expected time frame:

Level 10 - Community Moderator

## Re: Smart list for zero score change in time period

The database gets garbage-collected irregularly, which can be confusing, but eventually the retention period is enforced.
Level 8

## Re: Smart list for zero score change in time period

That is my experience as well. So simply said, beyond 90 days you cannot guarantee data is complete anymore, so you can not reliably use it as a reference.