📊
D365 Customer Insights
Customer Data Platform (CDP) and journey orchestration — unified customer profiles, segmentation, AI predictions, and real-time marketing journeys.
CDPData UnificationSegmentsJourneysLead ScoringGDPR ConsentAI Predictions75 Questions
Questions 1–10 of 75
D365 Customer Insights is Microsoft's Customer Data Platform (CDP) and Journey Orchestration platform with two main components:
1. Customer Insights - Data (formerly Customer Insights): A CDP that unifies customer data from multiple sources (CRM, ERP, website, loyalty system) into a single unified customer profile. Provides 360-degree customer view, segments, and AI-powered enrichments.
2. Customer Insights - Journeys (formerly D365 Marketing): A real-time marketing and journey orchestration platform for designing multi-step customer journeys across email, SMS, push notifications, and custom channels. Includes event management, lead scoring, and outbound marketing.
1. Customer Insights - Data (formerly Customer Insights): A CDP that unifies customer data from multiple sources (CRM, ERP, website, loyalty system) into a single unified customer profile. Provides 360-degree customer view, segments, and AI-powered enrichments.
2. Customer Insights - Journeys (formerly D365 Marketing): A real-time marketing and journey orchestration platform for designing multi-step customer journeys across email, SMS, push notifications, and custom channels. Includes event management, lead scoring, and outbound marketing.
💡 Pro Tip: Always distinguish the two components in interviews. "Customer Insights" alone is ambiguous — clarify whether the question is about the CDP (Data) or the Marketing/Journey Orchestration (Journeys) component. This distinction alone signals advanced product knowledge.
A Unified Customer Profile is a consolidated 360-degree view of a single customer, assembled from data ingested across multiple source systems.
Profile components: Demographic data (name, email, address, phone), Transactional data (purchase history, order value, frequency), Behavioural data (website visits, email engagement), Service data (case history, satisfaction scores), Loyalty data (points, tier), Predicted attributes (churn score, CLV, product affinity).
How profiles are created: Ingest data from multiple sources → Unify (match records across sources to the same person) → Merge (combine fields from different sources) → Enrich (add intelligence) → Measure (calculate KPIs) → Export (to downstream systems for activation).
Profile components: Demographic data (name, email, address, phone), Transactional data (purchase history, order value, frequency), Behavioural data (website visits, email engagement), Service data (case history, satisfaction scores), Loyalty data (points, tier), Predicted attributes (churn score, CLV, product affinity).
How profiles are created: Ingest data from multiple sources → Unify (match records across sources to the same person) → Merge (combine fields from different sources) → Enrich (add intelligence) → Measure (calculate KPIs) → Export (to downstream systems for activation).
💡 Pro Tip: The unified profile is the core CDP value proposition. When discussing it, always emphasise the identity stitching problem: one customer may be Jane Smith in the CRM, jane.smith@email.com on the website, and customer #12345 in the ERP. The CDP resolves all three into one profile.
Data Unification is the process of identifying records across multiple data sources that belong to the same real-world customer and merging them into a single unified profile.
Unification stages:
1. Source data selection — choose which entities from each data source to include.
2. Deduplication — remove exact and near-exact duplicates within each source.
3. Matching rules — define how records across sources are matched.
4. Merge policies — for fields that exist in multiple sources, define which source wins.
Matching rule configuration: Entity pair (CRM Contacts + eCommerce Customers). Match criteria: Email (exact) OR (First Name + Last Name + Postal Code, fuzzy match with normalisation). Precision levels: Exact → High → Medium → Low.
Unification stages:
1. Source data selection — choose which entities from each data source to include.
2. Deduplication — remove exact and near-exact duplicates within each source.
3. Matching rules — define how records across sources are matched.
4. Merge policies — for fields that exist in multiple sources, define which source wins.
Matching rule configuration: Entity pair (CRM Contacts + eCommerce Customers). Match criteria: Email (exact) OR (First Name + Last Name + Postal Code, fuzzy match with normalisation). Precision levels: Exact → High → Medium → Low.
⚠ Key Point: Identity resolution quality makes or breaks a CDP implementation. Poorly configured matching results in either phantom profiles (same person split into two) or merged profiles (two different people treated as one). Spend significant time on match rule definition.
Segments are groups of customers meeting specified criteria — used for targeting in marketing campaigns, personalisation, and reporting.
Segment types: Static segments (members do not update automatically, used for one-time campaign lists). Dynamic segments (automatically update as customers meet/leave criteria). Composed segments (union, intersection, or exclusion of other segments).
Segment builder: Filter customers by profile attributes (age, city, loyalty tier), behavioural data (purchased in last 30 days), predictive scores (churn risk > 70%), and segment membership. Combine conditions with AND/OR logic.
Segment export/activation: Segments exported to D365 Journeys (for campaigns), D365 Sales (for targeted outreach), Advertising platforms (LinkedIn, Google Ads), Email tools (Mailchimp, Constant Contact).
Segment types: Static segments (members do not update automatically, used for one-time campaign lists). Dynamic segments (automatically update as customers meet/leave criteria). Composed segments (union, intersection, or exclusion of other segments).
Segment builder: Filter customers by profile attributes (age, city, loyalty tier), behavioural data (purchased in last 30 days), predictive scores (churn risk > 70%), and segment membership. Combine conditions with AND/OR logic.
Segment export/activation: Segments exported to D365 Journeys (for campaigns), D365 Sales (for targeted outreach), Advertising platforms (LinkedIn, Google Ads), Email tools (Mailchimp, Constant Contact).
💡 Pro Tip: Segment refresh frequency is a critical requirement. Real-time segmentation matters for time-sensitive use cases (abandoned cart — send within 1 hour). Daily refresh is sufficient for most campaign use cases. Understand the use case to determine the right refresh frequency.
Journey Orchestration designs and executes automated, multi-step customer communication sequences that respond to customer behaviour in real time.
Journey types: Trigger-based (real-time) — starts when a customer takes an action ("Customer submits form", "Lead score reaches 50"). Segment-based — starts when a customer enters a segment ("All customers in the Lapsed 90 days segment"). Recurring — executes on a schedule ("Monthly newsletter").
Journey canvas elements: Trigger (start event), Wait (time delay or event-based wait), Send email/SMS, If/Else branch (condition split), Run flow (trigger Power Automate), Create lead/opportunity (in D365 Sales), Exit conditions.
Example welcome journey: Trigger: Contact created (from web form) → Immediate: Send welcome email → Wait 3 days → If opened email: Send onboarding guide; Else: Send re-engagement email → Wait 7 days → Create Sales Task for rep.
Journey types: Trigger-based (real-time) — starts when a customer takes an action ("Customer submits form", "Lead score reaches 50"). Segment-based — starts when a customer enters a segment ("All customers in the Lapsed 90 days segment"). Recurring — executes on a schedule ("Monthly newsletter").
Journey canvas elements: Trigger (start event), Wait (time delay or event-based wait), Send email/SMS, If/Else branch (condition split), Run flow (trigger Power Automate), Create lead/opportunity (in D365 Sales), Exit conditions.
Example welcome journey: Trigger: Contact created (from web form) → Immediate: Send welcome email → Wait 3 days → If opened email: Send onboarding guide; Else: Send re-engagement email → Wait 7 days → Create Sales Task for rep.
💡 Pro Tip: Real-time journeys are the strategic direction for D365 Customer Insights - Journeys. Outbound Marketing (older batch-based engine) is being retired. For new implementations, always build on real-time journeys exclusively.
Lead Scoring assigns a numeric score to leads based on profile attributes and behavioural engagement — helping sales prioritise leads most likely to convert.
Lead scoring dimensions:
Profile attributes: Job title (Director/VP = +20), Industry (Financial Services = +15), Company size (500+ employees = +10).
Behavioural engagement: Email opened (+5), Link clicked (+10), Webinar attended (+15), Pricing page visited (+20), Demo requested (+30).
Negative scoring: Email bounced (-10), Unsubscribed (-50), Inactive 30 days (-5 per week).
Sales Ready threshold: When a lead reaches the threshold (e.g., 60 points), it is automatically flagged as MQL (Marketing Qualified Lead), assigned to a sales rep in D365 Sales, and a notification is sent.
Lead scoring dimensions:
Profile attributes: Job title (Director/VP = +20), Industry (Financial Services = +15), Company size (500+ employees = +10).
Behavioural engagement: Email opened (+5), Link clicked (+10), Webinar attended (+15), Pricing page visited (+20), Demo requested (+30).
Negative scoring: Email bounced (-10), Unsubscribed (-50), Inactive 30 days (-5 per week).
Sales Ready threshold: When a lead reaches the threshold (e.g., 60 points), it is automatically flagged as MQL (Marketing Qualified Lead), assigned to a sales rep in D365 Sales, and a notification is sent.
💡 Pro Tip: Lead scoring is most valuable when the threshold is calibrated against real win rate data. Ask clients: "At what level of engagement do leads typically close?" Use historical CRM data to set the threshold, then review after 3 months and adjust.
Consent Management ensures that communications are only sent to customers who have given explicit consent — a legal requirement under GDPR (EU), PDPA (India/SEA), CAN-SPAM (US).
Consent model: Contact Point Consent tracks consent at the level of a specific email address or phone number for a specific purpose (Commercial, Transactional, Tracking). Topics are sub-categories (Product Updates, Newsletter, Promotions).
Consent levels: Opted In (explicit consent given, can send). Opted Out (explicitly unsubscribed, must not send). Not Set (behaviour depends on compliance level setting).
Compliance profiles: Restrictive (only send to Opted In contacts). Non-restrictive (send to all unless Opted Out).
Double opt-in: Send confirmation email after subscription; only record consent when confirmation link is clicked.
Consent model: Contact Point Consent tracks consent at the level of a specific email address or phone number for a specific purpose (Commercial, Transactional, Tracking). Topics are sub-categories (Product Updates, Newsletter, Promotions).
Consent levels: Opted In (explicit consent given, can send). Opted Out (explicitly unsubscribed, must not send). Not Set (behaviour depends on compliance level setting).
Compliance profiles: Restrictive (only send to Opted In contacts). Non-restrictive (send to all unless Opted Out).
Double opt-in: Send confirmation email after subscription; only record consent when confirmation link is clicked.
⚠ Key Point: GDPR non-compliance can result in fines up to 4% of global annual revenue. Always include a dedicated consent management section in your BRD for any marketing project. Document the compliance level, consent capture mechanism, and consent preference centre requirements.
D365 Customer Insights - Data includes built-in AI prediction models that generate predictive scores without requiring data science expertise:
Out-of-box prediction models:
Customer Churn Prediction: Predicts the probability a customer will churn in the next X days. Configurable churn definition (no purchase in 60 days). Returns a churn score (0-100%) per customer profile.
Customer Lifetime Value (CLV) Prediction: Predicts total revenue a customer will generate over their lifetime.
Product Recommendation: Predicts which products a customer is likely to purchase next based on purchase history.
Activation example: Churn score added to unified profile → Segment "High Churn Risk" created → Exported to D365 Journeys for win-back campaign activation.
Out-of-box prediction models:
Customer Churn Prediction: Predicts the probability a customer will churn in the next X days. Configurable churn definition (no purchase in 60 days). Returns a churn score (0-100%) per customer profile.
Customer Lifetime Value (CLV) Prediction: Predicts total revenue a customer will generate over their lifetime.
Product Recommendation: Predicts which products a customer is likely to purchase next based on purchase history.
Activation example: Churn score added to unified profile → Segment "High Churn Risk" created → Exported to D365 Journeys for win-back campaign activation.
💡 Pro Tip: Prediction models require sufficient historical data. The churn model needs at least 12 months of transaction history and a minimum of 1,000 customer records. Always check data availability before committing to predictive scoring requirements.
D365 Customer Insights - Journeys has two marketing engines. Understanding the difference is critical:
Microsoft is retiring Outbound Marketing. All new implementations should use Real-time Journeys exclusively.
| Feature | Outbound Marketing | Real-time Journeys |
|---|---|---|
| Architecture | Batch processing | Event-driven, real-time |
| Trigger | Segment membership | Any event (form, purchase, data change) |
| Response speed | Minutes to hours | Seconds |
| Channels | Email, SMS | Email, SMS, Push, custom |
| Future roadmap | Being retired | Strategic investment |
⚠ Key Point: Always build new implementations exclusively on Real-time Journeys. Clients who ask for Outbound Marketing because "the old system worked that way" need to understand this module is being retired. Document this decision and its rationale in the BRD.
Customer Insights - Data can ingest customer data from a wide variety of sources:
Native connectors: Dataverse (D365 Sales, Customer Service), Azure Blob Storage, Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure SQL Database, Microsoft Fabric.
Power Query connectors (100+ sources): Salesforce, SAP, Oracle, Google Analytics, Facebook Ads, LinkedIn, Mailchimp, Shopify, and many more.
Common data sources in a typical implementation: CRM (D365 Sales / Salesforce), ERP (D365 F&O / SAP) for transactional data, Email platform (Marketo / HubSpot) for engagement data, Website analytics (Google Analytics) for behavioural data, Loyalty platform for points and tier data.
Data refresh schedule: Each source can have an independent refresh schedule. Critical sources may refresh hourly; offline sources may refresh nightly.
Native connectors: Dataverse (D365 Sales, Customer Service), Azure Blob Storage, Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure SQL Database, Microsoft Fabric.
Power Query connectors (100+ sources): Salesforce, SAP, Oracle, Google Analytics, Facebook Ads, LinkedIn, Mailchimp, Shopify, and many more.
Common data sources in a typical implementation: CRM (D365 Sales / Salesforce), ERP (D365 F&O / SAP) for transactional data, Email platform (Marketo / HubSpot) for engagement data, Website analytics (Google Analytics) for behavioural data, Loyalty platform for points and tier data.
Data refresh schedule: Each source can have an independent refresh schedule. Critical sources may refresh hourly; offline sources may refresh nightly.
💡 Pro Tip: The data source and refresh schedule design is a key architecture decision. Document it in an Integration Architecture document: Source | Data Entity | Records | Refresh Frequency | Connection Method. This drives storage and compute cost sizing.
Questions 11–20 of 75
Measures in Customer Insights - Data are calculated fields added to the unified customer profile — turning raw data into business-relevant metrics that power segmentation and AI models.
Types of measures: Customer attribute (a calculated value per customer profile, e.g., Total Lifetime Spend, Average Order Value, Days Since Last Purchase, Loyalty Points Balance). Business measure (an aggregated metric across the customer base, e.g., Average CSAT across all customers).
Example measure — Total Lifetime Spend: Source: Sales Orders entity. Field: Order Amount. Aggregation: Sum. Filter: Order Status = Completed. Result: Single value per customer profile showing total spend.
Using measures in segments: "Total Lifetime Spend > $1,000 AND Days Since Last Purchase < 90" → "Active High-Value Customer" segment.
Types of measures: Customer attribute (a calculated value per customer profile, e.g., Total Lifetime Spend, Average Order Value, Days Since Last Purchase, Loyalty Points Balance). Business measure (an aggregated metric across the customer base, e.g., Average CSAT across all customers).
Example measure — Total Lifetime Spend: Source: Sales Orders entity. Field: Order Amount. Aggregation: Sum. Filter: Order Status = Completed. Result: Single value per customer profile showing total spend.
Using measures in segments: "Total Lifetime Spend > $1,000 AND Days Since Last Purchase < 90" → "Active High-Value Customer" segment.
💡 Pro Tip: Measures are the analytical foundation of the CDP. Define them with the business before building — not after. "What customer attributes do you need to segment your customers?" is the key requirements question. Start with the top 10 most business-critical measures.
Event Management provides end-to-end management of in-person, virtual, and hybrid events — from registration to post-event follow-up.
Event record components: Event details (name, date, location, format), Sessions (agenda items), Speakers, Sponsors, Registration form, Attendee tracking, Waitlist, Check-in management, Webinar integration (Teams/Webex/Zoom).
Registration flow: Marketing email with registration link → Customer registers on Power Pages portal → Confirmation email auto-sent → Reminder emails as event approaches → Day-of check-in (QR code or manual) → Post-event follow-up journey triggered by attendance status.
Integration with journeys: Attended event = send session recordings + survey. Registered but did not attend = send "missed you" message with on-demand recording link.
Event record components: Event details (name, date, location, format), Sessions (agenda items), Speakers, Sponsors, Registration form, Attendee tracking, Waitlist, Check-in management, Webinar integration (Teams/Webex/Zoom).
Registration flow: Marketing email with registration link → Customer registers on Power Pages portal → Confirmation email auto-sent → Reminder emails as event approaches → Day-of check-in (QR code or manual) → Post-event follow-up journey triggered by attendance status.
Integration with journeys: Attended event = send session recordings + survey. Registered but did not attend = send "missed you" message with on-demand recording link.
💡 Pro Tip: Post-event follow-up journeys are where event ROI is generated. Requirements should define the exact follow-up sequence for attendees vs. no-shows, and how event attendance feeds lead scoring (+20 points for webinar attended). This is often missed in requirements.
Email is typically the primary channel in D365 Customer Insights - Journeys. Configuring email correctly is foundational:
Email designer: Drag-and-drop canvas with pre-built blocks (text, image, button, divider, social links). Personalisation tokens ({{contact.firstname}}, {{contact.company}}). Conditional blocks (show block X only if customer is in segment Y).
Technical email setup (critical): Sending domain authentication: SPF, DKIM, DMARC records in DNS — required for deliverability. Email sending domain: Use a dedicated sending domain (e.g., marketing.company.com) separate from the main domain. Suppression list: Known bad addresses that should never receive email.
Email analytics: Sent, Delivered, Opened (unique and total), Clicked (by link), Unsubscribed, Bounced (hard and soft), Marked as spam.
Email designer: Drag-and-drop canvas with pre-built blocks (text, image, button, divider, social links). Personalisation tokens ({{contact.firstname}}, {{contact.company}}). Conditional blocks (show block X only if customer is in segment Y).
Technical email setup (critical): Sending domain authentication: SPF, DKIM, DMARC records in DNS — required for deliverability. Email sending domain: Use a dedicated sending domain (e.g., marketing.company.com) separate from the main domain. Suppression list: Known bad addresses that should never receive email.
Email analytics: Sent, Delivered, Opened (unique and total), Clicked (by link), Unsubscribed, Bounced (hard and soft), Marked as spam.
⚠ Key Point: Email authentication (SPF/DKIM/DMARC) is a technical requirement that must be completed before go-live. Without it, emails land in spam or are rejected. This requires DNS access from the client's IT team — involve them early and confirm timeline.
Marketing Forms capture customer information — for lead generation, event registration, newsletter subscription, or preference management.
Form types: Lead capture (name, email, phone, job title → creates Lead in D365). Contact creation. Subscription centre (customer preferences for email topics and frequency). Event registration.
Form builder: Drag-and-drop designer. Fields mapped to D365 entity fields. Validation rules (required, format). CAPTCHA for spam protection. Custom styling to match brand.
Embedding options: Standalone landing page (hosted by D365/Power Pages). Embedded script on external website. Redirect to a third-party page after submission.
Post-submission actions: Automatic confirmation email. Record creation/update in D365. Journey trigger (when form submitted, start welcome journey). Lead score increment.
Form types: Lead capture (name, email, phone, job title → creates Lead in D365). Contact creation. Subscription centre (customer preferences for email topics and frequency). Event registration.
Form builder: Drag-and-drop designer. Fields mapped to D365 entity fields. Validation rules (required, format). CAPTCHA for spam protection. Custom styling to match brand.
Embedding options: Standalone landing page (hosted by D365/Power Pages). Embedded script on external website. Redirect to a third-party page after submission.
Post-submission actions: Automatic confirmation email. Record creation/update in D365. Journey trigger (when form submitted, start welcome journey). Lead score increment.
💡 Pro Tip: The subscription preference centre is a legal requirement for compliant email marketing. Customers must be able to manage their own preferences. Requirements must define what preferences can be managed and what the opt-out experience looks like.
Personalisation uses customer profile data to tailor communications to each individual — making every message feel relevant rather than generic.
Personalisation types: Text personalisation ({{contact.firstname}}, {{customer_insights.churn_score}}). Conditional content (show Block A if customer is in "High Value" segment, else show Block B). Dynamic product recommendations (show top 3 recommended products based on Customer Insights prediction). Journey branching (take Path A if loyalty tier = Gold, Path B if tier = Silver).
Customer Insights profile data in journeys: Real-time journeys can access the unified Customer Insights profile — pulling measures, segment memberships, and prediction scores directly into email content and journey conditions.
Send time optimisation: AI predicts the best time to send each individual email based on their historical engagement patterns. Can improve open rates by 20-30%.
Personalisation types: Text personalisation ({{contact.firstname}}, {{customer_insights.churn_score}}). Conditional content (show Block A if customer is in "High Value" segment, else show Block B). Dynamic product recommendations (show top 3 recommended products based on Customer Insights prediction). Journey branching (take Path A if loyalty tier = Gold, Path B if tier = Silver).
Customer Insights profile data in journeys: Real-time journeys can access the unified Customer Insights profile — pulling measures, segment memberships, and prediction scores directly into email content and journey conditions.
Send time optimisation: AI predicts the best time to send each individual email based on their historical engagement patterns. Can improve open rates by 20-30%.
💡 Pro Tip: Personalisation requirements should be captured as a matrix: Segment x Communication x Personalisation Variable. Without this matrix, developers guess at what "personalisation" means. A well-defined personalisation matrix is one of the highest-value BA deliverables in a D365 Marketing project.
The integration between Customer Insights and D365 Sales creates a closed loop between marketing activity and sales pipeline:
Customer Insights → D365 Sales: Customer Insights segments exported as Marketing Lists in D365 Sales. Unified profile insights (predicted CLV, churn score) displayed on the Contact record in D365 Sales via the Customer Card add-in. Lead scores pushed to Lead records in D365 Sales. When lead score reaches threshold, lead is assigned in D365 Sales.
D365 Sales → Customer Insights: CRM contacts and accounts ingested as a data source. Sales activities contribute to profile data. Won/lost opportunity data trains predictive models.
Handoff workflow: Journey generates MQL → Power Automate notifies sales rep → Rep views lead with full Customer Insights context → Rep converts and works opportunity in D365 Sales → Revenue data feeds back to Customer Insights.
Customer Insights → D365 Sales: Customer Insights segments exported as Marketing Lists in D365 Sales. Unified profile insights (predicted CLV, churn score) displayed on the Contact record in D365 Sales via the Customer Card add-in. Lead scores pushed to Lead records in D365 Sales. When lead score reaches threshold, lead is assigned in D365 Sales.
D365 Sales → Customer Insights: CRM contacts and accounts ingested as a data source. Sales activities contribute to profile data. Won/lost opportunity data trains predictive models.
Handoff workflow: Journey generates MQL → Power Automate notifies sales rep → Rep views lead with full Customer Insights context → Rep converts and works opportunity in D365 Sales → Revenue data feeds back to Customer Insights.
💡 Pro Tip: The MQL handoff SLA is a critical integration requirement. "Marketing passes a lead to sales — how quickly must sales respond? What happens if they do not respond within X hours?" Define this process explicitly because it determines the Power Automate flow and the lead ageing requirements.
Customer Insights supports both B2B and B2C models, but the data structures and journeys differ significantly:
B2C Model: Primary entity is Contact (individual consumer). Unified profile is per individual. Segments target individuals. Journeys communicate with one person. Measure: individual transaction history, personal preferences.
B2B Model: Primary entities are Account (company) AND Contact (person at the company). Account hierarchy (parent → subsidiaries). A Contact belongs to an Account. Segments can target accounts OR contacts. Account engagement scoring (aggregate of all contact activities at an account).
Account-Based Marketing (ABM): D365 Customer Insights - Journeys supports ABM: target all contacts at high-priority accounts with coordinated messaging. Journey conditions can reference Account record attributes (industry, revenue tier).
B2C Model: Primary entity is Contact (individual consumer). Unified profile is per individual. Segments target individuals. Journeys communicate with one person. Measure: individual transaction history, personal preferences.
B2B Model: Primary entities are Account (company) AND Contact (person at the company). Account hierarchy (parent → subsidiaries). A Contact belongs to an Account. Segments can target accounts OR contacts. Account engagement scoring (aggregate of all contact activities at an account).
Account-Based Marketing (ABM): D365 Customer Insights - Journeys supports ABM: target all contacts at high-priority accounts with coordinated messaging. Journey conditions can reference Account record attributes (industry, revenue tier).
💡 Pro Tip: Clarify B2B vs B2C (or mixed) at the very start of requirements gathering. The data model, segmentation approach, and journey design are fundamentally different. A mixed B2B/B2C model is the most complex scenario and needs explicit requirements for how account and individual profiles relate.
A D365 Customer Insights Functional Consultant bridges marketing strategy, data architecture, and platform configuration:
Key responsibilities: Requirements (understand marketing objectives, data sources, segmentation strategy, campaign goals). Solution design (design the unified profile structure, segment library, journey architecture, measurement framework). Configuration (set up data sources, unification rules, segments, journeys, email templates). Data collaboration (work with data engineers on source system extraction and field mapping). Training (train marketing users on segment builder, journey canvas, and analytics).
Technical knowledge needed: Data concepts (customer identity resolution, match keys, deduplication). Marketing concepts (lead lifecycle, demand generation, GDPR consent). Platform (Power Apps, Power Automate, D365 integration points).
Key responsibilities: Requirements (understand marketing objectives, data sources, segmentation strategy, campaign goals). Solution design (design the unified profile structure, segment library, journey architecture, measurement framework). Configuration (set up data sources, unification rules, segments, journeys, email templates). Data collaboration (work with data engineers on source system extraction and field mapping). Training (train marketing users on segment builder, journey canvas, and analytics).
Technical knowledge needed: Data concepts (customer identity resolution, match keys, deduplication). Marketing concepts (lead lifecycle, demand generation, GDPR consent). Platform (Power Apps, Power Automate, D365 integration points).
💡 Pro Tip: The Customer Insights functional consultant role is rare and highly valued because it requires marketing domain knowledge + data concepts + Microsoft platform knowledge. Demonstrating understanding of all three areas makes you extremely competitive for these roles.
A structured implementation approach for Customer Insights - Data:
Phase 1 — Discovery (2-3 weeks): Map all customer data sources (CRM, ERP, website, loyalty). Identify data quality issues. Define the unified profile attributes required. Define key use cases (segments, predictions, activation targets).
Phase 2 — Environment setup (1 week): Provision Customer Insights environment. Configure Azure storage if required. Set up user access and security.
Phase 3 — Data ingestion (3-4 weeks): Connect each data source. Map fields. Schedule refresh.
Phase 4 — Data unification (2-3 weeks): Configure deduplication and match rules. Configure merge policies. Validate unified profiles (spot-check 50 profiles).
Phase 5 — Enrichment and measures (1-2 weeks): Configure measures (Total Spend, Days Since Last Purchase). Set up enrichments.
Phase 6 — Segments and predictions (2-3 weeks): Build required segments. Train AI prediction models.
Total typical duration: 12-16 weeks for a mid-complexity implementation.
Phase 1 — Discovery (2-3 weeks): Map all customer data sources (CRM, ERP, website, loyalty). Identify data quality issues. Define the unified profile attributes required. Define key use cases (segments, predictions, activation targets).
Phase 2 — Environment setup (1 week): Provision Customer Insights environment. Configure Azure storage if required. Set up user access and security.
Phase 3 — Data ingestion (3-4 weeks): Connect each data source. Map fields. Schedule refresh.
Phase 4 — Data unification (2-3 weeks): Configure deduplication and match rules. Configure merge policies. Validate unified profiles (spot-check 50 profiles).
Phase 5 — Enrichment and measures (1-2 weeks): Configure measures (Total Spend, Days Since Last Purchase). Set up enrichments.
Phase 6 — Segments and predictions (2-3 weeks): Build required segments. Train AI prediction models.
Total typical duration: 12-16 weeks for a mid-complexity implementation.
💡 Pro Tip: Always start with a "golden record test" — take one well-known customer, find their records across all source systems, and manually verify the unified profile is correct. This single test validates the entire unification configuration and builds client confidence.
Both handle large volumes of customer data — understanding the distinction prevents over-engineering or under-engineering the solution:
In enterprise implementations, Synapse often serves as the data lake that Customer Insights reads from — complementary, not competing.
| Aspect | Customer Insights - Data | Azure Synapse Analytics |
|---|---|---|
| Purpose | Unify customer identity for marketing activation | Enterprise data warehousing and analytics |
| Primary users | Business users and marketers (no-code) | Data engineers and analysts (SQL/Spark) |
| Key output | Unified profiles, segments, predictions | Analytical reports, data transformations |
| Activation | Marketing, CRM, ad platforms | Power BI, downstream data consumers |
💡 Pro Tip: In large enterprise implementations, avoid trying to make Customer Insights - Data serve as an analytics platform. Its strength is identity resolution and marketing activation. Use Power BI or Synapse for complex analytics. Define the tool boundary clearly in your architecture document.
Questions 21–30 of 75
A CRM (Customer Relationship Management) system and a CDP (Customer Data Platform) serve very different purposes — understanding this distinction is foundational for any Customer Insights consultant.
CRM (e.g., D365 Sales, Salesforce): Manages operational customer interactions — sales activities, opportunities, cases, and contacts. Data is entered manually by sales and service teams. Focus: enabling frontline staff to manage customer relationships. Data is siloed within the CRM — no visibility into website behaviour, purchase history from eCommerce, or loyalty programme data.
CDP (e.g., D365 Customer Insights - Data): Collects and unifies customer data from ALL systems — CRM, ERP, website, mobile app, loyalty, marketing platforms. Resolves identity across systems (same person in multiple databases = one unified profile). Focus: giving marketing, data, and AI teams a complete customer view for segmentation, personalisation, and prediction. Does not replace the CRM — enriches it.
Simple analogy: CRM = where your team records what they did with a customer. CDP = where you assemble everything you know about that customer from everywhere.
CRM (e.g., D365 Sales, Salesforce): Manages operational customer interactions — sales activities, opportunities, cases, and contacts. Data is entered manually by sales and service teams. Focus: enabling frontline staff to manage customer relationships. Data is siloed within the CRM — no visibility into website behaviour, purchase history from eCommerce, or loyalty programme data.
CDP (e.g., D365 Customer Insights - Data): Collects and unifies customer data from ALL systems — CRM, ERP, website, mobile app, loyalty, marketing platforms. Resolves identity across systems (same person in multiple databases = one unified profile). Focus: giving marketing, data, and AI teams a complete customer view for segmentation, personalisation, and prediction. Does not replace the CRM — enriches it.
Simple analogy: CRM = where your team records what they did with a customer. CDP = where you assemble everything you know about that customer from everywhere.
💡 Pro Tip: In discovery workshops, clients often confuse CDP and CRM capabilities. Frame it clearly: "Your CRM is your team's workspace. The CDP is your customer intelligence hub. They are complementary, not competing." This framing prevents misaligned expectations about what Customer Insights will and won't do.
D365 Customer Insights - Data unifies data from multiple source systems by mapping them to a common data structure. Key entities typically unified:
Customer identity entities: CRM Contacts (name, email, phone, address), ERP Customers (customer number, billing address, credit terms), eCommerce registrations (email, loyalty ID, shipping address), Mobile app profiles (device ID, push token, behavioural data).
Transaction entities: Sales orders (products purchased, order value, date, channel), Subscription records (plan type, renewal date, churn status), Invoice history (payment behaviour, outstanding balance).
Behavioural entities: Website sessions (pages viewed, time on site, events triggered), Email engagement (opens, clicks, unsubscribes), App events (features used, session frequency, last active date).
Service entities: Support cases (case count, resolution time, satisfaction scores), Product returns (return reason, return rate per product).
Loyalty entities: Points balance, tier, redemption history, enrolment date.
Customer identity entities: CRM Contacts (name, email, phone, address), ERP Customers (customer number, billing address, credit terms), eCommerce registrations (email, loyalty ID, shipping address), Mobile app profiles (device ID, push token, behavioural data).
Transaction entities: Sales orders (products purchased, order value, date, channel), Subscription records (plan type, renewal date, churn status), Invoice history (payment behaviour, outstanding balance).
Behavioural entities: Website sessions (pages viewed, time on site, events triggered), Email engagement (opens, clicks, unsubscribes), App events (features used, session frequency, last active date).
Service entities: Support cases (case count, resolution time, satisfaction scores), Product returns (return reason, return rate per product).
Loyalty entities: Points balance, tier, redemption history, enrolment date.
💡 Pro Tip: During discovery, create a "Data Source Inventory" spreadsheet: Source System | Entity Name | Record Count | Key Identifier | Refresh Frequency | Owner Team. This becomes the foundation for your data ingestion plan and helps identify which sources need data quality remediation before ingestion into the CDP.
Identity Resolution is the process of determining that multiple records across different systems represent the same real-world person — and merging them into a single unified profile. It is arguably the hardest problem in CDP implementation.
Why it is complex: The same customer may appear differently in each system: CRM: "Anita Sharma, anita.sharma@gmail.com, +91-98765-43210". eCommerce: "A. Sharma, anitasharma@yahoo.com". Loyalty app: "Anita S., Loyalty ID: L-12345". ERP: "Customer #C-9876, ANI SHARMA ENTERPRISES".
Match key strategies: Deterministic matching: Exact match on email address OR phone number (high confidence). Probabilistic matching: Fuzzy name + partial address + postal code match (lower confidence — risk of false positives). Hybrid: Deterministic first; probabilistic for remaining unmatched records.
Common identity resolution errors: Under-merge: Two profiles for the same person (phantom duplicates — inflates customer count). Over-merge: Two different people merged (e.g., two family members sharing an address — damages personalisation). Both errors cause downstream problems: wrong segment membership, wrong predictions, wrong communications.
Why it is complex: The same customer may appear differently in each system: CRM: "Anita Sharma, anita.sharma@gmail.com, +91-98765-43210". eCommerce: "A. Sharma, anitasharma@yahoo.com". Loyalty app: "Anita S., Loyalty ID: L-12345". ERP: "Customer #C-9876, ANI SHARMA ENTERPRISES".
Match key strategies: Deterministic matching: Exact match on email address OR phone number (high confidence). Probabilistic matching: Fuzzy name + partial address + postal code match (lower confidence — risk of false positives). Hybrid: Deterministic first; probabilistic for remaining unmatched records.
Common identity resolution errors: Under-merge: Two profiles for the same person (phantom duplicates — inflates customer count). Over-merge: Two different people merged (e.g., two family members sharing an address — damages personalisation). Both errors cause downstream problems: wrong segment membership, wrong predictions, wrong communications.
💡 Pro Tip: Always validate identity resolution quality with a "Golden Record Test": take 50 known customers and manually verify their unified profiles are correct. Check for both phantom duplicates (run a duplicate report) and false merges (spot-check profiles with unusual transaction counts). Do this before deploying segments or predictions — a bad unification foundation makes every downstream output unreliable.
D365 Customer Insights - Data supports multiple ingestion methods to connect data from diverse source systems:
Power Query connectors (the primary method — 100+ sources): Connect directly to: Azure SQL Database, Azure Data Lake Storage Gen2, Azure Blob Storage, Dataverse (D365 Sales, Customer Service), Salesforce, SAP, Oracle, Google Analytics, Facebook Ads, Shopify, Mailchimp, CSV/Excel files, SharePoint. Each connector has a wizard-based setup — no code required for most sources.
Azure Data Lake Storage (ADLS Gen2): For high-volume, complex data. The data engineering team writes files (CSV, Parquet, JSON) to ADLS. Customer Insights reads from ADLS on a schedule. Best for: ERP data exports, data warehouse outputs, large transaction datasets.
Real-time data ingestion (API): Customer Insights provides an API endpoint for real-time event streaming — e.g., a mobile app sends a "purchase_completed" event directly to Customer Insights the moment it occurs.
Microsoft Fabric / Azure Synapse: Direct integration for organisations with a data lake or warehouse in the Microsoft data ecosystem. Customer Insights can read from Fabric lakehouses natively.
Power Query connectors (the primary method — 100+ sources): Connect directly to: Azure SQL Database, Azure Data Lake Storage Gen2, Azure Blob Storage, Dataverse (D365 Sales, Customer Service), Salesforce, SAP, Oracle, Google Analytics, Facebook Ads, Shopify, Mailchimp, CSV/Excel files, SharePoint. Each connector has a wizard-based setup — no code required for most sources.
Azure Data Lake Storage (ADLS Gen2): For high-volume, complex data. The data engineering team writes files (CSV, Parquet, JSON) to ADLS. Customer Insights reads from ADLS on a schedule. Best for: ERP data exports, data warehouse outputs, large transaction datasets.
Real-time data ingestion (API): Customer Insights provides an API endpoint for real-time event streaming — e.g., a mobile app sends a "purchase_completed" event directly to Customer Insights the moment it occurs.
Microsoft Fabric / Azure Synapse: Direct integration for organisations with a data lake or warehouse in the Microsoft data ecosystem. Customer Insights can read from Fabric lakehouses natively.
💡 Pro Tip: For enterprise implementations, recommend the ADLS pattern for complex/large sources rather than direct Power Query connectors. ADLS decouples the source system from Customer Insights — if the source system changes its schema, only the data engineering pipeline breaks, not the Customer Insights connector. This architectural separation reduces maintenance cost significantly.
The Common Data Model (CDM) is Microsoft's standardised schema for business data entities — defining how data should be structured so that different Microsoft (and third-party) applications can share and understand it without custom mapping.
CDM and Customer Insights: Customer Insights uses CDM entities as the target schema for unified customer profiles. When you map source data fields during data unification, you are mapping them to CDM entities: Customer (CDM entity for a unified customer profile), Purchase (CDM entity for a transaction), Activity (CDM entity for a customer action).
Benefits of CDM alignment: Data ingested into Customer Insights that is already in CDM format (e.g., from Dataverse/D365) requires minimal mapping — fields align automatically. CDM-aligned data can be exported to other Microsoft services (Power BI, Azure Synapse, D365 apps) without re-transformation. Reduces integration effort between Microsoft ecosystem tools.
CDM entity examples relevant to Customer Insights: msdynci_Customer (unified customer profile entity), msdynci_Segment (segment membership), msdynci_Measure (KPI measure values).
CDM and Customer Insights: Customer Insights uses CDM entities as the target schema for unified customer profiles. When you map source data fields during data unification, you are mapping them to CDM entities: Customer (CDM entity for a unified customer profile), Purchase (CDM entity for a transaction), Activity (CDM entity for a customer action).
Benefits of CDM alignment: Data ingested into Customer Insights that is already in CDM format (e.g., from Dataverse/D365) requires minimal mapping — fields align automatically. CDM-aligned data can be exported to other Microsoft services (Power BI, Azure Synapse, D365 apps) without re-transformation. Reduces integration effort between Microsoft ecosystem tools.
CDM entity examples relevant to Customer Insights: msdynci_Customer (unified customer profile entity), msdynci_Segment (segment membership), msdynci_Measure (KPI measure values).
💡 Pro Tip: When working with D365 data (Dataverse sources), CDM alignment happens automatically — fields from D365 Contacts map directly to CDM Customer fields with minimal configuration. Non-Microsoft sources (SAP, Salesforce, custom databases) require explicit CDM field mapping. Flag this difference early in the project plan — non-Microsoft source mapping takes significantly longer.
Enrichments in D365 Customer Insights - Data supplement unified customer profiles with additional data from external sources — adding intelligence that the organisation does not hold internally.
Built-in enrichment providers:
Microsoft Bing Location Data: Validates and standardises customer addresses. Adds latitude/longitude for geographic analysis.
Experian / D&B (Dun & Bradstreet): Adds firmographic data for B2B profiles — company revenue, employee count, industry, credit rating (requires separate subscription).
Microsoft Bing Brand Affinities: Adds inferred brand affinity scores to consumer profiles based on aggregate browsing behaviour — "This customer profile shows affinity for luxury brands."
Microsoft Bing Interest categories: Adds inferred interest categories (Travel, Technology, Fitness) to consumer profiles.
Leadspace (B2B): Enriches B2B customer profiles with contact-level and company-level data from Leadspace's database.
Custom enrichment: Bring your own enrichment data — upload a file or connect an API that adds custom attributes to profiles (e.g., credit score from a bureau, NPS score from a survey platform).
Built-in enrichment providers:
Microsoft Bing Location Data: Validates and standardises customer addresses. Adds latitude/longitude for geographic analysis.
Experian / D&B (Dun & Bradstreet): Adds firmographic data for B2B profiles — company revenue, employee count, industry, credit rating (requires separate subscription).
Microsoft Bing Brand Affinities: Adds inferred brand affinity scores to consumer profiles based on aggregate browsing behaviour — "This customer profile shows affinity for luxury brands."
Microsoft Bing Interest categories: Adds inferred interest categories (Travel, Technology, Fitness) to consumer profiles.
Leadspace (B2B): Enriches B2B customer profiles with contact-level and company-level data from Leadspace's database.
Custom enrichment: Bring your own enrichment data — upload a file or connect an API that adds custom attributes to profiles (e.g., credit score from a bureau, NPS score from a survey platform).
💡 Pro Tip: Brand Affinity and Interest enrichments are powerful for consumer brands wanting to personalise without collecting first-party preference data. For a retail client launching a new product line, "Customers with High Fitness Affinity" is a usable segment immediately — without asking customers to fill in preference surveys. Mention this as a quick-win in discovery sessions.
Segments in D365 Customer Insights - Data come in two fundamentally different types — choosing the right one for each use case is important:
Dynamic Segments: Membership is automatically recalculated based on the latest data. If a customer's attributes change (they made a new purchase, their churn score increased, they moved to a new city), their segment membership updates accordingly. Recalculation happens on a configured schedule (hourly, daily, weekly). Best for: Ongoing campaigns, nurture programmes, real-time personalisation, any use case where "right now" accuracy matters.
Static Segments (also called Snapshot Segments): Membership is fixed at the time of creation — a one-time snapshot of customers who met the criteria at that moment. Membership does NOT change even if customer attributes change afterwards. Best for: One-time campaign lists (sending a specific promotional email to customers who were VIPs as of 1 January), audit snapshots, fixed analysis groups.
Composed Segments (Union, Intersection, Exclusion): Combine existing segments with set operations. "Segment A UNION Segment B" = all members of either. "Segment A INTERSECT Segment B" = only members of both. "Segment A MINUS Segment B" = members of A who are not in B.
Dynamic Segments: Membership is automatically recalculated based on the latest data. If a customer's attributes change (they made a new purchase, their churn score increased, they moved to a new city), their segment membership updates accordingly. Recalculation happens on a configured schedule (hourly, daily, weekly). Best for: Ongoing campaigns, nurture programmes, real-time personalisation, any use case where "right now" accuracy matters.
Static Segments (also called Snapshot Segments): Membership is fixed at the time of creation — a one-time snapshot of customers who met the criteria at that moment. Membership does NOT change even if customer attributes change afterwards. Best for: One-time campaign lists (sending a specific promotional email to customers who were VIPs as of 1 January), audit snapshots, fixed analysis groups.
Composed Segments (Union, Intersection, Exclusion): Combine existing segments with set operations. "Segment A UNION Segment B" = all members of either. "Segment A INTERSECT Segment B" = only members of both. "Segment A MINUS Segment B" = members of A who are not in B.
💡 Pro Tip: A common client requirement: "Send this email to our high-value customers." Use Dynamic if you want to always send to whoever qualifies today. Use Static if you want to send to specifically the customers who qualified last month as part of a campaign evaluation. Clarifying this difference early prevents sending the wrong list.
Customer Lifetime Value (CLV) prediction in D365 Customer Insights - Data uses machine learning to predict the total revenue a customer will generate over a defined future period — enabling resource allocation toward the most valuable customers.
Model inputs (required): Transaction history (purchase date, amount, product category). Customer profile data (tenure, demographics if available). A minimum of 12 months of transaction history and at least 1,000 customers with transactions.
Model outputs: Predicted CLV value (in the organisation's base currency). CLV tier (High, Medium, Low — automatically segmented by model). Percentile ranking (this customer is in the top 10% by predicted CLV).
Configuration steps: Customer Insights → Predictions → Customer Lifetime Value → New. Map the transaction entity, customer entity, transaction date field, and transaction amount field. Set the prediction window (e.g., predict CLV over next 12 months). Define what constitutes a "High Value" customer (top 30% by CLV).
Activation use cases: "High CLV" segment → dedicated account manager outreach. "High CLV + High Churn Risk" segment → urgent retention campaign. "Medium CLV + High Growth Potential" segment → upgrade offer journey.
Model inputs (required): Transaction history (purchase date, amount, product category). Customer profile data (tenure, demographics if available). A minimum of 12 months of transaction history and at least 1,000 customers with transactions.
Model outputs: Predicted CLV value (in the organisation's base currency). CLV tier (High, Medium, Low — automatically segmented by model). Percentile ranking (this customer is in the top 10% by predicted CLV).
Configuration steps: Customer Insights → Predictions → Customer Lifetime Value → New. Map the transaction entity, customer entity, transaction date field, and transaction amount field. Set the prediction window (e.g., predict CLV over next 12 months). Define what constitutes a "High Value" customer (top 30% by CLV).
Activation use cases: "High CLV" segment → dedicated account manager outreach. "High CLV + High Churn Risk" segment → urgent retention campaign. "Medium CLV + High Growth Potential" segment → upgrade offer journey.
💡 Pro Tip: CLV prediction is most valuable when combined with Churn prediction. A customer with High CLV AND High Churn Risk is your most important retention target — they will cost the most if lost. Build a composite segment: "CLV Tier = High AND Churn Score > 70%" and make this the top priority for your retention programme.
Product Recommendation prediction in D365 Customer Insights - Data uses collaborative filtering (similar to Netflix or Amazon recommendations) to predict which products a customer is most likely to purchase next — enabling personalised product recommendations in marketing and eCommerce.
How collaborative filtering works: "Customers who purchased Product A and Product B often also purchased Product C." The model finds patterns in purchase history across all customers, not just the individual's history. Customers with similar purchase histories get similar recommendations.
Model inputs: Transaction history entity (customer ID, product ID, transaction date). Product catalog entity (product name, category, attributes — optional but improves recommendations). Minimum: 12 months transaction history, 1,000+ customers, 10,000+ transactions.
Model outputs per customer profile: Top N recommended products (configurable — top 3, top 5, top 10). Recommendation score (confidence). Product category affinity scores.
Activation examples: "Recommended for you" section in a customer email — pulls the top 3 recommendations from Customer Insights into the email template dynamically. eCommerce "You might also like" — pulls recommendations via API at browse time.
How collaborative filtering works: "Customers who purchased Product A and Product B often also purchased Product C." The model finds patterns in purchase history across all customers, not just the individual's history. Customers with similar purchase histories get similar recommendations.
Model inputs: Transaction history entity (customer ID, product ID, transaction date). Product catalog entity (product name, category, attributes — optional but improves recommendations). Minimum: 12 months transaction history, 1,000+ customers, 10,000+ transactions.
Model outputs per customer profile: Top N recommended products (configurable — top 3, top 5, top 10). Recommendation score (confidence). Product category affinity scores.
Activation examples: "Recommended for you" section in a customer email — pulls the top 3 recommendations from Customer Insights into the email template dynamically. eCommerce "You might also like" — pulls recommendations via API at browse time.
💡 Pro Tip: Product Recommendation requires the most data of all Customer Insights prediction models. Before committing to this feature in requirements, verify: How many unique products? (Fewer than 50 products = collaborative filtering provides limited value.) How many transactions per customer on average? (Fewer than 3 transactions per customer = insufficient signal.) Set realistic expectations about recommendation quality based on data volume.
Real-time event triggers in D365 Customer Insights - Journeys allow journeys to start the moment a specific event occurs — within seconds of the trigger — rather than waiting for a scheduled segment refresh.
How triggers work: Any event in Dataverse or from external systems can be a trigger. When the event occurs, the trigger fires and the customer enters the journey immediately. Examples: Contact created → Welcome journey starts in seconds. Purchase completed (from eCommerce webhook) → Order confirmation journey fires. Lead score reaches 60 → MQL handoff journey starts. Case resolved → CSAT survey journey fires.
Trigger types: Dataverse record change (when a D365 record is created or updated — e.g., Case status = Resolved). Custom trigger (an external system calls the Customer Insights API directly — e.g., mobile app sends a "checkout_abandoned" event). Interaction trigger (when a customer interacts with a journey element — opens an email, clicks a link, fills a form).
Journey starting conditions: A trigger can start a journey for a specific contact, OR trigger an update mid-journey (advancing the contact to the next step based on their action).
How triggers work: Any event in Dataverse or from external systems can be a trigger. When the event occurs, the trigger fires and the customer enters the journey immediately. Examples: Contact created → Welcome journey starts in seconds. Purchase completed (from eCommerce webhook) → Order confirmation journey fires. Lead score reaches 60 → MQL handoff journey starts. Case resolved → CSAT survey journey fires.
Trigger types: Dataverse record change (when a D365 record is created or updated — e.g., Case status = Resolved). Custom trigger (an external system calls the Customer Insights API directly — e.g., mobile app sends a "checkout_abandoned" event). Interaction trigger (when a customer interacts with a journey element — opens an email, clicks a link, fills a form).
Journey starting conditions: A trigger can start a journey for a specific contact, OR trigger an update mid-journey (advancing the contact to the next step based on their action).
💡 Pro Tip: Custom triggers are one of the most powerful and most underused features in Customer Insights - Journeys. Any external system that can make an HTTP POST request can trigger a D365 journey. This enables journeys triggered by: a customer completing a support chat (from Zendesk or Genesys), a purchase in a physical store (from POS system), or a form submission on a non-Microsoft website. Document all desired trigger sources in requirements before build.
Questions 31–40 of 75
An Abandoned Cart journey is one of the highest-ROI marketing automations — automatically contacting customers who added items to their cart but did not complete the purchase. Industry data shows abandoned cart emails recover 5-15% of carts and generate 15x the revenue per email of standard promotional emails.
Implementation in D365 Customer Insights - Journeys:
1. eCommerce platform sends a custom trigger event to Customer Insights when a cart is created or updated with items (via API or webhook).
2. Journey starts when the custom trigger fires (cart_created or cart_updated event).
3. Wait step: 1 hour (give the customer time to return and purchase on their own).
4. Check condition: Did the customer purchase? (Query Dataverse — if a purchase record exists for this customer after the cart event, exit the journey).
5. If no purchase: Send abandoned cart email — showing the specific items left in cart with images (using personalisation tokens from the trigger payload).
6. Wait 24 hours. Check again. If still no purchase: Send a follow-up email with a discount offer (10% off).
7. Wait 48 hours. Final email: "Your cart is expiring" — urgency message.
Implementation in D365 Customer Insights - Journeys:
1. eCommerce platform sends a custom trigger event to Customer Insights when a cart is created or updated with items (via API or webhook).
2. Journey starts when the custom trigger fires (cart_created or cart_updated event).
3. Wait step: 1 hour (give the customer time to return and purchase on their own).
4. Check condition: Did the customer purchase? (Query Dataverse — if a purchase record exists for this customer after the cart event, exit the journey).
5. If no purchase: Send abandoned cart email — showing the specific items left in cart with images (using personalisation tokens from the trigger payload).
6. Wait 24 hours. Check again. If still no purchase: Send a follow-up email with a discount offer (10% off).
7. Wait 48 hours. Final email: "Your cart is expiring" — urgency message.
💡 Pro Tip: The item-specific personalisation (showing the actual product image and name from the cart) is what makes abandoned cart emails high-converting. This requires passing cart item data in the custom trigger payload. Work with the eCommerce developer to ensure the trigger payload includes: product name, product image URL, product price, cart total. Without this data, you can only send a generic "you left something behind" message — significantly lower conversion.
Send-Time Optimisation (STO) in D365 Customer Insights - Journeys uses AI to predict the optimal time to send each individual email — based on when that specific person has historically opened emails — improving open rates without manual testing.
How it works: The AI model analyses each contact's historical email engagement: What time of day did they open previous emails? What day of the week? How quickly did they open (within minutes or the next day)? At the configured send step in the journey, instead of sending at a fixed time, Customer Insights queues the email and sends it to each contact at their individually predicted optimal time — within a configured delivery window (e.g., "Send within the next 24 hours").
Typical improvements: Send-Time Optimisation typically improves open rates by 15-25% compared to a fixed-time send. The improvement is larger for contacts who have consistent engagement patterns (e.g., always checks email at 7am on weekdays).
Configuration: In the journey Email step → Advanced settings → Send time optimisation: Enable. Set the delivery window (how many hours Customer Insights has to optimise the send time). Minimum data requirement: Contact needs at least 3 prior email interactions for the model to have a reliable prediction.
How it works: The AI model analyses each contact's historical email engagement: What time of day did they open previous emails? What day of the week? How quickly did they open (within minutes or the next day)? At the configured send step in the journey, instead of sending at a fixed time, Customer Insights queues the email and sends it to each contact at their individually predicted optimal time — within a configured delivery window (e.g., "Send within the next 24 hours").
Typical improvements: Send-Time Optimisation typically improves open rates by 15-25% compared to a fixed-time send. The improvement is larger for contacts who have consistent engagement patterns (e.g., always checks email at 7am on weekdays).
Configuration: In the journey Email step → Advanced settings → Send time optimisation: Enable. Set the delivery window (how many hours Customer Insights has to optimise the send time). Minimum data requirement: Contact needs at least 3 prior email interactions for the model to have a reliable prediction.
💡 Pro Tip: STO is most impactful for newsletters and engagement emails where the timing is flexible. For transactional emails (order confirmation, password reset), STO should be disabled — customers expect these immediately. Always clarify in requirements which journey emails are time-flexible vs. time-critical.
A/B Testing in D365 Customer Insights - Journeys compares two variations of a message or journey branch to determine which performs better — allowing data-driven optimisation of marketing content.
A/B Test types in Customer Insights - Journeys: Email A/B test (compare two subject lines, two email bodies, or two from-names). Journey A/B test (compare two different journey paths — e.g., Path A sends a discount email; Path B sends a product highlight email).
Configuration steps:
1. In the journey canvas, add the Email step.
2. In the email step settings, enable A/B test.
3. Define Version A (original) and Version B (variant — change subject line, body, or from name).
4. Set the split ratio (50/50, or 20/80 for a more conservative test).
5. Set the winning metric: Open Rate (best for subject line tests), Click Rate (best for content tests), Conversion Rate (best for offer tests).
6. Set the test duration (e.g., 4 hours — the winning version is auto-selected and sent to the remaining audience).
Results interpretation: The A/B test report shows: Open rate, Click rate, and statistical confidence level for each variation. Customer Insights automatically sends the winning variation to the remaining contacts after the test period.
A/B Test types in Customer Insights - Journeys: Email A/B test (compare two subject lines, two email bodies, or two from-names). Journey A/B test (compare two different journey paths — e.g., Path A sends a discount email; Path B sends a product highlight email).
Configuration steps:
1. In the journey canvas, add the Email step.
2. In the email step settings, enable A/B test.
3. Define Version A (original) and Version B (variant — change subject line, body, or from name).
4. Set the split ratio (50/50, or 20/80 for a more conservative test).
5. Set the winning metric: Open Rate (best for subject line tests), Click Rate (best for content tests), Conversion Rate (best for offer tests).
6. Set the test duration (e.g., 4 hours — the winning version is auto-selected and sent to the remaining audience).
Results interpretation: The A/B test report shows: Open rate, Click rate, and statistical confidence level for each variation. Customer Insights automatically sends the winning variation to the remaining contacts after the test period.
💡 Pro Tip: A/B testing requires sufficient audience size to reach statistical significance. As a rule of thumb, each test variation needs at least 1,000 recipients to detect a meaningful difference in open rates. For smaller lists (< 2,000 total), A/B testing results may not be statistically reliable. Document this limitation in requirements to set realistic expectations about testing capabilities.
The Consent model in D365 Customer Insights - Journeys is the enforcement mechanism that ensures communications are only sent to contacts who have the appropriate consent — making GDPR, PDPA, and CAN-SPAM compliance systematic rather than manual.
Consent model architecture: Contact Point Consent: A record per contact email address AND per communication purpose. Purpose types: Commercial (marketing emails — requires explicit opt-in under GDPR). Transactional (order confirmations, password resets — no consent needed). Tracking (email open/click tracking pixels — requires consent in strict GDPR jurisdictions).
Compliance profiles (control how strictly consent is enforced): Restrictive: Only send to contacts with OptIn status — recommended for EU/UK markets under GDPR. Non-Restrictive: Send to all contacts unless they have explicitly OptedOut — more permissive, used for CAN-SPAM compliance (US). Disabled: No consent checking — use only for internal communications or fully transactional messages.
Topic-level consent: Within the Commercial purpose, Topics allow granular consent management. A customer can opt into "Product Updates" but opt out of "Promotional Offers." Journey steps check both Purpose consent AND Topic consent before sending.
Consent model architecture: Contact Point Consent: A record per contact email address AND per communication purpose. Purpose types: Commercial (marketing emails — requires explicit opt-in under GDPR). Transactional (order confirmations, password resets — no consent needed). Tracking (email open/click tracking pixels — requires consent in strict GDPR jurisdictions).
Compliance profiles (control how strictly consent is enforced): Restrictive: Only send to contacts with OptIn status — recommended for EU/UK markets under GDPR. Non-Restrictive: Send to all contacts unless they have explicitly OptedOut — more permissive, used for CAN-SPAM compliance (US). Disabled: No consent checking — use only for internal communications or fully transactional messages.
Topic-level consent: Within the Commercial purpose, Topics allow granular consent management. A customer can opt into "Product Updates" but opt out of "Promotional Offers." Journey steps check both Purpose consent AND Topic consent before sending.
💡 Pro Tip: GDPR fines can reach €20 million or 4% of global annual revenue. Always recommend the Restrictive compliance profile for European markets regardless of what the client requests. Document the compliance profile selection and the client's explicit approval in the BRD — this protects you as a consultant if consent enforcement is ever questioned.
Clients migrating from platforms like Mailchimp, HubSpot, or Marketo often ask how Customer Insights - Journeys differs. Understanding these distinctions helps you position the platform and manage expectations:
| Aspect | Traditional Email Marketing | Customer Insights - Journeys |
|---|---|---|
| Architecture | Batch send to static lists | Real-time, event-driven journeys |
| Trigger speed | Scheduled (minutes to hours) | Seconds (real-time triggers) |
| Data source | Contacts in the marketing tool | D365 contacts + Customer Insights unified profiles |
| Personalisation | Basic merge fields | Full CDP measures, segments, AI predictions |
| CRM integration | Via connector / sync | Native Dataverse — same database |
| AI features | Basic (limited) | Lead scoring, STO, CSAT prediction, Copilot content |
| Compliance | Manual suppression lists | Native GDPR consent model per contact |
💡 Pro Tip: The most significant advantage to highlight in competitive situations is real-time triggering + native CRM integration. "When a customer's case is resolved, a CSAT journey fires within seconds — no batch sync, no export-import, no delay." This capability requires significant custom integration to achieve in Mailchimp or HubSpot.
The Subscription Centre is a mandatory web page in D365 Customer Insights - Journeys that allows contacts to manage their own communication preferences — which topics they want to receive emails about and how frequently. It is a legal requirement under GDPR and CAN-SPAM for any commercial email programme.
What the Subscription Centre contains: A list of email Topics the organisation sends (Newsletter, Product Updates, Promotional Offers, Event Invitations, Company News). Toggle for each topic (subscribe / unsubscribe). Global unsubscribe option (opt out of all commercial emails). Preference save button.
How it works in practice: Every commercial email sent via Customer Insights - Journeys must include an unsubscribe link. That link points to the Subscription Centre. When a contact updates their preferences and saves, Customer Insights immediately updates their Contact Point Consent records — future journey steps check these consent records before sending.
Configuration: Customer Insights admin → Compliance → Subscription Centres → New. Design the page (hosted by Customer Insights or embedded in Power Pages). Map each page element to a Consent Purpose and Topic. Set the Compliance Profile to use this Subscription Centre as the default.
What the Subscription Centre contains: A list of email Topics the organisation sends (Newsletter, Product Updates, Promotional Offers, Event Invitations, Company News). Toggle for each topic (subscribe / unsubscribe). Global unsubscribe option (opt out of all commercial emails). Preference save button.
How it works in practice: Every commercial email sent via Customer Insights - Journeys must include an unsubscribe link. That link points to the Subscription Centre. When a contact updates their preferences and saves, Customer Insights immediately updates their Contact Point Consent records — future journey steps check these consent records before sending.
Configuration: Customer Insights admin → Compliance → Subscription Centres → New. Design the page (hosted by Customer Insights or embedded in Power Pages). Map each page element to a Consent Purpose and Topic. Set the Compliance Profile to use this Subscription Centre as the default.
💡 Pro Tip: Every email template in Customer Insights - Journeys must include the Subscription Centre link (added as a Footer component or manually). If an email is sent without an unsubscribe link, it violates GDPR and CAN-SPAM. Build the Subscription Centre link into your standard email footer template and make it part of every email design — never a last-minute addition.
D365 Customer Insights - Data exposes a REST API that allows external applications to query unified customer profiles, segment memberships, and prediction scores in real time — enabling activation beyond the built-in export capabilities.
Key API capabilities: Get a unified profile by customer ID (returns all profile attributes, measures, segment memberships, prediction scores). Check segment membership (is Customer X in segment "High Value"?). Get top predicted products for a customer (product recommendation model output). Real-time profile updates (write new events or attribute updates to a profile).
Common API activation use cases: eCommerce personalisation: At browse time, call the Customer Insights API to retrieve the customer's CLV tier and recommended products — personalise the homepage experience in real time. Mobile app: When customer opens the app, retrieve their loyalty tier and personalised offers from Customer Insights. Point of Sale: When a loyalty card is scanned, retrieve the customer profile and display their tier, points balance, and recommended products on the staff tablet.
Authentication: API calls use Azure AD app registration — the calling application authenticates with a service principal and receives an access token to call the Customer Insights API.
Key API capabilities: Get a unified profile by customer ID (returns all profile attributes, measures, segment memberships, prediction scores). Check segment membership (is Customer X in segment "High Value"?). Get top predicted products for a customer (product recommendation model output). Real-time profile updates (write new events or attribute updates to a profile).
Common API activation use cases: eCommerce personalisation: At browse time, call the Customer Insights API to retrieve the customer's CLV tier and recommended products — personalise the homepage experience in real time. Mobile app: When customer opens the app, retrieve their loyalty tier and personalised offers from Customer Insights. Point of Sale: When a loyalty card is scanned, retrieve the customer profile and display their tier, points balance, and recommended products on the staff tablet.
Authentication: API calls use Azure AD app registration — the calling application authenticates with a service principal and receives an access token to call the Customer Insights API.
💡 Pro Tip: The Customer Insights API enables the "segment of one" use case — every customer interaction is personalised based on their individual profile. Document API use cases in requirements as integration requirements, not just marketing requirements. They require developer effort and must be in the project scope and timeline.
Export destinations in D365 Customer Insights - Data connect unified profiles and segments to downstream systems where they are activated — transforming customer intelligence into business action.
Microsoft ecosystem exports: D365 Customer Insights - Journeys (segment → marketing journey audience). D365 Sales (unified profile attributes → Contact enrichment, Customer Card). Azure Blob Storage / ADLS Gen2 (full profile export for data science or BI teams). Azure Synapse Analytics (profile data for advanced analytics). Power BI (profile and segment data for custom dashboards). Dataverse (export measures and segment memberships back into D365 tables).
Advertising platform exports: LinkedIn Matched Audiences (export segments for LinkedIn ad targeting). Google Ads Customer Match (export email lists for Google audience targeting). Facebook Custom Audiences (export segments for Facebook/Instagram ad targeting). Microsoft Advertising (export segments for Bing Ads audiences).
Third-party marketing platform exports: Mailchimp, Klaviyo, Braze, Salesforce Marketing Cloud, HubSpot — via certified connectors or custom export (CSV/API).
Microsoft ecosystem exports: D365 Customer Insights - Journeys (segment → marketing journey audience). D365 Sales (unified profile attributes → Contact enrichment, Customer Card). Azure Blob Storage / ADLS Gen2 (full profile export for data science or BI teams). Azure Synapse Analytics (profile data for advanced analytics). Power BI (profile and segment data for custom dashboards). Dataverse (export measures and segment memberships back into D365 tables).
Advertising platform exports: LinkedIn Matched Audiences (export segments for LinkedIn ad targeting). Google Ads Customer Match (export email lists for Google audience targeting). Facebook Custom Audiences (export segments for Facebook/Instagram ad targeting). Microsoft Advertising (export segments for Bing Ads audiences).
Third-party marketing platform exports: Mailchimp, Klaviyo, Braze, Salesforce Marketing Cloud, HubSpot — via certified connectors or custom export (CSV/API).
💡 Pro Tip: The advertising platform exports (LinkedIn, Google, Facebook) are often the highest-ROI Customer Insights exports for consumer brands. "Suppress existing customers from acquisition campaigns" and "target lookalike audiences based on your High CLV segment" are immediate use cases that save ad spend. Include activation in advertising platforms as a requirements discussion — it often converts a data project into a revenue project.
Copilot in D365 Customer Insights - Journeys embeds generative AI (powered by Azure OpenAI) directly into the marketing platform — helping marketers create content, build segments, and design journeys faster.
Copilot capabilities in Journeys:
Email content generation: Marketer describes what they want ("Write a re-engagement email for customers who haven't purchased in 90 days — tone: friendly, offer: 15% discount"). Copilot generates a full email subject line and body. Marketer reviews, edits, and sends.
Segment builder (natural language): Type "Customers in Mumbai who purchased in the last 30 days and have a CLV score above 70" — Copilot translates this into segment filter conditions automatically. Marketer reviews the filter logic and saves.
Journey creation from description: Describe the journey goal: "Send a 3-part welcome series to new contacts — welcome email on day 1, product guide on day 3, discount offer on day 7." Copilot builds the journey canvas structure. Marketer fills in the specific content.
Image generation (Bing Image Creator): Generate marketing images directly within the email designer.
Copilot capabilities in Journeys:
Email content generation: Marketer describes what they want ("Write a re-engagement email for customers who haven't purchased in 90 days — tone: friendly, offer: 15% discount"). Copilot generates a full email subject line and body. Marketer reviews, edits, and sends.
Segment builder (natural language): Type "Customers in Mumbai who purchased in the last 30 days and have a CLV score above 70" — Copilot translates this into segment filter conditions automatically. Marketer reviews the filter logic and saves.
Journey creation from description: Describe the journey goal: "Send a 3-part welcome series to new contacts — welcome email on day 1, product guide on day 3, discount offer on day 7." Copilot builds the journey canvas structure. Marketer fills in the specific content.
Image generation (Bing Image Creator): Generate marketing images directly within the email designer.
💡 Pro Tip: Copilot content generation is most valuable for teams with limited copywriting resources or who need to produce content in multiple languages. Position it as a "first draft accelerator" not a replacement for the marketer's voice. In requirements, identify which content types (email copy, subject lines, SMS messages) the team wants Copilot to assist with — this shapes the adoption and governance framework for AI-generated content.
In D365 Customer Insights - Journeys, both Contacts and Leads can receive marketing communications — but they represent different stages of the customer lifecycle and have important distinctions:
Contact: A known person with a confirmed relationship to the organisation. In the Dataverse Contact entity. Can have consent records. Can receive commercial emails (with consent). Used for: existing customers, subscribers, attendees, partners.
Lead: A potential prospect — often not yet qualified for sales. In the Dataverse Lead entity. Can receive marketing emails before they are converted to a Contact. Leads have a Lead Score (from lead scoring models). When a Lead reaches the sales-ready threshold, they are assigned to a sales rep in D365 Sales and often converted to a Contact + Opportunity.
Real-time journeys support both: Real-time journeys can target Contacts, Leads, or Customer Insights unified profiles (which can span multiple entity types). This is a key advantage over Outbound Marketing which primarily targeted Contacts.
Consent for Leads: Leads also need consent records for commercial emails. Consent is captured at Lead creation (e.g., via a web form with opt-in checkbox).
Contact: A known person with a confirmed relationship to the organisation. In the Dataverse Contact entity. Can have consent records. Can receive commercial emails (with consent). Used for: existing customers, subscribers, attendees, partners.
Lead: A potential prospect — often not yet qualified for sales. In the Dataverse Lead entity. Can receive marketing emails before they are converted to a Contact. Leads have a Lead Score (from lead scoring models). When a Lead reaches the sales-ready threshold, they are assigned to a sales rep in D365 Sales and often converted to a Contact + Opportunity.
Real-time journeys support both: Real-time journeys can target Contacts, Leads, or Customer Insights unified profiles (which can span multiple entity types). This is a key advantage over Outbound Marketing which primarily targeted Contacts.
Consent for Leads: Leads also need consent records for commercial emails. Consent is captured at Lead creation (e.g., via a web form with opt-in checkbox).
💡 Pro Tip: In B2B scenarios, Leads are the primary audience for demand generation journeys (nurture sequences, event invitations, content download follow-ups). Contacts are the primary audience for retention and upsell journeys (existing customers). Design your journey architecture to clearly distinguish which entity type each journey targets — mixing Contact and Lead journeys without clear segmentation causes reporting confusion and consent management complexity.
Questions 41–50 of 75
Power Automate extends D365 Customer Insights - Journeys by enabling complex automation logic, cross-system actions, and custom integrations that are not possible within the journey canvas alone.
Common Power Automate use cases in Customer Insights - Journeys:
Journey exit trigger: "When a customer completes a journey, send their journey outcome (email engagement score, offer accepted/declined) to the CRM opportunity record." Keeps the sales team informed about marketing engagement.
Cross-system action: "When a contact reaches the MQL step in a journey, create a Task in D365 Sales assigned to the Account Manager, send a Teams message to the sales team channel, and update the Lead Stage field." A single journey event triggers multiple cross-system actions.
Custom trigger firing: "When a Zendesk ticket is resolved, call the Customer Insights custom trigger API to start a CSAT journey." Power Automate acts as the bridge between Zendesk and Customer Insights.
Conditional exit: "If a contact unsubscribes from a journey, update their CRM contact record with UnsubscribeReason and Unsubscribe Date."
Common Power Automate use cases in Customer Insights - Journeys:
Journey exit trigger: "When a customer completes a journey, send their journey outcome (email engagement score, offer accepted/declined) to the CRM opportunity record." Keeps the sales team informed about marketing engagement.
Cross-system action: "When a contact reaches the MQL step in a journey, create a Task in D365 Sales assigned to the Account Manager, send a Teams message to the sales team channel, and update the Lead Stage field." A single journey event triggers multiple cross-system actions.
Custom trigger firing: "When a Zendesk ticket is resolved, call the Customer Insights custom trigger API to start a CSAT journey." Power Automate acts as the bridge between Zendesk and Customer Insights.
Conditional exit: "If a contact unsubscribes from a journey, update their CRM contact record with UnsubscribeReason and Unsubscribe Date."
💡 Pro Tip: Power Automate flows that fire from journey triggers can significantly increase the business impact of a marketing journey — the journey becomes a cross-functional orchestration tool, not just an email-sending system. Always ask in requirements: "When a customer completes a marketing journey, what should happen in your sales or service systems?" The answers reveal the Power Automate integration requirements.
The Event Management module in Customer Insights - Journeys provides end-to-end management of in-person, virtual, and hybrid events — from planning and registration through to post-event follow-up journeys.
Event record configuration: Event name and description. Venue details (in-person: location, capacity, room setup). Event format (In-person, Online via Teams/Webex/Zoom, Hybrid). Sessions (agenda items with speakers, rooms, time slots, capacity limits per session). Registration form (standard or custom questions — dietary preferences, job title, areas of interest). Waitlist management (auto-notify when a spot opens).
Webinar integration: D365 Event Management integrates with Microsoft Teams Live Events (native), GoToWebinar, ON24, and Webex via connectors. Registrations in D365 automatically create meeting invites in the connected webinar platform. Attendance data (joined, duration) syncs back to D365 for post-event segmentation.
Registration portal: Built on Power Pages — customer-facing registration form with event details, session selection, and payment (if ticketed events). Brand-customisable.
Speaker management: Speaker profiles, session assignments, speaker portal for self-service bio and session material uploads.
Event record configuration: Event name and description. Venue details (in-person: location, capacity, room setup). Event format (In-person, Online via Teams/Webex/Zoom, Hybrid). Sessions (agenda items with speakers, rooms, time slots, capacity limits per session). Registration form (standard or custom questions — dietary preferences, job title, areas of interest). Waitlist management (auto-notify when a spot opens).
Webinar integration: D365 Event Management integrates with Microsoft Teams Live Events (native), GoToWebinar, ON24, and Webex via connectors. Registrations in D365 automatically create meeting invites in the connected webinar platform. Attendance data (joined, duration) syncs back to D365 for post-event segmentation.
Registration portal: Built on Power Pages — customer-facing registration form with event details, session selection, and payment (if ticketed events). Brand-customisable.
Speaker management: Speaker profiles, session assignments, speaker portal for self-service bio and session material uploads.
💡 Pro Tip: The post-event follow-up journey is where event ROI is captured. Configure an attendance-based branching journey: Attendees receive session recordings + survey + related content offer. No-shows receive a "Sorry we missed you" email with on-demand recording. Both segments are then scored (attended = +20 points, no-show = +10 points) — keeping all registrants in the nurture flow regardless of attendance.
The unification run in D365 Customer Insights - Data is the process that ingests, deduplicates, matches, and merges data from all connected sources into unified customer profiles — it must complete before segments, measures, and predictions can be calculated.
Unification run stages (in order):
1. Data refresh (pull latest data from all source connections).
2. Deduplication (remove duplicates within each source).
3. Matching (find records across sources that represent the same customer).
4. Merging (combine matched records into unified profiles).
5. Relationship analysis (establish relationships between unified profiles and other entities).
6. Enrichments (apply enrichment services to unified profiles).
7. Measures calculation (recalculate all defined KPI measures).
8. Segment refresh (update dynamic segment membership).
9. Predictions (run scheduled AI model refreshes).
Typical run duration: Small dataset (10K customers, 2 sources): 15-30 minutes. Medium dataset (500K customers, 5 sources): 1-3 hours. Large dataset (5M+ customers, 10+ sources): 4-12 hours.
Unification run stages (in order):
1. Data refresh (pull latest data from all source connections).
2. Deduplication (remove duplicates within each source).
3. Matching (find records across sources that represent the same customer).
4. Merging (combine matched records into unified profiles).
5. Relationship analysis (establish relationships between unified profiles and other entities).
6. Enrichments (apply enrichment services to unified profiles).
7. Measures calculation (recalculate all defined KPI measures).
8. Segment refresh (update dynamic segment membership).
9. Predictions (run scheduled AI model refreshes).
Typical run duration: Small dataset (10K customers, 2 sources): 15-30 minutes. Medium dataset (500K customers, 5 sources): 1-3 hours. Large dataset (5M+ customers, 10+ sources): 4-12 hours.
💡 Pro Tip: Unification run duration directly impacts the freshness of segments and predictions. If a client requires segments to be updated within 1 hour of a customer action, a 4-hour unification run is incompatible. Design the refresh schedule based on business requirements: "How fresh does the data need to be for your most time-sensitive use case?" This determines whether you need real-time streaming ingestion or daily batch unification.
The Email Analytics dashboard in D365 Customer Insights - Journeys provides performance metrics for individual emails and journey-level email performance — enabling marketers to optimise their communications.
Email-level metrics: Sent count, Delivered count, Delivery Rate (%). Opened (unique and total), Open Rate (%). Clicked (unique and total), Click Rate (%). Click-to-Open Rate — CTOR (clicked / opened — measures content quality independent of subject line). Unsubscribed, Spam complaints, Hard bounces, Soft bounces.
Journey-level metrics: Goal completion rate (percentage of journey entrants who achieved the journey goal — e.g., made a purchase, registered for an event). Journey throughput (how many contacts are currently at each step). Drop-off analysis (where are contacts exiting the journey — which step loses the most contacts).
Aggregate analytics (across all emails): Email performance trends over time. Top performing subject lines. Best performing email categories. Deliverability health (bounce rate, spam complaint rate — if high, email domain reputation is at risk).
Insights-driven actions: Low click rate → test different call-to-action button. High unsubscribe rate → review content relevance and frequency.
Email-level metrics: Sent count, Delivered count, Delivery Rate (%). Opened (unique and total), Open Rate (%). Clicked (unique and total), Click Rate (%). Click-to-Open Rate — CTOR (clicked / opened — measures content quality independent of subject line). Unsubscribed, Spam complaints, Hard bounces, Soft bounces.
Journey-level metrics: Goal completion rate (percentage of journey entrants who achieved the journey goal — e.g., made a purchase, registered for an event). Journey throughput (how many contacts are currently at each step). Drop-off analysis (where are contacts exiting the journey — which step loses the most contacts).
Aggregate analytics (across all emails): Email performance trends over time. Top performing subject lines. Best performing email categories. Deliverability health (bounce rate, spam complaint rate — if high, email domain reputation is at risk).
Insights-driven actions: Low click rate → test different call-to-action button. High unsubscribe rate → review content relevance and frequency.
💡 Pro Tip: Click-to-Open Rate (CTOR) is the best metric for measuring email content quality — it isolates content performance from subject line performance. A high open rate but low CTOR means the subject line was compelling but the email content disappointed. Use CTOR when reporting on content optimisation to the client's marketing team.
D365 Customer Insights - Journeys supports SMS (text message) as a channel alongside email — enabling multi-channel customer journeys.
SMS provider integration: D365 Customer Insights - Journeys integrates with SMS providers via connectors: Twilio (most common — supports global SMS, WhatsApp Business, and MMS). Azure Communication Services (Microsoft-native SMS provider). Telesign. Infobip. TeleSign. Custom providers via the SMS provider SDK.
SMS configuration steps: Customer Insights admin centre → Channels → SMS → New SMS Provider. Enter the provider API credentials (account SID, auth token for Twilio). Select phone numbers or short codes to send from. Map the phone number to a specific journey workstream.
SMS in journeys: Add an SMS step to a real-time journey. Select the SMS message template. Personalisation tokens work the same as email ({{contact.firstname}}, custom attributes). Consent checking: D365 checks that the contact has opted in to SMS communications before sending.
SMS analytics: Sent, Delivered, Delivery failures (invalid number, carrier rejection), Replies (if two-way SMS is configured).
SMS provider integration: D365 Customer Insights - Journeys integrates with SMS providers via connectors: Twilio (most common — supports global SMS, WhatsApp Business, and MMS). Azure Communication Services (Microsoft-native SMS provider). Telesign. Infobip. TeleSign. Custom providers via the SMS provider SDK.
SMS configuration steps: Customer Insights admin centre → Channels → SMS → New SMS Provider. Enter the provider API credentials (account SID, auth token for Twilio). Select phone numbers or short codes to send from. Map the phone number to a specific journey workstream.
SMS in journeys: Add an SMS step to a real-time journey. Select the SMS message template. Personalisation tokens work the same as email ({{contact.firstname}}, custom attributes). Consent checking: D365 checks that the contact has opted in to SMS communications before sending.
SMS analytics: Sent, Delivered, Delivery failures (invalid number, carrier rejection), Replies (if two-way SMS is configured).
💡 Pro Tip: SMS has significantly higher open rates than email (98% open rate vs 20% for email) but strict consent requirements and higher cost per message. Reserve SMS for high-priority, time-sensitive messages: order confirmations, appointment reminders, urgent offers. Define a "SMS worthy" threshold in requirements — sending promotional SMS at the same volume as email will frustrate customers and increase opt-out rates.
Understanding the internal data model of D365 Customer Insights - Data is essential for designing correct unification, segments, and integrations.
Core entities in Customer Insights - Data:
Customer profile (msdynci_Customer): The unified customer profile entity — one record per person after identity resolution. Contains all unified attributes from all sources.
Segment member (msdynci_SegmentMembership): Records which segments each customer profile belongs to.
Measure (msdynci_Measure): Calculated KPI values per customer (Total Spend, Average Order Value, Days Since Last Purchase).
Activity (msdynci_Activity): A unified timeline of customer actions across sources (purchases, website visits, email opens).
Prediction scores: Churn score, CLV prediction, and product recommendations are stored as attributes on the Customer Profile entity.
Source data tables: Each connected data source creates its own table in Customer Insights (prefixed with the connection name). These source tables are used only during the unification process — the unified Customer Profile is the master output entity.
Core entities in Customer Insights - Data:
Customer profile (msdynci_Customer): The unified customer profile entity — one record per person after identity resolution. Contains all unified attributes from all sources.
Segment member (msdynci_SegmentMembership): Records which segments each customer profile belongs to.
Measure (msdynci_Measure): Calculated KPI values per customer (Total Spend, Average Order Value, Days Since Last Purchase).
Activity (msdynci_Activity): A unified timeline of customer actions across sources (purchases, website visits, email opens).
Prediction scores: Churn score, CLV prediction, and product recommendations are stored as attributes on the Customer Profile entity.
Source data tables: Each connected data source creates its own table in Customer Insights (prefixed with the connection name). These source tables are used only during the unification process — the unified Customer Profile is the master output entity.
💡 Pro Tip: When working with developers integrating with Customer Insights (via API or exports), share the entity schema documentation from the Customer Insights admin center. The entity names (msdynci_*) are not intuitive — providing clear documentation of which entity holds which data saves significant developer investigation time.
D365 Customer Insights licences are structured differently from per-user D365 licences — understanding the pricing model is critical for scoping and budgeting:
D365 Customer Insights - Data: Licensed by environment + data volume (not per user). Includes: Unlimited unified customer profiles (up to the contracted environment capacity). Standard prediction models (churn, CLV, product recommendation). Segment export to built-in destinations (D365 apps, Azure). Connects to: All Power Query data sources. Approximately $1,700/environment/month (pricing varies — verify on Microsoft's current price sheet).
D365 Customer Insights - Journeys: Licensed by the number of marketable contacts (contacts who can receive commercial emails). 10,000 contacts as a base. Additional contacts in increments. Includes: Unlimited real-time journeys, emails, SMS (SMS delivery costs paid separately to provider). Approximately $1,500/month for 10,000 contacts (again — verify current pricing).
Add-on features: Additional AI Builder capacity for advanced predictions. Customer Voice (surveys) — included in most D365 licences. Power Pages portals — separate licence for customer-facing portals.
D365 Customer Insights - Data: Licensed by environment + data volume (not per user). Includes: Unlimited unified customer profiles (up to the contracted environment capacity). Standard prediction models (churn, CLV, product recommendation). Segment export to built-in destinations (D365 apps, Azure). Connects to: All Power Query data sources. Approximately $1,700/environment/month (pricing varies — verify on Microsoft's current price sheet).
D365 Customer Insights - Journeys: Licensed by the number of marketable contacts (contacts who can receive commercial emails). 10,000 contacts as a base. Additional contacts in increments. Includes: Unlimited real-time journeys, emails, SMS (SMS delivery costs paid separately to provider). Approximately $1,500/month for 10,000 contacts (again — verify current pricing).
Add-on features: Additional AI Builder capacity for advanced predictions. Customer Voice (surveys) — included in most D365 licences. Power Pages portals — separate licence for customer-facing portals.
💡 Pro Tip: The "marketable contacts" licensing model for Customer Insights - Journeys can surprise clients who have a large database but only market to a fraction of it. Clarify: "How many contacts do you currently email per month?" — that number determines the licence tier needed, not the total database size. Unsubscribed and bounced contacts do not count as marketable.
D365 Customer Insights - Journeys provides reporting at two distinct levels — understanding where to find what data prevents time wasted looking in the wrong place:
Journey Analytics (Journey-level reporting): Accessible from the journey canvas by clicking the Analytics button. Shows: Journey throughput (contacts at each step). Goal completion rate. Email performance per step. Channel performance comparison. Drop-off analysis (where contacts exit the journey). Available: while the journey is running and after completion.
Email Analytics (Individual email-level reporting): Accessible from the Email record. Shows: Delivery, open, click, bounce, unsubscribe metrics for that specific email across all journeys it was used in. Heatmap (which links in the email are clicked most). Performance over time (daily trend).
Aggregate Marketing Analytics (Power BI): D365 Customer Insights - Journeys ships with pre-built Power BI reports accessible from the Marketing Reports section. Shows: Aggregate email performance across all emails and journeys. Lead generation trends. Contact growth and churn. Channel performance comparison across all active journeys.
Journey Analytics (Journey-level reporting): Accessible from the journey canvas by clicking the Analytics button. Shows: Journey throughput (contacts at each step). Goal completion rate. Email performance per step. Channel performance comparison. Drop-off analysis (where contacts exit the journey). Available: while the journey is running and after completion.
Email Analytics (Individual email-level reporting): Accessible from the Email record. Shows: Delivery, open, click, bounce, unsubscribe metrics for that specific email across all journeys it was used in. Heatmap (which links in the email are clicked most). Performance over time (daily trend).
Aggregate Marketing Analytics (Power BI): D365 Customer Insights - Journeys ships with pre-built Power BI reports accessible from the Marketing Reports section. Shows: Aggregate email performance across all emails and journeys. Lead generation trends. Contact growth and churn. Channel performance comparison across all active journeys.
💡 Pro Tip: During requirements, map each reporting requirement to the correct reporting layer: "What was the open rate of the welcome email journey?" → Journey Analytics. "How is our email programme performing overall?" → Power BI aggregate report. "Which links in this email were clicked most?" → Email Analytics heatmap. This mapping prevents stakeholders from looking for aggregate data in journey reports or detailed data in aggregate reports.
A structured set of requirements gathering questions for scoping a Customer Insights - Journeys implementation:
Marketing programme requirements: What types of campaigns do you run? (Email newsletters, event invitations, promotional offers, lifecycle journeys, transactional messages). How many emails do you currently send per month and to how many contacts? What is your current email open rate and click rate? (Baseline for improvement measurement).
Journey requirements: Which journeys are most critical? (Welcome series, abandoned cart, re-engagement, birthday, post-purchase, onboarding). What events should trigger journeys? (Form submission, purchase, case resolution, loyalty tier change). How complex is your branching logic? (Simple linear vs. multi-branch with conditions).
Data and integration requirements: Which systems do your contacts and customers live in today? Is there an existing ESP (email service provider) to migrate from? What data should be available in emails for personalisation?
Compliance requirements: Which geographies do you market to? (EU = strict GDPR). Do you have a current consent management process? What is your current list quality (bounce rate, spam complaint rate)?
Marketing programme requirements: What types of campaigns do you run? (Email newsletters, event invitations, promotional offers, lifecycle journeys, transactional messages). How many emails do you currently send per month and to how many contacts? What is your current email open rate and click rate? (Baseline for improvement measurement).
Journey requirements: Which journeys are most critical? (Welcome series, abandoned cart, re-engagement, birthday, post-purchase, onboarding). What events should trigger journeys? (Form submission, purchase, case resolution, loyalty tier change). How complex is your branching logic? (Simple linear vs. multi-branch with conditions).
Data and integration requirements: Which systems do your contacts and customers live in today? Is there an existing ESP (email service provider) to migrate from? What data should be available in emails for personalisation?
Compliance requirements: Which geographies do you market to? (EU = strict GDPR). Do you have a current consent management process? What is your current list quality (bounce rate, spam complaint rate)?
💡 Pro Tip: Always ask "What is the journey that, if automated, would have the most business impact?" This question bypasses the long list of "nice to have" journeys and focuses the team on the highest-value use case. Build that journey first, go live, measure the results, and use the ROI to justify building the remaining journeys. This phased approach generates faster buy-in and funding for the broader programme.
Microsoft is retiring Outbound Marketing in 2025 and all clients must migrate to Real-Time Journeys. This is a significant migration with architectural differences that require careful planning:
Key differences requiring rework: Customer journeys (Outbound) → Real-time journeys (Journeys). Segments (Outbound segments) → Real-time segments in Customer Insights. Marketing emails (same technology, minor differences in template blocks). Lead scoring models (Outbound) → Customer Insights lead scoring (different configuration).
What does NOT directly migrate: Outbound Customer Journeys cannot be converted to Real-time journeys automatically — they must be recreated. Outbound segments work differently — conditions must be re-mapped. Outbound subscription centres → Real-time Compliance Profiles and Subscription Centres (different structure).
Migration approach: Phase 1: Deploy Real-time journeys alongside Outbound (both can coexist). Phase 2: Recreate all active Outbound journeys in Real-time (start with high-priority journeys). Phase 3: Migrate contacts and consent to Real-time consent model. Phase 4: Decommission Outbound journeys. Phase 5: Clean up Outbound configuration.
Key differences requiring rework: Customer journeys (Outbound) → Real-time journeys (Journeys). Segments (Outbound segments) → Real-time segments in Customer Insights. Marketing emails (same technology, minor differences in template blocks). Lead scoring models (Outbound) → Customer Insights lead scoring (different configuration).
What does NOT directly migrate: Outbound Customer Journeys cannot be converted to Real-time journeys automatically — they must be recreated. Outbound segments work differently — conditions must be re-mapped. Outbound subscription centres → Real-time Compliance Profiles and Subscription Centres (different structure).
Migration approach: Phase 1: Deploy Real-time journeys alongside Outbound (both can coexist). Phase 2: Recreate all active Outbound journeys in Real-time (start with high-priority journeys). Phase 3: Migrate contacts and consent to Real-time consent model. Phase 4: Decommission Outbound journeys. Phase 5: Clean up Outbound configuration.
💡 Pro Tip: Always perform an Outbound Marketing audit before starting the migration: list all active customer journeys, their trigger conditions, branching logic, email content, and measured outcomes. This audit becomes the migration backlog. Prioritise journeys by business impact — migrate the highest-revenue journeys first to maintain business continuity during the transition.
Questions 51–60 of 75
The Customer Insights - Data Functional Consultant occupies a unique position requiring cross-functional knowledge across marketing, data engineering, and the Microsoft platform:
Pre-project responsibilities: Discovery and scoping (data source inventory, use case definition, data quality assessment). Solution design (unification architecture, segment library design, prediction model selection, export and activation design). Project planning (phased delivery, data readiness milestones, stakeholder management).
During implementation: Data source configuration (Power Query connections, field mapping to CDM). Unification rule design and validation (match and merge policies, golden record testing). Segment creation and testing (validate segment counts against source data). Measures configuration (calculated KPI fields). Prediction model configuration and validation. Export configuration and end-to-end activation testing.
Post go-live: Training for marketing and data teams. Monitoring of data refresh quality. Iterative segment and measure expansion. Model performance monitoring (churn model accuracy over time).
Cross-functional collaboration required: Data engineers (source system extraction, ADLS pipeline), Marketing team (use case definition, segment sign-off), IT/Security (Azure AD, network access, data governance), D365 Sales/Service consultant (Customer Card integration, consent sync).
Pre-project responsibilities: Discovery and scoping (data source inventory, use case definition, data quality assessment). Solution design (unification architecture, segment library design, prediction model selection, export and activation design). Project planning (phased delivery, data readiness milestones, stakeholder management).
During implementation: Data source configuration (Power Query connections, field mapping to CDM). Unification rule design and validation (match and merge policies, golden record testing). Segment creation and testing (validate segment counts against source data). Measures configuration (calculated KPI fields). Prediction model configuration and validation. Export configuration and end-to-end activation testing.
Post go-live: Training for marketing and data teams. Monitoring of data refresh quality. Iterative segment and measure expansion. Model performance monitoring (churn model accuracy over time).
Cross-functional collaboration required: Data engineers (source system extraction, ADLS pipeline), Marketing team (use case definition, segment sign-off), IT/Security (Azure AD, network access, data governance), D365 Sales/Service consultant (Customer Card integration, consent sync).
💡 Pro Tip: The rarest and most valuable skill for a Customer Insights - Data consultant is the ability to translate between the data team's language ("we need to join the transaction table to the customer dimension with a left outer join") and the marketing team's language ("I want to see all customers who bought in the last 30 days"). Bridge this gap and you will be the most valuable person in every project workshop.
Consent management in D365 Customer Insights - Journeys extends beyond email to all channels — each channel has its own consent requirements and enforcement mechanisms.
SMS consent requirements: In most jurisdictions, SMS requires explicit opt-in before sending any commercial message. TRAI (India): Opt-in required. DND (Do Not Disturb) registry must be checked. Opt-out: Customer replies STOP and must be immediately removed. In D365: Contact Point Consent records for SMS channel (phone number) must show OptIn status. The SMS step in journeys checks this before sending.
Push notification consent: Mobile apps must request push notification permission from the device OS (iOS/Android). When the user grants permission, the app registers a device token and stores it in D365 Customer Insights. The push notification step checks: Is the device token active? Does the contact have consent for push notifications?
Push notification configuration: Customer Insights admin centre → Channels → Mobile apps → New Mobile Application. Configure the mobile app (iOS APNs or Android FCM credentials). The mobile app SDK (provided by Microsoft) handles device token registration and consent capture.
SMS consent requirements: In most jurisdictions, SMS requires explicit opt-in before sending any commercial message. TRAI (India): Opt-in required. DND (Do Not Disturb) registry must be checked. Opt-out: Customer replies STOP and must be immediately removed. In D365: Contact Point Consent records for SMS channel (phone number) must show OptIn status. The SMS step in journeys checks this before sending.
Push notification consent: Mobile apps must request push notification permission from the device OS (iOS/Android). When the user grants permission, the app registers a device token and stores it in D365 Customer Insights. The push notification step checks: Is the device token active? Does the contact have consent for push notifications?
Push notification configuration: Customer Insights admin centre → Channels → Mobile apps → New Mobile Application. Configure the mobile app (iOS APNs or Android FCM credentials). The mobile app SDK (provided by Microsoft) handles device token registration and consent capture.
💡 Pro Tip: Push notification opt-in rates are typically 40-60% on iOS (where the permission prompt is prominent) and 75%+ on Android (where push is enabled by default). When setting journey audience size expectations for push notifications, apply these opt-in rates to the total eligible customer base to estimate the realistic reachable audience.
Data Governance in D365 Customer Insights - Data ensures that customer data is managed responsibly, securely, and in compliance with regulations — a critical consideration given that CDPs centralise sensitive personal data.
Access control: Customer Insights uses Azure AD roles for access management. Roles: Administrator (full access — configure data sources, run unification, manage all settings), Contributor (build segments, measures, configure exports, cannot modify data sources or unification), Viewer (read-only access — view profiles, segments, reports). Row-level security: not natively available in Customer Insights — all users with a role can see all customer profiles.
Data residency: Customer Insights environments are provisioned in a specific Azure region. Customer data stays within that region (data residency compliance for EU organisations under GDPR). Environment region must be specified at provisioning time — cannot be changed afterwards without reprovisioning.
Right to Erasure (GDPR): Customer Insights → Privacy Centre → GDPR Subject Rights Request. Enter the customer's email address. Customer Insights deletes the unified profile and removes the customer from all segments and prediction scores. Source system data is NOT deleted (Customer Insights is not the source of truth — source systems must be updated separately).
Access control: Customer Insights uses Azure AD roles for access management. Roles: Administrator (full access — configure data sources, run unification, manage all settings), Contributor (build segments, measures, configure exports, cannot modify data sources or unification), Viewer (read-only access — view profiles, segments, reports). Row-level security: not natively available in Customer Insights — all users with a role can see all customer profiles.
Data residency: Customer Insights environments are provisioned in a specific Azure region. Customer data stays within that region (data residency compliance for EU organisations under GDPR). Environment region must be specified at provisioning time — cannot be changed afterwards without reprovisioning.
Right to Erasure (GDPR): Customer Insights → Privacy Centre → GDPR Subject Rights Request. Enter the customer's email address. Customer Insights deletes the unified profile and removes the customer from all segments and prediction scores. Source system data is NOT deleted (Customer Insights is not the source of truth — source systems must be updated separately).
💡 Pro Tip: Data residency is a critical architectural decision. European clients under GDPR typically require data to be stored in EU regions (West Europe, North Europe). Confirm the desired Azure region with the client's legal and IT teams before provisioning the Customer Insights environment — reprovisioning requires full data re-ingestion and is very disruptive.
Defining success KPIs before go-live transforms a Customer Insights implementation from a technology project into a business value delivery programme:
Data quality KPIs: Identity resolution rate: % of source records successfully matched to a unified profile (target: 85%+). Duplicate profile rate: % of profiles that are duplicates (target: < 2%). Data freshness: average age of data in unified profiles (target: < 24 hours for critical sources).
Segmentation KPIs: Segment count and coverage: How many actionable segments exist? What % of customers are in at least one active segment? Segment accuracy: Do manual validation checks confirm segment logic is correct? (Target: 98%+ accuracy on 50-record spot-checks).
Activation KPIs (Customer Insights - Journeys): Email open rate improvement: Target +15% vs. pre-Customer Insights baseline. Click-through rate improvement: Target +20%. Lead conversion rate: % of marketing-sourced leads that convert to opportunities. Churn reduction: % reduction in customer churn in the first 6 months after retention journeys go live.
Prediction model KPIs: Churn model precision (did it correctly identify customers who churned?). CLV model accuracy (were the predicted CLV tiers consistent with actual revenue?)
Data quality KPIs: Identity resolution rate: % of source records successfully matched to a unified profile (target: 85%+). Duplicate profile rate: % of profiles that are duplicates (target: < 2%). Data freshness: average age of data in unified profiles (target: < 24 hours for critical sources).
Segmentation KPIs: Segment count and coverage: How many actionable segments exist? What % of customers are in at least one active segment? Segment accuracy: Do manual validation checks confirm segment logic is correct? (Target: 98%+ accuracy on 50-record spot-checks).
Activation KPIs (Customer Insights - Journeys): Email open rate improvement: Target +15% vs. pre-Customer Insights baseline. Click-through rate improvement: Target +20%. Lead conversion rate: % of marketing-sourced leads that convert to opportunities. Churn reduction: % reduction in customer churn in the first 6 months after retention journeys go live.
Prediction model KPIs: Churn model precision (did it correctly identify customers who churned?). CLV model accuracy (were the predicted CLV tiers consistent with actual revenue?)
💡 Pro Tip: Always establish a pre-implementation baseline measurement before go-live. Take a snapshot of current email performance, current churn rate, and current conversion rates. Without a baseline, you cannot demonstrate the improvement that Customer Insights delivered — and the project loses its ability to justify the investment retrospectively.
Understanding common failure modes in Customer Insights projects helps consultants proactively address risks:
Challenge 1 — Poor source data quality: 40% of email addresses in the CRM are invalid. Customer IDs are inconsistent across systems. Name formats differ (ALL CAPS in ERP, Title Case in CRM). Mitigation: Data quality assessment in week 1. Agree acceptance criteria for data before ingestion. Run data cleansing as a parallel workstream.
Challenge 2 — Identity resolution producing too many or too few matches: Too strict rules → fragmented profiles (same person as 3 profiles). Too loose rules → merged profiles (3 family members as one profile). Mitigation: Golden Record testing with 100 known customers. Iterative tuning of match precision levels.
Challenge 3 — No clear use case prioritisation: Team wants to configure everything at once. Prediction models, all segments, all exports, full journey library. Mitigation: MVP scope — 5 segments, 2 measures, 1 prediction model, 2 journeys. Prove value first, expand second.
Challenge 4 — Insufficient historical data for predictions: Organisation is 6 months old — not enough transaction history for churn model. Mitigation: Set realistic prediction timeline. Collect data now; enable predictions after 12 months of history.
Challenge 1 — Poor source data quality: 40% of email addresses in the CRM are invalid. Customer IDs are inconsistent across systems. Name formats differ (ALL CAPS in ERP, Title Case in CRM). Mitigation: Data quality assessment in week 1. Agree acceptance criteria for data before ingestion. Run data cleansing as a parallel workstream.
Challenge 2 — Identity resolution producing too many or too few matches: Too strict rules → fragmented profiles (same person as 3 profiles). Too loose rules → merged profiles (3 family members as one profile). Mitigation: Golden Record testing with 100 known customers. Iterative tuning of match precision levels.
Challenge 3 — No clear use case prioritisation: Team wants to configure everything at once. Prediction models, all segments, all exports, full journey library. Mitigation: MVP scope — 5 segments, 2 measures, 1 prediction model, 2 journeys. Prove value first, expand second.
Challenge 4 — Insufficient historical data for predictions: Organisation is 6 months old — not enough transaction history for churn model. Mitigation: Set realistic prediction timeline. Collect data now; enable predictions after 12 months of history.
💡 Pro Tip: The single most common reason Customer Insights projects fail to deliver ROI is lack of activation — the CDP is built, profiles are unified, segments are created, and then nothing happens with them. Requirements must include activation for every data investment: for every segment built, there must be a defined activation destination and an owner responsible for using it. "Segment built but not activated" delivers zero business value.
The Churn Prediction model in D365 Customer Insights - Data is the most commonly used built-in AI model — predicting which customers are at risk of churning before they actually leave.
Churn definition (configurable): Subscription churn: Customer cancels their subscription or does not renew. Transactional churn: Customer has not made a purchase in X days (configurable — 60 days, 90 days, 180 days). The churn definition must match the client's business model — a SaaS company defines churn differently from a retail brand.
Configuration steps: Customer Insights → Predictions → Customer Churn → New. Define churn type (subscription vs. transactional). Map the required data entities (transaction history or subscription history). Set the churn window (how far back to look for activity). Set the prediction window (predict churn in the next 30, 60, or 90 days). Run the model.
Model validation metrics: AUC-ROC score (Area Under the Curve — 0.7+ is acceptable, 0.8+ is good, 0.9+ is excellent). Precision: Of customers predicted to churn, what % actually did? Recall: Of customers who actually churned, what % did the model catch?
Churn definition (configurable): Subscription churn: Customer cancels their subscription or does not renew. Transactional churn: Customer has not made a purchase in X days (configurable — 60 days, 90 days, 180 days). The churn definition must match the client's business model — a SaaS company defines churn differently from a retail brand.
Configuration steps: Customer Insights → Predictions → Customer Churn → New. Define churn type (subscription vs. transactional). Map the required data entities (transaction history or subscription history). Set the churn window (how far back to look for activity). Set the prediction window (predict churn in the next 30, 60, or 90 days). Run the model.
Model validation metrics: AUC-ROC score (Area Under the Curve — 0.7+ is acceptable, 0.8+ is good, 0.9+ is excellent). Precision: Of customers predicted to churn, what % actually did? Recall: Of customers who actually churned, what % did the model catch?
💡 Pro Tip: Never deploy a churn model without reviewing the AUC-ROC score and the top influencing factors. If the #1 factor is "customer was created less than 30 days ago" — the model is learning that new customers haven't had time to buy again, not that they are churning. Review the factor list with your data scientist or Microsoft FastTrack team to ensure the model is learning meaningful signals.
A Journey Goal in D365 Customer Insights - Journeys defines the desired outcome of a journey — the specific action a customer should take — and tracks what percentage of journey entrants achieve that goal.
Journey Goal configuration: In the journey settings, add a Goal condition. Goal type options: Email link clicked (the contact clicked a specific link). Form submitted (the contact completed a specific form). Event registration (the contact registered for an event). Custom trigger (any custom event you define — e.g., purchase completed, account upgraded).
Goal tracking: As contacts move through the journey, Customer Insights monitors whether each contact meets the goal condition. Goal completion rate = (contacts who achieved goal) / (total contacts who entered journey) x 100.
Journey exit on goal achievement: When a contact achieves the goal, they can be automatically exited from the journey (no further messages sent). This prevents sending a "we miss you" re-engagement email to someone who just made a purchase.
Goal comparison across journeys: Compare goal completion rates across different journey variations — which nurture sequence converts leads to MQL at the highest rate?
Journey Goal configuration: In the journey settings, add a Goal condition. Goal type options: Email link clicked (the contact clicked a specific link). Form submitted (the contact completed a specific form). Event registration (the contact registered for an event). Custom trigger (any custom event you define — e.g., purchase completed, account upgraded).
Goal tracking: As contacts move through the journey, Customer Insights monitors whether each contact meets the goal condition. Goal completion rate = (contacts who achieved goal) / (total contacts who entered journey) x 100.
Journey exit on goal achievement: When a contact achieves the goal, they can be automatically exited from the journey (no further messages sent). This prevents sending a "we miss you" re-engagement email to someone who just made a purchase.
Goal comparison across journeys: Compare goal completion rates across different journey variations — which nurture sequence converts leads to MQL at the highest rate?
💡 Pro Tip: Journey Goals should be defined BEFORE building the journey — they are requirements, not reporting afterthoughts. Ask: "What does success look like for this journey? What specific action do you want the customer to take?" Every journey should have exactly one primary goal. Multiple goals make reporting ambiguous and optimisation difficult.
WhatsApp Business integration in D365 Customer Insights - Journeys enables sending WhatsApp messages as part of customer journeys — a critical channel in India, Southeast Asia, Latin America, and Europe where WhatsApp is the primary messaging platform.
WhatsApp Business API (official): D365 Customer Insights - Journeys connects to the WhatsApp Business API via an approved Business Solution Provider (BSP) such as: Twilio (most common — also used for SMS), Vonage, MessageBird, Infobip, Sinch. The BSP provides the WhatsApp Business API credentials used to configure the channel in Customer Insights.
WhatsApp message types: Template messages (pre-approved by WhatsApp — can be sent to any opted-in number). Used for: transactional messages, notifications, alerts. Session messages (can only be sent within 24 hours of the customer's last message to you — used for conversational responses).
Template approval process: WhatsApp templates must be submitted to and approved by Meta before use. Approval typically takes 24-48 hours. Customer Insights - Journeys only sends pre-approved templates — no free-form commercial messages.
WhatsApp Business API (official): D365 Customer Insights - Journeys connects to the WhatsApp Business API via an approved Business Solution Provider (BSP) such as: Twilio (most common — also used for SMS), Vonage, MessageBird, Infobip, Sinch. The BSP provides the WhatsApp Business API credentials used to configure the channel in Customer Insights.
WhatsApp message types: Template messages (pre-approved by WhatsApp — can be sent to any opted-in number). Used for: transactional messages, notifications, alerts. Session messages (can only be sent within 24 hours of the customer's last message to you — used for conversational responses).
Template approval process: WhatsApp templates must be submitted to and approved by Meta before use. Approval typically takes 24-48 hours. Customer Insights - Journeys only sends pre-approved templates — no free-form commercial messages.
💡 Pro Tip: WhatsApp template approval is often on the critical path for WhatsApp journey go-lives. Submit templates for approval at the start of the project — not after the journey is built. Template rejection (Meta rejects templates that sound too promotional or include certain restricted content) can delay go-live by days. Build this approval buffer into the project timeline.
The business value of D365 Customer Insights - Data is realised through segment activation — using unified segments to drive targeted actions across marketing, sales, service, and advertising. Top use cases:
Marketing activation: Welcome journey for new customers (segment: Created in last 7 days). Re-engagement campaign (segment: No purchase in 90 days). Upgrade offer (segment: Medium CLV + High engagement). Win-back campaign (segment: High CLV + Churn Risk > 70%). Birthday email (segment: Birthday month = this month).
Sales activation: High CLV + Churn Risk exported to D365 Sales as a lead list — account manager outreach. "Ready to buy" signals exported to D365 Sales — rep notification when a customer has been to the pricing page 3 times.
Advertising activation: Suppress existing customers from new customer acquisition campaigns (LinkedIn, Google Ads). Lookalike audiences based on High CLV segment — find new prospects who look like your best customers.
Service activation: VIP Customer segment exported to D365 Customer Service — these customers always go to the priority queue. High Churn Risk segment visible in the Customer Service Customer Card — agent knows to be extra attentive.
Marketing activation: Welcome journey for new customers (segment: Created in last 7 days). Re-engagement campaign (segment: No purchase in 90 days). Upgrade offer (segment: Medium CLV + High engagement). Win-back campaign (segment: High CLV + Churn Risk > 70%). Birthday email (segment: Birthday month = this month).
Sales activation: High CLV + Churn Risk exported to D365 Sales as a lead list — account manager outreach. "Ready to buy" signals exported to D365 Sales — rep notification when a customer has been to the pricing page 3 times.
Advertising activation: Suppress existing customers from new customer acquisition campaigns (LinkedIn, Google Ads). Lookalike audiences based on High CLV segment — find new prospects who look like your best customers.
Service activation: VIP Customer segment exported to D365 Customer Service — these customers always go to the priority queue. High Churn Risk segment visible in the Customer Service Customer Card — agent knows to be extra attentive.
💡 Pro Tip: The suppression use case for advertising (excluding existing customers from acquisition campaigns) often has the fastest measurable ROI of any Customer Insights activation. Many brands waste 20-30% of their acquisition ad spend on people who are already customers. Calculate the current waste in requirements: "Monthly acquisition spend: Rs.10 lakh. Estimated 25% wasted on existing customers = Rs.2.5 lakh/month saved with suppression." This makes the business case concrete and immediate.
D365 Customer Insights - Journeys includes a library of pre-built journey templates — ready-to-use journey structures that cover the most common marketing automation use cases, reducing build time significantly.
Available template categories: Acquisition: "Download followed by nurture sequence." Onboarding: "Welcome series for new contacts (3-email sequence)." Retention: "Re-engagement for inactive customers." Winback: "Lapsed customer recovery journey." Event: "Event invitation, registration confirmation, and post-event follow-up." B2B demand generation: "Content download → nurture → MQL handoff."
How to use templates: Customer Insights - Journeys → Journeys → New → Select from templates. Browse the library by category. Select a template — a pre-built canvas loads with placeholder steps, timing, and branching logic. Customise: replace placeholder content with actual emails, adjust timing delays, modify conditions for the client's specific logic.
Custom template library: Organisations can save their own completed journeys as templates for reuse across campaigns or brands.
Available template categories: Acquisition: "Download followed by nurture sequence." Onboarding: "Welcome series for new contacts (3-email sequence)." Retention: "Re-engagement for inactive customers." Winback: "Lapsed customer recovery journey." Event: "Event invitation, registration confirmation, and post-event follow-up." B2B demand generation: "Content download → nurture → MQL handoff."
How to use templates: Customer Insights - Journeys → Journeys → New → Select from templates. Browse the library by category. Select a template — a pre-built canvas loads with placeholder steps, timing, and branching logic. Customise: replace placeholder content with actual emails, adjust timing delays, modify conditions for the client's specific logic.
Custom template library: Organisations can save their own completed journeys as templates for reuse across campaigns or brands.
💡 Pro Tip: Always demo the template library to clients in discovery sessions — seeing a pre-built Abandoned Cart journey or Welcome Series canvas immediately makes Customer Insights - Journeys tangible. The question changes from "can D365 do this?" to "how do we configure this template for our specific scenario?" which accelerates requirements gathering significantly.
Questions 61–70 of 75
Frequency capping (also called contact fatigue management) in D365 Customer Insights - Journeys prevents customers from receiving too many communications within a short period — protecting the quality of the customer experience and reducing unsubscribe rates.
Without frequency capping: A customer could be enrolled in 5 active journeys simultaneously and receive 3 emails on the same day from different journeys — causing email fatigue, high unsubscribes, and brand damage.
Customer Insights - Journeys frequency capping configuration: Customer Insights admin centre → Marketing Settings → Frequency Cap. Set rules such as: Maximum 1 commercial email per day. Maximum 3 commercial emails per week. Maximum 8 commercial emails per month. The frequency cap applies across ALL real-time journeys simultaneously — not per journey.
Cap enforcement behaviour: When a customer is due to receive an email but the frequency cap is reached, the email is skipped for that customer. The journey continues — the customer moves to the next step without receiving that specific message. The cap is only applied to commercial messages — transactional messages (order confirmation, password reset) are never capped.
Without frequency capping: A customer could be enrolled in 5 active journeys simultaneously and receive 3 emails on the same day from different journeys — causing email fatigue, high unsubscribes, and brand damage.
Customer Insights - Journeys frequency capping configuration: Customer Insights admin centre → Marketing Settings → Frequency Cap. Set rules such as: Maximum 1 commercial email per day. Maximum 3 commercial emails per week. Maximum 8 commercial emails per month. The frequency cap applies across ALL real-time journeys simultaneously — not per journey.
Cap enforcement behaviour: When a customer is due to receive an email but the frequency cap is reached, the email is skipped for that customer. The journey continues — the customer moves to the next step without receiving that specific message. The cap is only applied to commercial messages — transactional messages (order confirmation, password reset) are never capped.
💡 Pro Tip: Define frequency caps in requirements as a policy decision — "How many marketing emails is it acceptable to send to one customer per week?" This is a brand and customer experience question, not a technical one. Typical B2C consumer brands: max 2-3 per week. B2B enterprise: max 1-2 per week. High-frequency promotional retail: up to 1 per day. Document the agreed policy in the BRD.
The Customer Journey Insights view on the Contact or Lead record in D365 shows a timeline of all marketing interactions that person has had across all journeys — giving sales reps and service agents full marketing engagement context.
What the marketing timeline shows: Emails sent (date, email name, journey name). Emails opened (which emails and when). Links clicked (which links in which emails). Forms submitted (which form, when, what data submitted). Events registered for and attended. Journey entries and exits. SMS messages sent. Unsubscribe actions.
Where to find it: Contact record in D365 Sales → Customer Journeys tab (or Timeline view when marketing activities are included). Lead record → same location.
Business value for sales reps: Before calling a prospect, a rep checks their marketing timeline: "She opened the pricing comparison email 3 times yesterday and clicked the demo request link but did not submit the form." This is a hot buying signal — the rep should follow up with a demo offer immediately rather than a generic check-in call.
What the marketing timeline shows: Emails sent (date, email name, journey name). Emails opened (which emails and when). Links clicked (which links in which emails). Forms submitted (which form, when, what data submitted). Events registered for and attended. Journey entries and exits. SMS messages sent. Unsubscribe actions.
Where to find it: Contact record in D365 Sales → Customer Journeys tab (or Timeline view when marketing activities are included). Lead record → same location.
Business value for sales reps: Before calling a prospect, a rep checks their marketing timeline: "She opened the pricing comparison email 3 times yesterday and clicked the demo request link but did not submit the form." This is a hot buying signal — the rep should follow up with a demo offer immediately rather than a generic check-in call.
💡 Pro Tip: Training sales reps to check the marketing timeline before customer calls is one of the highest-ROI training investments in a Customer Insights - Journeys go-live. Sales reps who use marketing engagement data in their call preparation convert 2-3x more effectively than those who call cold. Include this in the joint Sales + Marketing alignment workshop at go-live.
Clients often compare D365 Customer Insights - Journeys with HubSpot Marketing Hub. Understanding the competitive positioning helps you advise clients appropriately:
| Aspect | Customer Insights - Journeys | HubSpot Marketing Hub |
|---|---|---|
| CRM integration | Native Dataverse — zero sync needed | Native HubSpot CRM (separate sync for Salesforce/other CRMs) |
| Real-time triggers | Yes — sub-second | Workflows (minutes delay) |
| CDP integration | Native Customer Insights - Data | Requires HubSpot CRM data enrichment tools or third-party CDP |
| B2B features | Strong (lead scoring, account-based) | Very strong (HubSpot designed for B2B) |
| Ease of use | More complex — steeper learning curve | More intuitive — faster time to first campaign |
| AI features | Copilot, STO, churn/CLV predictions | AI content generation, basic predictive scoring |
| Best for | Microsoft-ecosystem organisations needing deep CRM + CDP integration | Organisations prioritising marketing-first with strong B2B features |
💡 Pro Tip: The decisive question in competitive situations: "What is your CRM?" If D365 Sales — Customer Insights - Journeys wins on native integration alone. If Salesforce or no CRM — HubSpot may be the better fit for marketing-first organisations. The integration depth with D365 Sales is Customer Insights - Journeys' strongest competitive advantage.
D365 Customer Insights - Data environments are provisioned in the Power Platform admin centre — the environment type determines its purpose and restrictions:
Production environment: Live, customer-facing data. Fully licensed. All features available. Full data volumes. Connected to live source systems. Used by: marketing team for live segments and journeys, data team for live predictions and exports.
Sandbox environment: For testing, training, and development. Can be refreshed from production data (data copy). Not connected to real marketing send — prevents accidental emails to real customers. Used by: consultants during implementation, business users during UAT.
Trial environment: 30-day free trial. Limited data volumes (up to 100K profiles). Good for demo and proof-of-concept. Expires after 30 days — all data lost. Used by: presales demos, initial client evaluations.
Environment capacity management: Each Customer Insights - Data environment has a licensed capacity limit (number of unified profiles). If the unified profile count exceeds the licensed capacity, new profiles are not created for the overflow records.
Production environment: Live, customer-facing data. Fully licensed. All features available. Full data volumes. Connected to live source systems. Used by: marketing team for live segments and journeys, data team for live predictions and exports.
Sandbox environment: For testing, training, and development. Can be refreshed from production data (data copy). Not connected to real marketing send — prevents accidental emails to real customers. Used by: consultants during implementation, business users during UAT.
Trial environment: 30-day free trial. Limited data volumes (up to 100K profiles). Good for demo and proof-of-concept. Expires after 30 days — all data lost. Used by: presales demos, initial client evaluations.
Environment capacity management: Each Customer Insights - Data environment has a licensed capacity limit (number of unified profiles). If the unified profile count exceeds the licensed capacity, new profiles are not created for the overflow records.
💡 Pro Tip: Always provision a dedicated Sandbox environment for implementation before go-live — never develop directly in the production environment. The Sandbox allows the team to test unification rule changes without disrupting production segments and journeys. The cost of a Sandbox environment is typically a fraction of the cost of a production incident caused by untested configuration changes.
B2B journey orchestration in D365 Customer Insights - Journeys addresses the unique requirements of business-to-business demand generation — where decisions involve multiple stakeholders and take months.
B2B-specific journey patterns:
Account-based marketing (ABM) journey: Target all contacts at a specific high-value Account with a coordinated sequence — different messages for the Economic Buyer, Technical Buyer, and End User at the same company. Conditions check contact role and account attributes.
Lead nurture journey (B2B): Content download → Wait 3 days → Follow-up email with related content → Check lead score: if score > 40, continue nurture; if score < 40, move to re-engagement. Continue until MQL threshold reached → Sales handoff trigger fires.
Trial-to-paid conversion journey: User signs up for trial → Daily tips for first 7 days. Day 7: Check if user has activated key feature. If yes: upgrade offer email. If no: activation help email + in-app support triggered.
Executive engagement journey: Target C-suite contacts at strategic accounts with an executive briefing invitation. After attending: send follow-up from CEO (personalised with exec's name).
B2B-specific journey patterns:
Account-based marketing (ABM) journey: Target all contacts at a specific high-value Account with a coordinated sequence — different messages for the Economic Buyer, Technical Buyer, and End User at the same company. Conditions check contact role and account attributes.
Lead nurture journey (B2B): Content download → Wait 3 days → Follow-up email with related content → Check lead score: if score > 40, continue nurture; if score < 40, move to re-engagement. Continue until MQL threshold reached → Sales handoff trigger fires.
Trial-to-paid conversion journey: User signs up for trial → Daily tips for first 7 days. Day 7: Check if user has activated key feature. If yes: upgrade offer email. If no: activation help email + in-app support triggered.
Executive engagement journey: Target C-suite contacts at strategic accounts with an executive briefing invitation. After attending: send follow-up from CEO (personalised with exec's name).
💡 Pro Tip: In B2B, the buying committee is the customer — not an individual. Requirements for ABM journeys must map each journey message to a specific buyer persona role (Economic Buyer, Champion, Technical Evaluator). Different personas need different messages. Build a "Persona x Journey Stage x Message" matrix before building any B2B journey.
D365 Customer Insights - Journeys integrates with Microsoft Teams in multiple ways — from event management to internal notifications and collaborative marketing workflows.
Teams Live Events for webinars: D365 Event Management creates a Teams Live Event (or Teams Meeting) automatically when an event is created in Customer Insights - Journeys. Registrations in D365 auto-generate Teams meeting invitations sent to attendees. Post-event attendance data (who joined, for how long) syncs back to D365 from Teams.
Teams channel notifications via Power Automate: Journey milestones trigger Teams channel notifications: "200 contacts have entered the Q3 nurture journey." "The lead_score_reached trigger fired 50 times today — 50 MQLs created." "Abandoned cart journey recovered 35 purchases today — Rs.52,000 revenue recovered."
Teams for internal collaboration: Marketing team members can @mention each other in journey notes (if integrated via Teams app for D365). Approval workflows for email templates can route through Teams for review and approval.
Teams for event check-in: Event attendees can join Teams Live Events directly from their email confirmation link — no separate platform login required.
Teams Live Events for webinars: D365 Event Management creates a Teams Live Event (or Teams Meeting) automatically when an event is created in Customer Insights - Journeys. Registrations in D365 auto-generate Teams meeting invitations sent to attendees. Post-event attendance data (who joined, for how long) syncs back to D365 from Teams.
Teams channel notifications via Power Automate: Journey milestones trigger Teams channel notifications: "200 contacts have entered the Q3 nurture journey." "The lead_score_reached trigger fired 50 times today — 50 MQLs created." "Abandoned cart journey recovered 35 purchases today — Rs.52,000 revenue recovered."
Teams for internal collaboration: Marketing team members can @mention each other in journey notes (if integrated via Teams app for D365). Approval workflows for email templates can route through Teams for review and approval.
Teams for event check-in: Event attendees can join Teams Live Events directly from their email confirmation link — no separate platform login required.
💡 Pro Tip: The Teams webinar integration is one of the quickest wins in a Customer Insights - Journeys implementation. Configure it in the first sprint and run a test webinar before other journeys are live. Seeing end-to-end flow — registration in D365 → Teams invite sent automatically → attendance data synced back → post-event journey fires — builds immediate client confidence in the platform.
The Activity entity in D365 Customer Insights - Data creates a unified timeline of customer actions across all source systems — forming the behavioural backbone of the unified customer profile.
What Activities represent: Any discrete customer action: purchases, website page views, email clicks, support case creations, loyalty point redemptions, app feature usage, event check-ins, physical store visits.
Mapping source events to Activities: When configuring data unification, you designate specific source tables as "Activity" entities. Map the required CDM fields: Activity type (purchase, page view, email click — free text label). Event time (timestamp of the activity). Customer ID (links the activity to a unified profile). Optional: Product, Channel, Amount, Notes.
How Activities are used: Timeline visualisation: All activities from all sources displayed chronologically on the Customer Profile record. Segmentation: "Customers who performed Activity Type = Purchase in the last 30 days." Measures: "Number of purchase activities in the last 90 days" (a rollup measure). Predictions: The churn and CLV models use activity data as key input signals.
Activity timeline in the profile UI: Switch between activity types, filter by time range, and see the full multi-channel history in one view.
What Activities represent: Any discrete customer action: purchases, website page views, email clicks, support case creations, loyalty point redemptions, app feature usage, event check-ins, physical store visits.
Mapping source events to Activities: When configuring data unification, you designate specific source tables as "Activity" entities. Map the required CDM fields: Activity type (purchase, page view, email click — free text label). Event time (timestamp of the activity). Customer ID (links the activity to a unified profile). Optional: Product, Channel, Amount, Notes.
How Activities are used: Timeline visualisation: All activities from all sources displayed chronologically on the Customer Profile record. Segmentation: "Customers who performed Activity Type = Purchase in the last 30 days." Measures: "Number of purchase activities in the last 90 days" (a rollup measure). Predictions: The churn and CLV models use activity data as key input signals.
Activity timeline in the profile UI: Switch between activity types, filter by time range, and see the full multi-channel history in one view.
💡 Pro Tip: The richer the Activity data ingested, the more powerful the segmentation and predictions. A common mistake is only ingesting purchase activities. Also ingest: website sessions, email opens, app events, and support interactions. This multi-signal approach enables segments like "High engagement + no purchase in 60 days" which are far more actionable than single-signal segments.
Migrating from a legacy Email Service Provider (Mailchimp, Constant Contact, Marketo, HubSpot) to D365 Customer Insights - Journeys requires careful planning to avoid disrupting active marketing programmes:
Phase 1 — Inventory and assessment: Document all active automations in the legacy ESP (name, trigger, audience, email content, performance metrics). Export all contact lists with subscription statuses and tags. Export all email templates (HTML). Map legacy concept to Customer Insights equivalent: Mailchimp Audience → Customer Insights Contact list. Mailchimp Tag → Customer Insights Segment. Mailchimp Automation → Customer Insights Journey. Mailchimp Campaign → Customer Insights Email send.
Phase 2 — Technical setup: Configure sending domain authentication (SPF/DKIM/DMARC) on the new sending domain. Import contact list with subscription statuses preserved. Recreate email templates in Customer Insights email designer. Configure suppression list (unsubscribes from legacy system).
Phase 3 — Parallel running: Run both systems simultaneously for 30 days — the same emails sent from both systems with a suppression to prevent duplicates. Monitor deliverability from the new domain during warm-up period.
Phase 1 — Inventory and assessment: Document all active automations in the legacy ESP (name, trigger, audience, email content, performance metrics). Export all contact lists with subscription statuses and tags. Export all email templates (HTML). Map legacy concept to Customer Insights equivalent: Mailchimp Audience → Customer Insights Contact list. Mailchimp Tag → Customer Insights Segment. Mailchimp Automation → Customer Insights Journey. Mailchimp Campaign → Customer Insights Email send.
Phase 2 — Technical setup: Configure sending domain authentication (SPF/DKIM/DMARC) on the new sending domain. Import contact list with subscription statuses preserved. Recreate email templates in Customer Insights email designer. Configure suppression list (unsubscribes from legacy system).
Phase 3 — Parallel running: Run both systems simultaneously for 30 days — the same emails sent from both systems with a suppression to prevent duplicates. Monitor deliverability from the new domain during warm-up period.
💡 Pro Tip: Email domain warm-up is the most critical technical risk in an ESP migration. A new sending domain starts with no reputation — sending large volumes immediately can cause emails to land in spam. Warm up the new domain over 4-6 weeks by gradually increasing daily send volume: week 1 = 1,000 emails/day, week 2 = 5,000/day, week 3 = 20,000/day, until reaching full send volume. Never cut over to full volume on day 1.
Data quality is the foundation of any CDP — Customer Insights cannot generate reliable profiles, segments, or predictions from poor quality source data. Key data quality requirements:
Identity fields quality (critical for unification): Email addresses: Valid format, no obvious typos (gmai.com instead of gmail.com), not test addresses. Phone numbers: Consistent format (+91 prefix, no spaces or dashes, 10 digits). Customer IDs: Consistent across systems (same format in CRM and ERP). Names: Consistent casing and formatting (not ALL CAPS from legacy systems).
Transaction data quality (critical for predictions): Transaction dates: Valid dates, no null values, no future dates. Transaction amounts: Positive values (negative = returns, need separate handling). Product identifiers: Consistent across transactions (same product not referred to by 3 different IDs).
Completeness requirements: Email address present on > 80% of customer records (for identity resolution to work effectively). Transaction history present for > 75% of customers (for churn and CLV models to be meaningful).
Data quality assessment process: Profile each source data table: count of records, null rates per column, duplicate rates, format consistency, outlier analysis. Produce a Data Quality Report with a traffic light score per source and per field.
Identity fields quality (critical for unification): Email addresses: Valid format, no obvious typos (gmai.com instead of gmail.com), not test addresses. Phone numbers: Consistent format (+91 prefix, no spaces or dashes, 10 digits). Customer IDs: Consistent across systems (same format in CRM and ERP). Names: Consistent casing and formatting (not ALL CAPS from legacy systems).
Transaction data quality (critical for predictions): Transaction dates: Valid dates, no null values, no future dates. Transaction amounts: Positive values (negative = returns, need separate handling). Product identifiers: Consistent across transactions (same product not referred to by 3 different IDs).
Completeness requirements: Email address present on > 80% of customer records (for identity resolution to work effectively). Transaction history present for > 75% of customers (for churn and CLV models to be meaningful).
Data quality assessment process: Profile each source data table: count of records, null rates per column, duplicate rates, format consistency, outlier analysis. Produce a Data Quality Report with a traffic light score per source and per field.
💡 Pro Tip: Never skip the data quality assessment step — even if the client says "our data is clean." In 10 years of implementing CDPs, "our data is clean" has never been true. The data quality assessment is also a risk management document: if the implementation underdelivers because data quality was poor, the assessment demonstrates that the risk was identified and the client accepted it. Document acceptance criteria for data quality before proceeding to build.
A Loyalty Programme journey in D365 Customer Insights - Journeys automates the communications that drive loyalty programme engagement and tier progression — one of the highest-ROI uses of marketing automation for B2C brands.
Key loyalty journeys to configure:
Tier upgrade notification: Trigger: Loyalty tier changed from Silver to Gold (Dataverse record update). Action: Send congratulations email. Include personalised benefits of Gold tier. Invite to exclusive Gold member event. Time-sensitive offer to celebrate the upgrade.
Points expiry warning: Trigger: Loyalty points expiry date within 30 days AND points balance > 500. Action: 30 days before: "Your points are expiring" email. 7 days before: Urgent SMS reminder. Day before: Final WhatsApp message with direct redemption link.
Tier renewal motivation: Trigger: Annual tier review date within 60 days AND customer is at risk of dropping a tier. Action: "You need X more purchases to keep your Gold status" email series with personalised spend gap.
Birthday rewards journey: Trigger: Contact birthday month = current month. Action: Birthday email with double-points offer on birthday week.
Key loyalty journeys to configure:
Tier upgrade notification: Trigger: Loyalty tier changed from Silver to Gold (Dataverse record update). Action: Send congratulations email. Include personalised benefits of Gold tier. Invite to exclusive Gold member event. Time-sensitive offer to celebrate the upgrade.
Points expiry warning: Trigger: Loyalty points expiry date within 30 days AND points balance > 500. Action: 30 days before: "Your points are expiring" email. 7 days before: Urgent SMS reminder. Day before: Final WhatsApp message with direct redemption link.
Tier renewal motivation: Trigger: Annual tier review date within 60 days AND customer is at risk of dropping a tier. Action: "You need X more purchases to keep your Gold status" email series with personalised spend gap.
Birthday rewards journey: Trigger: Contact birthday month = current month. Action: Birthday email with double-points offer on birthday week.
💡 Pro Tip: Loyalty journey ROI is highly measurable: compare the redemption rate and subsequent purchase rate between customers who received the points-expiry journey vs. those who did not. This A/B comparison typically shows 30-50% higher redemption rates for journey-contacted customers — a compelling number to report to marketing leadership.
Questions 71–75 of 75
Microsoft Fabric is Microsoft's unified data analytics platform — combining data engineering, data warehousing, data science, and BI in one SaaS platform. Its relationship to Customer Insights - Data is increasingly important for enterprise implementations:
Customer Insights reads from Fabric: Customer Insights - Data connects natively to Microsoft Fabric lakehouses and warehouses as data sources. Instead of configuring individual Power Query connections for each source system, the data engineering team builds a Fabric lakehouse that consolidates all source data. Customer Insights reads from the consolidated Fabric tables. This is the recommended enterprise architecture for large, multi-source implementations.
Customer Insights writes to Fabric: Unified customer profiles, segments, and prediction scores can be exported to a Fabric lakehouse. Data science teams can then use Fabric notebooks to build custom ML models on top of Customer Insights unified profiles. Power BI reports connect to Fabric for advanced analytics combining Customer Insights data with other enterprise data.
OneLake integration: Microsoft's OneLake (Fabric's unified data lake) is a single storage layer for all Microsoft data. Customer Insights data stored in OneLake can be accessed by any Fabric workload without duplication.
Customer Insights reads from Fabric: Customer Insights - Data connects natively to Microsoft Fabric lakehouses and warehouses as data sources. Instead of configuring individual Power Query connections for each source system, the data engineering team builds a Fabric lakehouse that consolidates all source data. Customer Insights reads from the consolidated Fabric tables. This is the recommended enterprise architecture for large, multi-source implementations.
Customer Insights writes to Fabric: Unified customer profiles, segments, and prediction scores can be exported to a Fabric lakehouse. Data science teams can then use Fabric notebooks to build custom ML models on top of Customer Insights unified profiles. Power BI reports connect to Fabric for advanced analytics combining Customer Insights data with other enterprise data.
OneLake integration: Microsoft's OneLake (Fabric's unified data lake) is a single storage layer for all Microsoft data. Customer Insights data stored in OneLake can be accessed by any Fabric workload without duplication.
💡 Pro Tip: For large enterprise clients with complex data ecosystems, the Fabric-first architecture is the strategic recommendation: Fabric ingests and consolidates all source data, Customer Insights reads from Fabric for CDP capabilities, Power BI reads from Fabric for analytics. This avoids building 15 separate Power Query connections in Customer Insights and gives the data team full control over the data pipeline.
Email deliverability — whether emails actually reach the inbox vs. landing in spam — is one of the most critical operational concerns in any email marketing implementation. Poor deliverability undermines all marketing investment.
Technical deliverability requirements: SPF record: Authorises Customer Insights' sending servers to send on behalf of your domain. DKIM signature: Cryptographically signs each email — proves it genuinely came from your domain. DMARC policy: Instructs receiving servers on what to do with emails that fail SPF/DKIM (quarantine or reject). All three must be configured in your DNS before going live. DMARC rejection policy (p=reject) is the highest level of protection — recommended for production.
Domain warm-up: New sending domains need a warm-up period (4-8 weeks) — gradually increasing daily send volume to build sender reputation with major ISPs (Gmail, Yahoo, Outlook).
List hygiene: Never send to purchased lists. Remove hard bounces immediately (a hard bounce means the email address does not exist). Remove soft bounces after 3 consecutive failures. Suppress contacts who have not opened in 12+ months (re-engagement campaign first, then suppress non-responders).
Spam complaint rate: Keep below 0.1% (Gmail's threshold for deliverability impact). Above 0.3% will cause Gmail to block all emails from your domain.
Technical deliverability requirements: SPF record: Authorises Customer Insights' sending servers to send on behalf of your domain. DKIM signature: Cryptographically signs each email — proves it genuinely came from your domain. DMARC policy: Instructs receiving servers on what to do with emails that fail SPF/DKIM (quarantine or reject). All three must be configured in your DNS before going live. DMARC rejection policy (p=reject) is the highest level of protection — recommended for production.
Domain warm-up: New sending domains need a warm-up period (4-8 weeks) — gradually increasing daily send volume to build sender reputation with major ISPs (Gmail, Yahoo, Outlook).
List hygiene: Never send to purchased lists. Remove hard bounces immediately (a hard bounce means the email address does not exist). Remove soft bounces after 3 consecutive failures. Suppress contacts who have not opened in 12+ months (re-engagement campaign first, then suppress non-responders).
Spam complaint rate: Keep below 0.1% (Gmail's threshold for deliverability impact). Above 0.3% will cause Gmail to block all emails from your domain.
💡 Pro Tip: Set up Google Postmaster Tools and Microsoft SNDS (Smart Network Data Services) monitoring before go-live. These free tools show your domain reputation score, spam complaint rate, and delivery rate at Gmail and Outlook — the two largest email providers. Monitor weekly. A declining reputation score is an early warning to investigate before a full deliverability crisis occurs.
Industry email performance benchmarks help set realistic targets in requirements and evaluate the impact of Customer Insights - Journeys post-implementation:
Average email performance benchmarks (2024, global): Open rate: 20-25% average across industries. Click rate: 2-3% average. Click-to-Open Rate (CTOR): 10-12% average. Unsubscribe rate: 0.1-0.2% (above 0.5% = concerning).
Industry-specific benchmarks: Retail/eCommerce: Open 18-22%, Click 2-3%, Abandoned cart email open 40-50%. Financial Services: Open 24-28%, Click 2-3% (regulated content reduces engagement). Healthcare: Open 22-25%, Click 2-3% (appointment reminders open at 35-45%). B2B Technology: Open 25-30%, Click 3-5% (targeted lists with relevant content).
Transactional vs commercial emails: Order confirmation: Open 60-70% (customers want to see it). Password reset: Open 50-60%. Welcome email: Open 40-50% (highest commercial open rate — send immediately after signup). Promotional email: Open 15-20%.
Average email performance benchmarks (2024, global): Open rate: 20-25% average across industries. Click rate: 2-3% average. Click-to-Open Rate (CTOR): 10-12% average. Unsubscribe rate: 0.1-0.2% (above 0.5% = concerning).
Industry-specific benchmarks: Retail/eCommerce: Open 18-22%, Click 2-3%, Abandoned cart email open 40-50%. Financial Services: Open 24-28%, Click 2-3% (regulated content reduces engagement). Healthcare: Open 22-25%, Click 2-3% (appointment reminders open at 35-45%). B2B Technology: Open 25-30%, Click 3-5% (targeted lists with relevant content).
Transactional vs commercial emails: Order confirmation: Open 60-70% (customers want to see it). Password reset: Open 50-60%. Welcome email: Open 40-50% (highest commercial open rate — send immediately after signup). Promotional email: Open 15-20%.
💡 Pro Tip: Always present benchmarks as context, not targets. A client achieving 15% open rates vs. a 22% industry benchmark has a gap to close — but first investigate why: poor subject lines? Wrong send time? Unclean list? Weak personalisation? The benchmark identifies a problem to investigate, not a number to chase blindly.
A realistic implementation timeline for a combined Customer Insights - Data + Journeys project, based on industry-standard project experience:
Phase 1 — Discovery and Design (Weeks 1-3): Data source inventory and quality assessment. Use case prioritisation. Solution architecture design. Consent and compliance framework design. Journey requirements workshops. Email template design brief.
Phase 2 — Customer Insights - Data (Weeks 4-14): Environment provisioning. Data source connections (2-3 weeks for complex sources). Unification rule design and configuration (1-2 weeks). Golden record testing and tuning (1 week). Measures and segment creation (1 week). Prediction model configuration and validation (1-2 weeks).
Phase 3 — Customer Insights - Journeys (Weeks 8-18, overlapping with Phase 2): Email template development (2-3 weeks). Consent model and subscription centre setup (1 week). Domain authentication and warm-up initiation (weeks 8-12). Journey 1 (Welcome Series) build and test (1-2 weeks). Journey 2-4 build and test (2-3 weeks). UAT with marketing team (1-2 weeks).
Phase 4 — Go-live and optimisation (Weeks 18-22): Production deployment. Domain warm-up completion. Monitoring: deliverability, journey performance, segment accuracy.
Phase 1 — Discovery and Design (Weeks 1-3): Data source inventory and quality assessment. Use case prioritisation. Solution architecture design. Consent and compliance framework design. Journey requirements workshops. Email template design brief.
Phase 2 — Customer Insights - Data (Weeks 4-14): Environment provisioning. Data source connections (2-3 weeks for complex sources). Unification rule design and configuration (1-2 weeks). Golden record testing and tuning (1 week). Measures and segment creation (1 week). Prediction model configuration and validation (1-2 weeks).
Phase 3 — Customer Insights - Journeys (Weeks 8-18, overlapping with Phase 2): Email template development (2-3 weeks). Consent model and subscription centre setup (1 week). Domain authentication and warm-up initiation (weeks 8-12). Journey 1 (Welcome Series) build and test (1-2 weeks). Journey 2-4 build and test (2-3 weeks). UAT with marketing team (1-2 weeks).
Phase 4 — Go-live and optimisation (Weeks 18-22): Production deployment. Domain warm-up completion. Monitoring: deliverability, journey performance, segment accuracy.
💡 Pro Tip: The most common timeline mistake: underestimating data source connection time. Connecting a single SAP source can take 2-4 weeks (data extract design, field mapping, quality validation). Connecting 8 sources takes proportionally longer. Start source connections as early as possible — they are almost always on the critical path.
The discovery workshop sets the foundation for the entire Customer Insights implementation. The right questions reveal the true business requirements behind the technology investment:
Data questions: "Where does your customer data live today — which systems hold which data about your customers?" "When you think about a customer, what information do you wish you had but cannot currently see in one place?" "What is your current duplicate customer rate — do you have the same person in multiple systems?"
Use case questions: "What is the single marketing campaign you would run first if you had a 360-degree customer view today?" "Which customers are you losing that you should be retaining — and what does that churn cost you annually?" "Are there customer segments you know exist but cannot reach because the data is in different systems?"
Activation questions: "What do your marketing team, sales team, and service team each need from customer data that they cannot get today?" "Do you currently use LinkedIn/Google/Facebook for paid advertising — and do you ever accidentally advertise to your existing customers?"
Compliance questions: "Which countries do you market to? Have you had any GDPR data requests?" "Do you have a consent management process today — and how is it enforced?"
Data questions: "Where does your customer data live today — which systems hold which data about your customers?" "When you think about a customer, what information do you wish you had but cannot currently see in one place?" "What is your current duplicate customer rate — do you have the same person in multiple systems?"
Use case questions: "What is the single marketing campaign you would run first if you had a 360-degree customer view today?" "Which customers are you losing that you should be retaining — and what does that churn cost you annually?" "Are there customer segments you know exist but cannot reach because the data is in different systems?"
Activation questions: "What do your marketing team, sales team, and service team each need from customer data that they cannot get today?" "Do you currently use LinkedIn/Google/Facebook for paid advertising — and do you ever accidentally advertise to your existing customers?"
Compliance questions: "Which countries do you market to? Have you had any GDPR data requests?" "Do you have a consent management process today — and how is it enforced?"
💡 Pro Tip: The most powerful discovery question is: "Which customers are you losing that you should be retaining — and what does that cost annually?" This question forces a quantification of the churn problem which becomes the business case for the entire Customer Insights investment. If the answer is "we lose 15% of High Value customers per year and each is worth Rs.50,000 — that is Rs.75 lakh/year in lost revenue", suddenly the CDP investment is justified in the first 10 minutes of the workshop.
Page 1 of 8