Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.

"messages to sent" by channel and month?

Avatar

Level 4

I need to know how much messages where sent by channel and month. 

Is this possible with a workflow?

Not the quantity of deliveries, but the quantity of "messages to send" that where effectivly sent.

4 Replies

Avatar

Employee

Hi @ogonzalesdiaz ,

 

There are multiple ways of achieving this.

 

Using a workflow, you can query the broadlogRcp schema or the custom delivery log schema (if you created one) and then take the count of messages that were sent. 

Avatar

Level 4

I don't find the field where the amount of "messages to sent" is store... is it in broadLogRcp?

Avatar

Employee

Hi @ogonzalesdiaz ,

 

You can count the number of records in broadLogRcp schema where status is "Sent". This will give the count of messages already sent.

 

You can also look at the delivery indicators like the processed count, success, sent count etc..

 

AnanthanJa_0-1707836593207.png

The above screen shot shows the count of messages processed and success count from the delivery schema.

Avatar

Level 4

@AnanthanJa hi, 

how do you count the records?

Could you provide clear steps since I'm kind of new to ACC?