MS Dynamics Field Data Types supported with Marketo via Native Sync
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 🙂