Sales Activity Scoreboard
See who's selling and who's stalling.
What changes when you build this
The gaps you're living with today,
and what this tool fixes.
Problems
- Reps log activities in the CRM, a spreadsheet, and Slack — nobody agrees on actual call volume
- Managers run 1:1s using gut feel because there's no single view of rep activity versus outcomes
- Top performers and underperformers look identical until quota day reveals the gap
- Activity reports take RevOps 2+ hours to pull each week, and they're outdated by the next morning
- No connection between activity volume (calls, emails, meetings) and stage progression
Solutions
- One scoreboard shows every rep's activity count, type breakdown, and trend line in real time
- Managers walk into 1:1s with data — calls made, meetings booked, deals moved — per rep, per week
- Leaderboard ranks reps by weighted activity score so effort and impact are both visible
- Live queries replace weekly report pulls — RevOps saves hours and data is always current
- Activity-to-pipeline linking shows which behaviors actually move deals forward
What the data model looks like
Refine generates this table structure from your
prompt. Edit columns, types, and relationships after.
100%
Mistakes to avoid
These are the failure patterns teams hit most often
when building this.
Counting activities without weightingFix: Assign point values per activity type — a completed demo should score higher than a cold email.
Counting activities without weighting
Fix:Assign point values per activity type — a completed demo should score higher than a cold email.
No link between activities and dealsFix: Join the activities table to opportunities so every activity shows which deal it moved.
No link between activities and deals
Fix:Join the activities table to opportunities so every activity shows which deal it moved.
Leaderboard without contextFix: Show activity score alongside pipeline value and win rate so volume isn't confused with performance.
Leaderboard without context
Fix:Show activity score alongside pipeline value and win rate so volume isn't confused with performance.
Stale activity dataFix: Flag reps with zero logged activities in the past 3 days and surface them in the manager view.
Stale activity data
Fix:Flag reps with zero logged activities in the past 3 days and surface them in the manager view.
One view for every roleFix: Build separate views — reps see their own scorecard, managers see the full leaderboard and trend lines.
One view for every role
Fix:Build separate views — reps see their own scorecard, managers see the full leaderboard and trend lines.