MENU
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)
Suggested Answer: A
Get Premium Marketing Cloud Intelligence Accredited Professional (AP-215) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
26 comments · newest first
RU
Ruthann
8 months ago
I feel unsure about all options. Need to double-check the mappings.
VI
Vivienne
8 months ago
Option D might work too. It has the right references.
AB
Abraham
9 months ago
I’m leaning towards Option A. It matches the criteria well.
SH
Sherrell
9 months ago
I think Option B looks promising. The data alignment seems right.
AI
Aileen
9 months ago
Just a reminder, VLOOKUP needs a sorted range for accurate results!
AN
Annamae
9 months ago
Wait, are we sure about these options? Seems off.
LY
Lynda
9 months ago
Not so sure about B, I lean towards Option D.
NA
Natalya
9 months ago
I’m a bit confused about the mapping; I thought it was supposed to match the campaign IDs, but I can’t recall the exact details.
CA
Carman
10 months ago
I feel like I’ve seen a similar question before, and I think Option D could be the right choice based on the structure.
KY
Kyoko
10 months ago
I think it might be Option B, but I need to double-check how the data aligns with the lookup values.
LU
Luke
10 months ago
I'm going to have to go with Option C, just to be different.
NA
Nada
10 months ago
Haha, this question is a piece of cake! Option B all the way.
DE
Deandrea
10 months ago
Option A seems too simple, I'm going with Option B.
IN
India
10 months ago
I think Option B is the way to go.
RE
Renea
11 months ago
I'm not sure, but I think Option D might be the way to go here.
DE
Delpha
11 months ago
I remember practicing VLOOKUP questions, but I’m not sure which mapping option is correct for this specific data.
MA
Matthew
11 months ago
Definitely agree with that!
RO
Royal
11 months ago
Option B looks like the correct choice to me.
MA
Mattie
11 months ago
I'm a bit unsure about how to approach this question. I'll need to review my VLOOKUP knowledge and really analyze the data and options carefully to make the right choice.
LA
Laurel
12 months ago
This is a good test of my VLOOKUP skills. I'm feeling confident that I can work through this and find the right mapping option to solve the problem.
SH
Shelia
12 months ago
Okay, I think I've got a strategy here. I'll need to identify the key fields in the data streams and match them up with the mapping options to find the one that will give me the expected result.
SA
Samira
1 year ago
The data streams seem straightforward, but I'm a bit confused about how the mapping options relate to the VLOOKUP formula. I'll need to think this through step-by-step.
PE
Pearly
1 year ago
This looks like a tricky VLOOKUP question. I'll need to carefully analyze the data streams and mapping options to determine the best approach.
JE
Jesus
7 months ago
I’m leaning towards Option B. It seems to align well with the data.
AP
Apolonia
7 months ago
Agreed! Mapping is crucial for VLOOKUP to work correctly.
DO
Dominga
8 months ago
This is definitely tricky! I think we need to focus on the key columns.