Default Dynamics Field Mapping

When you initially sync your Marketo account with Microsoft, Marketo automatically makes these associations between your built-in Dynamics and Marketo fields. Marketo will also sync your custom fields on your Leads, Accounts, Opportunities, and Contacts.

Lead Fields

Marketo Field MS Dynamics Field MS Dynamics API Name
Microsoft Created Date Created On createdon
Salutation Salutation salutation
First First Name firstname
Middle Middle Name middlename
Last Last Name lastname
Email Email emailaddress1
Job Title Job title jobtitle
Phone Business Phone telephone1
Mobile Mobile Phone mobilephone
Fax Fax fax
Address Street 1 address1_line1
City City address1_city
State State/Province address1_stateorprovince
Country Country/Region address1_country
Postal Code Zip/Postal Code address1_postalcode
Person Source Lead Source leadsourcecode
Person Status Status statecode
Status Reason Status Reason statuscode
Person Notes Description description
Do Not Call Do Not Allow Phone Calls donotphone
Unsubscribed Do not bulk email donotbulkemail
Person Rating Rating leadqualitycode
Microsoft Address 2 Street 2 address1_line2
Microsoft Address 3 Street 3 address1_line3
Microsoft Do Not Email Do Not Allow Emails donotemail
Microsoft Do Not Fax Do Not Allow Faxes donotfax
Microsoft Do Not Send Marketing Material Marketing Material donotsendmm
Microsoft Home Phone Home Phone telephone2
Microsoft Preferred Method Of Contact Preferred Method of Contact preferredcontactmethodcode
Microsoft Topic Topic subject

Contact Fields

Marketo Field MS Dynamics Field MS Dynamics API Name
Microsoft Created Date Created On createdon
Salutation Salutation salutation
First First Name firstname
Middle Middle Name middlename
Last Last Name lastname
Email Email emailaddress1
Job Title Job Title jobtitle
Phone Business Phone telephone1
Mobile Mobile Phone mobilephone
Address Address 1: Street 1 address1_line1
City Address 1: City address1_city
State Address 1: State/Province address1_stateorprovince
Country Address 1: Country/Region address1_country
Postal Code Address 1: Zip/Postal Code address1_postalcode
Person Status Status statecode
Status Reason Status Reason statuscode
Do Not Call Do Not Allow Phone Calls donotphone
Unsubscribed Do not bulk email donotbulkemail
Microsoft Address 2 Address 1: Street 2 address1_line2
Microsoft Address 3 Address 1: Street 3 address1_line3
Microsoft Do Not Email Do Not Allow Emails donotemail
Microsoft Home Phone Home Phone telephone2
Microsoft Preferred Method Of Contact Preferred Method Of Contact preferredcontactmethodcode

Account Fields

Marketo Field MS Dynamics Field MS Dynamics API Name
Account (a) Account accountid
Billing Address Address 1: Street 1 address1_line1
Billing City Address 1: City address1_city
Billing Country Address 1: Country/Region address1_country
Billing Postal Code Address 1: Zip/Postal Code address1_postalcode
Microsoft Billing Address 2 Address 1: Street 2 address1_line2
Microsoft Billing Address 3 Address 1: Street 3 address1_line3
Main Phone Main Phone telephone1
Business Type Business Type businesstypecode
Microsoft Account Number Account Number accountnumber
Microsoft Company Status Status statecode
Annual Revenue Annual Revenue revenue
Company Notes Description description
Industry Industry industrycode
SIC Code SIC Code sic
Website Website website

These fields are created in Marketo but can’t be adjusted by customers.

Marketo Field Description
Microsoft Type Lead or Contact. If empty, the lead exists only as a person in Marketo
Microsoft Created Date Date created in MS Dynamics (can be different from Created in Marketo)
Microsoft is Deleted Person used to be in Microsoft but was deleted and now lives only in Marketo

On this page