Edit Marketing Cloud Mappings

Topics:

Understand the MarketingCloudCompanyExport Mapping

Note: Mappings that contain contact attributes require a subscription for contact records. For example, the MarketingCloudContact&CompanyMatch mapping requires a subscription for both Oracle Contact Enrichment (for contact attributes) and Oracle Account Enrichment (for company attributes).

Use the following table to understand how MarketingCloudCompanyExport attributes map to Eloqua Marketing Cloud attributes.

Data Attribute	Subscription Level	Eloqua Attribute	Description	Column in TXT/CSV File
External ID	internal attribute	Eloqua Company ID	The unique ID of a company in Eloqua.	Eloqua Company ID
Company ID	internal attribute	DaaS Company ID	The ID of a company in DaaS for Sales.	DaaS Company ID
Business Name	Oracle Account Enrichment	Company Name	The primary or registered name of the business.	Company Name
Street Address 1	Oracle Account Enrichment	Address	The first street address line where a business is physically located. Generally in local language.	Address
Street Address 2	Oracle Account Enrichment	Address 2	The second street address line where a business is physically located. Generally in local language.	Address 2
City	Oracle Account Enrichment	City	The name of the city where the business is physically located. Generally in local language.	City
State Name	Oracle Account Enrichment	State or Province	The full name of the physical state or province name where the business is located.	State or Province
Full Postal Code	Oracle Account Enrichment	Zip or Postal Code	The postal code where the business is physically located.	Zip or Postal Code
County	Oracle Account Enrichment	Country	The full name of the county where the business is located.	Country
Phone Number	Oracle Account Enrichment	Business Phone	The primary phone number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).	Business Phone
Facsimile Number	Oracle Account Enrichment	Fax	The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).	Fax
Major Industry Category	internal attribute	Company Category	A value that denotes under which major industry category an establishment falls.	Company Category
DUNS Number	Oracle Account Enrichment	DUNS Number	A randomly generated nine-digit number assigned by D&B to identify unique business establishments. May contain lead zeros, which are lost if field is treated as numeric.	DUNS Number

Understand the MarketingCloudCompanyMatch Mapping

The Marketing Cloud CompanyMatch mapping attributes are the same as the Marketing Cloud CompanyExport attributes – see Understand the MarketingCloudCompanyExport Mapping.

Understand the MarketingCloudContactExport Mapping

Use the following table to understand how MarketingCloudContactExport attributes map to Eloqua Marketing Cloud attributes.

Data Attribute	Subscription Level	Eloqua Attribute	Description	Column in TXT/CSV File
Person ID	internal attribute	DaaS Person ID	The ID of a contact in DaaS for Sales.	DaaS Person ID
External ID	internal attribute	Eloqua Contact ID	The ID of the contact in Eloqua.	Eloqua Contact ID
Prefix	Oracle Contact Enrichment	Salutation	The prefix (Mr, Ms, Dr, and so on) associated with the professional’s name.	Salutation
First Name	Oracle Contact Enrichment	First Name	The first name of the professional.	First Name
Last Name	Oracle Contact Enrichment	Last Name	The last name of the professional.	Last Name
Title	Oracle Contact Enrichment	Title	This is the title associated with the professional’s role. This is the title as it would read on a professional’s business card.	Title
Email	Oracle Contact Enrichment	Email Address	This is the main email address associated with this professional’s role/contact record.	Email Address
Primary Phone	Oracle Contact Enrichment	Business Phone	This is the direct dial phone number associated with this professional in this role.	Business Phone
DUNS Number	Oracle Contact Enrichment	DUNS Number	DUNS number of the business location.	DUNS Number

Understand the MarketingCloudContactMatch Mapping

The Marketing Cloud ContactMatch mapping attributes are the same as the Marketing Cloud ContactExport mapping attributes – see Understand the MarketingCloudContactExport Mapping.

Understand the MarketingCloudContact&CompanyExport Mapping

Use the following table to understand how MarketingCloudContact&CompanyExport attributes map to Eloqua Marketing Cloud attributes.

Data Attribute	Attribute Type	Subscription Level	Eloqua Attribute	Description	Column in TXT/CSV File
Person ID	Contact	internal attribute	DaaS Person ID	The ID of a contact in DaaS for Sales.	DaaS Person ID
External ID	Contact	internal attribute	Eloqua Contact ID	The ID of the contact in Eloqua.	Eloqua Contact ID
Prefix	Contact	Oracle Contact Enrichment	Salutation	The prefix (Mr, Ms, Dr, etc.) associated with the professional’s name.	Salutation
First Name	Contact	Oracle Contact Enrichment	First Name	The first name of the professional.	First Name
Last Name	Contact	Oracle Contact Enrichment	Last Name	The last name of the professional.	Last Name
Title	Contact	Oracle Contact Enrichment	Title	The title associated with the professional’s role. This is the title as it would read on a professional’s business card.	Title
Email	Contact	Oracle Contact Enrichment	Email Address	The main email address associated with this professional’s role/contact record.	Email Address
Primary Phone	Contact	Oracle Contact Enrichment	Business Phone	The direct dial phone number associated with this professional in this role.	Business Phone
Street Address 1	Company	Oracle Account Enrichment	Address 1	The first street address line where a business is physically located. Generally in local language.	Address 1
City	Company	Oracle Account Enrichment	City	The name of the city where the business is physically located. Generally in local language.	City
State	Company	Oracle Account Enrichment	State or Province	The name of the state/province where the business is located. Generally in local language.	State or Province
Primary Full Postal Code	Company	Oracle Account Enrichment	Zip or Postal Code	The 5-digit postal code where the business is physically located.	Zip or Postal Code
Country	Company	Oracle Account Enrichment	Country	The name of the country where the business is located. In English.	Country
Organization Name	Company	Oracle Account Enrichment	Company	The primary or registered name of the business. Derived from the associated company record.	Company
Sales Volume (US Dollars)	Company	Oracle Account Enrichment	Annual Revenue	The total annual sales/revenue for this business, expressed in US dollars as a signed, decimal field. If the sales/revenue figure is collected in local currency, the local value converts to US dollars. Note: Data converts to US dollars based on the date of the financial figures/statement of the record. If the sales/revenue figure is from Jun-2009, the conversion rate is as of Jun-2009.	Annual Revenue
Employees Total	Company	Oracle Account Enrichment	Employees	The total number of employees in the business organization; it should include subsidiary and branch locations.	Employees
Major Industry Category	Company	internal attribute	Industry	A value that denotes under which major industry category an establishment falls.	Industry
Facsimile Number	Company	Oracle Account Enrichment	Fax	The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).	Fax
Street Address 2	Company	Oracle Account Enrichment	Address 2	The second street address line where a business is physically located. Generally in local language.	Address 2
DUNS Number	Contact	Oracle Contact Enrichment	DUNS Number	DUNS number of the business location.	DUNS Number

Understand the MarketingCloudContact&CompanyMatch Mapping

The Marketing Cloud Contact&CompanyMatch mapping attributes are the same as the Marketing Cloud Contact&CompanyExport mapping attributes – see Understand the MarketingCloudContact&CompanyExport Mapping.