MS Dynamics Field Data Types supported with Marketo via Native Sync

[AmritTandon]

Below are the MSD field types and how they sync over to Marketo via native sync

MSD Data Types	MSD Field Type	Marketo Data Type	Comment
Single Line of Text	Simple	String
Single Line of Text	Calculated	String
Option Set	Simple	String
Option Set	Calculated	Boolean
MultiSelect Option Set	Simple	String	As Dropdown
Two Options	Simple	Boolean
Two Options	Calculated	Boolean
Image		X	Not supported
Whole Number	Simple	Integer
Whole Number	Calculated	Integer
Whole Number	Rollup	Integer
Floating Point Number		Float
Decimal	Simple	Float
Decimal	Calculated	Float
Decimal	Rollup	Float	The field changes wont sync into Marketo. Hence, should not be used
Currency	Simple	Currency
Currency	Calculated	Currency
Currency	Rollup	Currency	The field changes wont sync into Marketo. Hence, should not be used
Multiple Lines of Text		Text
Date and Time	Simple	DateTime or Date	Depends on the format selected in MSD
Date and Time	Calculated	DateTime or Date	Depends on the format selected in MSD
Date and Time	Rollup	DateTime or Date	Depends on the format selected in MSD. The field changes wont sync into Marketo. Hence, should not be used
Lookup		String	MSD GUID would sync over for the field

Hope this is helpful. Let me know your thoughts 🙂

[AmritTandon]

Rollup fields are unsupported as events in child objects do not generate change events in the rolled up field and hence, changes do not come through.