Expand my Community achievements bar.

SOLVED

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

Avatar

Level 5

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,

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

10 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Community Advisor

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

Avatar

Level 5

Hello Jean-Serge,

Thank you so much for that detailed answer. I will work on that asap and hope it will work !

Kind regards,

Avatar

Level 5

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,

Avatar

Level 10

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

Avatar

Level 5

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

Avatar

Level 10

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

Avatar

Level 10

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

Avatar

Level 5

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