Made by@revopslabCrm field audit
@revopslab/crm-field-audit
Audit the fields in any CRM export (HubSpot, Salesforce, or other CSV). Reports fill rates, placeholder junk like n/a and unknown, top values, and flags empty, sparse, constant, default-heavy, and likely duplicate fields, plus fill rates by owner or team. Ends with a cleanup plan: what to hide, merge, make required, or fix.
- Activity
- New: be the first to try it
- Installs
- 0 installs
- Likes
- 0 likes
- Clones
- 0 clones
- 1# CRM field audit
- 3Finds out which CRM fields are actually used. From one export it measures fill rates, spots placeholder junk, and flags empty, constant, default-heavy, and duplicate fields, then writes a cleanup plan.
- 5## Who it is for
- 7RevOps and CRM admins on HubSpot, Salesforce, or any CRM, planning a cleanup, a migration, or better reporting.
- 9## Example
- 11Input: `examples/companies.csv` (12 companies, 14 fields), grouped by Owner.
- 13Output (`out/field-audit.md`):
- 15| Field | Fill | Top value | Flags |
- 16| --- | ---: | --- | --- |
- 17| Legacy Score | 0% | | empty |
- 18| Partner Tier | 8.3% | Gold (100%) | sparse |
- 19| Original Source | 50% | Organic search (33.3%) | placeholders |
- 20| Industry (Custom) | 83.3% | Retail (30%) | possible_duplicate |
- 21| Lifecycle Stage | 100% | Lead (91.7%) | default_heavy |
- 22| Region | 100% | NA (100%) | constant |
- 24Plus fill rate by owner and a plan: archive, merge, fix defaults, enrich.
- 26## What it can access
- 28- Runs `node scripts/field-audit.mjs` (Node built-ins only, no network).
- 29- Reads `data/` (plus the kit's own `examples/`), writes `out/`.
- 31## Setup
- 33None. Export the object with all columns to `data/`.