Annual Report Data Import – Social Marketing Channels

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
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
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
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
1=Yes, 0=No; 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