Add a New Project to the Annual Report

To add a new project or update an existing project, open the Projects and Activity Results module. Projects reported for the current year appear in a list. To add a new project, click Add Project. To update an existing project, click the edit icon. To add a project that has not previously been reported in … Read more

How is Data Entered into the Annual Report

Data can be entered into the Annual Report through three ways: Data that is copied from the State plan into to the report Data that is added through the importer Data that is manually entered into the system. To jump to a specific module, click one of the links below: Module 1: Project and Activity … Read more

Troubleshooting Annual Report Data Import

Overview National PEARS offers a data importer to ease data entry. When an error prevents the document from importing, the system will provide a variety of notifications to assist with completion of the document.  Clicking Download file with errors will download a spreadsheet that notates the issues preventing the importer from completing. Hovering over the red … Read more

Annual Report Data Import – Coalitions

Column Name Definition Location in N-PEARS Helpful Notes external_coalition_id Unique numeric identifier for each coalition   Create any number that is unique to reference the Coalition throughout the template. It does not matter what number you use, as long as it is not already used in this sheet. name Name of the coalition Coordination and … Read more

Annual Report Data Import – Success Stories

Column Name Definition Location in N-PEARS Helpful Notes external_story_id Unique numeric identifier for each story   Create any number that is unique to reference the Success Story.  NOTE: If you re-import the template for the same report, and reuse these identifiers, ensure the identifiers match the intended stories that were already imported. Any story with … Read more

Annual Report Data Import – Indirect Education

Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project. languages Language(s) used to deliver this program Project and Activity Results > Project > Indirect Education Channels > Languages Enter the … Read more

Annual Report Data Import – Social Marketing Channels

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet. If the project does not match exactly, it will create a new project. external_campaign_id Unique numeric identifier for each campaign   This … Read more

Annual Report Data Import – Social Marketing Segments

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet.  If the project does not match exactly, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   This … Read more

Annual Report Data Import – Social Marketing

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   Create any number that is unique to reference this campaign throughout the template. … Read more

Annual Report Data Import – PSE Partners

This information will filter into Active Partners within a Project in the Projects and Activities module. Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  partner_type Type of partner organization … Read more