📋 Summary:
What it calculates: This measures how many different email campaigns are being sent to each contact on average during the selected time period. It takes the total number of email campaigns sent (where Was Sent = '' and Marketing Channel Type = 'email') and divides by the number of unique contacts who received those campaigns.
Variants:
• CP: Current period average
How to use it:
• Monitor email frequency to ensure you're not overwhelming customers with too many campaigns
• Compare across different time periods to see if your email marketing volume is increasing or decreasing per contact
Tip: A higher number isn't always better - track this alongside engagement metrics to find the sweet spot where you're staying top-of-mind without causing unsubscribes.
This summary was generated by AI.
📊 Quick Stats:
🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: ρ Avg # of Email Campaigns Sent Per Contact
Avg # of Email 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] = 'email'
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] = 'email'
Output Format: #,##0.00
ℹ️ Additional Details
Key:
[calculation].[Avg # of Email Campaigns Sent Per Contact CP ]ID:
ca7effff-f3b6-55e1-8750-431d4481b7e7
🏷️ Tags
Avg # of Email Campaigns Sent Per Contact CP
Contact Eid
Marketing Channel Type
Sent Date
Source Name
Was Sent