Free Preparation Discussions
MENU
Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam - Topic 8 Question 40 Discussion
Topic #: 8
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?
A)
B)
D)
To calculate Cost per Campaign Advertiser using a VLOOKUP formula, the client needs to look up the 'Cost' from Data Stream 2 based on a matching 'Media Buy Name' in Data Stream 1. Option A shows that 'Media Buy Name' is the lookup value, which is correct. The 'Campaign Advertiser' is then linked to the 'Cost' from Data Stream 2 through the VLOOKUP formula applied to the 'Media Buy Custom Attribute 01' in Data Stream 2. This setup will correctly associate the cost with the campaign advertiser.
Vivienne
3 days agoAbraham
8 days agoSherrell
13 days agoAileen
18 days agoAnnamae
23 days agoLynda
29 days agoNatalya
1 month agoCarman
1 month agoKyoko
1 month agoLuke
2 months agoNada
2 months agoDeandrea
2 months agoIndia
2 months agoRenea
2 months agoDelpha
3 months agoMatthew
3 months agoRoyal
3 months agoMattie
3 months agoLaurel
3 months agoShelia
4 months agoSamira
4 months agoPearly
4 months ago