SOLVED

Comparing two field in Marketo

Go to solution
Highlighted
Level 3

Comparing two field in Marketo

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?

 

Tags (2)
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Comparing two field in Marketo

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

View solution in original post

Highlighted
Level 10 - Community Moderator

Re: Comparing two field in Marketo


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.

View solution in original post

6 REPLIES 6
Highlighted
Level 10 - Community Moderator

Re: Comparing two field in Marketo

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

View solution in original post

Highlighted
Level 3

Re: Comparing two field in Marketo

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.

 

Highlighted
Level 10 - Community Moderator

Re: Comparing two field in Marketo


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.

View solution in original post

Highlighted

Re: Comparing two field in Marketo

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 😕

Highlighted
Level 10 - Community Moderator

Re: Comparing two field in Marketo

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

 

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

Highlighted
Level 5

Re: Comparing two field in Marketo

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