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

SOLVED

Adobe Campaign Delivery Reporting

thomash82948276
Level 3
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
RamaRajesh
Correct answer by
Employee
Employee

And finally the report looks like below.

1372778_pastedImage_2.png

View solution in original post

13 Replies
RamaRajesh
Employee
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

thomash82948276
Level 3
Level 3

Thank you Rajesh.

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

Thanks

Tom

RamaRajesh
Employee
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.,

thomash82948276
Level 3
Level 3

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

courtneyd578424
Level 2
Level 2

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

thomash82948276
Level 3
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

noahk68561915
Level 1
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

RamaRajesh
Employee
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

courtneyd578424
Level 2
Level 2

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

RamaRajesh
Employee
Employee

Hi Courtney,

Please find the screens below.

1372735_pastedImage_0.png

1372748_pastedImage_1.png

1372749_pastedImage_2.png

Thanks,

Rajesh

RamaRajesh
Employee
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

RamaRajesh
Correct answer by
Employee
Employee

And finally the report looks like below.

1372778_pastedImage_2.png

View solution in original post