Scoring Field Comparison and Tie Hierarchy | Community
Skip to main content
N
nhabischWings
Level 5
August 20, 2025
Solved

Scoring Field Comparison and Tie Hierarchy

  • August 20, 2025
  • 1 reply
  • 646 views

Hello all,

Working on a campaign that essentially does the following:

 

  1. Tracks website page views related to products and assigns a score of +1 for each visit to a corresponding field.
  2. Using Triggers, if a Lead hits a threshold put them into a Program related to that product.
  3. The Lead can only be in one Program at a time, but scoring continues until they leave the initial Program and can qualify again.

Where I am looking for advice is after the Lead leaves the initial Program. We're wanting to basically move them into the next qualifying Program but since Marketo cannot directly compare Score fields on the Smart List side I am looking for the best way to be able to compare and select the highest score if there are multiple fields above the threshold.

 

I've seen some solutions around using additional fields to append the score and product and update to the higher scoring field, but everything I've seen is a multi-step process so was curious if there was a more efficient way?

Best answer by Michael_Florin-2

We have done exactly that score comparison - which results in a lead enter either into Program A or Program B - by using a Self-Service Flow Step that is sent to Adobe Runtime, which calculates a rather simple Excel formula. Looks something like this:

 

IF({{lead.Score Product A}} >= {{lead.Score Product B}}, "A", "B")

 

And certainly you could a webhook to https://flowboo.st/ to make this kinds of calculations. But in any case: You will need to find help outside of Marketo, because - as you said - Marketo can't compare scores. 

1 reply

Michael_Florin-2
Michael_Florin-2Accepted solution
Level 10
August 20, 2025

We have done exactly that score comparison - which results in a lead enter either into Program A or Program B - by using a Self-Service Flow Step that is sent to Adobe Runtime, which calculates a rather simple Excel formula. Looks something like this:

 

IF({{lead.Score Product A}} >= {{lead.Score Product B}}, "A", "B")

 

And certainly you could a webhook to https://flowboo.st/ to make this kinds of calculations. But in any case: You will need to find help outside of Marketo, because - as you said - Marketo can't compare scores. 

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 20, 2025

    FlowBoost (i.e. JS) to return the highest value among a set of scores is just:

    highScore = Math.max({{lead.Score Product A}}, {{lead.Score Product B}}, {{lead.Score Product C}});

     

    To return the name of a field with the highest score do something fun:

    scores = [ { name: "Product A", value: {{lead.Score Product A}} }, { name: "Product B", value: {{lead.Score Product B}} }, { name: "Product C", value: {{lead.Score Product C}} } ]; highScore = scores.reduce( (high,next) => high.value >= next.value ? high : next ).name;

    That’ll return the string like "Product A" if you want to act on that.

     

      Terms & ConditionsAccessibility statement

      Loading footer...