# Data Completeness

> Whether all the rows and fields that should be there are there.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Completeness (Data Quality), Missing Data

## Think of it like

A puzzle with three pieces missing. You can see the picture, but not all of it.

## Definition

Data completeness is whether all the data that should be there is there. It looks at blank fields, such as a missing email. It also looks at missing rows, such as a day with no orders at all. A field can be allowed to be blank, so the rule must say which ones are required. Completeness is usually given as a percentage.

## Example

A daily load brings 9,800 orders when it usually brings 10,000. A missing file from one shop explains the gap.

## Example code

```sql
SELECT COUNT(*) AS total,
       COUNT(email) AS with_email,
       100.0 * COUNT(email) / COUNT(*) AS pct_complete
FROM customers;
```

COUNT(email) skips blanks, so the two counts give the share of customers with an email.

## Why it matters

Gaps make every total too small, and no one sees it. A report can look fine while a whole region is gone.

## Common mistake

Only counting blanks. A load that skips a whole file has no blanks at all, just fewer rows.

## Three principles

- **No blanks.** Required fields are filled in.
- **No missing rows.** Every expected record arrived.
- **A percentage.** Measured as a share of the total.

## Related terms

- [Data Quality Dimensions](https://learn.benibix.com/term/data/data-quality-dimensions)
- [Data Quality Check](https://learn.benibix.com/term/data/data-quality-check)
- [Data Observability](https://learn.benibix.com/term/data/data-observability)
- [Data Accuracy](https://learn.benibix.com/term/data/data-accuracy)

![Six tiles, one per quality dimension, each with a small broken example: accuracy shows a wrong price, completeness a blank email, consistency two totals that disagree, freshness a table last loaded 3 days ago, uniqueness an order listed twice, and validity a date of 31 February.](https://learn.benibix.com/diagrams/data-quality-dimensions.svg)

---

Source: https://learn.benibix.com/term/data/data-completeness
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
