SOLVED

Adding Field Values for Total Lead Score.

Go to solution
Anonymous
Not applicable

Adding Field Values for Total Lead Score.

Hi All,

I created two custom fields of Type:Score . First, Behaviour Score and second, Role Score.

Based on a lead's role and behaviour , I have flows that update these two scoring fields separately.

Could you guys help me out , if Lead Scoring based on addition of Behaviour Score and Role Score is possible,i.e., something like Lead Score = Behaviour Score + Role Score ?

This way, the separate scorings can be tracked and alongside the total score will also be taken care of.

Awaiting your guidance.

Thanks !

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: Adding Field Values for Total Lead Score.

We had this issue a while ago with an instance that is not connected to CRM and not the possibility whatsoever to use a webhook. This is how we did it:

The goal was to compute Total score = Behavior + Demographic

We new the demographic score was limited to a maximum of 40, while the behavior score could climb much higher. So we created a smart campaign that looks like this :

  1. Flow step 1 : Total score = {{Lead.behavior score}}
  2. Flow step 2 : 40 choices :
    1. if demographic score = 40 then Total score = +40
    2. if demographic score = 39 then Total score = +39
    3. if demographic score = 38 then Total score = +38
    4. ...
    5. if demographic score = 2 then Total score = +2
    6. if demographic score = 1 then Total score = +1

Not very elegant, takes some patience, I agree but it works.

The hard point is to avoid this flow to be called at each flow step when recomputing the demographic score, which is a multi-step computation. So this smart campaign trigger has 2 triggers :

  • behavior score is changed
  • Campaign is requested

And the demographic score campaign calls it only when it's complete.

-Greg

View solution in original post

4 REPLIES 4
Diederik_Marte4
Level 6

Re: Adding Field Values for Total Lead Score.

You can't calculate with field values unfortunately. There are some work arounds:

1. Your custom score fields originate from Salesforce. In salesforce you can have a formula field, which combines both.

2. You use the API for some customization script, which do the trick.

3. You use the service I created, called CalcItNow, but I just took it offline this weekend 😉 I'm thinking about selling it. In the tool you can configure formulas, you then get a code to put into a webhook in Marketo. Putting the sum of two fields into another field is pretty much the easiest formula to set up. If anyone is interest in this tool please email me on info@diederikmartens.com.

6x Marketo Champion | Marketo Certified Solutions Architect (MCSA) | Marketo User Group Leader | International Speaker on Marketing Technology
Josh_Hill13
Level 10 - Champion Alumni

Re: Adding Field Values for Total Lead Score.

There is no math in Marketo in this case. Instead, do this in the Flow:

Smart List: Trigger is X

Flow:

Change Score: Behavior Score +5

Change Score: Lead Score +5

Resetting Behavior:

Change Score: Behavior Score =0

Change Score: Lead Score = {{lead.Demographic Score}} (although I find Change Data Value works better here)

Grégoire_Miche2
Level 10

Re: Adding Field Values for Total Lead Score.

We had this issue a while ago with an instance that is not connected to CRM and not the possibility whatsoever to use a webhook. This is how we did it:

The goal was to compute Total score = Behavior + Demographic

We new the demographic score was limited to a maximum of 40, while the behavior score could climb much higher. So we created a smart campaign that looks like this :

  1. Flow step 1 : Total score = {{Lead.behavior score}}
  2. Flow step 2 : 40 choices :
    1. if demographic score = 40 then Total score = +40
    2. if demographic score = 39 then Total score = +39
    3. if demographic score = 38 then Total score = +38
    4. ...
    5. if demographic score = 2 then Total score = +2
    6. if demographic score = 1 then Total score = +1

Not very elegant, takes some patience, I agree but it works.

The hard point is to avoid this flow to be called at each flow step when recomputing the demographic score, which is a multi-step computation. So this smart campaign trigger has 2 triggers :

  • behavior score is changed
  • Campaign is requested

And the demographic score campaign calls it only when it's complete.

-Greg

Alok_Ramsisaria
Level 10

Re: Adding Field Values for Total Lead Score.

You can do this using a webhook OR a complicated smart campaign. Reach out at alok@grazitti.com and we can discuss.