Automation and AI

Field Mapping

Also called data mapping

The instruction that tells one system which box a piece of data belongs in when it arrives from another system.

Quick facts: Field Mapping

Category
Automation and AI
Also called
data mapping
Level
Intermediate
Affects
Data quality, attribution, automation reliability
Where to see it
Zapier, Make, n8n, native CRM integrations, webhook logs
In this article4
  1. How field mapping works
  2. Why field mapping matters
  3. Where field mapping goes wrong
  4. How to act on it

How field mapping works

Two systems almost never describe the same thing in the same way. A web form calls it Full name; the CRM wants a first name and a last name. The form calls it Service; the CRM expects one of a fixed list of options and will reject anything else. A field map is the line-by-line instruction that says which field on the way out becomes which field on the way in.

Real maps do more than pair names. They transform: splitting a name at the space, adding or stripping a country code on a phone number, converting a date into the format the destination expects, translating the words a visitor chose into the option value the destination stores internally. They also satisfy the destination’s required fields, which is why a record can be refused outright for missing something the sender never had.

The fields worth mapping are wider than most people set up. Alongside name, email and phone, the useful ones are the page the enquiry came from, the campaign parameters, and the ad click identifiers that let a platform match a sale back to a click.

Why field mapping matters

It is the point where marketing data either survives the journey or quietly dies. An enquiry that arrives in the CRM without its source cannot be attributed to any channel, so the reporting you built on top of it is guesswork with a chart around it.

It also decides whether automation is trustworthy. Routing rules, follow-up sequences and lead scoring all read fields. If the industry field is sometimes a dropdown value and sometimes free text, every rule downstream behaves inconsistently and nobody can say why.

Where field mapping goes wrong

The dangerous failure is the silent one. An unmapped field is usually just dropped: the record arrives, looks complete, and nobody notices the missing column until a report is questioned months later.

Phone numbers cause more trouble than anything else, especially where numbers are entered sometimes with a country code and sometimes without. The same person then appears twice, and matching against ad platform data fails. Dropdown values are the second offender, because renaming an option in one system breaks a map that still refers to the old value. And someone renaming a form field without checking what reads it will break an integration that had worked for a year.

How to act on it

Write the map down before you build it — source field, destination field, what happens in between, and what should occur if the value is missing. That document is what lets somebody else fix the integration when you are unavailable.

Standardise formats at the source rather than patching them later: one date format, one phone format including the country code, dropdowns instead of free text wherever a fixed list exists. Push a test record through end to end and open it in the destination, checking the campaign parameters arrived as well as the name. If data flows both ways, agree in advance which side wins a conflict, because a two-way sync without that rule will overwrite good data with old data.

Do and do not

Do

  • Map source, campaign and click identifiers, not just contact details
  • Send a test record through and open the destination
  • Agree which system wins when both hold a value

Do not

  • Leave unmapped fields to fail silently
  • Store phone numbers in inconsistent formats
  • Rename a field without checking what reads it

Questions people ask about this

Why did my form submission arrive with fields missing?

Usually because those fields were never mapped, or because the destination rejected the value. Most integrations drop what they cannot place rather than raising an error, so the record looks fine at a glance. Open the integration log for a failed run, compare it against a submission you made yourself, and check required fields and dropdown values first.

Should I map every available field?

No. Map what someone will actually use: contact details, what the person asked for, the page they were on, and the campaign and click identifiers needed for reporting. Every extra field is another thing to maintain and another way for a rename to break the integration. Start narrow and add fields when a real question needs them.

How do I stop duplicate contacts being created?

Choose a matching key, normally email address, and make sure both systems store it in the same lower-case form. Standardise phone numbers to one format with the country code, since a number stored two ways will match neither. Then set the integration to update an existing record when the key matches rather than always creating a new one.

Related terms

Found this useful?

Share it, or ask an AI to summarise it

Back to the glossary

Knowing the term is the easy part

Applying it to your own site and budget is the work. Book a call and I will tell you what actually applies to you.