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 id must match the id for this campaign in the Social Marketing sheet |
market_segment | Name of the market segment | Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment | Enter the key found in the market_segment section of the key mapping sheet. |
market_segment_ethnic_groups | If other ethnic market segment was selected, this is the market segment specified by the user | Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment > Ethnic/language groups | Must enter ethnic-groups in the previous field to use this option. |
market_segment_other | If other market segment was selected, this is the market segment specified by the user | Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment > other | |
segment_snaped_individuals | Number of SNAP-Ed individuals | Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment > Number of SNAP-Ed eligible individuals | |
segment_total_individuals | Total number of individuals | Project and Activity Results > Project > Social Marketing Campaigns > Market segments > Market Segment > Total Number of individuals | |