---
schema_version: "1"
id: 8fbbad4e779b20a09c446120ac55432cd84924f9b04d68cf4eb238741a856925
title: Map Data in Marketing Intelligence
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_mi_mapping_in_mi.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_mi_mapping_in_mi.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f79b619d894c3f65f46abec036a69c086d7476d32f43886a663fe33fee562e39
description: Map source data to the Marketing Intelligence data model to prepare it for analysis and reporting. Review automatically suggested mappings, transform source values with mapping formulas, and resolve validation errors before deploying your data pipeline.
products:
  - Marketing
  - Marketing Cloud Intelligence
  - Marketing Cloud Next
release: "264"
---
# Map Data in Marketing Intelligence

Map source data to the Marketing Intelligence data model to prepare it for analysis and reporting. Review automatically suggested mappings, transform source values with mapping formulas, and resolve validation errors before deploying your data pipeline.

- **[Field Mapping in Marketing Intelligence](https://help.salesforce.com/s/articleView?id=mktg.mc_mi_automapping.htm&release=264.0.0&type=5)**  
    Automapping streamlines data integration by automatically mapping source file or Data Lake Object (DLO) fields to the Marketing Intelligence data model. TotalConnect automatically creates the data transforms necessary to align input with the Marketing Intelligence semantic data model.
- **[Troubleshooting Mapping Errors in Marketing Intelligence](https://help.salesforce.com/s/articleView?id=mktg.mc_mi_troubleshooting_mapping.htm&release=264.0.0&type=5)**  
    TotalConnect automatically validates your data mapping to meet system requirements during ingestion. These validations detect errors like missing templates, mismatched data types, or unmapped primary keys and provide guidance for resolution. Improving data accuracy enhances analysis and reporting quality.
- **[Mapping Formulas in Marketing Intelligence](https://help.salesforce.com/s/articleView?id=mktg.mc_mi_mapping_formulas.htm&release=264.0.0&type=5)**  
    Mapping formulas transform source data during ingestion, before it’s stored in Marketing Intelligence. Use them to clean, standardize, and enrich incomplete, inconsistent, or incorrectly formatted data without editing the source files. Unlike calculated fields in the semantic layer, which apply logic at runtime, mapping formulas permanently change the stored values.