Comments
-
Are you using the Prospect Email Activities report type to pull in the data? In that table there is an Activity Type field (Open, Send, Click, Bounce, etc) and the Created_At field is the timestamp for that action type. You could filter to Activity Type = Send and use the Created_At field as the effective send date.