Add two Scores in Marketo

[Anonymous]

I want to add two scores ( demographic and Behavior) to new field created in Marketo called , "Sales ready score". The two scores are scored independently. The "Sales ready score" I created having field type "formula", but it does not work therefore, I switched backed to "score",

Any suggestions?

[Anonymous]

Thanks Raj!  I was initially confused by the example in your post as it has hard-coded values; however, when I enlarged the screen shot I was able to see the correct configuration.

[Anonymous]

I have set up a service which can be invoked using webhooks to add scores.  This is in beta (can't guarantee 100% availability/reliability), but we can move this into production if there is enough demand.  Here is how you would configure the webhook

 http://ec2-54-244-75-158.us-west-2.compute.amazonaws.com:9000/add?munchkinId=100-AEK-913&leadId=1090177&score1=99&score2=4

[Anonymous]

I have the scores split up in Latent and Active. These should be combined to a single total lead score. I'm trying to set up a trigger on when one of both scores change to recalculate the total score.

={{lead.Custom Score Active}}+{{lead.Custom Score Latent}}

But the system says only MY. tokens are allowed.

[Anonymous]

Hi Edward - Oops! Yes that was a typo. Demographic Score - Normalized is based on a field called "Demographic Score," not Behavior Score.

I also incorporated Brigid's advice to use tokens to append the two values, rather than multiple processing campaigns.

Flow:
Change Data Value: {{lead.Demographic Score - Normalized:default=D}}{{lead.Behavior Score - Normalized:default=4}}

[Edward_Masson]

Hi Kim S,
I love your score grid and I’m looking to update something similar.
 
I wanted to double check with you, on the Behavior Score – Normalized your using the behavior score field and on the ‘Demographic Score – Normalized’ your using the Behavior Score field again for the range to normalized to a letter.
 
Should it be the ‘Demographic Score – Normalized’ look at the ‘If Demographic Score is 1-20, set normalized to D?
 
I want to get this right as we wanted to move to a 16 grid approach.

[Anonymous]

And it works well I might add :0)  It normalizes the phone number, almost always retrieves the appropriate state and retreives the city when its available.

Raj, are you going to make the addition function available via Webhook as well?

[Anonymous]

I have implemented a webhook service which will format phone numbers and provide geolocation (US/Canada only).  Send me a note if interested in trying this out as a beta - rrajamani@marketo.com

[Anonymous]

Thanks Eric - another cool Webhook tip from you today!  Are there any online string manipulation services out there than can be leveraged (e.g. converting all caps to initial cap, normalizing phone numbers, etc.)?  You should totally write a Webhooks tips article for the Community :0)

[Anonymous]

I did something similar with a Lead Scoring program, but instead of several programs, but created an additional score fields in our CRM software and then leveraged tokens as such:

I used the out of the box score fields in marketo, then ran two different programs for behavioral and demographic using choices.
(ie. if behavioral score is between 100 to 75, then 1, if between 74 and 50 then 2, etc etc)
(if demo score is between 100 and 75 then A, if between 74 and 50 then B...)

then ran a campaign that runs every day that will re-combine the values with tokens

i.e. If: combined score is not empty, then change data value {{behavioral score CRM}} {{demographic score CRM}}

[Anonymous]

Ah but it can if you perform it via a webhook.  There are several online calculators that can do this type of thing

here'sone
www.html2xml.nl/Services/Calculator/Version1/Calculator.asmx?op=Add

1. you would construct the initial GET request
http://www.html2xml.nl/Services/Calculator/Version1/Calculator.asmx/Add?a={{lead.score1:default=0}}&b={{lead.score2:default=0}}

2. setup the parsing to go into the field result
<int xmlns="http://tempuri.org/">3</int>

i.e. make the parse look for the "int"

Hope this helps
Eric

[Anonymous]

Agree Elliott - I didn't read the question close enough - without the CRM doing the formula, then no this won't work.

[Anonymous]

Marketo cannot do arithmetic or string functions other than to append values using tokens.  If you are synching these fields to a CRM, you can create a workflow rule that will add them together and put the sum in a separate field that will by synched back to Marketo.

[Anonymous]

I think that you can use tokens to add the two scores together to make the third field - but it would require a trigger campaign to always look for changes to the original two fields and the timing might be tricky.

[Anonymous]

I set up something similar - I have 2 score fields in Marketo:

- Behavior Score
- Demographic Score

As a score field, each of these is a number.

Then, I have 2 more fields - both of which are string fields:
- Behavior Score - Normalized

(This is normalized to one of 4 values - 1,2,3,4)

- Demographic Score - Normalized

(This is normalized to one of 4 values - A,B,C,D)

I have a campaign for each of these to fill in normalized scores based on a range:
-Behavior Score:

If behavior score is 1-20, set normalized to 4
If behavior score is 21-40, set normalized to 3
If behavior score is 41-60, set normalized to 2
If behavior score is 61+, set normalized to 1

-Demographic Score:

If demographic score is 1-20, set normalized to D
If demographicscore is 21-40, set normalized to C
If demographicscore is 41-60, set normalized to B
If demographicscore is 61+, set normalized to A

Then, I wrote 4 programs to fill in a new string value - Total Score:
Smart list - if Data Value (Behavior Score - Normalized changes) and new value is 1
Flow - if Demographic Score - Normalized is A, set total score to 1A. If Demographic Score - Normalized is B, set total score to 1B

And so on - 4 programs, one for each Behavior Score - Normalized. 4 flow options in each campaign to set Total Score.

Thus, there are 16 score values in a matrix. MQL is Total Score = 1A-3C (i.e., 4s and Ds don't get to sales).