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