5 Replies Latest reply on Jan 27, 2017 5:49 PM by 99ab6f5548a84d23cd7d3522c14067a0532e9f79

    Cap Demographic Score with Flow

      Hello,

       

      I am working on a lead scoring project and have been asked to cap the demographic scores associated with data value changes that fit within our demographic parameters.  IE Job Title changes from VP (+8) to Executive (+9).  We would like the value assigned to Job Title, not to exceed 10, but equal to 9. 

       

      Is there a way to keep the demographic score from going over 10 for the Job Title category?

       

      I really appreciate the help.

        • Re: Cap Demographic Score with Flow
          Sanford Whiteman

          Sure, use Add Choice + Do Nothing steps to create that condition/cap.

          • Re: Cap Demographic Score with Flow
            Grégoire Michel

            Hi Hollie,

             

            Your problem would be asked otherwise: how do you withdraw the previous job title score value before adding the new one.

             

            It really depends on how you have implemented your scoring.

             

            If you only have 1 scoring field for both behavior and demographic or if you have implemented it the way it's done in Marketo's importable programs, you will have to create a series of smart campaign that test both new and previous value. E.g.:

            • data value changes - job title - Previous value contains "VP"
              • Choice:  Job Title contains "Executive" -> +1
              • Choice: Job Title contains "Manage" -> -5
              • ...
            • Data value changes - job title - Previous value is Executive
              • Choice: Job Title contains VP -> -1
              • Choice: Job Title contains "Manage" -> -6
              • ...
            • Data value changes - job title - Previous value is empty ->
              • Choice: Job Title contains "Executive" -> +9
              • Choice: Job Title contains "VP" -> +8
              • ...

             

            I you have to combine multiple titles, it wan become very cumbersome. Let's say you have N possible job titles, N+1 smart campaigns, and in each one, N+1 choices

             

            The alternative is to store the previous value in another fields. Then in your smart campaign, you will first decrease the score based on the previous value, then increase based on the new one, and finally copy the new value to the previous value field. Typically, in your case, the flow will be something such as

            1. change score.
              1. Choice: if previous value is VP -> -8
              2. Choice: if previous value is Executive -> -9
              3. ...
            2. Change score
              1. Choice: if job title is Executive -> +9
              2. Choice: if job title is VP -> +8
              3. ...
            3. Change data value - Attribute: Previous Value - New value: {{lead.Job Title}}

             

            This method will break if you decide to change the scoring values.

             

            I personally have stopped using this technique quite a while ago exactly for these reasons. I use a system by which the demo score is a separate field and is recomputed from 0 each time one of the criteria changes, making it much more accurate. The process is to use 1 unique smart campaign with multiple triggers. In the flow, you reset the demo score to 0, then add the exact number of points for each criteria.

             

            -Greg

            3 of 3 people found this helpful