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
Template Name Definition Location in N-PEARS Helpful Notes external_coalition_id Unique numeric identifier for each coalition name Name of the coalition Coordination and Collaboration > Multisector Partnerships/Coalitions > Partnership/Coalition Name level Geographic level of the coalition Coordination and Collaboration > Multisector Partnerships/Coalitions > Geographic Level(s) of Partnership/Coalition sector Sector of the coalition Coordination and Collaboration > … Read more
Template Name Definition Location in N-PEARS Helpful Notes external_story_id Unique numeric identifier for each story title Title of the story Success Stories > Success Story Name external_site_ids Unique numeric identifier for each site Success Stories > Success Story > Sites and Indicators > Site(s) or Organization(s) other_sites Name of any site not listed Success Stories … Read more
Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name languages Language(s) used to deliver this program Project and Activity Results > Project > Indirect Education Channels > Languages languages_other If other language was selected, these are the languages specified by the user Project and Activity Results … Read more
Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name external_campaign_id Unique numeric identifier for each campaign channel Name of the channel Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel impressions Total number of impressions … Read more
Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name external_campaign_id Unique numeric identifier for each campaign market_segment Name of the market segment Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment market_segment_ethnic_other If other ethnic market segment was selected, … Read more
Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name external_campaign_id Unique numeric identifier for each campaign campaign_name Name of the campaign Project and Activity Results > Project > Social Marketing Campaigns > Basic Information > Campaign Name primary_topics The campaign’s primary topic(s) Project and Activity Results … Read more
Create a new row for each partner type Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name partner_type Type of partner organization Project and Activity Results > Project > PSE Change Initiatives > Active Partners > Partner Type These values will need to match the keys … Read more
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 … Read more
Template Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name method_in_person This project was delivered in person Project and Activity Results > Project > Direct Education > Mode of Delivery > In Person Enter 1 for Yes or 0 for No method_virtual_live_online This project was delivered … Read more