Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

A client has provided you with sample files of their data from the following data sources:1.Google Analytics2.Salesforce Marketing CloudThe link between these sources is on the following two fields:Message Send KeyA portion of: web_site_source_keyBelow 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 digitnumber, which matches the 'Message Send Key' values from the Salesforce Marketing Cloud file. Possible examples of this can be seen in thefollowing 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?
A) Within 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.
B) Create 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.
C) Upload the two files and create a Parent-Child relationship between them. The Override Media Buy Hierarchy checkbox is checked in Google Analytics.
D) Create 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.

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?

Show Suggested Answer Hide 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%

Off

Get Premium Marketing Cloud Intelligence Accredited Professional (AP-215) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Alita
29 days ago
Option D looks good too. It aligns well with the extraction logic needed.
upvoted 0 times
...
Casie
1 month ago
I prefer option B. Creating a custom attribute seems more straightforward for visualization.
upvoted 0 times
...
Berry
1 month ago
I think option A is the best. Mapping to Custom Classification Key makes sense.
upvoted 0 times
...
Arletta
2 months ago
This question is tricky! I feel like it requires a solid understanding of data mapping.
upvoted 0 times
...
Gertude
2 months ago
Not sure about that, C seems more straightforward to me.
upvoted 0 times
...
Sage
2 months ago
I think option B makes the most sense for the data fusion.
upvoted 0 times
...
Denise
2 months ago
Wait, does the 4-digit number always match? Sounds tricky.
upvoted 0 times
...
Nettie
2 months ago
Totally agree, that's the right way to connect the data!
upvoted 0 times
...
Izetta
2 months ago
The link is on Message Send Key and web_site_source_key.
upvoted 0 times
...
Felicidad
3 months ago
Option B looks good, but I think D is the way to go. Gotta love those custom attributes!
upvoted 0 times
...
Horace
3 months ago
Haha, I bet the client is really hoping we get this right. No pressure, right?
upvoted 0 times
...
Idella
3 months ago
Hmm, I'm not sure about checking the Override Media Buy Hierarchy checkbox. Seems like it might cause some issues.
upvoted 0 times
...
Silvana
4 months ago
I agree, the extraction logic should be mapped to a custom attribute.
upvoted 0 times
...
Jolanda
4 months ago
Option D seems the most logical choice here.
upvoted 0 times
...
Kris
4 months ago
I feel like option A could work, but I’m not sure if mapping the entire Message Key is necessary. We might need to check the requirements again.
upvoted 0 times
...
Youlanda
4 months ago
I’m a bit confused about the extraction logic part. I think it involves regex, but I can’t recall the exact steps we practiced.
upvoted 0 times
...
Jani
4 months ago
This question feels similar to one we practiced where we had to link different data sources. I think using a custom attribute might be the way to go.
upvoted 0 times
...
Cyndy
4 months ago
I remember we discussed how to map fields in Datorama, but I'm not entirely sure which option is best for this scenario.
upvoted 0 times
...
Linsey
5 months ago
Ah, I see the connection now. The 4-digit number in the web_site_source_key needs to be matched to the Message Send Key. Option D looks like the best way to achieve that. Time to double-check my work before submitting.
upvoted 0 times
...
Jesus
5 months ago
This is a good test of my data integration skills. I'm going to carefully review the data sources and the expected output to make sure I fully understand the requirements before selecting an answer.
upvoted 0 times
...
Desirae
5 months ago
Okay, I see what they're asking for. I think option D is the right approach - create a custom attribute to hold the extraction logic and then fuse that with the Message Send Key. Seems straightforward enough.
upvoted 0 times
...
Gussie
5 months ago
Hmm, the key is matching the 4-digit number from the web_site_source_key to the Message Send Key. I think option D might be the way to go, but I'll double-check the other choices just to be sure.
upvoted 0 times
...
Javier
5 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
Jolanda
24 days ago
This is definitely complex! I see the connection points.
upvoted 0 times
...
...

Save Cancel