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

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

0 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