We have pulled out email history from _Open Data View.
However, for most records - TriggererSendDefinitionObjectID is empty.
To understand which email was opened, we had no choice - but match on JobIDs from the _Job DataView. So we started by querying _Job into a DataExtension, for intermediate results.
select JobID, EmailID, EmailName, EmailSubject, DeliveredTime from _Job
When we manually search a specific JobID which exists in _Open, many are missing from _Job.
What does this mean? What are we missing? Also, is the fact that most TriggererSendDefinitionObjectID are missing is because List Sends / Manual sends don't get this populated?
Thanks in advance for your help!