Mobile Commons: Snowflake _ How to get the broadcast recipient from the Snowflake instance

• Mobile Commons
• Read-replica
• Snowflake

Explained how to get the broadcast recipient count from Snowflake

• There is an estimated_recipients_count column in the broadcasts table that indicate the number of profiles expected to receive a scheduled broadcast
• In order to get the number of profiles that received a sent broadcast, you should refer to the broadcast_id in the MTs table, which shows the total number of messages sent for this broadcast.

 NOTE:  if a broadcast contains multiple messages, and you wish to check the count of messages sent for each individual message, you can refer to the message_id in the MTs table.If you refer to the broadcast_id for a broadcast containing multiple messages, the count displayed will reflect only the number of messages sent for the first message in that broadcast.