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

Delivery Log

SWaghmode
Level 2
Level 2

Hello,

 

I have created workflow having file loading activity.

The file contains delivery status, error message if any.

I want to show these details adobe delivery reports.

How to proceed to achieve this.

I believe I have to insert file data in system tables from which default adobe reports are getting generated.

Please suggest.

1 Accepted Solution
Jyoti_Y
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Reports in Adobe are based on below tables:

1) Delivery

2) Recipient Delivery Log

3) Campaign

4) Recipient Tracking Log

 

Now let's consider if you want to display your data in 'Delivery Throughput' Report, then data which you have should have deliveries linked to campaign and delivery table. It should contain number of processed message, number of sent data, i.e

1) You need to load data using 'Data Loading'

2) reconcile your data with 'campaign' and 'delivery' table. If you do not want mapping of deliveries with Campaign table, do not reconcile with campaign.

3) Perform data insert/update in delivery table.

4) View Reports related to your data.

 

Thanks.

 

View solution in original post

2 Replies
wodnicki
Community Advisor
Community Advisor

Hi,

 

Copy the data into broadLog, then run nms.delivery.RecomputeStats() on the deliveries in the file.

If you have tracking data, copy it into trackingLog+trackingUrl ahead of the call.

 

Thanks,

-Jon

Jyoti_Y
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Reports in Adobe are based on below tables:

1) Delivery

2) Recipient Delivery Log

3) Campaign

4) Recipient Tracking Log

 

Now let's consider if you want to display your data in 'Delivery Throughput' Report, then data which you have should have deliveries linked to campaign and delivery table. It should contain number of processed message, number of sent data, i.e

1) You need to load data using 'Data Loading'

2) reconcile your data with 'campaign' and 'delivery' table. If you do not want mapping of deliveries with Campaign table, do not reconcile with campaign.

3) Perform data insert/update in delivery table.

4) View Reports related to your data.

 

Thanks.

 

View solution in original post