Expand my Community achievements bar.

SOLVED

Adobe Campaign Classic V7 Reporting

Avatar

Level 7

Hi!

I am trying to extract the data of Delivery and tracking logs in Adobe Campaign classic V7.

 

Is there way we can select particular date range? Please suggest if any other way to get this data.

 

Thanks,

 

Pradeep

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @pradeep_07 ,

If you are trying to extract data in a workflow, then you can create query condition as below,

For extracting Delivery Logs (broadLog records), you can select broadLogRcp schema as targeting and filtering dimension, and select date range using @eventDate

ParthaSarathy_0-1682488652318.png

 

Above method, We are Hardcoding the date range as from 1st April to 26th April (static date range)

For extracting Tracking Logs, you can select trackingLogRcp schema as targeting and filtering dimension, and select date range using @logDate

Example, @logDate on or after DaysAgo(5)

ParthaSarathy_1-1682488797756.png

 

The above method of using DaysAgo() function will provide last 5 days to previous day record whenever the workflow runs.

And after each query, you can use data extraction activity and can generate a file.

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @pradeep_07 ,

If you are trying to extract data in a workflow, then you can create query condition as below,

For extracting Delivery Logs (broadLog records), you can select broadLogRcp schema as targeting and filtering dimension, and select date range using @eventDate

ParthaSarathy_0-1682488652318.png

 

Above method, We are Hardcoding the date range as from 1st April to 26th April (static date range)

For extracting Tracking Logs, you can select trackingLogRcp schema as targeting and filtering dimension, and select date range using @logDate

Example, @logDate on or after DaysAgo(5)

ParthaSarathy_1-1682488797756.png

 

The above method of using DaysAgo() function will provide last 5 days to previous day record whenever the workflow runs.

And after each query, you can use data extraction activity and can generate a file.

 

 

Avatar

Level 1

Hello,

 

Some points to be added in this :

1) If recurring delivery using in Campaign so use contact date.

2) If Continue delivery using in Automation so use Event date.