📋 Summary:

What it calculates: This measures how many text message campaigns each contact receives on average during the current period. It counts the total number of SMS campaigns sent (where Marketing Channel Type = 'sms' and Was Sent = '') and divides by the number of unique contacts who received those messages.

Variants:
• CP: Current period average

How to use it:
• Monitor SMS campaign frequency to ensure you're not over-messaging customers and risking opt-outs
• Compare text messaging volume across different customer segments to optimize engagement strategies

Tip: Track this alongside SMS engagement rates - if the average campaigns per contact increases but engagement drops, you may be sending too frequently.

This summary was generated by AI.

📊 Quick Stats:

🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: ρ Avg # of Text Campaigns Sent Per Contact

Avg # of Text Campaigns Sent Per Contact CP

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Count([Vw Marketing Details].[Source Name])
    WHERE
        [Vw Marketing Details].[Sent Date] ≥ 'Start of Current Period'
        AND [Vw Marketing Details].[Sent Date] ≤ 'End of Current Period'
        AND [Vw Marketing Details].[Was Sent] = true
        AND [Vw Marketing Details].[Marketing Channel Type] = 'sms'
m₂ = Distinct Count([Vw Marketing Details].[Contact Eid])
    WHERE
        [Vw Marketing Details].[Sent Date] ≥ 'Start of Current Period'
        AND [Vw Marketing Details].[Sent Date] ≤ 'End of Current Period'
        AND [Vw Marketing Details].[Was Sent] = true
        AND [Vw Marketing Details].[Marketing Channel Type] = 'sms'

Output Format: #,##0.00

Formula Last Updated: 2026-02-02T20:54:56Z