Annual Report Data Import – PSE Changes

by
Each row in Excel represents one PSE Change. To report multiple PSE changes for a site, create a new row for each PSE Change.

Template Name

Definition

Location in N-PEARS

Helpful Notes

project
Project name
Project and Activity Results > Project Name
 
external_site_id
Unique numeric identifier for each site
 
Match site id to the number you entered in the sites sheet. 
change_text
Name of PSE Change
 Project and Activity Results > Project > PSE Change Initiatives > PSE Changes > PSE change(s)
These values will need to match the keys indicated in the PSE Changes section of the Key Mapping sheet.
reach_total
Total number of participants reached
Project and Activity Results > Project > PSE Change Initiatives > PSE Changes > Estimated Reach
N-PEARS pulls in the highest “reach_total” number for each site.
  • Example 1: Three PSE changes at the same site each list a total reach of 175 in the Excel import file.

    The total reach listed for PSE changes at that site will be 175 after data is imported.

  • Example 2: Three PSE changes at the same site list different numbers for total reach in the import file: 125, 200, and 175.

    The total reach listed for PSE changes at that site will be 200 after data is imported.