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

[DhananjayaW]

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?

[Floyd_Alvares2]

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

[SanfordWhiteman · Accepted solution]

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

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

[Floyd_Alvares2]

@SanfordWhiteman Agreed!