Back to Cookbook

ATS Data Cleanup

Make your pipeline searchable, deduped, and decision-ready

Cleans recruiter notes and pipeline exports: dedupes candidates, normalizes stages, flags missing fields, and produces a "next actions" list to prevent candidates from falling through cracks.

CommunityWork5 min

INGREDIENTS

📄Google Docs

PROMPT

Create a skill called "ATS Data Cleanup". I will paste or upload: - An ATS export (CSV rows), or - A copy/paste list of candidates with stages and notes Output: 1) Duplicates detected (with merge suggestion) 2) Missing critical fields list (e.g., stage owner, last touch date, comp, location) 3) Stale candidates (no activity) with recommended actions 4) Stage normalization suggestions (standard definitions) 5) A prioritized "today list" of next actions (who to contact, who to reject, who to schedule) Keep output compatible with spreadsheet workflows.

How It Works

Paste or describe your ATS export. The skill finds duplicates, missing data,

stale candidates, and gives you a prioritized action list.

What You Get

  • Duplicate detection with merge suggestions
  • Missing critical fields list
  • Stale candidate list with recommended actions
  • Stage normalization suggestions
  • A prioritized "today list" of next actions

Setup Steps

  1. Export your pipeline data (CSV or copy/paste)
  2. Run the cleanup
  3. Action the "today list" first
  4. Apply stage normalization to your ATS settings

Tips

  • Run this monthly at minimum — pipeline rot is real
  • The stale candidate list often reveals people you forgot about
  • Stage normalization makes reporting possible across roles
  • Output is spreadsheet-compatible for easy import back into your ATS
Tags:#recruiting#ats#pipeline#cleanup