TheBar.com Identity & Data Architecture
Cross-Brand Identity Resolution Across a Shared Commerce Ecosystem
Executive Summary
Led the CRM identity and data architecture strategy for the migration of 20+ Diageo brand experiences into a centralized commerce ecosystem on TheBar.com, ensuring brand-level attribution, lifecycle continuity, and scalable personalization within a shared-domain environment.
Designed and operationalized a Salesforce Marketing Cloud data architecture capable of preserving source-level brand identity and consumer intent despite all registrations flowing through a unified ingestion point. Implemented scalable workarounds for SFMC’s relational limitations while enabling downstream segmentation, affinity enrichment, journey orchestration, and future commerce-triggered lifecycle use cases.
This work transformed a fragmented multi-site acquisition model into a centralized but attributable identity framework capable of supporting enterprise-scale CRM personalization.
Business Challenge
Diageo began consolidating numerous standalone brand websites into a single commerce ecosystem: TheBar.com.
This introduced a major CRM architecture problem:
- Multiple brands now shared one signup source
- Consumers could enter from dozens of branded experiences
- SFMC traditionally stored one row per subscriber in affinity tables
- Brand attribution risked being lost at ingestion
- Existing lifecycle programs depended on brand-level identity signals
- Commerce-style use cases required cleaner identity continuity
Without architectural intervention:
- acquisition attribution would collapse
- personalization quality would degrade
- lifecycle journeys would lose contextual relevance
- downstream CDP and media audiences would become unreliable
The system required a method to preserve:
- original source brand
- originating page context
- behavioral identity
- lifecycle continuity
- future segmentation flexibility
—all inside SFMC’s operational constraints.
My Role
Owned CRM ingestion architecture and identity resolution strategy within Salesforce Marketing Cloud for the TheBar.com migration initiative.
Responsibilities included:
- ingestion architecture planning
- source attribution framework design
- Data Extension strategy
- lifecycle continuity mapping
- identity normalization logic
- workaround architecture for SFMC relational limitations
- downstream personalization planning
- cross-brand data governance strategy
Acted as the technical bridge between:
- commerce ecosystem requirements
- CRM operational realities
- SFMC platform constraints
- future CDP activation goals
Technical Architecture
Core Problem
TheBar.com became:
- a centralized acquisition environment
- with decentralized brand intent
A single subscriber could:
- enter from Casamigos
- browse Don Julio
- engage with Bulleit
- purchase Johnnie Walker
—all under one domain and ingestion stream.
Traditional CRM structures were not designed for this level of shared-brand behavioral complexity.
Architecture Solution
Designed a hybrid identity attribution model using:
- shared ingestion endpoints
- structured source attribution values
- auxiliary attribution storage
- affinity normalization
- scalable behavioral enrichment patterns
Example Ingestion Logic
Incoming records contained:
- subscriber identity
- entry source
- URL/page context
- encoded brand attribution values
Example:
BBO | /collections/bulleit-bourbon-recipes
Where:
- BBO represented the originating brand abbreviation
- URL preserved behavioral context
- combined value enabled future parsing and attribution logic
Data Modeling Strategy
Problem
Standard affinity tables in SFMC supported:
- one subscriber
- one current state row
This structure could not reliably store:
- many-to-many source relationships
- evolving multi-brand behavioral history
- repeated source interactions
Solution
Architected supplemental attribution storage patterns to preserve:
- historical source entries
- multi-brand identity relationships
- evolving behavioral context
This allowed:
- normalized sendable identity
- while preserving granular acquisition intelligence separately
The design balanced:
- SFMC performance constraints
- operational simplicity
- future extensibility
Lifecycle Continuity Strategy
Ensured existing CRM programs could continue operating despite migration to a shared ecosystem.
Maintained:
- welcome journey continuity
- brand-specific personalization
- affinity enrichment logic
- engagement attribution
- downstream segmentation compatibility
Designed architecture so that:
- acquisition source remained actionable
- journeys still “understood” brand intent
- future automation layers could build upon the same framework
CRM Intelligence Strategy
This architecture enabled future-state capabilities including:
Cross-Brand Behavioral Intelligence
Consumers could accumulate signals across:
- categories
- brands
- products
- occasions
without losing original acquisition context.
Smarter Personalization
Enabled:
- brand-aware lifecycle messaging
- product-level segmentation
- category affinity development
- multi-brand recommendation logic
Future Commerce Activation
Architecture supported future expansion into:
- abandon cart
- browse abandonment
- product recommendation systems
- purchase-triggered journeys
- CDP audience syndication
- paid media lookalikes
Platform Constraints Solved
This work required designing around several SFMC limitations:
Constraints
- non-relational architecture
- limited native identity resolution
- shared sendable model limitations
- single-row affinity structures
- cross-brand attribution complexity
Solutions
Implemented:
- encoded source structures
- supplemental attribution storage
- normalization logic
- modular enrichment frameworks
- scalable ingestion conventions
This allowed enterprise-level identity behavior modeling inside a platform not inherently designed for modern commerce identity graphs.
Business Impact
Operational Impact
- preserved attribution integrity during migration
- prevented lifecycle disruption
- enabled scalable cross-brand CRM operations
- reduced future rework risk
Strategic Impact
- established groundwork for enterprise behavioral intelligence
- improved long-term personalization readiness
- enabled future commerce-triggered CRM use cases
- supported downstream CDP and audience activation strategies
Organizational Impact
Positioned CRM not as a downstream execution tool, but as a core architectural layer within the broader consumer identity ecosystem.
Key Demonstrated Capabilities
- Enterprise CRM architecture
- Identity resolution strategy
- SFMC data modeling
- Multi-brand ecosystem design
- Lifecycle systems thinking
- Ingestion architecture
- Attribution framework design
- Behavioral intelligence strategy
- Platform constraint workaround design
- Cross-functional technical leadership
Why This Work Matters
Most CRM systems assume:
- one brand
- one source
- one identity path
This architecture solved for:
- many brands
- many behavioral entry points
- shared commerce infrastructure
- evolving identity relationships
while still maintaining operational scalability inside Salesforce Marketing Cloud.
This is sophisticated enterprise CRM systems architecture—not simply campaign execution.