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
BedrockMission!

Learn More

View all

Sign in to view all badges

Extract customers with last opened date

Avatar

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sqwgglz
Level 2

17-01-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

17-01-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

Answers (2)

Answers (2)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

17-01-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

Avatar

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sqwgglz
Level 2

Likes

15 likes

Total Posts

41 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sqwgglz
Level 2

17-01-2018

Thanks Adhiyan,

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

Thanks

Kevin