MENU
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?
Suggested Answer: A
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
38 comments · newest first
HA
Haydee
11 months ago
Definitely agree with A, it's clear and easy to implement!
CA
Cassandra
11 months ago
D sounds interesting, but I'm not convinced it's the best choice.
SH
Shelia
12 months ago
Wait, are we sure the 4-digit number is always consistent?
BR
Brittani
12 months ago
I think B could work better for flexibility.
DO
Dorothy
1 year ago
Seems like A is the most straightforward option.
JU
Justine
1 year ago
I think we might need to create a Parent-Child relationship, but I’m not clear on whether the Override Media Buy Hierarchy checkbox is necessary for this scenario.
KR
Krystina
1 year ago
I feel like the extraction logic is crucial here, but I’m uncertain if it should go into a custom attribute or directly into the classification key.
MA
Marci
1 year ago
This question seems similar to one we practiced about linking data sources. I think creating a Data Fusion might be the right approach, but I can't recall the exact steps.
IV
Ivan
1 year ago
I remember we discussed how to map keys in Datorama, but I'm not sure if we should use Custom Classification Key or a custom attribute for this case.
LY
Lynelle
1 year ago
This seems straightforward enough. I'd start by creating the custom attribute in Datorama to hold the extracted 4-digit number, then use a data fusion to link it to the 'Message Send Key' from the Salesforce data. Shouldn't be too much trouble as long as I pay close attention to the details.
WI
Willow
1 year ago
Okay, I think I've got it. The client wants us to extract a 4-digit number from the 'web_site_source_key' field in the Google Analytics data, and match that to the 'Message Send Key' in the Salesforce Marketing Cloud data. Then we can visualize the data from both sources in a table. Option D looks like the way to go.
PA
Paris
1 year ago
I'm a little confused by the different data sources and how they're supposed to be connected. Can someone walk me through the logic step-by-step? I want to make sure I understand it before I start trying to implement anything.
LE
Lenita
1 year ago
This looks like a tricky one, but I think I can handle it. The key is to focus on mapping the desired values from each data source to a common custom attribute that can be used to link the data.
DA
Daron
1 year ago
I think the Copy Artifact plugin is the one that allows you to use artifacts from previous builds, but I'm not entirely sure.
RA
Rana
1 year ago
I think all three options are pretty important based on similar practice questions we did. Maybe it's option D?
AR
Arthur
1 year ago
I think I know the answer to this one. The question is asking about scheduling Expressway backups, so I'm guessing the correct answer is C - it's allowed from both the CLI and GUI of the Expressway.
AL
Allene
2 years ago
Option D, no doubt. Gotta love those 4-digit numbers - they're like the secret sauce of data integration!
DO
Donte
2 years 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!
MA
Malcom
2 years 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.
GE
Georgene
2 years ago
I agree, option D seems like the most intuitive approach. It will definitely help visualize the mutual key values effectively.
JA
Jaime
2 years ago
Option D sounds like the best choice. It will help keep the data organized and aligned with the client's objective.
TA
Tammara
2 years 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.
CL
Claudia
2 years ago
Great idea! Let's go with 'Email Marketing Source' for better clarity.
PH
Phyliss
2 years ago
That sounds more fitting for the data sources we're working with.
JU
Juliann
2 years ago
What about naming it 'Email Marketing Source' instead?
CA
Carlton
2 years ago
Option B is a good choice, but I agree, the name could be more descriptive.
BE
Beckie
2 years 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.
QU
Quiana
2 years ago
I'm not sure, I think option B could also work by creating a custom attribute and data fusion.
GL
Glory
2 years 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.
CH
Chau
2 years 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.
CA
Cammy
2 years 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.
KR
Kristel
2 years 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.
MA
Margart
2 years 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.
ST
Stephanie
2 years ago
I agree with Myong, option A seems to be the most logical step to take in this scenario.
MY
Myong
2 years ago
I think option A is the right choice because it involves mapping the key values correctly.
SI
Silvana
2 years 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.
GL
Gladys
2 years 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.
EV
Evan
2 years ago
Option D is definitely the best choice. It simplifies the process and makes the connection clear.