How to create custom reports for a specific campaign using cube, workflow, etc.,?

Forum|Forum|8 years ago
September 22, 2017
5 replies
4421 views

Hi Folks,

I'm new to adobe campaign and trying to generate reports in such a way that, if we select a specific campaign, the report should display a table between email domain and status of delivery.

Can anyone help me with this?

	Gmail	yahoo	AoL
Sent
Ignored
Failed

This is how i want a report to be generated.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by vraghav

There is an OOTB report as Adhiyan suggested and it is called as Delivery Statistics. It gives you much more information than you need.

Still if you wish to have a report as the one you want follow these steps.

Go to Tool> Descriptive Analysis...
A popup dialog box will open requesting the type of report to be created. Select the option "New descriptive analysis from a template".
Default filtering dimension is Nms:recipient and for your scenario you will need to change it to nms:broadLogRcp. For doing so, click on Advanced settings...
Change the document type to Recipient Delivery Logs and provide a condition to select the broadLogs of your choice. I'm selecting all broadLogs that belong to deliveries with DM inside their internal name.
Hit Ok to make the changes permanent and then click on Next button.
It shows the settings like so
Click on the Add button to select Recipient Email Domain on the rows side and on the column side select Status from broadLogRcp
Apply Binning. Default is up to 10 domains but you can increase
Proceed clicking Next till a report is generated.
You can save this report for re-use at a later stage.

Regards,
Vipul

Adhiyan

Adobe Employee

Hi Krishna,

Did you check the OOTB reports available in Campaign . I believe there are reports which shows the breakdown of a delivery based on Domains.

Regards,

Adhiyan

vraghav

Accepted solution

Adobe Employee

There is an OOTB report as Adhiyan suggested and it is called as Delivery Statistics. It gives you much more information than you need.

Still if you wish to have a report as the one you want follow these steps.

Go to Tool> Descriptive Analysis...
A popup dialog box will open requesting the type of report to be created. Select the option "New descriptive analysis from a template".
Default filtering dimension is Nms:recipient and for your scenario you will need to change it to nms:broadLogRcp. For doing so, click on Advanced settings...
Change the document type to Recipient Delivery Logs and provide a condition to select the broadLogs of your choice. I'm selecting all broadLogs that belong to deliveries with DM inside their internal name.
Hit Ok to make the changes permanent and then click on Next button.
It shows the settings like so
Click on the Add button to select Recipient Email Domain on the rows side and on the column side select Status from broadLogRcp
Apply Binning. Default is up to 10 domains but you can increase
Proceed clicking Next till a report is generated.
You can save this report for re-use at a later stage.

Regards,
Vipul

K

krishnakanthp76Author

Level 2

Hi Vipul,

I have already tried this approach and was successful in generating and saving the report. My intention is to view this saved report in Reports Universe.

I was able to save a report created using cubes and it is visible in Reports Universe. But when I created using the above mentioned approach, it didn't work.

Please let me know if this is not possible.

Thanks,

Krishna