Possibility to see the delivery logs and tracking logs through a Web App ?

Avatar

Avatar

thibaultb473199

Avatar

thibaultb473199

thibaultb473199

03-05-2019

Hello everyone,

Is it possible in Adobe Campaign to create a Web App and check for the delivery logs and the tracking logs when I put any emails from a customer or from a campaign in a label text input ?

Is there any example or tutorials on how to manage that task ?

Do I have to work with a specific Web App, dataSchema, ... ?

Kind regards,

View Entire Topic

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

10-05-2019

Thibault,

Yes, broadlog and tracking logs are huge tables, and the query could last some seconds, but 10 minutes seems abnormal, because email fields are indexed.
For comparison, it takes about 1 minute for me for 14 millions of contacts and broadlogs/trackinglogs purge after 1year and half.

I tried with limiting the result set of the 2 query activities to 100 lines or not limiting at all, the same response time.
(the matter of this limitation treshold would be to reduce RAM memory dedicated to XML context, but in that use case, only one recipient so the volume is quite small).

One optimization may be: find first the recipient.id corresponding to the email entered in the form field, then search the trackinglogs and broadlogs by using the recipient.id.

Best Regards
JS