# CRM field audit

12 records, 14 fields. Empty 1, sparse (under 10%) 1, constant 1, default-heavy 1, placeholder values 1, possible duplicate pairs 1.

## Key fields

| Field | Fill rate |
| --- | ---: |
| Industry | 91.7% |
| Employees | 100% |
| Owner | 91.7% |

## All fields (lowest fill first)

| Field | Type | Fill | Distinct | Top value | Flags |
| --- | --- | ---: | ---: | --- | --- |
| Legacy Score | empty | 0% | 0 |  | empty |
| Partner Tier | text | 8.3% | 1 | Gold (100%) | sparse |
| Annual Revenue | number | 33.3% | 4 | 21000000 (25%) |  |
| Original Source | text | 50% | 5 | Organic search (33.3%) | placeholders |
| Industry (Custom) | text | 83.3% | 8 | Retail (30%) | possible_duplicate |
| Industry | text | 91.7% | 8 | Retail (27.3%) | possible_duplicate |
| Owner | picklist | 91.7% | 3 | Rep A (36.4%) |  |
| Company Name | identifier | 100% | 12 | Adventure Works (8.3%) |  |
| Country | picklist | 100% | 5 | US (66.7%) |  |
| Domain | identifier | 100% | 12 | adventure.example (8.3%) |  |
| Employees | number | 100% | 12 | 12 (8.3%) |  |
| Lifecycle Stage | picklist | 100% | 2 | Lead (91.7%) | default_heavy |
| Record ID | identifier | 100% | 12 | 1 (8.3%) |  |
| Region | picklist | 100% | 1 | NA (100%) | constant |

## Possible duplicates

- Industry and Industry (Custom) (91.7% and 83.3%): similar names; same value on 10 of 10 rows where both are filled

## Fill rate by Owner

| Owner | Records | Average fill |
| --- | ---: | ---: |
| (blank) | 1 | 66.7% |
| Rep A | 4 | 100% |
| Rep B | 3 | 100% |
| Rep C | 4 | 91.7% |