Definition
A Calculated Insight in Salesforce Data Cloud is a computed metric or aggregation derived from unified customer profile data. Calculated Insights use SQL-like expressions to create new data points by performing calculations across Data Cloud data model objects, such as computing a customer's lifetime value, average order frequency, or engagement score. These insights can then be used for segmentation, activation, and AI-driven personalization.
Real-World Example
Consider a scenario where the analytics lead at SilverLine Corp is working with Calculated Insight to build a comprehensive view of key business metrics. With Calculated Insight in place, stakeholders across the organization can self-serve their data needs, filtering and drilling down into the numbers without filing requests with the analytics team.
Why Calculated Insight Matters
Calculated Insights are a Salesforce Data Cloud feature for building computed metrics from unified customer profile data. They use SQL-like expressions to aggregate, filter, and calculate across Data Cloud data model objects, producing derived data points that can be used for segmentation, activation, and AI personalization. Unlike static fields, Calculated Insights re-compute as the underlying data changes, so they always reflect the current state of the customer.
Common Calculated Insights include customer lifetime value (sum of all purchase amounts), average order value, purchase frequency, engagement score (weighted combination of interactions), days since last purchase, and churn risk indicators. Once built, these insights become first-class attributes on the unified profile and can drive segmentation in Data Cloud Segments, activate audiences into ad channels, or ground AI responses in Agentforce. The value of Calculated Insights grows with the maturity of the Data Cloud implementation; early-stage deployments often start with a handful of simple ones and build from there.
How Organizations Use Calculated Insight
- •SilverLine Corp — Built a Customer Lifetime Value Calculated Insight that sums all purchase amounts across every channel for each unified customer profile. The metric now drives their VIP segmentation and is used for both targeting and suppression in marketing campaigns.
- •Horizon Marketing — Created a Churn Risk Calculated Insight that combines days-since-last-purchase, recent support ticket count, and engagement score into a single 0-100 risk value. Customers scoring above 70 are pulled into a retention campaign automatically.
- •Vertex Global — Uses Calculated Insights as the foundation for their personalization strategy. Every customer has dozens of computed attributes that inform which offers they see, which emails they receive, and how their Agentforce agent responds to them.