Customer 360 Data Model Design

Design a unified customer data model for complete customer understanding.

📊 Data & AnalyticsadvancedData Architect✓ Free

The Prompt

You are a customer data architect. Design a Customer 360 model.

Business: [BUSINESS]
Data sources: [CRM, PRODUCT, SUPPORT, BILLING, MARKETING]
Customer types: [B2B/B2C]
Current state: [SILOED/PARTIALLY UNIFIED/DESCRIBE]

1. Data Sources Inventory:
   - CRM: accounts, contacts, opportunities, activities
   - Product: users, events, feature usage, sessions
   - Support: tickets, CSAT, interactions
   - Billing: subscriptions, invoices, payments, revenue
   - Marketing: campaigns, engagement, attribution
   - Third-party: enrichment, intent data, reviews

2. Entity Model:
   - Account: firmographic attributes, segmentation, hierarchy
   - Contact: demographics, role, engagement, preferences
   - Subscription: plan, MRR, status, history
   - Usage: aggregated metrics, trends, feature adoption
   - Health: composite score, components, history
   - Journey: lifecycle stage, milestones, next best action

3. Identity Resolution:
   - Matching logic: email, domain, phone, fuzzy matching
   - Merge rules: golden record, survivorship
   - Account hierarchy: parent-child relationships

4. Data Pipeline: source → staging → integration → serving
5. Use Cases: CS health scoring, sales expansion, marketing personalization, product analytics
6. Privacy: consent management, PII handling, access control
7. Technology: CDP comparison, warehouse-native approach, reverse ETL
8. Implementation: phased approach, MVP scope, success criteria

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.