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.
Thanks Valerie. We finally got this set up in SFDC, and it works well for synched leads/contacts. Now we need to be able to do this with anon leads in Marketo that aren't synched to SFDC so we can move them from anon to known by targeting their interests. Would love to get a formula field so we could make this happen. If you would too, please vote: "Formula" Field Type .