Q: 12
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?
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?Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
