📋 Summary:
What it calculates: Counts unique Contact IDs (Eids) where RFM (Recency, Frequency, Monetary) status changed within the current defined time period, using the Contact Rfm History table and filtered by RFM Change Date.
How to use it:
• Track customer segment migration and churn dynamics
• Monitor how many customers shift RFM status in a given timeframe
Tip: Ensure date picker is set to capture the exact period you want to analyze customer status transitions, as the calculation depends precisely on the RFM Change Date range.
This summary was generated by AI.
📊 Quick Stats:
🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: γ RFM Status Changes
RFM Status Changes CP
🔢 Formula
m₁
with:
m₁ = Count([Contact Rfm History].[Contact Eid])
WHERE
[Contact Rfm History].[Rfm Change Date] ≥ 'Start of Current Period'
AND [Contact Rfm History].[Rfm Change Date] ≤ 'End of Current Period'
Output Format: #,##0
Formula Last Updated: 2025-03-25T12:20:03Z
ℹ️ Additional Details
Key:
[calculation].[RFM Status Changes CP]ID:
09a96961-12ba-4932-81ff-af4960b757a2
🏷️ Tags
Contact Eid
RFM Status Changes CP
Rfm Change Date