Question 31
Choose 2
A developer receives a request for tracking data for alt sends associated with a specific JoblD. The developer needs to see Sends, Opens, Clicks, and Bounces. Which two activities could the developer use?
(Choose 2 answers)
(Choose 2 answers)
Correct answer:
A. Tracking Extract Activity
D. SQL Query Activity
Summary:
To retrieve individual send, open, click, and bounce tracking data tied to a specific JobID in Marketing Cloud, the data must come from the underlying tracking sent data views (_Sent, _Open, _Click, _Bounce). The only two Automation Studio activities that can extract or query this granular tracking data at the JobID level are the Tracking Extract and the SQL Query Activity (targeting a data extension).
Correct Option:
A. Tracking Extract Activity
The Tracking Extract can export Job-level tracking details (Sends, Opens, Clicks, Bounces, Unsubscribes, etc.) for one or more specific JobIDs. When configured with “Job” scope and the desired JobID(s), it generates a _Job.csv file plus the corresponding _Sent.csv, _Open.csv, _Click.csv, and _Bounce.csv files containing subscriber-level records.
D. SQL Query Activity
SQL Query Activities can directly query the tracking data views (_Sent, _Open, _Click, _Bounce) using a WHERE JobID = XXXXX condition. This is the most common and flexible method developers use to pull send, open, click, and bounce data for a specific JobID into a data extension for reporting or further processing.
Incorrect Option:
B. Server-Side JavaScript Activity
Server-Side JavaScript cannot directly access the tracking data views or perform a tracking extract. It can only call limited WSProxy or Core functions and is not designed for bulk tracking exports.
C. Campaign Data Extract
Campaign Data Extract is part of the legacy Automation Studio “Data Extract” activity and is limited to campaign-level summaries. It does not provide individual tracking events tied to a specific JobID.
Reference:
Salesforce Official Documentation: Data Encryption at Rest
To retrieve individual send, open, click, and bounce tracking data tied to a specific JobID in Marketing Cloud, the data must come from the underlying tracking sent data views (_Sent, _Open, _Click, _Bounce). The only two Automation Studio activities that can extract or query this granular tracking data at the JobID level are the Tracking Extract and the SQL Query Activity (targeting a data extension).
Correct Option:
A. Tracking Extract Activity
The Tracking Extract can export Job-level tracking details (Sends, Opens, Clicks, Bounces, Unsubscribes, etc.) for one or more specific JobIDs. When configured with “Job” scope and the desired JobID(s), it generates a _Job.csv file plus the corresponding _Sent.csv, _Open.csv, _Click.csv, and _Bounce.csv files containing subscriber-level records.
D. SQL Query Activity
SQL Query Activities can directly query the tracking data views (_Sent, _Open, _Click, _Bounce) using a WHERE JobID = XXXXX condition. This is the most common and flexible method developers use to pull send, open, click, and bounce data for a specific JobID into a data extension for reporting or further processing.
Incorrect Option:
B. Server-Side JavaScript Activity
Server-Side JavaScript cannot directly access the tracking data views or perform a tracking extract. It can only call limited WSProxy or Core functions and is not designed for bulk tracking exports.
C. Campaign Data Extract
Campaign Data Extract is part of the legacy Automation Studio “Data Extract” activity and is limited to campaign-level summaries. It does not provide individual tracking events tied to a specific JobID.
Reference:
Salesforce Official Documentation: Data Encryption at Rest
