Team Operations: Team Data Hygiene Scorecard

Prompt: Team Data Hygiene Scorecard

Description: Operational quality check on how well the team keeps Clockwork records complete and current — note frequency, stale candidacies, and missing fields.
Frequency: Monthly
Connectors: Clockwork Recruiting

Prompt: (copy/paste the prompt below into your chat in your LLM)

Build a Team Data Hygiene Scorecard for Clockwork Recruiting.

For each active firm staff member — fetch users via list_reference_data(data_type=users), keep Partner/Recruiter/Researcher/Admin only — across the projects where they're a team member (use get_user_projects(user_id=...) per person, with ?include=client_company), score:

Note recency — % of their active candidacies with a note in the last 14 days

Stage freshness — % of their active candidacies with updated_at in the last 14 days

Stalled candidacies owned — count with no note and no update in 21+ days (filter status.rank < 100)

Project notes cadence — average days between notes per project they own

Combine into a 0–100 hygiene score (note recency 40, stage freshness 30, stalled inverse 20, cadence 10).

Output a leaderboard with project references as <Company> \ <Project>, then a "Coaching Opportunities" section listing the bottom 3 with the specific projects and candidacies dragging their score down.

Adapt It: Add a résumé-attached or comp-captured completeness dimension Scope to one team or one partner's book Raise the bar (7-day windows) for high-touch searches Pair with previous prompts to drill from team scores into per-candidate fixes