Check score sums | Community
Skip to main content
A
Anonymous
May 31, 2017
Solved

Check score sums

  • May 31, 2017
  • 1 reply
  • 1581 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by SanfordWhiteman

    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.

    1 reply

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    New Participant
    May 31, 2017

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...