Build a prospect data hygiene checklist for a recruiting database

On this page
  1. Start with one owner and one field list
  2. Remove duplicate records before adding new ones
  3. Standardize names, graduation years, and positions
  4. Verify contact details before every send
  5. Separate working notes from verified facts
  6. Archive stale records on a schedule
  7. Train the next person on the same rules
  8. Sources
Build a prospect data hygiene checklist for a recruiting database illustration

A recruiting database is only useful when the entries match the athletes behind them. One duplicate record, one old phone number, or one wrong graduation year can send a message to the wrong inbox or drop a prospect from a list. Data hygiene is the routine work of keeping those records clean before a busy month begins. It does not require a new platform or a large budget. It requires a repeatable checklist and one person who owns the standard.

This checklist treats the individual prospect record as the unit of work. It covers names, graduation years, positions, contact details, and the notes that sit beside them. The goal is a database that a new assistant can read without calling the previous coach. The routine takes one short session each week and a longer review each season. A clean record is easier to search, easier to trust, and easier to hand off.

Start with one owner and one field list

Name one person who can change the structure of the database. That owner approves new fields, merges duplicates, and decides which notes belong in a shared record. Without a named owner, every staff member invents a slightly different format. The result is a table that looks complete but cannot be sorted or trusted. The owner does not have to enter every record, but the owner must settle the arguments.

Write the field list on a single page and keep it beside the database. Include the required fields, the accepted values, and an example for each one. A short list is easier to enforce than a long policy that nobody reads. Review the list at the start of each recruiting cycle and remove fields that no one uses. A field that no one maintains becomes a place where bad data hides.

Remove duplicate records before adding new ones

Search for an existing record before creating a new prospect. Search by last name, graduation year, and high school, then check the result against the athlete's current team. A duplicate often appears when a parent and an athlete both submit a questionnaire. The second entry should be merged, not kept as a separate contact. A quick search takes seconds and prevents months of split notes.

Merge carefully and keep a note that explains the merge. Combine the verified contact details, the current position, and the most recent film link into one record. Delete the empty shell only after the surviving record is checked. A merge that loses a coach's note is worse than a duplicate that is easy to see. The merge note should name the person who made the change and the date.

Standardize names, graduation years, and positions

Use the athlete's legal name in the name field and a common name in a separate display field. This prevents a nickname from breaking a search while still letting staff use the name the athlete prefers. Capitalize consistently and avoid all-caps entries that sort differently from the rest of the list. A small standard saves hours during a roster review. The display field also helps a coach address the athlete correctly in a message.

Store graduation year as a four-digit number and position as a controlled value. Free text invites entries such as "mid" and "midfielder" in the same column. A controlled list makes filters reliable and keeps a coach from missing a prospect during a position search. Add a note field for secondary positions instead of crowding the main field. The standard should be written where a new staff member can find it.

Verify contact details before every send

Check the athlete's email and phone number against the most recent message in the thread. A bounced email is a signal to pause the whole sequence, not to resend the same address. Ask the athlete to confirm the best contact method at the start of each season. A parent's address may be more reliable during a school transition. The record should show which contact is preferred and which is a backup.

Keep a date beside each contact detail and mark how it was confirmed. A phone number confirmed by a reply is stronger than one copied from a camp form. Remove old numbers instead of leaving them in a notes field where they can be selected by mistake. The record should show the current path, not the history of every path. A dated detail is easier to defend when a message goes astray.

Separate working notes from verified facts

Create one area for facts and another for staff observations. A verified fact includes a source and a date, such as a transcript received from the school. An observation might be a coach's impression from a camp and should be labeled as such. Mixing the two makes a guess look like evidence when the record is reviewed later. The label should be visible without opening a separate document.

Write notes in neutral language and avoid labels that might follow an athlete unfairly. "Answered questions slowly in a group setting" is more useful than "poor communicator." A note should help the next coach prepare a conversation, not close a door. Review sensitive notes at the end of each season and remove anything that is no longer relevant. The standard is a note that a family could read without feeling misrepresented.

Archive stale records on a schedule

Set a rule for when a record becomes inactive. A prospect who has signed elsewhere, stopped responding for a full cycle, or graduated should move to an archive view. Archiving keeps the working list short without destroying the history. The rule should be written down so two staff members apply it the same way. An archive is a storage decision, not a judgment about the athlete.

Before archiving, confirm that the record has no open task or pending document. A record with a scheduled call should stay active until the call is closed. Add the archive date and the reason to the record for future reference. A clean archive is easier to audit than a working list that grows without limit. The archive should also be searchable when a coach asks about an old contact.

Train the next person on the same rules

Give every new staff member the one-page field list and a short walkthrough of the database. Ask the new person to enter three test records and review them together. This catches misunderstandings before they reach a live prospect. The training should take less than an hour and happen before the first outreach wave. A new person who understands the why is more likely to follow the rule.

Review one sample of records each month against the checklist. Pick five entries at random and check the fields, the contact dates, and the notes. Share what looks good as often as what needs repair. A routine review keeps the standard visible without turning the work into a punishment. The findings should improve the form, not just scold the person who filled it out.

Sources

Related Articles

Coach Outreach

Build a coach response log that separates silence from a soft no

A coach response log for recruiting outreach that records channel, timing, and next action so a family can tell a slow reply from a polite decline.

Campus Visits

Create an official visit family cost estimate before you accept

A practical cost estimate for the family share of an official visit, covering airfare, incidentals, meals, ground transport, and the questions to ask the host program.

Recruiting Support

Set a recruiting social media review checklist before a coach follows

A social media review checklist for recruits and families, covering account inventory, old posts, photo consent, comments, and a simple posting boundary.