Expand my Community achievements bar.

SOLVED

Export tracking logs of any email sent on request

Avatar

Level 5

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

Avatar

Correct answer by
Level 10

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

Avatar

Correct answer by
Level 10

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

Avatar

Level 5

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