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

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.

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.

Get Premium Marketing Cloud Intelligence Accredited Professional (AP-215) Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Alita 6 months ago

Option D looks good too. It aligns well with the extraction logic needed.

Casie 6 months ago

I prefer option B. Creating a custom attribute seems more straightforward for visualization.

Berry 6 months ago

I think option A is the best. Mapping to Custom Classification Key makes sense.

Arletta 6 months ago

This question is tricky! I feel like it requires a solid understanding of data mapping.

Gertude 6 months ago

Not sure about that, C seems more straightforward to me.

Sage 6 months ago

I think option B makes the most sense for the data fusion.

Denise 7 months ago

Wait, does the 4-digit number always match? Sounds tricky.

Nettie 7 months ago

Totally agree, that's the right way to connect the data!

Izetta 7 months ago

The link is on Message Send Key and web_site_source_key.

Felicidad 7 months ago

Option B looks good, but I think D is the way to go. Gotta love those custom attributes!

Horace 7 months ago

Haha, I bet the client is really hoping we get this right. No pressure, right?

Idella 8 months ago

Hmm, I'm not sure about checking the Override Media Buy Hierarchy checkbox. Seems like it might cause some issues.

Silvana 8 months ago

I agree, the extraction logic should be mapped to a custom attribute.

Jolanda 8 months ago

Option D seems the most logical choice here.

Kris 8 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.

Youlanda 9 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.

Jani 9 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.

Cyndy 9 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.

Linsey 9 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.

Jesus 9 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.

Desirae 10 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.

Gussie 10 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.

Javier 10 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.

Lavera 4 months ago

↳ replying to Javier

I think option A makes the most sense for clarity.

Selene 4 months ago

↳ replying to Javier

Agreed! The mapping logic is key here.

Jolanda 5 months ago

↳ replying to Javier

This is definitely complex! I see the connection points.

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