Highlighted

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

thibaultb473199

09-07-2019

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,

Replies

Highlighted

kapilKochar

MVP

10-07-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

Highlighted

thibaultb473199

10-07-2019

Hello kapscool​ ,

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

o5YdjIFbZM.png

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.

Highlighted

pulkit2304

Employee

11-07-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'

1788997_pastedImage_2.png

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

1789016_pastedImage_7.png

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