MENU
A customer wants a list of subscribers who were sent an email within the past 12 months.
How shouldthis request be completed?
Suggested Answer: C
Get Premium MCE-Dev-201 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
To get a list of subscribers who were sent an email within the past 12 months, you should query the Job and Sent data views. These data views contain detailed information about email sends and can be used to filter subscribers based on the send date.
SQL Query Example:
SELECT s.SubscriberKey FROM _Sent s JOIN _Job j ON s.JobID = j.JobID WHERE j.SendDate >= DATEADD(month, -12, GETDATE())
: Salesforce Data Views
31 comments · newest first
LA
Lacey
4 months ago
C gives precise results quickly.
RE
Rene
5 months ago
D is too manual for large lists.
XO
Xochitl
6 months ago
A seems too complicated.
WI
Winfred
6 months ago
I prefer B. SOAP API is efficient.
NI
Nickole
6 months ago
It directly queries the data views.
LA
Latricia
6 months ago
Why C?
NI
Nickole
6 months ago
I think option C is the best.
JI
Jina
6 months ago
Isn't there a simpler way to get this info?
DO
Dorathy
7 months ago
Definitely agree with C, it's straightforward!
HA
Hana
7 months ago
Wait, why would you use 565 days? That seems off.
EL
Elmira
7 months ago
I think D could work too, but it's not as efficient.
MA
Marvel
7 months ago
Option C is the best choice for this.
ED
Eden
7 months ago
D) Tracking tab, all the way! Less work, more results.
MI
Mirta
8 months ago
Hmm, I'd go with C. Who wants to deal with SOAP APIs these days?
RY
Ryann
8 months ago
A) Creating a measure with the criteria is a bit convoluted, don't you think?
TE
Tequila
8 months ago
D) Locating the email sends in the Tracking tab is the easiest way to get this done.
LA
Lashon
9 months ago
B) Running a tracking extract via the SOAP API would give me the most detailed information.
KI
Kirk
9 months ago
Running a tracking extract via the SOAP API seems like a valid approach, but I feel like it might be more complex than necessary.
LO
Louvenia
9 months ago
I remember we discussed using the Tracking tab in Email Studio, but I can't recall if it gives a complete list like this.
JO
Josephine
9 months ago
I'm leaning towards option C as well. Querying the data views feels like the most reliable and efficient approach for this type of request.
RE
Reyes
9 months ago
The Tracking tab in Email Studio could work, but I'm not sure how scalable that would be for a large subscriber base. I think the database query route is the way to go here.
HA
Haley
9 months ago
Option A with the measure calculation seems a bit convoluted. I'd probably try to avoid that if possible and stick to a more direct database query.
CL
Clarinda
10 months ago
Hmm, I'm not sure about this one. I'd have to double-check the documentation to see if the SOAP API option is viable. Might be worth exploring that as well.
EL
Elizabeth
10 months ago
I think I'd go with option C. Querying the Job and Sent data views seems like the most straightforward way to get the subscriber list.
RA
Raul
10 months ago
I'm not sure about the exact days, but isn't 565 days a bit too much for just 12 months?
CY
Cyndy
10 months ago
C) Query against the Job and Sent data views seems like the most straightforward approach.
DO
Donette
3 months ago
A seems complicated, I’d stick with C too.
AN
Annelle
3 months ago
C is definitely easier for quick access.
DI
Diego
4 months ago
Why not B? The API can be useful.
DA
Danica
4 months ago
I agree, C is the best option.
SA
Samira
10 months ago
I think option C sounds familiar, like something we practiced with SQL queries in class.