Expand my Community achievements bar.

Join us for the Adobe Campaign Community Q&A Coffee Break on 30th September at 8 am PT with Campaign experts Arthur Lacroix and Sandra Hausmann.
SOLVED

Retrieve success percentage for each send while using a continuous Delivery.

Avatar

Level 3

I have a campaign that Runs every hour and send email communication to users. So 24 email send occurs everyday.

We are using a continuous Delivery to send the emails. 

Now we have been asked to create a report  with the success percentage of each send. So there will be 24 rows in the report with each row having success percentage for each send

The report will be generated 12 pm daily will cover the data from the previous day.

 

I kindly request to help me with a possible approach using a continuous delivery

@Denis_Bozonnet

@Manoj_Kumar_ 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @bhaskarc1289447 ,

 

You can run a query on broadLogs table and group by event date. You'll need to use hour formula to get sending hours.

 

Thanks,

David



David Kangni

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @bhaskarc1289447 ,

 

You can run a query on broadLogs table and group by event date. You'll need to use hour formula to get sending hours.

 

Thanks,

David



David Kangni