Default Dynamics Field Mapping
Last update: October 25, 2023
- Topics:
- Microsoft Dynamics
When you initially sync your Marketo Engage 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 |
| 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 |
| 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 | Account Name | 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
Microsoft-Related System Fields in Marketo (Read-only)
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
recommendation-more-help
94ec3174-1d6c-4f51-822d-5424bedeecac