Extract customers with last opened date | Community
Skip to main content
sqwgglz
sqwgglz
Level 3
Jan 17, 2018 12:57 PM UTC
Solved

Extract customers with last opened date

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Employee
Jan 17, 2018 3:21 PM UTC

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 reply

3 replies

Adhiyan
Adhiyan
Employee
Jan 17, 2018 5:03 PM UTC

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

Translate
sqwgglz
sqwgglzAuthor
Level 3
Jan 17, 2018 4:57 PM UTC

Thanks Adhiyan,

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

Thanks

Kevin

Translate
Adhiyan
AdhiyanAccepted solution
Employee
Jan 17, 2018 3:21 PM UTC

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...