Re: Marketo rounding figures? How to stop it?

Anonymous
Not applicable

Marketo rounding figures? How to stop it?

Hi All,

Our Marketo instance is integrated with SFDC, which uses Data.com Clean for lead/data enhancement.

Recently some contacts were enhanced by adding their annual revenue, which triggered a bunch of API requests.  Turns out Marketo was rounding the annual revenue and syncing it.... SFDC was seeing the change and pulling it's preferred number from Clean... and on and on. 

Here's the actual text from our SFDC admin.   Is there any setting that toggles on/off this rounding function?  Or any other suggestions?  Thanks!

XXXXXX was a lead in the system over the weekend clean set the Annual revenue to $108,598,708.00. However yesterday Marketo decided to change this value to 108,599,000.00. It appears clean detected this as a change and has moved it back to $108,598,708.00. Any idea why Marketo would have changed that value in the system? They are going to just keep conflicting with each other and making changes back and forth to round the value out?

22 REPLIES 22
Jim_Thao7
Level 9

Re: Marketo rounding figures? How to stop it?

Have you tried to find out the source of the change in Marketo? Activity logs for CDV, etc.? Any details on the sync activity and what was actually pushed to SFDC? Is this the Annual Revenue field on the Company object?  Is this issue happening on a Lead or Contact? Do note that Account sync is 1 way, SFDC>Marketo if the record affected is a Contact.

Anonymous
Not applicable

Re: Marketo rounding figures? How to stop it?

Yes, Annual Revenue is a Company field and this particular example is a Lead.

Activity Log records the change:

pastedImage_0.png

But when you go to the Company Info tab:

pastedImage_1.png

No instance of rounding or any other change is noted in the Activity Log.

Jim_Thao7
Level 9

Re: Marketo rounding figures?  How to stop it?

I would strongly suggest to keep troubleshooting and find the root cause of why it was changed to that value in Marketo.  There definitely has to be a reason why that changed and Marketo should not be automatically changing string values for you that I'm aware of. 

BTW, is there a merge on this record? 

Anonymous
Not applicable

Re: Marketo rounding figures? How to stop it?

No merge.

Thanks.

Jim_Thao7
Level 9

Re: Marketo rounding figures?  How to stop it?

So I just ran a test, and it looks like SFDC is the culprit here.  I would strongly recommend reaching out to your SFDC admin to take a look at the Annual Revenue field and update it accordingly.

Anonymous
Not applicable

Re: Marketo rounding figures?  How to stop it?

Thank you.  What kind of test and what details can I give him?

Jim_Thao7
Level 9

Re: Marketo rounding figures?  How to stop it?

Actually, I take it back, it's not an SFDC issue.  Marketo is pushing a rounded up number to SFDC.  I'll let you know if I can find the real culprit.

Grégoire_Miche2
Level 10

Re: Marketo rounding figures? How to stop it?

Look at any Data value change in Marketo on the field.

It might also look like Marketo pushing it, but in fact some SFDC workflow or trigger that does the change, under the Marketo user name.

-Greg

Jim_Thao7
Level 9

Re: Marketo rounding figures?  How to stop it?

So I've been looking at this and it is definitely Marketo rounding up the numbers.

I have a test lead that is not synced to SFDC

pastedImage_0.png

I updated the value for Annual Revenue to 80923849085 and immediately, this is the value found in the Company Info tab

pastedImage_1.png

There's definitely something going on here directly in Marketo.   I haven't heard or read anything about this, but I will definitely keep looking and listening for things related to this.