Add More Measures to Calculated Insights

Now you can add more measures to your calculated insights to achieve an improved result. The max number of measures per calculated insight has increased from 5 to 20.

View Calculated Insights in Builder

Now it’s easier to review the objects, filters, relationships, and logic that you selected for a Calculated Insight. When you use the Insight Builder to create a Calculated Insight, you can view insight logic in the builder and in SQL.

Where: This change applies to Lightning Experience in all editions.

How: From Customer Data Platform, click Calculated Insights, and then click Show In Builder.

Install or Update Data Kits That Power Standard Data Bundles

Salesforce CRM data bundles are now powered by data kits to enable more scalable delivery and faster innovation for Salesforce CRM data bundles. As a Customer Data Platform Admin, you can install or update data kits that power Salesforce CRM data bundles.

Where: This change applies to Lightning Experience in all editions.

Exploring the Power of Calculated Insights (CI)

Calculated Insights (CIs) in Salesforce Data Cloud enable you to define and compute complex, multidimensional metrics, offering a deeper understanding of your data. These insights help analyze performance across different dimensions—like channel-level activity or customer engagement metrics—empowering your organization to make data-driven decisions.

For example, CIs can rank customers by engagement or spending, evaluate product performance, and uncover trends in purchasing or browsing behavior. Let’s walk through how to use CIs effectively, with examples and reporting guidance.

---

Example 1: Simplifying Metrics with a Single Measure

Consider a CI with one aggregatable metric, such as Lifetime Value (LTV). To report on this CI:

1. Navigate to the Reports tab in your Data Cloud instance.
2. Click New Report and select the Data Cloud category.
3. Search for the desired report type, e.g., LTV, and select Start Report.

When the report opens, all CI dimensions appear as groupings, while measures display as columns in a summary format.

What Happens with CIs Containing More Than Three Dimensions?

Currently, reports support up to three groupings. For CIs with more than three dimensions, the first three are automatically included, though you can replace one dimension with another. Salesforce plans to expand this limit in the future.

For example, a CI with the dimensions brand, customer ID, and product category will default to these three groupings in a summary report.

---

Example 2: Handling Complex Metrics

Now, imagine a CI that includes:

• Three aggregatable metrics: Total Employees, Highest Employee Count, Lowest Employee Count.
• Three non-aggregatable metrics: Rank by Employee Count, Rank by Lowest Revenue Amount, Rank by Highest Revenue Amount.

A measure is non-aggregatable when summing it wouldn’t provide meaningful results. For instance, summing rank values for 10 customers doesn’t make sense; instead, metrics like min or max can be applied.

Reporting for Complex CIs:

By default, reports group CI dimensions and display measures as columns in summary format. However, non-aggregatable measures depend on all dimensions being present. For example, Rank values rely on dimensions like Lead Source and Stage—if one dimension is removed, the related non-aggregatable measures will also be excluded to maintain data integrity.

---

Using Calculated Insights in Real-World Scenarios

Use Case 1: Optimizing Marketing Efforts

Create a report on a CI that ranks web traffic sources and breaks them down by product category.

• Rank acts as a non-aggregatable metric, while Probability is an aggregatable metric.
• This allows marketers to identify high-performing traffic sources and tailor campaigns accordingly.

Use Case 2: Enhancing Patient Engagement

Develop a report on a unified patient profile CI, grouping patients by age group and health score.

• Target patients below the ideal health score with personalized emails, suggesting actionable steps like wellness visits or health screenings tailored to their demographic.

Use Case 3: Identifying High-Performing Channels

Generate a CI report grouped by marketing channels and regions in your Customer Lifetime Value metric.

• Pinpoint the most effective channels for each region and allocate resources to underperforming areas to maximize impact.

---

Visualizing CIs in Reports

You can add charts to your CI reports, adhering to the same restrictions as in Lightning Reports. This visualization capability enables you to uncover trends and share insights effectively.

---

Calculated Insights unlock a powerful layer of reporting in Salesforce, offering flexibility, precision, and actionable intelligence. Whether optimizing marketing efforts, improving patient engagement, or refining customer segmentation, CIs empower teams to make data-driven decisions that drive success.