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 |
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 |