We are using the following query to get tracking data into a staging data extension. The data we are getting is looking weird - the open and click dates have a timestamp that is earlier than the actual sent date.
Now I'm not sure whether there's a problem in the query, or in the data itself? I think for the Click, it is just pulling the same timestamp for each record, but not sure why the Open results have different values then:
`SELECT s.SubscriberKey, s.TriggererSendDefinitionObjectID, s.JobID, s.BatchID, s.EventDate,j.EmailName, j.DeliveredTime, b.Domain, b.BounceCategory, b.SMTPBounceReason, b.EventDate as BounceDate, o.EventDate as OpenDate, c.EventDate as ClickDate FROM _Sent AS s INNER JOIN _Job as j ON s.JobID = j.JobID INNER JOIN _Click as c ON j.JobID = c.JobID INNER JOIN _Open as o ON c.JobID = o.JobID LEFT JOIN _bounce AS b ON o.JobID = b.JobID`
And a screenshot of the results: