Workflow requirements in Adobe campaign classic

Hi KD1.

To get you started:

You'll need to start with a scheduled workflow that queries the nms:delivery and nms:deliveryLogStats tables. Specifically, query the nms:delivery and then JOIN between the primary ID and the foreign key of the delivery ID on nms:deliveryLogStats. Scheduling-wise, it's really a matter of preference, but I would say no less than every 15 minutes.

Note: The nms:deliveryLogStats table contains all of this bounce information and could be queried by itself, but to identify the delivery in question, you would have to go purely off the foreign key (the primary key of the delivery in the nms:delivery table), which may not be user-friendly.

From here, it really depends on how you want to alert and the format of your delivery. Are you trying to create a daily report, group all deliveries into a single report, or send out individual alerts? This will change how you are going to segment and group your data in the workflow.

For report formatting, you'll need to include personalizations that pull in the desired info from the tables that I mentioned above into a recurring or continuous delivery activity.

Regards,

Craig