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 |
channel
|
Name of the channel
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel
|
Enter the key found in the channel section of the key mapping sheet. |
channel_other
|
Add an Additional Channel
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Add an Additional Channel
|
|
impressions
|
Total number of impressions
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Impressions
|
|
snaped_eligible_reach
|
Total number of SNAP-Ed eligible reach
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > SNAP-Ed Eligible Reach
|
|
reach_source
|
Source of reach data
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Reach Source
|
Enter the key found in the reach_source section of the key mapping sheet. |
reach_source_other
|
If other source of reach was selected, this is the source specified by the user
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Reach Source Other
|
Must enter other in the previous field to use this option. |
engagement_comments
|
Total number of comments
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Engagement Count by Measure > Comments
|
|
engagement_likes
|
Total number of likes
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Engagement Count by Measure > Likes
|
|
engagement_clicks
|
Total number of clicks
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Engagement Count by Measure > Clicks
|
|
engagement_shares
|
Total number of shares
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Engagement Count by Measure > Shares
|
|
engagement_score
|
Total engagement score
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Engagement Count by Measure > Engagement Score
|
|
directs_audience_to_website
|
This channel directs audience to website
|
Project and Activity Results > Project > Social Marketing Campaigns > Impressions, Reach, & Engagement by Channel (MT12b) > Channel > Directs Audience to Website
|
Enter 1 for Yes or 0 for No |