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

SOLVED

Export tracking logs of any email sent on request

thibaultb473199
Level 4
Level 4

Hello everyone,


Is it possible to have the info of the tracking logs of any email sent on request ?

Can we manage to use an API that would query the tracking logs on a campaign or email in real time ?

If you have recommendation on how to do that with tutorial or have better ideas about the tracking logs, feel free to help me

Have a good day !

Thibault

1 Accepted Solution
Jean-Serge_Biro
Correct answer by
Community Advisor
Community Advisor

Hi Thibault,

The default tracking workflow executes every hour by default.

So it is not strictky speaking "realtime"; but usually, by explaining this usual process to marketing managers, it is enough to make understandable the delay to get hourly refresh statistics.

1716071_pastedImage_0.png

Reminder: the technical nlserver module (server-side) reads the web server httpd logs and saves the result in database (nms:trackinglog entity/table), but up to a threshold; if there are plenty of httpd logs, it could happen that the tracking process inserts the data later in the DB.

Regarding API to reda nms:trackinglog, yes you can use it the usual way, please read the documentation for SOAP API or JSAPI (queryDef method), depending of from where you must get the results and the way you want to proceed.

Regards
J-Serge

View solution in original post

2 Replies
Jean-Serge_Biro
Correct answer by
Community Advisor
Community Advisor

Hi Thibault,

The default tracking workflow executes every hour by default.

So it is not strictky speaking "realtime"; but usually, by explaining this usual process to marketing managers, it is enough to make understandable the delay to get hourly refresh statistics.

1716071_pastedImage_0.png

Reminder: the technical nlserver module (server-side) reads the web server httpd logs and saves the result in database (nms:trackinglog entity/table), but up to a threshold; if there are plenty of httpd logs, it could happen that the tracking process inserts the data later in the DB.

Regarding API to reda nms:trackinglog, yes you can use it the usual way, please read the documentation for SOAP API or JSAPI (queryDef method), depending of from where you must get the results and the way you want to proceed.

Regards
J-Serge

View solution in original post

thibaultb473199
Level 4
Level 4

Hello Jean-Serge Biron​ ,

Thank you for the answer !

And what about this : the possibility to consult the status of the email (sent, in progress, etc) and the tracking log if there is any (open, click or not)
This need is mainly for real times - but if it's possible for all campaigns I'm a taker.

Regards