N-PEARS Export

Export PEARS data in a format compatible with National PEARS (N-PEARS) for federal annual reporting.

The N-PEARS Export transforms your organization's PEARS data into a format that can be imported directly into National PEARS (N-PEARS) for federal annual reporting. The export aggregates SNAP-Ed programming data by project and applies the field mappings required by N-PEARS.

Screenshot: N-PEARS Export page showing the fiscal year dropdown, unit selector, reported by field, configuration options, and Start Export button

TIP: Navigate to Analyze > N-PEARS Export to access this feature. The N-PEARS Export is only available to state-level (IA) organizations.

Getting Started

The N-PEARS Export generates a .zip file containing two Excel workbooks:

• N-PEARS Export — Aggregated data formatted for direct import into N-PEARS.

• N-PEARS Raw Export — Disaggregated detail data for verification purposes. This file should not be imported into N-PEARS.

How to Run the N-PEARS Export

Record Types

The export includes data from eight PEARS record types. Each record type has specific inclusion criteria and field mappings that determine how PEARS data translates to N-PEARS fields.

1

Programming Data

• Program Activities — Maps to the Direct Education section in N-PEARS.

• Indirect Activities — Maps to the Indirect Education Channels section in N-PEARS.

• Social Marketing Campaigns — Maps to the Social Marketing Campaigns section in N-PEARS.

2

PSE Data

• PSE Site Activities — Maps to the PSE Change Initiatives section in N-PEARS.

• Partnerships — Maps to PSE Active Partners in N-PEARS. Only partnerships attached to PSE Site Activities are included.

3

Collaboration & Stories

• Coalitions — Maps to the Multisector Partnerships and Coalitions section in N-PEARS.

• Success Stories — Maps to the Success Stories section in N-PEARS.

4

Sites

• Sites — Maps to Project Sites in N-PEARS. Any site linked to an included program, PSE, or success story is included.

Additional Resources

• Data Cleaning Checklist — Review this checklist before running the export to ensure your data is ready.

Global Inclusion Criteria

The following criteria apply to all record types unless otherwise noted:

• Only records attached to the selected reporting year are included.

• Only records with the SNAP-Ed program area are included.

• Only records marked as complete are included.

• Records entered by Canopy staff or test users are excluded.