Possibility to see the delivery logs and tracking logs through a Web App ? | Community
Skip to main content
thibaultb473199
thibaultb473199
Level 4
May 3, 2019
Solved

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

  • May 3, 2019
  • 10 replies
  • 7614 views

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,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jean-Serge_Biro

    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

    10 replies

    Venu_Reddy
    Venu_Reddy
    Level 6
    May 3, 2019

    Hello,

    Here you go About web applications

    Regards,

    Venu

      Jean-Serge_Biro
      Jean-Serge_BiroAccepted solution
      Level 10
      May 3, 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:

      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
        Community Advisor
        Jonathon_wodnickiCommunity Advisor
        Community Advisor
        May 3, 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
          thibaultb473199Author
          Level 4
          May 6, 2019

          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
            thibaultb473199Author
            Level 4
            May 7, 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 :

            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
              Jean-Serge_Biro
              Level 10
              May 10, 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.

              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
              thibaultb473199Author
              Level 4
              May 10, 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
              Jean-Serge_Biro
              Level 10
              May 10, 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

              Jean-Serge_Biro
              Jean-Serge_Biro
              Level 10
              May 10, 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:

              BR
              JS

              thibaultb473199
              thibaultb473199Author
              Level 4
              May 10, 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

              Terms & ConditionsAccessibility statement

              Loading footer...