What Marketing Automation Needs From Your Data
Automation platforms are only as smart as the record they're given
A marketing automation platform (MAP) can only personalize, segment, trigger, and score based on data that actually exists in a usable form on the customer record. Teams routinely buy a sophisticated platform expecting it to compensate for a messy or incomplete data foundation, and then blame the platform when automations misfire, sends go to the wrong people, or scoring never gets built. The platform doesn't fix the data — it exposes exactly how good or bad it already was.
The four data categories every MAP needs at minimum
1. Identity — a stable, unique way to recognize the same person across every channel and device: email address at minimum, ideally resolved to a single customer ID that also ties to phone, device IDs, and any CRM record. Without stable identity, the same person shows up as three unrelated contacts, and every segment, score, and journey downstream is wrong.
2. Consent — explicit record of what each contact has agreed to receive, through which channel, and when/how they agreed (critical for GDPR, CAN-SPAM, CASL compliance). Consent isn't a single yes/no flag — it needs to be channel-specific (email opt-in and SMS opt-in are legally separate) and timestamped.
3. Transaction history — what they've purchased, when, how much, at what margin. This is the raw material for RFM scoring, LTV calculation, and any revenue-based segmentation.
4. Engagement history — opens, clicks, site visits, app usage, support interactions. This is what lets a platform distinguish an active, interested contact from a dormant one, and is the primary input to lead scoring and lifecycle stage.
Data category and what breaks without it
| Data category | Minimum viable form | What breaks if missing or poor |
|---|---|---|
| Identity | Unique customer ID resolved across email, device, CRM | Duplicate/fragmented profiles, double-sends, broken attribution, wrong lifecycle stage |
| Consent | Channel-specific opt-in with timestamp and source | Legal/compliance exposure, sends to unsubscribed contacts, blocked deliverability |
| Transaction history | Order date, amount, product, margin, linked to customer ID | No real RFM, no accurate LTV, no margin-aware targeting — segmentation reduces to guesswork |
| Engagement history | Opens/clicks/site events with timestamps, linked to customer ID | Lead scoring has nothing to score on, journeys can't trigger on real behavior, nurture sequences fire blind |
Consent is the one category that can't be backfilled later
Identity resolution is the dependency that breaks everything else
Every other category — consent, transactions, engagement — is only useful if it's reliably attached to the *same* identity record over time. A contact who signs up with a work email, later buys with a personal email, and engages from a mobile app under a third identifier will look like three different people unless the platform (or a connected CDP) actively resolves these into one profile.
Most marketing automation platforms offer only basic identity stitching (usually just deduplication by exact email match). Businesses with meaningfully fragmented identity — multiple brands, apps, and purchase channels — typically need a dedicated Customer Data Platform (CDP) sitting in front of or alongside the MAP specifically to do this resolution before data reaches automation workflows.
BEFORE identity resolution (3 unrelated records):
Contact A: email=j.smith@work.com, source=webform, orders=0
Contact B: email=jsmith22@gmail.com, source=app signup, orders=2
Contact C: device_id=a1b2c3, source=mobile ads, engagement=high
AFTER identity resolution (1 unified profile):
Customer ID: CUST-48213
Emails: j.smith@work.com, jsmith22@gmail.com
Device: a1b2c3
Orders: 2 (from Contact B)
Engagement: high (from Contact C)
Consent: opted in via webform on 2025-03-02
Now RFM, scoring, and journeys all operate on ONE accurate
picture instead of three partial, contradictory ones.Data freshness and completeness thresholds
Beyond having the four categories at all, two practical quality bars matter: freshness (how recently was this data updated — a transaction sync that lags by a week makes real-time triggered campaigns respond to stale information) and completeness (what percentage of contacts actually have usable values in each category — a field that's 90% null is functionally useless for segmentation even if it exists in the schema). Before building any automation that depends on a field, check both: when was it last updated, and for what share of the audience does it actually have a value.
Audit the data before blaming the platform
What's next
Transaction and consent data most often lives split across finance and marketing systems that don't naturally talk to each other. The next lesson covers how to integrate them and reconcile the numbers each side reports.
Next: Integrating Financial & Marketing Information →
I build these systems professionally.
Whether it's a RAG pipeline, analytics migration, or AI workflow — let's talk.