A field with a 2% global fill rate can be 85% populated on a single record type. Global numbers create false cleanup candidates. Reviewing usage by record type reduces them.
Read-only diagnostics · Review-ready workbooks · No package install · No Connected App
A field has a 2% fill rate across the whole object. By the global number, it looks unused — an obvious candidate to hide or remove. Then you split the same field by record type and find it is 85% populated on one of them.
Nothing about the field changed. The way you measured it did. That single field is essential to one business process and irrelevant to the rest, and the global fill rate flattened both realities into a misleading 2%.
This is one of the most common ways field cleanup goes wrong: global fill rate alone creates false cleanup candidates. This guide explains how record types change the meaning of field usage, why that matters during cleanup, when record-type review applies, and how to use record-type context to reduce false positives before you make a decision.
Global fill rate compares how many records have a value in a field against the total number of records on the object. It is a strong first-pass signal because it quickly separates fields that are widely populated from fields that are rarely touched.
That is exactly what you want at the start of a cleanup review: a way to narrow hundreds of fields down to a shortlist worth investigating. The limitation is that a single global percentage averages across every record on the object, regardless of which process created it. When an object serves several distinct processes, one number cannot represent all of them faithfully.
Global fill rate is a good starting point. It becomes misleading the moment one object is doing several different jobs.
Record types are how a single Salesforce object supports more than one business process. The same object can carry several record types, each with its own page layouts, picklist values, and the fields that process actually needs.
In practice, record types often map to meaningfully different things:
Because each record type represents a different process, a field's usage only makes sense in the context of the record type it belongs to. A field that is core to one process will naturally look rare when diluted across every other process on the object.
Consider a single custom field on the Account object, viewed first globally and then by record type:
| Scope | Fill rate |
|---|---|
| All Account records | 2% fill |
| Member Company record type | 40% fill |
| Prospect record type | 0% fill |
| Vendor record type | 0% fill |
Globally, this field looks like a clear cleanup candidate at 2%. By record type, the picture is completely different. The field is part of an active process on Member Company accounts and genuinely unused on Prospect and Vendor accounts.
The right decision is not "delete" or "keep" — it is "this is a Member Company field." That framing changes who you talk to, which layouts you check, and what a safe change would even look like. The global number alone would have pointed you toward removing a field that one team relies on.
Acting on global fill rate without record-type context introduces specific, avoidable risks:
Each of these is hard to catch after the fact, because the team that relied on the field may not notice until the process it supports runs again. Reviewing by record type is a low-cost way to catch the problem before the change, not after.
Inherited orgs are where record-type context matters most, because the history behind the configuration is usually missing.
Over years of changes, inherited orgs accumulate old record types that are no longer obvious, processes that were renamed without renaming the underlying record type, legacy fields that were hidden rather than removed, and inconsistent decisions made by a series of admins who each had their own conventions. A field tied to a record type from a process that was rebranded two years ago can look like noise — until you find the team still using it.
Reviewing usage by record type helps rebuild that missing context. For the wider first-pass approach to taking over an unfamiliar org, see the guide to inheriting a Salesforce org.
Record-type fill rate is one signal among several. Before acting on a low-fill field, work through the full set of usage signals:
Low-fill field review checklist
For the full reasoning behind why no single usage number is enough, see Salesforce field cleanup: why fill rate alone is not enough, and the broader field cleanup checklist.
Record-type segmentation is valuable, but it does not apply everywhere. It is worth knowing when the signal is not available or could mislead:
In these cases, lean on the other signals — layout exposure, references, integrations, and business-owner confirmation — rather than reading too much into a record-type percentage that cannot carry the weight.
Field & Object Audit adds record-type usage context for cleanup review candidates where record types exist. This helps admins and consultants distinguish globally low-fill fields from fields that may matter to a specific process or team.
The record-type view is presented as a field usage signal for review, not as proof that a field is safe to delete. It is one part of a review-ready workbook designed to reduce false positives, alongside the cleanup candidates, supported reference signals, and validation notes you would work through before any change.
In the workbook
Relevant Workbook
Field & Object Audit adds record-type usage context for cleanup review candidates where record types exist, alongside usage, exposure, supported reference signals, and validation notes — in a read-only, review-ready XLSX workbook that requires no package install and no Connected App setup.
Global fill rate is where review starts, not where it ends. On objects that serve multiple processes, a single percentage can quietly hide a field that one team depends on.
A Salesforce field is not unused just because its global fill rate is low. Review by record type before making cleanup decisions.
Why should Salesforce field usage be reviewed by record type?
Record types often represent different business processes on the same object. A field can look unused when measured across all records but be heavily used on one record type. Reviewing usage by record type helps admins avoid treating a process-specific field as a global cleanup candidate.
Can a field with low global fill rate still be important?
Yes. A low global fill rate can hide strong usage within a single record type, profile, or process. A field at 2% globally may be 85% populated on one record type, which makes it important to that process even though the global number suggests otherwise.
Should record type usage determine whether a field is deleted?
No. Record-type usage is a field usage signal that reduces false positives during review. It does not prove a field is safe to delete and it does not replace admin judgment. It is one input alongside layout exposure, FLS, references, integrations, and business-owner confirmation.
What objects need record-type field usage review?
Objects that use multiple active record types to represent distinct processes benefit most — commonly Account, Opportunity, Case, Lead, and heavily customized custom objects. Objects without record types, or with only one active record type, do not need record-type segmentation.
What should admins check besides record-type fill rate?
Record-type fill rate is one signal. A complete review also looks at global fill rate, record counts per record type, layout and FLS exposure, formula and validation rule references, Apex source-text signals, reports and dashboards, integrations, and the confirmed business owner before any change.
KeelCadence Field & Object Audit adds record-type usage context for cleanup review candidates where record types exist, alongside usage, exposure, supported reference signals, and validation notes in a review-ready XLSX workbook.