Salesforce Field Cleanup

WHY SALESFORCE FIELD USAGE SHOULD BE REVIEWED BY RECORD TYPE.

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.

01

GLOBAL FILL RATE IS USEFUL, BUT IT CAN HIDE PROCESS-SPECIFIC USAGE.

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.

02

RECORD TYPES CHANGE THE MEANING OF FIELD USAGE.

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:

  • Different sales motions or deal types on Opportunity.
  • Different account types — customer, partner, vendor, member.
  • Different case types — support, billing, escalation.
  • Different regions, product lines, or business units.
  • Different member or customer categories on custom objects.

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.

03

HOW A FIELD CAN LOOK UNUSED GLOBALLY BUT MATTER LOCALLY.

Consider a single custom field on the Account object, viewed first globally and then by record type:

ScopeFill rate
All Account records2% fill
Member Company record type40% fill
Prospect record type0% fill
Vendor record type0% 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.

04

WHY THIS MATTERS DURING SALESFORCE CLEANUP.

Acting on global fill rate without record-type context introduces specific, avoidable risks:

  • Removing or hiding a field that is used by one process while it looks unused overall.
  • Confusing one team's valid field with another team's unused field on the same object.
  • Breaking reports, list views, or user workflows that depend on a process-specific field.
  • Misclassifying a process-specific field as a global cleanup candidate.

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.

05

RECORD TYPE USAGE IS ESPECIALLY IMPORTANT IN INHERITED ORGS.

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.

06

WHAT ADMINS SHOULD CHECK BEFORE ACTING ON A LOW-FILL FIELD.

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

  • Global fill rate.
  • Fill rate by record type.
  • Record count by record type.
  • Layout visibility by record type or profile, where applicable.
  • FLS exposure.
  • Formula and validation rule references.
  • Apex and source-text signals.
  • Reports and dashboards.
  • Integrations, confirmed with the teams that own them.
  • The confirmed business owner.

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.

07

WHEN RECORD-TYPE USAGE DOES NOT APPLY.

Record-type segmentation is valuable, but it does not apply everywhere. It is worth knowing when the signal is not available or could mislead:

  • Objects without record types — there is nothing to segment.
  • Objects with only one active record type — the breakdown matches the global number.
  • Fields that are not queryable or aggregatable for usage measurement.
  • Formula and encrypted fields, where populated-value measurement does not behave the same way.
  • Low record-count segments, where a small denominator makes percentages volatile and easy to misread.

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.

08

HOW KEELCADENCE FIELD & OBJECT AUDIT USES RECORD-TYPE CONTEXT.

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

  • Cleanup Candidates tab — low-usage fields surfaced for review.
  • Record Type Usage tab — fill rate context by record type where it exists.
  • Review Tracker — a place to record decisions and owners.
  • Reference Signals tab — supported references to investigate next.

Relevant Workbook

Field & Object Audit

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.

09

FINAL TAKEAWAY.

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.

Common Questions

COMMON QUESTIONS.

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.

Where to Start

SEE FIELD USAGE BY RECORD TYPE BEFORE YOU CLEAN UP.

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.