The following file was uploaded into Marketing Cloud Intelligence as a generic dataset type:
The mapping is as follows:
Day — Day
Web_site_source — Main Generic Entity Attribute 01
Page Views — Generic Metric 1
*Note that ‘web_site_key’ and ‘web_site_name’ are NOT mapped.
How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?
Which two statements are correct regarding LiteConnect?
Animplementation engineer has been provided with 4 different source files: 03m 48s
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 by
File structure/headers:
A)
B)
C)
D)
Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence’s data model?
A client created a new KPI: CPS (Cost per Sign-up).
The new KIP is mapped within the data stream mapping, and is populated with the following logic: (Media Cost) / Sign-ups)
As can be seen in the table below, CPS was created twice and was set with two different aggregations:
From looking at the table, what are the aggregation settings for each one of the newly created KPIs?
A)
B)
C)
D)
A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data
follows a naming convention as shown below:
Facebook Ads Naming Convention - Campaign Name:
Camp|D_CampName#Market_Objective#TargetAge_TargetGender
Twitter Ads Naming Convention - Media Buy Name:
Market|TargetAge|Objective|OrderID
' Google Ads Naming Convention - Media Buy Name:
Buying Type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization ‘Center.
In addition to the previous details, the client provides the following data sample:
Logic specification:
If a value is not present in the Validation List, return “Not Valid”
If a value is not present in the Classification File, return “Unclassified”.
If the Harmonization center is used to harmonize the above data and files, what table will show the final output?
A)
B)
C)
D)
Your client is interested in ingested the below file to a new generic data stream type:
The field ‘Meeting Code’ was mapped to the main entity key. ‘How should the ‘Room Number’ be mapped?
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:
The client suggested to create, without any mapping manipulations, several patterns via the harmonization center that will generate two
Harmonized Dimensions:
Exam ID
Exam Topic
Given the above information, which statement is correct regarding the ability to implement this request with the above suggestion?
Animplementation engineer has been provided with the below dataset:
*Note: CPC = Cost per Click
Formula: Cost / Clicks
Which action should an engineer take to successfully integrate CPC?
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?
A client's data consists of three data streams as follows:
Data Stream A:
A client's data consists of three data streams as follows:
Data Stream A:
The data streams should be linked together through a parent-child relationship.
Out of the three data streams, Data Stream C is considered the source of truth for both the dimensions and measurements.
The client would like to have a "Site Revenue" measurement.
This measurement should return the highest revenue value per Site, for example:
For Site Key ‘SK_C_2’, the "Site Revenue" should be $7.00.
When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites.
For example:
For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys ‘SK_C_1' ($4.00) and ‘SK_C_2’ ($7.00))
Which options will yield the desired result;
A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activityanalysis. Below are details regarding the different data sources and the number of data streams required for each source.
What three advantages are gained when using Patterns & Data Classification as the harmonization method for creating the Objective field?
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?
An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.
For example:
Campaign Name: AFD@Mulop-1290
Desired outcome: AFD
Other examples:
Which formula will return the desired values?
A client has integrated data from Facebook Ads. Twitter ads, and Google ads in marketing Cloud intelligence. For each data source, the source, the data follows a naming convensions as …
Facebook Ads Naming Convention - Campaign Name:
CampID_CampName#Market_Object#object#targetAge_TargetGender
Twitter Ads Naming Convention- Media Buy Name
MarketTargeAgeObjectiveOrderID
Google ads Naming Convention-Media Buy Name:
Buying_type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization Center. Given the above information, which statement is correct regarding the ability to implement this request?
wet Me - Given the above information, which statement i 's Correct regarding the ability to implement this request?
Animplementation engineer is requested to extract the second position
of the Campaign Name values.
The Campaign values consist of multiple delimiter types, as can be
seen in the following example:
Campaign Name: Ad15X2w&Delux_wal90
Desired value: Delux
Which three harmonization methods will achieve the desired outcome?
Your client has provided sample files of their data from the following data sources:
Google Campaign Manager
Below are the requirements from the client and additional information:
* The sources are linked to each other by shared Media Buy names.
* In addition to the mutual Media Buys, the sources contain campaign and site values. However, the client would like to see the campaign/site values coming from Google CM and not from Google DV360.
* The source of truth for cost is Google DV360
Which action(s) are needed to take place in order to meet the client’s requirement and set Google DV360 as the source of truth for Cost?