Cost Per Click (CPC) is a ratio metric, calculated by dividing a total Cost by a total number of Clicks. In Marketing Cloud Intelligence, the correct way to handle such metrics is to create a custom measurement with the formula [Cost] / [Clicks]. The platform's engine is designed to first aggregate the component metrics (i.e., SUM(Cost) and SUM(Clicks)) based on the selected dimensions and date range, and only then perform the division. This ensures mathematical accuracy at any level of granularity. Manually setting the aggregation of the CPC metric itself to AVG or SUM would lead to incorrect calculations when data is rolled up. Therefore, the standard practice is to define the logic and leave the aggregation as the default.

B. Unmap it, as Datorama will calculate it automatically.

Marketing Cloud Intelligence does not automatically create standard calculated metrics like CPC. They must be explicitly defined by a user.

C. Populate the logic within a custom measurement. Set Aggregation to AVG.

Averaging pre-calculated ratios (e.g., averaging the CPC of Day 1 and Day 2) is mathematically incorrect and does not yield the true CPC for the combined period.

D. Populate the logic within a custom measurement. Set Aggregation to SUM.

Summing a rate metric like CPC is logically meaningless. For example, adding the CPC from Campaign A to the CPC from Campaign B provides no analytical value.

---

1. Salesforce Trailhead, Data Modeling in Marketing Cloud Intelligence, "Extend Your Data Model with Calculated Dimensions and Measurements" Unit.

This unit explains the principle for ratio metrics: "For example, to calculate click-through rate (CTR), you divide clicks by impressions. If you were to average the daily CTRs to get a weekly CTR, your calculation would be incorrect. Instead, you must sum the total clicks for the week and divide them by the sum of the total impressions for the week. Datorama does this for you automatically when you create a calculated measurement." This confirms that the platform handles the component aggregation (SUM) before the calculation, making options C and D incorrect.

2. Salesforce Help, Marketing Cloud Intelligence, "Create a Calculated Measurement in Marketing Cloud Intelligence".

This document outlines the procedure for creating a calculated measurement. It instructs the user to enter a formula in the "Calculation" section. The documentation on aggregation types (SUM, AVG, MIN, MAX) does not recommend setting AVG or SUM for ratio metrics, as the platform's query-time calculation SUM(Numerator)/SUM(Denominator) is the correct methodology. This supports creating the formula without an explicit, and incorrect, aggregation change.