The data model and data extensions
Almost every other finding traces back here. We inventory what exists, establish which tables are actually in use, test whether the relationships hold, and work out why the contact count is what it is — which is usually the finding with the clearest monetary value attached.
- Data extension inventory: what exists, what is referenced, what is dead
- Relationship integrity and key strategy in Contact Builder
- Duplication across extensions and within them
- Retention policy, or its absence, and the storage it costs
- Contact count growth attributed to a specific source
- Consent and preference data: complete, current, and honoured