Customer base report (CRM dashboard)
Customer base report (CRM dashboard): the state of the base. How many customers, new and returning, how much they bring, how they are retained and how they respond to communications. It underpins decisions on retention, segments and the acquisition budget.
Formula
Rows: period, channel, segment | Columns: active customers, new, returning, repeat share, frequency, average check, revenue per customer, LTV, churn, share of customers with mailing consent, campaign response
How to read
How to read: revenue = customers × frequency × average check. Mistakes: counting active customers over different windows, not merging duplicate customers, counting revenue without returns, looking only at totals without cohorts. In your company it may be named differently: check the reference book of your accounting system.