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