2 Replies Latest reply on Jul 2, 2015 6:03 AM by 7f3ecac12d2b6ee659f018b1204a6acb1e62bb2f

    How to identify highest score among several score fields?

      We have several score fields to capture a user's affinity for product lines that are triggered when the user visits a web page specific to a product line. For example, visit a product line A page twice and a product line B page once, and product line A affinity score = 2 and product line B affinity score = 1. Is there a way to identify which affinity score is higher in order to segment? Ideally, we would use the highest affinity score field to display custom content for product line A, for this example, because the user's behavior indicates a greater interest in product line A over product line B.
        • Re: How to identify highest score among several score fields?
          Valerie Armstrong
          Hi Jason,

          We currently have four lead scores, one for each of our product lines.  We created a SFDC custom formula field to calculate which is the highest score and sync this field back to Marketo in order to segement.  Your SFDC admin should be able to help you create this field if you decide to go this route.

          The formula evaluates for the following
          • If the Market scores are null or they are all zero, the field value is No Score
          • If one of the Market scores is higher than all the others, the field value is the name of that Market.
          • If two or more of the Market scores are the same value, the field value is Tie.
          To identify the most recent interest of leads who are tagged as No Score or Tie, I created a different field called "Recent Market" to track their most recent product line interest.  I set up a smart campaign that triggers off a change to the calculated SFDC field (excluding those that change to a value of No Score or Tie) and in the flow steps, the value of the SFDC field is written to the Recent Market field.