SalesForce MARKETING-CLOUD-INTELLIGENCE - Questions & Answers
Free preview · every answer includes a full explanation
Product page: https://prepkeys.com/marketing-cloud-intelligence.html
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?
Given the above information, which statement i 's Correct regarding the ability to implement this request?
A client provides the following two data streams:
Data Stream 1:

The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020.
Which mapping options should the client apply to obtain the expected result?

An implementation 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?


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" + Generic Entity Key 2 A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 7th - 11th.
Which option reflects the stage(s) the Opportunity key 123AA01 is associated with?
Which two statements are correct regarding the Parent-Child configuration?
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?
What Is a disadvantage of using a Vlookup formula?
What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?
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:
1. "Day" -- Standard "Day" field
2. "Opportunity Key" > Main Generic Entity Key
3. "Opportunity Stage" -- Main Generic Entity Attribute
4. "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 Interest stage?
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 assume that the file is mapped in the OPPORTUNITIES Data Stream type with the following mapping:
1. "Day" -- "Created Date"
2. "Opportunity Key" + Opportunity Key
3. "Opportunity Stage" -- Opportunity Stage
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?