SFDC Field Types Mapped to Marketo Field Types

[Brian_Law_MKTO]

Field types from SFDC fields are automatically mapped to field types in Marketo.

SFDC Field	Marketo Field Type
Text	String
Long Text Area	Text
Checkbox	Boolean
Picklist	String
Number	Integer but can be changed to Score
Date	Date
Date/Time	Datetime

You can change the field type in Marketo for custom fields as long as the field is not in use.

Common use case: Create a number field in SFDC for Behavioral Score on the lead and contact records and change it to a Score field in Marketo.

Here are some of the field types in Marketo. A full glossary can be found here.

When you change a field type in Marketo the data may be deleted. To preserve the data, you will want to export it and re-import it after you change the field type. You may need to change the format of the value, depending on what the date field will accept and how the string is formatted now. In order to change the field type you'd need to remove it from all assets currently referencing it as well, so if you have a lot it might be easier to create a new field and start using that one instead. Additional information can be found here.

Implications of changing a field's type in SFDC.

Additional resources for learning about the Marketo integration with SFDC.