Field Automapping 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 align input with the Marketing Intelligence semantic data model.

Review the suggested mappings and make adjustments as needed before deploying the pipeline. Marketing Intelligence selects the appropriate data model template based on uploaded data and suggests mappings based on these considerations.

• Field name matching—aligns DLO and data model object (DMO) fields using exact match, standardized match, and fuzzy match to account for minor spelling or formatting differences.
• Synonyms—includes common synonyms in comparisons to improve mapping accuracy. For example, a DLO field named "Spend" likely maps to "Media Spend."
• Template selection rules—Marketing Intelligence selects one of these data model templates.
  • Delivery Template—tracks marketing content delivery and channel performance. For example, impressions, clicks, media buy, ads, and campaign.
  • Conversion Tag Template—measures customer actions resulting from marketing interactions. For example, purchases or customer actions.
  • Web Analytics Events Template—captures visitor interactions at the event level on a website, such as form fills or button clicks.
  • Web Analytics Pages Template—captures interactions at the individual page level, such as views, exits, and visitor engagement.