I'd like to extract a selection of our customers and the date they last opened an email.
How would I find this in the database?
The details about open and their date can be found in nms:trackingLogRcp schema .The @type field under url tells you if it's an Open or click. The date field shows the date the open / click was logged,
Yes that's the one I am referring to. It gets timestamped when an Open is registered , so it's the most accurate time when the open was done
Is the date field you're referring to @logDate under @trackingLog or another one?