Salesforce Updated Marketing-Cloud-Intelligence Exam Questions and Answers by santiago

CPC (Cost per Click) is a calculated metric that should be created using a custom measurement based on the formula provided (Cost / Clicks). This calculation does not require a change in the aggregation setting because it is derived from other base metrics that are already aggregated appropriately. In Salesforce Marketing Cloud Intelligence, custom measurements are used to create new metrics from existing data points, and the system will use the underlying data's aggregation to perform the calculation. References: Salesforce Marketing Cloud Intelligence documentation on creating custom measurements and calculated metrics.

Patterns & Data Classification in Marketing Cloud Intelligence offer several advantages. These include:

Ease of Maintenance (A): Patterns allow for the standardization of data harmonization processes. Once set up, they can be easily maintained and adjusted as needed, without having to manipulate each data stream individually.

Performance (B): By using patterns, data is classified and standardized at ingestion, which can improve the performance of dashboard page loading because the system does not need to perform complex, on-the-fly calculations or transformations.

Scalability (D): Patterns can be applied across multiple data streams consistently, allowing them to scale with the data. This means that as the amount of data grows or as new data sources are added, the same patterns can be reused, ensuring that the data remains harmonized.

In Marketing Cloud Intelligence, when linking two data streams, the parent data stream (File A) provides the main structure. Since 'Override Media Buy Hierarchies' is checked for File A, the hierarchies from File B will be aligned with File A. Given 'Data Updates Permissions' set for file B as 'Update Attributes and Hierarchy', this means that attributes and hierarchy will be updated in the parent file based on the child file (File B), but the child file’s metrics won’t be associated with the parent file’s date.

Hence, when filtering on the entire date range (1-30/8), the resulting view will align with the structure of the parent data stream, showing the KPIs (‘Tasks Completed’ from File A and ‘Tasks Assigned’ from File B) alongside the employee names and squads from the respective files. Since the employee IDs align, the data can be linked properly. However, since the dates do not align (File A data is from 01/08/2019 and File B from 15/08/2019), only attributes from File B will be updated without date association.

The result will look like Option C, where the employee names are corrected based on File B's data, the squads are added from File B, and the tasks_completed and tasks_assigned are displayed from their respective files. The tasks_assigned from File B are shown without date association as File B's date doesn't match with File A's.

Option 4 presents two calculated measurements for 'Group Min Cost' with 'MIN' and 'AVG' aggregations. This approach aligns with the client's need for the minimum and average media cost values. 'Group Min Cost 4 MIN' will calculate the minimum media cost across the 'Media Buy Key', while 'Group Min Cost 4 FINAL' will average these minimum costs at the 'Campaign Key' level. This will yield the desired result where minimum costs are calculated at the Media Buy Key level and then averaged at the Campaign Key level.