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
Last interesting moment date Last interesting moment date mkt_lastinterestingmomentdate
Last Interesting moment desc Last Interesting moment desc mkt_lastinterestingmomentdesc
Last Interesting moment source Last Interesting moment source mkt_leadinterestingmomentsource
Last interesting moment type Last interesting moment type mkt_lastinterestingmomenttype
Company Company Name companyname
Relative Score Relative Score mkt_relativescore
Priority Priority mkt_priority
Relative Urgency urgency mkt_urgency
Subject Topic subject
Annual Revenue Annual Revenue revenue

The Lead fields below are synced for internal use.

MS Dynamics Field MS Dynamics API Name
Owner  ownerid
created On createdon

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
Last interesting moment date Last interesting moment date mkt_lastinterestingmomentdate
Last interesting moment type Last interesting moment type mkt_lastinterestingmomenttype
Last Interesting moment source Last Interesting moment source mkt_leadinterestingmomentsource
Last Interesting moment desc Last Interesting moment desc mkt_lastinterestingmomentdesc
Microsoft Do Not Send Marketing Material Marketing Material donotsendmm
Microsoft Do Not Fax Microsoft Do Not Fax donotfax
Priority Priority mkt_priority
Relative Urgency urgency mkt_urgency
Relative Score Relative Score mkt_relativescore
Person Notes Description description 
Person Score Lead Score mkt_leadscore
Person Notes Description description 

The Contact fields below are synced for internal use.

MS Dynamics Field MS Dynamics API Name
Owner  ownerid
created On createdon
parentcustomerid Company Name

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
Num Employees Number of Employees numberofemployees
SIC Code SIC Code sic
Company name Account Name
Num Employees Number of Employees numberofemployees

The Account fields below are synced for internal use.

MS Dynamics Field MS Dynamics API Name
Owner  ownerid
created On createdon

Opportunity Fields

Marketo Field MS Dynamics Field MS Dynamics API Name
Close Probability Probabliity closeprobability
Stage status statecode
Actual Close Date Actual Close Date actualclosedate
Name Topic name
Estimated Value Est. Revenue estimatedValue
Description Description description

The Account fields below are synced for internal use.

MS Dynamics Field MS Dynamics API Name
Owner  ownerid
Opportunity opportunityId
Potential Customer customerId

The fields below are created in Marketo but cannot be adjusted by users.

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