SOLVED

Check score sums

Go to solution
Anonymous
Not applicable

Check score sums

Hi guys,

We have 3 score fields (Total, Behavior and Demographic). And some users noted that some leads have a total score different from the sum of the B-score and D-score.

Now I want to create a report of what leads have this issue. Is there a way to filter like "if field1+field2 != field3" so I can fix them?

Regards,

Raúl

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Check score sums

You can't do a filter like this natively.

Even if you could, it would probably take as long to process the Smart List in Marketo as just to reset the value for all your leads.

If you have FlowBoost, you could do

if ( +{{lead.field1}} + +{{lead.field2}} != +{{lead.field3}} ) {

  var irregularTotalScore = true;

}

Then trigger on Webhook is Called, Response [contains] "irregularTotalScore" → Add to List.

But again, running your whole db through something like this, where you can (re)set the same value in a Flow, is probably not an improvement.

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Check score sums

You can't do a filter like this natively.

Even if you could, it would probably take as long to process the Smart List in Marketo as just to reset the value for all your leads.

If you have FlowBoost, you could do

if ( +{{lead.field1}} + +{{lead.field2}} != +{{lead.field3}} ) {

  var irregularTotalScore = true;

}

Then trigger on Webhook is Called, Response [contains] "irregularTotalScore" → Add to List.

But again, running your whole db through something like this, where you can (re)set the same value in a Flow, is probably not an improvement.