Question 6

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:
  • Question 7

    A client provides the following two data streams:
    Data Stream 1:

    Question-
    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?
  • Question 8

    An implementation 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?
  • Question 9

    Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?
  • Question 10

    What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?