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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

How to add delivery date to a report

Avatar

Level 1

Hi,

I need to add a "date delivered" to my typical OOB engagement metrics report. I don't want to apply a "date range" I just want to add a field to the excel spreadsheet that has "delivered date" to a regular delivery summary (opens, clicks, unsubs, etc) without having to go through a workflow scenario. Is this possible? and if not, how to do this easily with a workflow. Has anyone had to do this?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Unfortunately in dynamic reporting al you can do is to define a date range.

Though this won't fit your requirements as e.g. a click might be reported on another day than the delivery.

 

Brst guess for such aggregated numbers would indeed be a workflow:

 * Query activity to load the deliveries

 * Extract file to generate a csv file

* Transfer file to upload the file to SFTP/S3

 

 

2 Replies

Avatar

Correct answer by
Employee Advisor

Unfortunately in dynamic reporting al you can do is to define a date range.

Though this won't fit your requirements as e.g. a click might be reported on another day than the delivery.

 

Brst guess for such aggregated numbers would indeed be a workflow:

 * Query activity to load the deliveries

 * Extract file to generate a csv file

* Transfer file to upload the file to SFTP/S3

 

 

Avatar

Level 2

I wish Campaign had delivery date too. In lieu of that, we name all of our campaigns and deliveries by putting year/month/date at the front of the name so you can export out of Campaign into another tools and use the name field to sort by date. But I hear you.