Extract customers with last opened date | Community
Skip to main content
sqwgglz
sqwgglz
Level 3
January 17, 2018
Solved

Extract customers with last opened date

  • January 17, 2018
  • 3 replies
  • 1371 views

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.
Best answer by Adhiyan

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

3 replies

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
January 17, 2018

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

    sqwgglz
    sqwgglzAuthor
    Level 3
    January 17, 2018

    Thanks Adhiyan,

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

    Thanks

    Kevin

    Adhiyan
    Adobe Employee
    AdhiyanAdobe Employee
    Adobe Employee
    January 17, 2018

    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

    Terms & ConditionsAccessibility statement

    Loading footer...