Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now