# Data Cleaning Checklist

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. Data Managers can update project names in bulk if needed.

**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 in draft status 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 required for FY24 and later. If subcategory data is missing, the export will estimate by evenly distributing the 5-17 total across the four subcategories. For more accurate reporting, enter the actual subcategory counts before running the export.
{% endstep %}

{% step %}

#### PSE Reach and Implementation Stages

PSE changes require **reach data** (greater than 0) and an implementation stage of **Started implementation of changes** or higher to be included. Review PSE records to ensure reach is reported for all adopted changes.
{% 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** must be selected on each Success Story in SNAP-Ed Custom Data. Stories without a project are excluded from the export.
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.pears.io/analyze/n-pears-export/data-cleaning-checklist.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.