Tracking Comms Cadence Across Manual and Automated Messages

Question

I'm looking to get a sense of the average comms cadence our members typically receive. It’s a bit tricky to assess since our messaging is highly targeted and includes a mix of automated and manual communications. Just wanted to see if anyone else has successfully tackled this—I’d love to hear what’s worked for you!

sydneymack_ · Answer

Thanks for your suggestion, Deepanshu!I was able to figure out an alternative way using Braze Queries as well! The query below analyzes message volume per user for Email, Push, and In-App over the past 30 days. It groups users into buckets based on their message counts relative to percentile thresholds — median (50th), 75th, and 90th percentiles. For each bucket, it summarizes the number of users, as well as the average, minimum, and maximum messages received, and provides a sample of 5 users per bucket per channel. In case this might be helpful for you as well:WITH email AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; EXTERNAL_USER_ID,&nbsp; &nbsp; COUNT(DISTINCT DISPATCH_ID) AS message_count,&nbsp; &nbsp; 'Email' AS channel&nbsp; FROM USERS_MESSAGES_EMAIL_SEND_SHARED&nbsp; WHERE TIME &gt; (DATE_PART(EPOCH_SECOND, CURRENT_TIMESTAMP()) - 2592000)&nbsp; AND EXTERNAL_USER_ID IN ()&nbsp; GROUP BY EXTERNAL_USER_ID),inapp AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; EXTERNAL_USER_ID,&nbsp; &nbsp; COUNT(*) AS message_count,&nbsp; &nbsp; 'In-App Message' AS channel&nbsp; FROM USERS_MESSAGES_INAPPMESSAGE_IMPRESSION_SHARED&nbsp; WHERE TIME &gt; (DATE_PART(EPOCH_SECOND, CURRENT_TIMESTAMP()) - 2592000)&nbsp; AND EXTERNAL_USER_ID IN ()&nbsp; GROUP BY EXTERNAL_USER_ID),push AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; EXTERNAL_USER_ID,&nbsp; &nbsp; COUNT(DISTINCT DISPATCH_ID) AS message_count,&nbsp; &nbsp; 'Push Notification' AS channel&nbsp; FROM USERS_MESSAGES_PUSHNOTIFICATION_SEND_SHARED&nbsp; WHERE TIME &gt; (DATE_PART(EPOCH_SECOND, CURRENT_TIMESTAMP()) - 2592000)&nbsp; AND EXTERNAL_USER_ID IN ()&nbsp; GROUP BY EXTERNAL_USER_ID),all_messages AS (&nbsp; SELECT * FROM email&nbsp; UNION ALL&nbsp; SELECT * FROM inapp&nbsp; UNION ALL&nbsp; SELECT * FROM push),stats AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; channel,&nbsp; &nbsp; PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY message_count) AS median,&nbsp; &nbsp; PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY message_count) AS p75,&nbsp; &nbsp; PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY message_count) AS p90&nbsp; FROM all_messages&nbsp; GROUP BY channel),buckets AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; m.channel,&nbsp; &nbsp; m.EXTERNAL_USER_ID,&nbsp; &nbsp; m.message_count,&nbsp; &nbsp; s.median,&nbsp; &nbsp; s.p75,&nbsp; &nbsp; s.p90,&nbsp; &nbsp; CASE&nbsp;&nbsp; &nbsp; &nbsp; WHEN m.message_count &lt;= s.median THEN 'Up to median'&nbsp; &nbsp; &nbsp; WHEN m.message_count &lt;= s.p75 THEN 'Above median up to 75th percentile'&nbsp; &nbsp; &nbsp; WHEN m.message_count &lt;= s.p90 THEN 'Above 75th percentile up to 90th percentile'&nbsp; &nbsp; &nbsp; ELSE 'Above 90th percentile'&nbsp; &nbsp; END AS bucket&nbsp; FROM all_messages m&nbsp; JOIN stats s ON m.channel = s.channel),bucket_counts AS (&nbsp; SELECT&nbsp;&nbsp; &nbsp; channel,&nbsp; &nbsp; bucket,&nbsp; &nbsp; COUNT(*) AS user_count,&nbsp; &nbsp; AVG(message_count) AS avg_messages,&nbsp; &nbsp; MIN(message_count) AS min_messages,&nbsp; &nbsp; MAX(message_count) AS max_messages&nbsp; FROM buckets&nbsp; GROUP BY channel, bucket)-- Final output: bucket stats + sample users per bucketSELECT&nbsp;&nbsp; b.channel,&nbsp; b.bucket,&nbsp; bc.user_count,&nbsp; bc.avg_messages,&nbsp; bc.min_messages,&nbsp; bc.max_messages,&nbsp; b.EXTERNAL_USER_ID,&nbsp; b.message_countFROM buckets bJOIN bucket_counts bc&nbsp;&nbsp; ON b.channel = bc.channel AND b.bucket = bc.bucketQUALIFY ROW_NUMBER() OVER (PARTITION BY b.channel, b.bucket ORDER BY b.EXTERNAL_USER_ID) &lt;= 5ORDER BY b.channel, b.bucket, b.EXTERNAL_USER_ID;

deepanshup18 · Answer

Hey sydneymack_​ I think you can probably use Tags in Braze dashboard.You can create a parent tag with the name of Campaign_Cadence and then nest the child tags like this :Campaign_Cadence/Automated(Daily, weekly, monthly) or Campaign_Cadence/Manual (one-off)and then you can see the numbers populate against each category in the Tags section in the braze dashboard and maybe use it for analytics or further segmentation purposes.Hope this works :)

allanheofnm · Answer

sydneymack_​ This is a SUPER COOL query solution! Thank you so much for sharing!