Comparing two field in Marketo

[Jay00031987]

Business need is to compare two fields and based on that update the lead score. Both fields are integer types and if both value are same that time need to update the lead score. Both field value are being updated from REST API call. 

What would be simplest way in Marketo to compare those fields and update the score?

[SanfordWhiteman · Accepted solution]

You need to use a webhook-based service to compare Integer/Score fields in Marketo (in general, fields are not comparable to each other within a Smart Campaign — as opposed to comparing a field with a known static value).

[Jay00031987]

Hi Sanford,

Is it possible to store the result using VTL in Marketo?  If Yes, then I would like to set the value as boolean and based on that update the score. 

Else, I will go with the approach as suggested Webhook-based service.

[SanfordWhiteman · Accepted solution]

---

Is it possible to store the result using VTL in Marketo?  If Yes, then I would like to set the value as boolean and based on that update the score. 

---

Store, no. Velocity can certainly compare any fields you want, any way you want. But it can only output email content based on conditions, it can't update the fields in the database.

[BenjaminJacquet]

You may be able to do this in the flow of a Smart Campaign using a choice. 

Say you have something like

SL:

- Trigger Data Value changes (Field A) 

- or Trigger Data Value changes (Field B)

Flow:

Changes Score:

- Choice 1 if (Field A) is {{lead.Field B}}, change the score

- Else, do nothing

I don't have Integer fields that I can readily edit to test but it works fine with Strings and given you're looking for "equal" value, I can't imagine it would be very different.

Otherwise you could consider storing the value into String fields but that's not a very "elegant" solution 😕

[SanfordWhiteman]

I think you need to test this again, Benjamin. 🙂 

Unless something has drastically changed, it doesn't work the way you describe.

[Jo_Pitts1]

Jay,

I know @SanfordWhiteman hasn't mentioned a specific service, but FlowBoost is a fantastic service to use for the type of stuff you want to do (http://flowboost.tk/).   I'm guessing the reason he didn't mention it is because FlowBoost is his baby and I think the ToS stops him from mentioning his own work :).

Cheers

Jo