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

SOLVED

Automate basic email report (v6)

craigf66228339
Level 1
Level 1

Hi all,

New to AC (v6) and have a question on reporting and automating.

I'm looking to create a weekly report (to generate on Mondays), that simply highlights the last 7 days overview of email delivery metrics (i.e opens, clicks, etc etc).

i can't see anywhere where this is possible and I don't want to have to view in 'campaign deliveries' only and have to select each time.

is this possible?

Thanks

1 Accepted Solution
davidl14970702
Correct answer by
Level 5
Level 5

I do the same high level, but I do it monthly. Non of the OOB reports will get at what you want. So two options

1. Run a query for the last 7days and export your data to excel (This is what I do).

     Just run a query on the Delivery table for contact date is on or after 7 days ago.

     then in the add data, add all your columns you want to sum up. I added an image of my query.

2. Build your custom report in the reports section. I added a video on how to get started with that. (Warning this can be complex, why I don't know, but its not as easy as in the video. Creating a Report in Adobe Campaign Classic | )

report.png

View solution in original post

1 Reply
davidl14970702
Correct answer by
Level 5
Level 5

I do the same high level, but I do it monthly. Non of the OOB reports will get at what you want. So two options

1. Run a query for the last 7days and export your data to excel (This is what I do).

     Just run a query on the Delivery table for contact date is on or after 7 days ago.

     then in the add data, add all your columns you want to sum up. I added an image of my query.

2. Build your custom report in the reports section. I added a video on how to get started with that. (Warning this can be complex, why I don't know, but its not as easy as in the video. Creating a Report in Adobe Campaign Classic | )

report.png

View solution in original post