Annual Report Data Import – Social Marketing

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 > Project > Social Marketing Campaigns > Campaign Details > Campaign Topics
Must match the primary_topics under Social Marketing on the Key Mapping sheet. 
primary_topics_other
If other primary topic was selected, this is the topic specified by the user
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Campaign Topics > Other
Previous field must say “other” to use this field.
stage_of_implementation
Highest stage of implementation
Project and Activity Results > Project > Social Marketing Campaigns > Basic Information > Stage
Must match the stage_of_implementation under Social Marketing on the Key Mapping sheet. 
languages
Language(s) used to deliver this program
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Languages
 
languages_others
If other language was selected, these are the languages specified by the user
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Languages > Other
 
scale
The type of scale of this campaign measured by the largest geographic unit use for planning.
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Campaign Scale
 
scale_market_name
If multi-state media markets primary topic was selected, this is the market name specified by the user
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Campaign scale > Multi State Media Markets
 
scale_other
If other primary topic was selected, this is the market name specified by the user
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Campaign scale > Other
 
project_areas
Project areas for the campaign
Project and Activity Results > Project > Social Marketing Campaigns > Campaign Details > Campaign scale > Indicate the ___ to be covered by the social marketing campaign.