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?
An implementation engineer has been asked by a client for assistance with the following problem:
The below dataset was ingested:
However, when performing QA and querying a pivot table with Campaign Category and Clicks, the value for Type’ is 4.
What could be the reason for this discrepancy?
Which two statements are correct regarding the Parent-Child configuration?
TESTED 21 Nov 2024
