Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Extract customers with last opened date

Avatar

Level 3

Hi there,

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?

Thanks

Kevin

1 Accepted Solution

Avatar

Correct answer by
Employee

Hello K,

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,

Regards,

Adhiyan

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

Hello K,

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,

Regards,

Adhiyan

Avatar

Level 3

Thanks Adhiyan,

Is the date field you're referring to @logDate under @trackingLog or another one?

Thanks

Kevin

Avatar

Employee

Hello Kevin,

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

Regards,

Adhiyan