Mapping connects the source fields in your uploaded file to the corresponding Marketing Cloud Intelligence Data Pipelines fields. MDP uses machine learning algorithms to map your data. The mapping process is similar regardless of which method you use to upload your data, with some minor differences. If you’re using an API connector to upload your data, MDP automatically maps the fields for you, but you can make changes to the mapping. If you’re using TotalConnect, MDP identifies the most suitable data stream type according to your data and offers an initial mapping suggestion.
- MDP View How Your Data Is Mapped
On the mapping page, you can see all the fields that were mapped and unmapped in your data stream. - Map a Source Field to a MDP Field
Map source fields to Marketing Cloud Intelligence Data Pipelines fields to connect the data and create a match between your source data and MDP. - MDP Change the Data Stream Type
All data in Marketing Cloud Intelligence Data Pipelines is categorized using data steam types. A data stream type is assigned automatically when data is uploaded. For example, if the data includes advertising data, such as clicks, impressions, and campaigns, MDP applies the Ads data stream type. You can change the data stream type if it isn’t correct, or use a different type. - MDP Customize a Field
You can customize an existing data model field. - MDP Use the Formula Editor to Map
You can apply formulas directly to your field mappings to perform complex manipulations of your data. The formulas are intuitive and use a similar syntax found in Excel. For more complex manipulations, you can also use MVEL, a Java-based expression language. You apply formulas during the mapping stage when creating data streams. - MDP Mapping Actions
There are some handy actions you can apply when mapping. Some appear in the toolbar, while others can be found in the More Actions dropdown list. - MDP Mapping Validations
TotalConnect and API data streams offer enhanced mapping validations during the Map to Model stage of data ingestion. The mapping validations allow you to check if there are errors or irregularities with your mapping. They also provide details on how you can rectify errors. - Mapping Formulas
Use the mapping formula editor to apply formulas directly in your mapping fields. Using functions in your mapping formulas, such as text and date functions, allows you to perform more complex manipulations to your data. - Date Format Syntax
When setting up date formats in TotalConnect, you may need to convert textual data to dates using formulas. The PARSEDATE function can be used for the conversion. The function receives text containing the date information, and an expression that specifies how to construct the date using the text. - Formula Operators
A formula is a mathematical relationship or rule expressed in symbols. With Marketing Cloud Intelligence Data Pipelines, you can use formulas to create calculated measurements and dimensions when mapping your data. Operators specify the type of calculation to perform on the terms in a formula—such as addition, subtraction, multiplication, or division. - Mapping Functions in MDP
Functions are used when creating mapping formulas, allowing you to perform complex manipulations to your data. These functions are available in Marketing Cloud Intelligence Data Pipelines and are divided into different groups to easily search for the function you’re looking for. - Control Flow Operators in MDP
Marketing Intelligence Data Pipelines supports an assortment of control flow operators, so you can perform advanced scripting operations. Aside from the custom functions that are supported in the formula editor, you can write formulas based in C and Java Script syntax to make more complex decisions. - Mapping Geolocation Dimensions in MDP
Geolocation refers to the geographical location of an internet-connected device. Found from the user's IP address, geolocation includes information about the device user's location, such as country, region, and city.