Which SQL statement retrieves tracking information for a triggered send by querying the tracking data view?

• A. SELECT * FROM _Open WHERE TriggeredSendCustomerKey = 'External Key of Triggered Send'
• B. SELECT * FROM _Open WHERE TriggeredSendCustomerKey = 'External Key of Triggered Send' AND Status = 'Open'
• C. SELECT * FROM _Click WHERE TriggeredSendCustomerKey = 'External Key of Triggered Send'
• D. SELECT * FROM _Open

Answer: (A)

Open tracking data lives in the _Open data view, which records each recipient open event along with the TriggeredSendCustomerKey that links it to a specific triggered send. By selecting all rows from _Open where TriggeredSendCustomerKey matches the external key of the triggered send, you retrieve exactly the open events for that particular send. Filtering by the triggered send key is the right way to focus the results, rather than pulling all opens or mixing in click data. Using a Status filter isn’t necessary here and may not apply to opens, and querying the _Click view would return click events, not opens, which isn’t what this question asks.