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

[thibaultb473199]

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,

[Venu_Reddy]

Hello,

Here you go About web applications

Regards,

Venu

[Jean-Serge_Biro · Accepted solution]

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:

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):

Then define the query activities as is:

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

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

Now the page tables for displaying the results

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

Do the same with trackingLogs:

Hope this helps.

Regards

Jean-Serge

[Jonathon_wodnicki]

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]

Hello Jean-Serge,

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

Kind regards,

[thibaultb473199]

Hello Jean-Serge Biron​

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

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

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

Also, one more question about this part :

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 :

Thank you in advance !

Kind regards,

[Jean-Serge_Biro]

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.

appears as:

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

The same for the Value to this:

appears as:

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

Regards

Jean-Serge

[thibaultb473199]

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]

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

[Jean-Serge_Biro]

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:

BR
JS

[thibaultb473199]

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