Example deliverable · technical diagnosis

From customer data question to architecture decision

Fictional example using synthetic data.

This document illustrates the approach and deliverable; it does not describe an actual client project.

What you receive at the end of a technical diagnosis: the question and its boundaries, what the evidence shows and what is still an assumption, the decisions that need an owner, and how the team validates and takes over the follow-up.

A

Question, scope and facts

Original question

"We want to build audiences across our CRM, the webshop and the loyalty programme and use them in our marketing channels. Can our data support that, and what does the target architecture need to account for?"

Current situation, simplified

  • CRM: customer master with a customer number and email address. One marketing opt-in field with a date.
  • E-commerce platform: accounts with email as the login, order history, guest checkout without an account, and its own newsletter checkbox.
  • Loyalty programme: card number and points transactions. Part of the members is linked to a CRM customer number.

The organisation is considering a CDP. Adobe Real-Time CDP is one of the options; no platform has been chosen.

Synthetic evidence available

  • E1 Field definitions exported from the three systems.
  • E2 A synthetic sample of 10,000 records per system, with the keys that can link them.
  • E3 The three audience definitions marketing currently uses: "active customers", "lapsed customers" and "newsletter".
  • E4 Notes from conversations with the CRM owner and the e-commerce product owner.

Missing information

  • How loyalty members get linked to a CRM customer number: by hand, at sign-up, or in a batch job.
  • Which channels the audiences go to, and how quickly an audience needs to update.
  • The consent texts and the legal basis per channel.
  • Whether in-store purchases reach the CRM.

Out of scope

Platform selection and vendor comparison, the implementation itself, a legal assessment of the consent texts, and cleansing of the source data.

B

Findings and decisions

Established means the evidence shows it directly. Hypothesis means it is a plausible explanation that still has to be checked. There are no urgency scores: the order in section C follows which decisions other decisions depend on.

All figures come from the synthetic sample.

#ObservationEvidence or assumptionPossible impactDecision or follow-up needed
1 "Active customer" has three definitions: an order in the last 12 months (CRM), a login in the last 90 days (webshop), a points transaction in the last 6 months (loyalty). Established
E1, E4. Each definition fits the purpose of the team that uses it. The difference itself is deliberate and not an error.
None, as long as each definition is used under its own name. Keep the three definitions, give them distinct names in the documentation.
2 The marketing audience "active customers" adds up counts from all three systems without stating which definition applies. Established
E3. This is where the difference turns into inconsistent use.
Audience sizes cannot be compared between campaigns; one person can be counted up to three times. Marketing decides on one definition for cross-channel audiences, with the source fields named.
3 31% of webshop accounts match a CRM record on email address; 18% of loyalty members have no CRM customer number. Established
E2.
One customer ends up as several profiles; loyalty-only members fall outside CRM-based audiences. Agree identity rules: which keys link records, in what order of priority, and what happens to guest orders.
4 The low match rate between webshop and CRM comes from guest checkouts and from customers using a different email address in each system. Hypothesis
E2 shows the gap, not its cause. Suggested by the product owner in E4.
If the cause lies elsewhere, identity rules built on this assumption will not close the gap. Check 200 unmatched records together with the e-commerce product owner before the identity rules are fixed.
5 Consent is recorded in two places, CRM opt-in and the webshop checkbox, with no rule for which one wins. 6% of matched customers have conflicting values. Established
E1, E2. Which system is leading is not documented.
A customer who withdrew consent in one system can still be selected through the other. Decide the leading source per purpose and channel. Legal confirms the basis; that assessment is outside this scope.
6 "Lapsed customers" includes people who now buy in store, where those purchases do not reach the webshop data. Hypothesis
Based on E4; not visible in the sample.
Loyal store customers receive win-back campaigns. Establish whether store sales reach the CRM, and with which key.

What this means for the platform choice

A CDP can hold several definitions side by side and link identities, but it does not decide which definition is leading or which consent value wins. Findings 2, 3 and 5 need a decision whichever platform is chosen, Adobe Real-Time CDP included. Those decisions then become requirements for the platform selection: which identifiers, which channels, how fast an audience needs to update.

C

Approach, validation and handover

Recommended order and owners

  1. Leading consent source per purpose and channel (finding 5). Owner: privacy officer with the CRM owner. First, because every activation depends on it.
  2. Check hypotheses 4 and 6. Owners: e-commerce product owner and CRM owner, with the architect. Before step 3, so the identity rules rest on verified causes.
  3. Identity rules (finding 3). Owner: data architect with the three system owners.
  4. One definition for cross-channel audiences (finding 2). Owner: marketing lead with an analyst.
  5. Platform requirements derived from steps 1 to 4, as input for the platform choice. Owner: the programme lead.

Acceptance criteria

  • Every cross-channel audience names its definition and its source fields.
  • For each purpose and channel, the consent source and the rules for conflicting values are documented. Test cases confirm that withdrawn consent blocks the activation concerned, even when another source system still holds a positive value.
  • The identity rules are written down, with test records for three cases: a matched customer, a guest order, and a loyalty member without a CRM number.
  • The "active customers" count can be reproduced from the source data, and any difference above the threshold the team agrees is explained.

Validation

  • Re-run the sample analysis with the same queries once the decisions are in place, and compare the results with this report.
  • Walk through 20 test profiles with the system owners.
  • Follow one audience from source to destination in a test environment before anything goes to production.

Remaining uncertainties

  • The causes behind findings 4 and 6 have not been verified.
  • The legal basis per channel was not assessed in this engagement.
  • The analysis covers a sample; the full data set may show patterns the sample does not.

What the handover contains

  • This report, with a reference to the evidence behind each finding.
  • A decision log with owner and status per decision.
  • The queries used, so the team can repeat the analysis without me.
  • Test records and acceptance criteria.
  • A walkthrough of an hour with the people who will carry out the follow-up.

This example is fictional and not one of the case studies. Scope, evidence and deliverable are agreed per engagement.