Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 4 Question 44 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence Accredited Professional (AP-215) exam

Question #: 44
Topic #: 4

[All Marketing Cloud Intelligence Accredited Professional (AP-215) Questions]

A client has provided you with sample files of their data from the following data sources:

1.Google Analytics

2.Salesforce Marketing Cloud

The link between these sources is on the following two fields:

Message Send Key

A portion of: web_site_source_key

Below is the logic the client would like to have implemented in Datorama:

For 'web site medium' values containing the word ''email'' (in all of its forms), the section after the ''_'' delimiter in 'web_site_source_key' is a 4 digit

number, which matches the 'Message Send Key' values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in the

following table:

Google Analytics:

Salesforce Marketing Cloud:

The client's objective is to visualize the mutual key values alongside measurements from both files in a table.

In order to achieve this, what steps should be taken?

AWithin both files, map the desired value to Custom Classification Key as follows
Salesforce Marketing Cloud: map entire Message Key to Custom Classification Key.
Google Analytics: map the extraction logic to Custom Classification Key.

BCreate a Web Analytics Site custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.

CUpload the two files and create a Parent-Child relationship between them. The Override Media Buy Hierarchy checkbox is checked in Google Analytics.

DCreate a Web Analytics Site Source custom attribute and populate it with the extraction logic. Create a Data Fusion between the newly created attribute and the Message Send Key.

Show Suggested Answer

Suggested Answer: A

To create a linkage between Google Analytics and Salesforce Marketing Cloud data based on the 'Message Send Key' and a portion of the 'web_site_source_key,' both values need to be harmonized into a common key. This is done by mapping the full Message Send Key from Salesforce Marketing Cloud and the extracted part of the web_site_source_key from Google Analytics to the same Custom Classification Key. This mapping will create a common identifier that can be used to combine the data from both sources for analysis and visualization.

by Melinda at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

2 months ago

This looks like a tricky one. I'll need to carefully read through the details and think through the logic step-by-step.

upvoted 0 times

...