A weekly lead quality dashboard should show accepted enquiries, qualified enquiries, disqualifications and pending reviews by campaign. Pair the qualification rate with its denominator and the amount of work still pending. This makes campaign comparisons easier to interpret.
A manager sees that one campaign has a 75% qualification rate and another has 45%. The first had four reviewed enquiries. The second had twenty. Both figures describe real observations, but they carry different amounts of evidence and may be affected by how quickly sales reviewed each cohort.
Pick one cohort and define each count
Group enquiries by acceptance date in an explicit timezone. Include records accepted during that week and evaluate their current status at a recorded cutoff time. Each enquiry should be counted once, using its stable ID.
For the example below, reviewed enquiries are those with a qualified or disqualified decision. A pending enquiry is still awaiting a decision.…