Salesforce Exam Marketing Cloud Intelligence Topic 3 Question 12 Discussion

Actual exam question for Salesforce's Marketing Cloud Intelligence exam

Question #: 12
Topic #: 3

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

6 months ago

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

upvoted 0 times

...

Donte

6 months 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

Malcom

5 months ago

Yes, option D is the way to go. It will ensure the data is clean and organized, making it easier to create the table the client wants.

upvoted 0 times

...

Georgene

5 months 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

5 months 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

6 months 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

5 months ago

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

upvoted 0 times

...

Phyliss

5 months ago

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

upvoted 0 times

...

Juliann

5 months ago

What about naming it 'Email Marketing Source' instead?

upvoted 0 times

...

Carlton

6 months ago

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

upvoted 0 times

...

Beckie

6 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

6 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

7 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

5 months 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

5 months 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

6 months 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

6 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

7 months ago

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

upvoted 0 times

...

Myong

7 months ago

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

upvoted 0 times

...

Silvana

7 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

6 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

7 months ago

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

upvoted 0 times

...