Microsoft Dynamics 365 Customer Experience Analyst : Create measures and segments in Customer Insights - Data

In Dynamics 365 Customer Insights – Data, measures and segments play a key role in analyzing and targeting customers effectively. Measures are quantitative metrics that help track and evaluate customer behavior or business performance — for example, total purchases, average order value, or customer lifetime spend. They are calculated using data from unified customer profiles and can be used to monitor trends or feed into predictive models. Segments, on the other hand, are dynamic groups of customers that share common characteristics or behaviors, such as high-value customers, inactive users, or recent buyers. Segments can be built using attributes, interactions, or measures and are refreshed automatically as data changes. Together, measures and segments enable organizations to gain deeper insights, personalize engagement strategies, and drive data-driven decision-making within Customer Insights.

 Overview

In Microsoft Dynamics 365 Customer Insights – Data, two core analytical components help businesses understand their customers better:

• Measures → Numeric insights that summarize customer behavior or performance (e.g., total spend, average order value).
• Segments → Dynamic customer groups created based on shared attributes, behaviors, or engagement levels (e.g., loyal customers, churn-risk customers).

Together, they help organizations personalize marketing, optimize sales efforts, and improve customer experience.

Create Measures in Customer Insights

What is a Measure?

A measure is a calculated numeric value derived from data across your unified customer profiles, transactions, or activities.

It aggregates data, such as sums, counts, or averages, over a defined period.

Steps to Create a Measure

1. Go to the “Measures” tab in Customer Insights – Data.

2. Click “+ New measure.”

3. Choose a data source or entity (e.g., Purchase, Interaction, Account).

4. Define your aggregation logic, such as:

• Sum of total purchase amount
• Average number of transactions per customer
• Count of support tickets raised in the last 90 days

5. Assign a name and description for the measure.

6. Save and run the calculation — Customer Insights computes the measure across all unified profiles.

Examples of Measures

• Total Spend: Sum of all transactions per customer.
• Average Order Value: Average of transaction amounts for a customer.
• Interactions Last Month: Count of email clicks or visits in the past 30 days.

Create Segments in Customer Insights

What is a Segment?

A segment is a dynamic grouping of customers who share certain criteria, such as behavior, demographics, or calculated measures.

Steps to Create a Segment

1. Go to the Segments area in Customer Insights.

2. Click “+ New segment.”

3. Choose Segment Builder or Query Builder mode:

• Segment Builder: Visual drag-and-drop interface.
• Query Builder: Advanced filter-based approach for complex rules.

4. Define your segment criteria, for example:

• Customers with Total Spend > $10,000 (using a measure).
• Customers whose last purchase date is within 30 days.
• Customers in a specific geographic region.

5. Preview the segment results.

6. Save and activate the segment — Customer Insights will automatically update it as data refreshes.

Examples of Segments

High-Value Customers: Total Spend > $10,000.

At-Risk Customers: No purchase in the last 90 days.

 New Subscribers: Joined within the last month.

Upsell Targets: Purchased Product A but not Product B.

4. Business Use Cases and Requirements

A. Marketing Personalization

• Use case: Send personalized email campaigns.
• How: Create a segment like "Customers who purchased in the last 60 days but haven’t repurchased."
• Use this segment in Dynamics 365 Customer Insights – Journeys (Real-Time Marketing) to send targeted re-engagement emails.

B. Sales Enablement

• Use case: Help sales teams focus on high-value leads.
• How: Create a measure for Total Revenue per Account and a segment for Top 10% of customers by revenue.
• Sync this with Dynamics 365 Sales to prioritize outreach.

 C. Customer Retention

• Use case: Detect churn risk early.
• How: Use a measure like Number of Support Tickets or Days Since Last Purchase.
• Build a segment where customers haven’t interacted for a certain period.

D. Service Optimization

• Use case: Identify frequent support users or dissatisfied customers.
• How: Create measures like Average Response Time or Cases per Customer, and segment users who exceed thresholds.

E. Cross-Selling and Upselling

• Use case: Identify customers who can be targeted with complementary offers.
• How: Segment customers who bought a product but not a related one.

5. Where You Can Use Measures and Segments

• In Dynamics 365 Marketing / Customer Insights – Journeys:
• Use segments to define target audiences for campaigns.
• In Dynamics 365 Sales:
• Help sellers identify valuable customers or upsell opportunities.
• In Power BI Reports:
• Visualize measures and segment data for dashboards.
• In Power Automate / Logic Apps:
• Trigger workflows when customers enter or leave a segment (e.g., send a thank-you message).
• In External Systems:
• Export segments via Data Export or connect through Azure Synapse for analytics and modeling.

In Dynamics 365 Customer Insights – Data, measures and segments are powerful tools for understanding and engaging customers more effectively. Measures are calculated numeric values, such as total spend or average order value, that provide insights into customer behavior and business performance. Segments, on the other hand, are dynamic groups of customers who share common attributes or behaviors, such as high-value or at-risk customers.

Creating measures involves selecting data sources, defining aggregation logic, and generating metrics that can be used for analysis or targeting. Segments are built using attributes, interactions, or measures to identify specific customer groups that automatically update as data changes.

In business scenarios, these features enable personalized marketing, targeted sales outreach, customer retention strategies, and service optimization. They can be used across Dynamics 365 Sales, Customer Insights – Journeys, Power BI, and Power Automate to drive data-driven decision-making. In short, measures and segments turn raw data into actionable intelligence for better customer engagement and business growth.