A technical architect is provided with the logic and Opportunity file shown below:

The opportunity status logic is as follows:

For the opportunity stages “Interest”, “Confirmed Interest” and “Registered”, the status should be “Open”.

For the opportunity stage “Closed”, the opportunity status should be closed Otherwise, return null for the opportunity status.

Given the above file and logic and assuming that the file is mapped in a GENERIC data stream type with the following mapping

“Day” ― Standard “Day” field

“Opportunity Key” > Main Generic Entity Key

“Opportunity Stage” ― Main Generic Entity Attribute

“Opportunity Count” ― Generic Custom Metric

A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 11th.

What is the number of ‘opportunities in the Confirmed Interest stage?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

A client Ingested the following We into Marketing Cloud Intelligence:

The mapping of the above file can be seen below:

Date ― Day

Media Buy Key ― Media Buy Key

Campaign Name ― Campaign Name

Campaign Group -. Campaign Custom Attribute 01

Clicks ―> Clicks

Media Cost ―> Media Cost

Campaign Planned Clicks ―> Delivery Custom Metric 01

The client would like to have a "Campaign Planned Clicks" measurement.

This measurement should return the "Campaign Planned Clicks" value per Campaign, for example: For Campaign Name ‘Campaign AAA", the "Campaign Planned Clicks" should be 2000, rather than 6000 (the total sum by the number of Media Buy keys).

In order to create this measurement, the client considered multiple approaches. Please review the different approaches and answer the following question:

Which two options will yield a false result:

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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;

Reveal Solution Hide Solution

A client has integrated the following files:

File A:

File B:

The client would like to link the two files in order to view the two KPIs (‘Tasks Completed’ and ‘Tasks Assigned) alongside ‘Employee Name’ and/or ‘Squad’.

The client set the following properties:

+ File A is set as the Parent data stream

* Both files were uploaded to a generic data stream type.

* Override Media Buy Hierarchies is checked for file A.

* The ‘Data Updates Permissions’ set for file B is ‘Update Attributes and Hierarchy’.

When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements – what will the result look like?

A)

B)

C)

D)

Reveal Solution Hide Solution

What is the relationship between "Media Buy Key" and "Creative Key?

Reveal Solution Hide Solution

Which three statements accurately describe the different data stream types in Marketing Cloud intelligence?

Reveal Solution Hide Solution

A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing insights and cross-channel marketing activity analysis.

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?

Reveal Solution Hide Solution