Add two Scores in Marketo

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 - Demographic Score - Normalized
I have a campaign for each of these to fill in normalized scores based on a range:
-Behavior Score:

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.

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.

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

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
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

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}}

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)

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

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?

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.