Skip to content

Field Mapping

Field mapping is the setting that determines which ad source columns correspond to which CRM columns. Correct mapping is a key factor in attribution accuracy.

How it works

For each UTM field, the following are specified:

  1. Primary column in the ad source — where to take the UTM value from
  2. Primary column in the CRM — where to look for the corresponding value
  3. Fallback columns — backup options if the primary column is empty

Mapping table

Ad columns and their fallbacks

UTM fieldPrimary column (Ad)Fallback 1Fallback 2Fallback 3
utm_campaignutm_campaigncampaign_namecampaign
utm_sourceutm_source
utm_mediumutm_medium
utm_contentutm_contentad_namecreative_namead
utm_termutm_term

System ad columns

PurposePrimary columnFallback 1Fallback 2
Ad setadset_namead_group_name
Creative namead_namecreative_namead

Mapping to CRM (Strict Mode)

UTM fieldPrimary CRM columnFallback
utm_sourceutm_source
utm_mediumutm_mediumadset_name, ad_group_name
utm_campaignutm_campaigncampaign_name
utm_contentutm_contentad_name
utm_termutm_term

Mapping to CRM (Non-strict Mode)

In non-strict mode, all 5 UTM fields are mapped directly:

UTM fieldCRM column
utm_sourceutm_source
utm_mediumutm_medium
utm_campaignutm_campaign
utm_contentutm_content
utm_termutm_term

How fallback works

The system checks fields in priority order:

  1. First, the primary column is checked
  2. If the value is empty or missing — Fallback 1 is checked
  3. If Fallback 1 is empty — Fallback 2 is checked
  4. And so on

Example for utm_campaign:

1. Check the utm_campaign column
2. If empty → check campaign_name
3. If empty → check campaign
4. If all are empty → the field participates in matching as "empty"

Manual configuration

In addition to automatic mapping, you can manually specify:

  • Which ad source column corresponds to which CRM column
  • Override the fallback order
  • Exclude a field from matching

Recommendations

For maximum accuracy

  • Use separate UTM fields in your CRM (not a single string field)
  • Fill in all 5 UTM fields in your ads
  • Use standard column names in your CRM (utm_source, utm_medium, etc.)

For maximum coverage

  • Configure fallback columns for all UTM fields
  • Use balanced or loose match mode
  • Enable source constant inference, where applicable

Maintained by the LightLead Documentation Team · Last verified: 2026-07-26