Salesforce Exam Marketing-Cloud-Intelligence Topic 3 Question 12 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence Accredited Professional exam

Question #: 12
Topic #: 3

[All Marketing Cloud Intelligence Accredited Professional 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

by Reta at Jul 01, 2024, 09:19 PM

Limited Time Offer

25%

Off

Get Premium Marketing-Cloud-Intelligence Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Allene

20 days ago

Option D, no doubt. Gotta love those 4-digit numbers - they're like the secret sauce of data integration!

upvoted 0 times

...

Donte

21 days ago

I'm going with option D. It's the most intuitive and aligns with the client's objective. Plus, it keeps the data clean and organized. Definitely the way to go!

upvoted 0 times

Georgene

5 days ago

I agree, option D seems like the most intuitive approach. It will definitely help visualize the mutual key values effectively.

upvoted 0 times

...

Jaime

9 days ago

Option D sounds like the best choice. It will help keep the data organized and aligned with the client's objective.

upvoted 0 times

...

Tammara

26 days ago

Option B is a solid choice, but I'm a bit worried about the name 'Web Analytics Site' - it just doesn't seem to fit the use case here. Maybe a more descriptive name would be better.

upvoted 0 times

Claudia

1 days ago

Great idea! Let's go with 'Email Marketing Source' for better clarity.

upvoted 0 times

...

Phyliss

9 days ago

That sounds more fitting for the data sources we're working with.

upvoted 0 times

...

Juliann

13 days ago

What about naming it 'Email Marketing Source' instead?

upvoted 0 times

...

Carlton

20 days ago

Option B is a good choice, but I agree, the name could be more descriptive.

upvoted 0 times

...

Beckie

2 months ago

Hmm, option C is interesting, but I'm not sure about that Override Media Buy Hierarchy checkbox. Feels like it might introduce some unexpected behavior.

upvoted 0 times

...

Quiana

2 months ago

I'm not sure, I think option B could also work by creating a custom attribute and data fusion.

upvoted 0 times

...

Glory

2 months ago

Option A looks good too, but I'm not sure about mapping the entire Message Key to the Custom Classification Key. Seems like we might lose some valuable information that way.

upvoted 0 times

Chau

6 days ago

Yes, that way we can maintain the important information and still achieve the client's objective. Option B seems like the way to go.

upvoted 0 times

...

Cammy

10 days ago

That sounds like a good idea. We can then create a Data Fusion between the new attribute and the Message Send Key for better visualization.

upvoted 0 times

...

Kristel

29 days ago

I agree, we need to be careful with that. Maybe Option B would be a better choice to create a Web Analytics Site custom attribute.

upvoted 0 times

...

Margart

1 months ago

Option A looks good too, but I'm not sure about mapping the entire Message Key to the Custom Classification Key. Seems like we might lose some valuable information that way.

upvoted 0 times

...

Stephanie

2 months ago

I agree with Myong, option A seems to be the most logical step to take in this scenario.

upvoted 0 times

...

Myong

2 months ago

I think option A is the right choice because it involves mapping the key values correctly.

upvoted 0 times

...

Silvana

2 months ago

I think option D is the way to go. Creating a custom attribute for the Web Analytics Site Source and then fusing it with the Message Send Key seems like the most straightforward approach.

upvoted 0 times

Gladys

2 months ago

I agree, creating a custom attribute for the Web Analytics Site Source and fusing it with the Message Send Key is the way to go.

upvoted 0 times

...

Evan

2 months ago

Option D is definitely the best choice. It simplifies the process and makes the connection clear.

upvoted 0 times

...