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
Solved! Go to Solution.
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.
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.