> For the complete documentation index, see [llms.txt](https://support.pears.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.pears.io/analyze/n-pears-export/data-cleaning-checklist.md).

# Data Cleaning Checklist

Review this checklist before running the N-PEARS Export to ensure your PEARS data is ready.

Review each item below before running the [N-PEARS Export](/analyze/n-pears-export/how-to-run-the-export.md) to ensure your data imports correctly into N-PEARS.

{% stepper %}
{% step %}

#### Project Names

Project names in PEARS must **exactly match** the corresponding project names in N-PEARS. Mismatched names will cause N-PEARS to create new projects instead of matching to existing ones. Project names come from [Manage Lists](/administration/administration/manage-lists.md), so renaming a project there updates every record that uses it. Data Managers can also move records to a different project in bulk from a module's list page.

**Affected record types:** [Program Activities](/analyze/n-pears-export/program-activities.md), [PSE Site Activities](/analyze/n-pears-export/pse-site-activities.md), [Social Marketing Campaigns](/analyze/n-pears-export/social-marketing-campaigns.md), [Indirect Activities](/analyze/n-pears-export/indirect-activities.md), [Success Stories](/analyze/n-pears-export/success-stories.md)
{% endstep %}

{% step %}

#### Mark Records as Complete

Only **completed** records are included in the N-PEARS Export. Review your data for any records still marked **Incomplete** and mark them as complete before running the export. Data Managers can mark records complete in bulk once all required fields are filled.
{% endstep %}

{% step %}

#### Program Activity Session Length

Program Activities must have at least one session or module that is **20 minutes or longer** to be included. Review session data for accuracy and correct any apparent data entry errors (e.g., sessions recorded as 1 minute).
{% endstep %}

{% step %}

#### Age Subcategories (5-17)

The 5-17 age subcategories (5-7, 8-10, 11-13, 14-17) are reported separately for FY24 and later. When the 5-17 total is larger than the sum of the four subcategories, the export spreads the difference evenly across them and reports it as estimated reach. For more accurate reporting, enter the actual subcategory counts before running the export.
{% endstep %}

{% step %}

#### PSE Reach and Implementation Stages

PSE changes are included only when the PSE Site Activity records a **total reach** in **Changes Adopted**. Selecting **Unknown** as the **Method used to determine total reach** clears that total and leaves the site activity's changes out of the export; a reach of zero is still exported. Stages of implementation do not control inclusion — they determine which intervention approaches are reported for the project site.
{% endstep %}

{% step %}

#### PSE Partners

Both the **PSE Site Activity** and the associated **Partnership** record must be marked as complete for partnership data to be included in the export.
{% endstep %}

{% step %}

#### Coalition Sectors

Coalitions must have at least **5 distinct sectors** represented among their members to be included. Review coalition membership to ensure sectors are assigned and that the minimum threshold is met.
{% endstep %}

{% step %}

#### Success Story Projects

A **Project name** must be selected on each Success Story in **SNAP-Ed Custom Data**. Stories without a project are excluded from the export.
{% endstep %}
{% endstepper %}