What are Calculated Insights in Data Cloud and how are they built?

Calculated Insights (CIs) are pre-aggregated metrics computed using ANSI SQL and stored as enrichment attributes on DMOs. They allow complex calculations to be computed once and reused across many segments and activations. Key points:

1. ANSI SQL based — CIs are written as SQL SELECT statements with GROUP BY clauses; they run on Data Cloud's lake-house engine.
2. groupBy segments — CIs can group by Unified Individual ID to produce per-person metrics (e.g., total_spend, avg_order_value, days_since_last_purchase).
3. CI on Unified Individual vs DMO — CIs can target the Unified Individual DMO for person-level scores or other DMOs for object-level aggregates.
4. Refresh — CIs can be refreshed on a schedule or on-demand; output is stored back in Data Cloud as a new attribute available for segmentation and activation.