SOLVED

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

Go to solution
DhananjayaW
Level 2

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

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?ZI Revenue Field Mapping.pngZI Revenue.png

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

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

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.

View solution in original post

3 REPLIES 3
Floyd_Alvares2
Level 8

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

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
Level 10 - Community Moderator

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

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
Level 8

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

@SanfordWhiteman Agreed!