Fill rate, inconsistent values and cross-field checks

Updated Markdown

Beyond checking individual fields, ListPlus looks at your list as a whole — how filled each column is, whether the same value is written differently across rows, and whether values in different columns contradict each other. All of these are free, deterministic checks.

Fill rate and column structure#

  • Low Fill Rate — a column where less than 30% of rows have a value.
  • Mixed Types in Column — a column mostly numbers or dates has a minority (over 10%) of a different type, often a misaligned import.
  • Date Format Inconsistency — a date column mixes formats, e.g. YYYY-MM-DD with DD.MM.YYYY.
  • Numeric Outlier — a value statistically far outside the rest of its column.
  • Untyped Column — a column with data that wasn't classified with a content type during import, so most checks don't cover it.
  • Temp/Scratch Column — a column name suggests scratch data (e.g. "temp", "delete", "WIP").
  • Empty Row — a row with no data in any column; its Fix ("Delete Empty Rows") hides it, restorable from Hidden rows.

Inconsistent values (Normalize)#

Nine content types get their own consistency check when your list has that column: State, Industry, Language, Salutation, Seniority, Department, Job Function, Lead Source and Lead Status Inconsistency. Each flags case or spelling variants of the same value (e.g. "california" vs "California") and offers a Normalize fix, which opens a review window where you confirm the standard value for each group. Fix all skips it — see "fixing-issues" for how Normalize fits into Quick fixes.

Cross-field conflicts#

  • Email-Company Mismatch — the email domain doesn't match the company name.
  • Name-Email Mismatch — the email address contains no part of the person's name, which can mean the wrong person is attached to that row.

ZIP and phone number mismatches against the country column are covered in "addresses-and-countries".

quality-checks-overview · fixing-issues · addresses-and-countries · select-rows-by-checks.

FAQ#

Does ListPlus tell me if a column is mostly empty?#

Yes — the Low Fill Rate check flags any column where less than 30% of rows have a value, so you can see which fields are worth filling or removing.

Can ListPlus catch a column that mixes text, numbers and dates?#

Yes, with Mixed Types in Column — it flags the minority-type values when a column is mostly one type (number or date) but over 10% of values are something else.

How does ListPlus normalize inconsistent values like "california" and "California"?#

For nine content types (State, Industry, Language, Salutation, Seniority, Department, Job Function, Lead Source, Lead Status), the matching consistency check flags less common spellings and offers a Normalize fix that opens a review window where you confirm the standard value before anything changes.

What does "cross-field conflict" mean?#

A value in one column contradicts a value in another on the same row — for example the Email-Company Mismatch check flags when the email domain doesn't match the company name, and Name-Email Mismatch flags when the email contains no part of the person's name.

Does ListPlus catch inconsistent date formats in a column?#

Yes — Date Format Inconsistency flags rows using a minority date format (e.g. a handful of DD.MM.YYYY values mixed into a mostly YYYY-MM-DD column).

Are these checks free?#

Yes — every check listed on this page is deterministic and free, and runs automatically the first time you open the Analyze panel.