I am planning on using the
_Open data view in my queries in automation studio, but I am not entirely sure how data gets stored there. I will phrase my question in the following scenario: I sent 2 emails to data extension A containing 2 subscribers.
Subscriber 1 opened email 1 and email 2
Subscriber 2 opened email 1 only
Subscriber 2 is also in data extension B and opened email 5 from DE B after email 1 from DE A.
Would Sub 1 show up only once in the
_Open with all the data coming from last email sent (email 2) i.e. the date, JobID, etc. would be only for email 2?
Sub 2's data would be only for email 5 DE B?
The IsUnique column is for when a subscriber opens the same email more than once or has opened more than one email?
Final question: is there any way to get more than 6 months of open data on a per subscriber basis?
Thanks in advance