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