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.

      P
      Adobe Employee
      pulkit2304Adobe Employee
      Adobe Employee
      July 11, 2019

      Hi,

      You will need to follow the steps below

      1. create an Option (Administration > Platform > Options) with a high Date i.e 01/01/1900 (this is done to get full extract the first time you run the workflow. If you do not want this set this time from when you want the extract to begin, say the name of the options is 'broadlogExtractTime'

      2.  In your workflow add the Javascript Activity to initialize the variable and add the following script below:

      vars.endTime = formatDate(getCurrentDate(),'%4Y/%2M/%2D %2H:%2M:%2S');

      vars.startTime = formatDate(getOption('broadlogExtractTime'),'%4Y/%2M/%2D %2H:%2M:%2S');

      3. Add a query Activity after the Initialization JavaSrcipt Code and filter by last modified date like shown below

      To add these variables you will need to use the expression editor in the Query activity and add the expression in the following format

      $datetime(vars/@startTime) and $datetime(vars/@endTime)

      4. Last and the most important step is to update the Option to capture the successful increment of the extract. Add an End activity and in the Advanced tab add the script below:

      setOption('broadlogExtractTime',vars.endTime);

      Congratulation!!! you have set up an incremental extract of the delivery logs.

      Thanks,

      Pulkit

        Terms & ConditionsAccessibility statement

        Loading footer...