Expand my Community achievements bar.

SOLVED

Adobe Campaign Delivery Reporting

Avatar

Level 3

I'm looking to create a simple daily overview report showing the following:

Email name

Sent

Open Rate

Click Rate

Unsub Rate

Bounce Rate

No. Spam Complaints

Password Reset

10

50%

10%

0%

0.1%

0

Welcome300025%5%0.4%0.8%2

Which template do I need to use to generate a report with these dimensions and measures.  I can’t find it from the pre-set list.

1 Accepted Solution

Avatar

Correct answer by
Employee

And finally the report looks like below.

1372778_pastedImage_2.png

View solution in original post

13 Replies

Avatar

Employee

Hi,

I have created the below cube and made changes as per your requirement. Please find the below screenshots and I hope, this helps. Please let me know.

1367334_pastedImage_0.png

1367335_pastedImage_1.png

1367336_pastedImage_2.png

Thanks,

Rajesh

Avatar

Level 3

Thank you Rajesh.

Just to confirm, are these possible to build in Campaign?  Or only in Adobe Analytics?

Thanks

Tom

Avatar

Employee

HI,

The cube i have generated and the screens are from Adobe campaign, only. Analytics gives a different level of reports. Example, Cart abandonment etc.,

Avatar

Level 3

Great, thank you.  How can I add in sent date to this report?  Also, how can I filter by date?

Avatar

Level 2

I am interested in knowing the field that would give me data on the number of spam complaints too. Thanks!

Avatar

Level 3

Hello Rajesh, I've since found out that you can only edit Dimensions in Cube Reports in Adobe Campaign if you're also signed up to Adobe Analytics - which we're not.

I need to edit the Dimensions in this pre-loaded Cube in order to get the date to display.

Therefore, this doesn't help me unfortunately. 

I think the User Activities pre-loaded report under Administration > Configuration can give me what I want.  There are just two problems with it though:

- It only shows day, I need date.  Any ideas on how I can add that?

- It tracks Opens, Clicks and Transactions.  I don't need Transactions, I need Volume Sent instead.

Many thanks for your help

Avatar

Level 1

Rajesh - Per our brief conversation over direct message, can you paste in the screenshot you were referencing, which will show how to identify the # of complaints or screamers by email?

Thanks!

Noah

@ramarajeshk90896120

Avatar

Employee

We could certainly pull the # of complaints or screamers by email. Below is the screenshot for reference.

1372165_pastedImage_1.png

1372181_pastedImage_2.png

Avatar

Level 2

Thank you. How can I pull back @screamers in a workflow query?

Avatar

Employee

Hi Courtney,

Please find the screens below.

1372735_pastedImage_0.png

1372748_pastedImage_1.png

1372749_pastedImage_2.png

Thanks,

Rajesh

Avatar

Employee

Hi Thomas,

Please find the below report created out of a workflow.

1372750_pastedImage_0.png

1372766_pastedImage_1.png

1372767_pastedImage_2.png

1372768_pastedImage_3.png

Thanks,

Rajesh

Avatar

Correct answer by
Employee

And finally the report looks like below.

1372778_pastedImage_2.png