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

How to add delivery date to a report

Avatar

Avatar
Level 1
missys45447057
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
missys45447057
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
missys45447057
Level 1

08-09-2020

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

09-09-2020

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

 

 

Answers (1)

Answers (1)

Avatar

Avatar
Boost 3
Level 1
mbkass
Level 1

Likes

3 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
View profile

Avatar
Boost 3
Level 1
mbkass
Level 1

Likes

3 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Boost 3
Validate 1
Boost 1
View profile
mbkass
Level 1

16-09-2020

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.