Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
thibaultb473199
Level 3

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

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
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

Avatar

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
thibaultb473199
Level 3

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.

Avatar

Avatar
Give Back 3
Employee
pulkit2304
Employee

Likes

48 likes

Total Posts

44 posts

Correct Reply

25 solutions
Top badges earned
Give Back 3
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back 3
Employee
pulkit2304
Employee

Likes

48 likes

Total Posts

44 posts

Correct Reply

25 solutions
Top badges earned
Give Back 3
Give Back
Boost 5
Boost 3
Boost 25
View profile
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

Avatar

Avatar
Boost 5
Level 3
Yassine_N
Level 3

Likes

20 likes

Total Posts

24 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 3
Yassine_N
Level 3

Likes

20 likes

Total Posts

24 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
Yassine_N
Level 3

11-07-2019

Hello,

the Error is due to the null Date.

this may help you with the enrichment Enriching data