What would be the best way to sync a Revenue field in SFDC to Marketo that can easily be above 2.147billion?

Question

Hi all,In our instance, we have a ZoomInfo enriched field in SFDC that is synced into Marketo called ZI Revenue. But due to the Integer field limitations the moment the records get synced to Marketo, it automatically get updated and reverted back to 2.147Billion which is the highest possible value for a Marketo Integer.
Currently we have stopped the sync but we need the sync to work for FormComplete part.
How do we make sure that the two fields can be synced and yet hold the correct value without changing it to a value that is wrongly assigned by the limitation?

SanfordWhiteman · Accepted Answer

Unfortunately, Marketo has regressed and no longer uses 64-bit Integers. As a result, there isn’t a proper mapping other than String.

@falvares Float & Currency shouldn’t be used here. They lack both range and fidelity.

falvares · Answer

Hi @dhananjayaw ,Do you need the field as an integer type?Marketo has multiple other field types such as Currency/Float or event String (if you do not plan on doing any calculations and just storing data).

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded