Question 5 - Salesforce Marketing Cloud Intelligence Real Exam Questions [April 2026 Update]

Q: 5

A client Ingested the following We into Marketing Cloud Intelligence: Salesforce Marketing Cloud Intelligence question

The mapping of the above file can be seen below: Date — Day Media Buy Key — Media Buy Key Campaign Name — Campaign Name Campaign Group -. Campaign Custom Attribute 01 Clicks —> Clicks Media Cost —> Media Cost Campaign Planned Clicks —> Delivery Custom Metric 01 The client would like to have a "Campaign Planned Clicks" measurement. This measurement should return the "Campaign Planned Clicks" value per Campaign, for example: For Campaign Name 'Campaign AAA", the "Campaign Planned Clicks" should be 2000, rather than 6000 (the total sum by the number of Media Buy keys). In order to create this measurement, the client considered multiple approaches. Please review the different approaches and answer the following question: Salesforce Marketing Cloud Intelligence question

Which two options will yield a false result:

Options

Correct Answer:

B, D

Explanation

The objective is to create a measurement that displays the unique "Campaign Planned Clicks" value for each campaign, effectively de-duplicating the value which is repeated across multiple rows (e.g., Media Buys). For 'Campaign AAA', the desired result is 2000, not the sum of 6000.

Option 5 (SUM) is incorrect because it explicitly aggregates all values for the metric, resulting in 6000 for 'Campaign AAA', which is the problem the client wants to solve.

Option 4 (VLOOKUP) is also incorrect. VLOOKUP is a row-level function. When a row-level formula is used as a measurement in a widget, its results are aggregated. The default aggregation is SUM. Therefore, it will return the value for each row and then sum them, yielding the same false result of 6000.

Why Incorrect

A. Option 2 (MIN): This option yields a correct result. Since the 'Campaign Planned Clicks' value is constant (2000) for all rows of 'Campaign AAA', the minimum value is 2000.

C. Option 3 (MAX): This option yields a correct result. Similar to MIN, since the value is constant (2000) for all rows of 'Campaign AAA', the maximum value is 2000.

E. Option 1 (AVG): This option yields a correct result. The average of a set of identical numbers is the number itself. The average of (2000, 2000, 2000) is 2000.

References

1. Salesforce Official Documentation, Marketing Cloud Intelligence Functions, "SUM": The SUM function is defined as "Returns the sum of a set of numbers." This directly supports why Option 5 produces the undesired total aggregation.

2. Salesforce Official Documentation, Marketing Cloud Intelligence Functions, "VLOOKUP": The VLOOKUP function is described as a row-level function that returns a value from the same row. When a row-level formula is used as a measurement, its results are aggregated based on the dimensions in the widget. The default aggregation is SUM, which explains why this option also produces the incorrect total.

3. Salesforce Official Documentation, Marketing Cloud Intelligence Functions, "MIN", "MAX", "AVG": These functions are defined to return the minimum, maximum, or average of a set of numbers, respectively. In a scenario where the value is constant across all rows for a given dimension (like Campaign Name), all three of these functions will correctly return the de-duplicated value.

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE