A marketing manager wants to import the Not Sent extract into a data extension to leverage as an exclusion audience.
Which steps should be configured within Automation Studio to accomplish this?
Suggested Answer: B
Get Premium Salesforce Certified Marketing Cloud Engagement Specialist (MC-202) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
31 comments · newest first
YU
Yuette
10 months ago
Wait, can you really use Not Sent for exclusions?
SO
Sommer
11 months ago
C seems off, not sure about that one.
MA
Maurine
11 months ago
I think B makes more sense for this.
OL
Oliva
11 months ago
Agreed, A is the best choice here!
CR
Cristal
11 months ago
Definitely A, that's the right order!
OW
Owen
11 months ago
I thought the Tracking Extract was just for pulling data, but now I'm wondering if we actually need to include a File Transfer step before the Import Activity.
CH
Cheryl
12 months ago
I’m leaning towards option A because it seems like the most logical sequence, but I’m a bit confused about the role of SQL Activity in this context.
SU
Suzi
12 months ago
I remember practicing a similar question, and I feel like the Import Activity is crucial, but I can't recall if we need to do a Data Extension Extract afterward.
KR
Krissy
1 year ago
I think the first step should definitely be a Tracking Extract, but I'm not sure if it should go straight to an Import Activity or if we need to do something else first.
DE
Deonna
1 year ago
Ugh, I'm a little confused on the specifics here. Is the File Transfer step necessary, or can we skip that and just go straight from Tracking Extract to Import Activity? I want to make sure I get this right.
MA
Mabel
1 year ago
I've got this! The answer is Tracking Extract, Import Activity, and then SQL Activity. That's the way to get that Not Sent data into a data extension and ready to use. Piece of cake!
NA
Nada
1 year ago
Okay, let me think this through. We need to get the Not Sent extract into a data extension, so we can use it as an exclusion audience. I believe the right steps are Tracking Extract, then Import Activity, and finally a Data Extension Extract to pull it all together.
WI
Winfred
1 year ago
Hmm, I'm a bit unsure about this one. Do we need to do a File Transfer before the Import Activity? I remember something about that from the training, but I can't quite recall the details.
ST
Steffanie
1 year ago
I think the key here is to use the Import Activity to bring the Not Sent extract into a data extension. The steps seem pretty straightforward - Tracking Extract, then Import Activity, and finally a SQL Activity to leverage the data.
NI
Nickie
2 years ago
Option B is the way to go, hands down. It's like the Swiss Army knife of marketing automation - does everything you need, without all the extra fluff.
MA
Marica
1 year ago
Does everything you need, without all the extra fluff.
DE
Deandrea
1 year ago
It's like the Swiss Army knife of marketing automation.
WI
William
1 year ago
Option B is the way to go, hands down.
SA
Sarina
2 years ago
Ah, the age-old question: Tracking Extract, File Transfer, or Import Activity? It's like choosing between chocolate, vanilla, and 'I have no idea what I'm doing.'
DU
Dulce
1 year ago
I usually go with option B for importing the Not Sent extract into a data extension.
FL
Flo
1 year ago
C) Tracking Extract > File Transfer > Import Activity
RO
Rosendo
2 years ago
B) Tracking Extract > Import Activity > Data Extension Extract
TA
Tamie
2 years ago
A) Tracking Extract > Import Activity > SQL Activity
EL
Elza
2 years ago
I'm sorry, but Option C is just too much work. I'd rather just send the Not Sent extract via carrier pigeon and call it a day.
ER
Erin
2 years ago
Option B sounds like the way to go. I mean, who doesn't love a good Data Extension Extract? It's like the guacamole of marketing automation.
LE
Leatha
2 years ago
Yeah, I agree. Data Extension Extract is definitely the way to go for importing the Not Sent extract. It's like the secret sauce for exclusion audiences.
WI
Wilda
2 years ago
Option B sounds like the way to go. I mean, who doesn't love a good Data Extension Extract? It's like the guacamole of marketing automation.
LA
Lauran
2 years ago
A Tracking Extract followed by an Import Activity and a SQL Activity? That's like trying to build a house with a hammer, a screwdriver, and a rolling pin.
LA
Lawanda
2 years ago
I think option C) Tracking Extract > File Transfer > Import Activity makes more sense because we need to transfer the file before importing it into the data extension.
LE
Lera
2 years ago
I disagree, I believe the correct steps are B) Tracking Extract > Import Activity > Data Extension Extract.
DO
Dorcas
2 years ago
I think the correct steps are A) Tracking Extract > Import Activity > SQL Activity.