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

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,

Accepted Solutions (1)

Accepted Solutions (1)

Jean-Serge_Biro

MVP

03-05-2019

Hi Thibault,

There are 2 solutions:

  • easy with Page compatibility v5 activity (with the drawback of not enough control on html and css so not to use if Responsive design is mandatory)
  • more complex with Page activity (but needed if sophisticated design of the web page is needed).

Hereinafter, a simple example with Page v5 activity:

1745448_pastedImage_24.png1745447_pastedImage_23.png

In both cases, it is the same principle/same workfklow; there are also such many cases in the factory Reports (which are actually very similar to Page compatibility v5 webApp) if you need inspiration.

Please create this webApp workflow (example taken with Page compatibility v5):

1745426_pastedImage_5.png

Then define the query activities as is:

1745434_pastedImage_13.png

1745435_pastedImage_14.png

you can filter on @address of broadLogRcp, it is the short path instead of recipient.email:

1745437_pastedImage_15.png

Then the same with trackingLog, but you must use recipient.email:

1745439_pastedImage_16.png

1745440_pastedImage_17.png

1745444_pastedImage_18.png

Now the page tables for displaying the results

1745427_pastedImage_6.png

1745428_pastedImage_7.png

1745429_pastedImage_8.png

Insert a table object, and choose the query XML object related in path for broadlogs:

1745430_pastedImage_9.png

Do the same with trackingLogs:

1745431_pastedImage_11.png

1745445_pastedImage_21.png

1745446_pastedImage_22.png

Hope this helps.

Regards

Jean-Serge

Answers (9)

Answers (9)

thibaultb473199

06-05-2019

Hello Jean-Serge Biron

I follow your tutorial and I encounter a strange issue, here is what happened when I input an address email :

nlclient_VdNHwv2xoj.png

The error mention that I'm using a boolean but when looking at my variable, I'm using a text in the screenshot below :

nlclient_3fPw3ApaHZ.png

Is it the correct way to put the variable in the storage like mention in your tutorial ?

Also, one more question about this part :

chrome_RXfvgxjr3L.png

At the step "Valeur" and "Pris en compte si", is it okay if i write down those lines by hands without using any function ? (I'm not good in that part) I have the same result as you but I don't know if Campaign will like if I write those lines by hands.

My expression right now looks like as follow :

nlclient_7BplU7W87m.png

Thank you in advance !

Kind regards,

wodnicki

MVP

03-05-2019

Hi,

Repurpose nms:contactHistory.jssp, pretty much just adding an input field for lookup and changing the authentication and styling as needed. I do this all the time for sfdc and dynamics integrations.

Thanks,

-Jon

thibaultb473199

10-05-2019

Indeed, to make sure the Web App works, i test it on another instance on my own and it works fine after 15-20 seconds.

So my first request is complete and I don't need more information about that. I will talk with the admin on the main instance to see hat he can do about what you just say previously.

Thank you so much for all the explanations and tutorials. I mark your first solution as correct

Have a great day !

Kind regards,

Thibault

Jean-Serge_Biro

MVP

10-05-2019

I confirm, this optimization on query activity on broadlogs is very efficient, by using recipient.email instead of broadlogRcp.address field, it takes only 1 second to display the result:

1750222_pastedImage_0.png

BR
JS

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

thibaultb473199

10-05-2019

Hello Jean-Serge,

I made the modification as follow and I don't get the error anymore but the loading for the information to display is really long and doesn't seem to display them (waiting for a good 10min)

Any idea where this can coming from ?

Kind regards,

Thibault

Jean-Serge_Biro

MVP

10-05-2019

Hi Thibault,

Regarding the Filter parameter screen in Query activity, the problem is that this fields form is quite buggy with special characters management, often it generates bad escaping chars; so the best is to use the Advanced editor to circumvent such issues;

Often with direct type in field, backslash are added.

1750213_pastedImage_0.png

appears as:

1750218_pastedImage_2.png

when line is selected, and appears as this when you are in the field:

1750219_pastedImage_3.png

The same for the Value to this:

1750217_pastedImage_1.png

appears as:

1750220_pastedImage_4.png

Then, it should resolve your issue about boolean type, because I guess Adobe Campaign is misleaded/wrong issue reported.

Regards

Jean-Serge