Question 36
Animplementation engineer has been provided with 4 different source files: 03m 16s
1. Twitter Ads
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:

Creative ID - links back to Creative Key (Twitter Ads)
1st Party Placement Classification &
File structure/headers:

Category - links back to Campaign Category (Twitter Ads)
Which proposed solution meets the client's requirements for the above use case?
1. Twitter Ads
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:

Creative ID - links back to Creative Key (Twitter Ads)
1st Party Placement Classification &
File structure/headers:

Category - links back to Campaign Category (Twitter Ads)
Which proposed solution meets the client's requirements for the above use case?
Question 37
Your client is interested in ingesting the below file:

The client decided to upload the file to a new generic data stream type and map 'Date' to 'Day' and 'Number of Topics' to a generic custom metric.
In regards to the fields 'Meeting Code' and 'Meeting Name', your client is debating several options.
Which two options would you recommend in order to avoid data loss?

The client decided to upload the file to a new generic data stream type and map 'Date' to 'Day' and 'Number of Topics' to a generic custom metric.
In regards to the fields 'Meeting Code' and 'Meeting Name', your client is debating several options.
Which two options would you recommend in order to avoid data loss?
Question 38
Your client provided the following sources:
Source 1:

Source 2:

Source 3:

As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

Which two options will meet the client's requirement and enable the desired view?
Source 1:

Source 2:

Source 3:

As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

Which two options will meet the client's requirement and enable the desired view?
Question 39
Your client would like to create a new harmonization field - Exam Topic.
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client's requirement?
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client's requirement?
Question 40
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?
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?
