Export Delivery logs and Tracking logs using a workflow on Adobe Campaign Classic | Community
Skip to main content
thibaultb473199
thibaultb473199
Level 4
July 9, 2019

Export Delivery logs and Tracking logs using a workflow on Adobe Campaign Classic

  • July 9, 2019
  • 1 reply
  • 8674 views

Hello everyone,

Is there an efficient way to export data from the delivery logs and the tracking logs using a workflow with a data extraction ? Let's say I want to have those data everyday running on a scheduler that only take the data the previous day with some parameters such as email, date, etc... I see that on Adobe Standard they use incremental query but I didn't see such good things on how to use it for Adobe Classic. Is there a way to create that workflow ?

What I'm looking for but this one is for Adobe Standard : Exporting logs

Kind regards,

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    kapilKochar
    kapilKochar
    Level 6
    July 11, 2019

    Hi ,

    For Adobe Classic as well you can use incremental query on delivery logs. Alternatively,

    For creating daily report create a technical workflow with

    - Scheduler

    - Query activity with JS in advance tab which take time from global option(Store last run timnig og this worklfow) somthing like below

    vars.currDate=getCurrentDate();

    vars.dfilter=formatDate(getOption('Globalvariable'),'%4Y%2M%2D.%2H%2M%2S')

    - Your Data extraction Logic

    -End activity using below code

    setOption('GlobalVariable',vars.currDate);

    We call this as Delta testing!

    Hope this helps!

    Thanks,

    Kapil

      thibaultb473199
      thibaultb473199Author
      Level 4
      July 11, 2019

      Hello kapscool​ ,

      Thank you very much for those information. When including the JS in the query, I have an error that show this :

      Also, how can I set up my enrichment to pick up my data from recipients starting with a query using the delivery logs or use change dimension ? Do I have to use a link in the enrichment ?

      Kind regards and thanks in advance.

      Y
      Yassine_N
      Level 2
      July 11, 2019

      Hello,

      the Error is due to the null Date.

      this may help you with the enrichment Enriching data

        Terms & ConditionsAccessibility statement

        Loading footer...