Northern Trail Qutfitters wants to be able to calculate each customer's lifetime value {LTV) but also create breakdowns of the revenue sourced by…

The use case requires calculating an aggregate value (Lifetime Value) and also viewing that value broken down by a dimension (channel). This is the primary function of Metrics in Data Cloud's Calculated Insights feature. A consultant can create a metric for LTV and include "Channel" as a dimension. This allows for querying the total LTV for a customer or filtering the LTV by each channel. "Metrics on metrics" further extends this by allowing the creation of a composite metric (total LTV) from other base metrics (e.g., LTV from website, LTV from mobile app).

A. Flow Orchestration is a process automation tool for coordinating multi-step, multi-user workflows, not for performing data aggregation and analytics.

B. Nested segments are used to create audiences based on other audiences, which is a segmentation tool, not a calculation engine for metrics.

D. Streaming data transforms are used for row-by-row data manipulation on ingest, not for complex, post-ingestion aggregations across multiple records like LTV.

1. Salesforce Help, Calculated Insights in Data Cloud, Section: "Metrics on Metrics". This page explains, "A metric on a metric is a calculated insight that uses one or more metrics and dimensions." This directly supports building a total LTV from channel-specific metrics.

2. Salesforce Help, Create a Calculated Insight in Data Cloud, Section: "Metrics". The documentation states, "To create a metric, select a calculation, a measure, and one or more dimensions... Dimensions are used to break down and filter your metric." This perfectly describes the requirement.