Menu

Build a Weekly Lead Quality Dashboard from CRM Data
📰

Build a Weekly Lead Quality Dashboard from CRM Data

DEV Community: beginners·chirag·about 7 hours ago
#oIayNzOF
#devtobeginners#devto#dev#enquiries#reviewed
Reading 0:00
15s threshold

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.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.