We are having an audit and they want to know:
email, mailing (subject line), date sent, was it opened?, was a link clicked?, did it bounce?, if bounced, bounce reason, did they unsubscribe.
I can see it in statistics but when doing export for a particular statistic, I only get the latest status for link clicked (etc).
I can see what I want in an xml export of one person.
Is there:
- a query I can do?
- How would I do the query?
Failing that, can I export all persons in xml format so I can pull in to my own tables (although that'll be fun too).
I was a senior dba for 7 years so I can handle complex sql statements if I have access to the tables and am given a data dictionary.