Social Marketing Campaigns

by
Program activities in PEARS feed into the Social Marketing Campaigns section of Project and Activity Results in National PEARS.
A video walkthrough of this mapping document is provided here:

Logic Applied

Records Included:
  • Only records attached to the selected Reporting Year (i.e., 2023)
  • Only records with the “SNAP-Ed” Program Area attached
  • Only records that are marked as complete
Records Excluded:
  • Any record entered by Canopy staff or test users
Additional Logic:
  • For any data in Project and Activity Results, the project specified in the “General Information” section of PEARS must match a corresponding Project in N-PEARS. Data will be aggregated/included by project.

Field Mapping

PEARS Field

Location in PEARS

N-PEARS Field

Location in N-PEARS

Calculation
Project
General Information
Does this project include one or more social marketing campaigns?
Project Results-> [Project Record]-> Social Marketing
If any social marketing campaign the logic criteria exists, select “Yes”. Otherwise, select “No”.
Please indicate the campaign’s primary topic(s).
General Information
Please indicate the campaign’s primary topic(s).
 Project Results-> [Project Record]->  
Social Marketing-> [Social Marketing Campaign Record]-> Campaign Details
This field is only imported if the “Stages of implementation” is greater than or equal to “Implementing”.
The mapping of this field is an exact match between PEARS and N-PEARS, so no mapping table is shown.
Which stages of planning & implementation did you work on during the current reporting year (select all that apply)?
General Information
What was the stage of this social marketing campaign at the end of the reporting year?
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Basic Information
The highest stage of planning & implementation will be selected for use in N-PEARS.
Language(s)
General Information
In what languages was the campaign (at least one channel) offered?
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Campaign Details
Please specify additional language(s)
General Information
Other Languages
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Campaign Details
For each unique “other language” specified, a new row will be added to the N-PEARS “Other Languages”.
Campaign scale
General Information
What is the smallest geographic unit for which you measure your social marketing campaign coverage?
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Campaign Details
This field is only imported if the “Stages of implementation” is greater than or equal to “Implementing”.
Project areas
General Information
Indicate the areas covered by the social marketing campaign
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Campaign Details
This field is only imported if the “Stages of implementation” is greater than or equal to “Implementing”.
Market Segment
Potential Reach by Market Segment -> Market Segment Record]
Market Segments
 Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]->  
Market Segments
Each matching market segment and related information from PEARS will be imported into the corresponding market segment in N-PEARS.
The list of Market Segments matches exactly between PEARS and N-PEARS, so no mapping table is shown.
Number SNAP-Ed-eligible Individuals
Potential Reach by Market Segment ->[Market Segment Record]
Market Segments -> Number of SNAP-Ed-Eligible Individuals Where Social Marketing Campaign Was Conducted
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Market Segments
Each matching market segment and related information from PEARS will be imported into the corresponding market segment in N-PEARS.
Total number of Individuals
Potential Reach by Market Segment ->[Market Segment Record]
Market Segments -> Number of Individuals (Total) Where Social Marketing Campaign Was Conducted
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Market Segments
Each matching market segment and related information from PEARS will be imported into the corresponding market segment in N-PEARS.
Channel
Reach & Impressions by Channel -> [Channel Record]
Impressions, Reach, & Engagement by Channel (MT12b)
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
The list of Channels matches exactly between PEARS and N-PEARS, so no mapping table is shown.
Number of Impressions
Reach & Impressions by Channel -> [Channel Record]
Impressions
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
SNAP-Ed Eligible Reach
Reach & Impressions by Channel -> [Channel Record]
SNAP-Ed Eligible Reach
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Source of Reach
Reach & Impressions by Channel -> [Channel Record]
Source
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Engagement ->
Number of Comments
Reach & Impressions by Channel -> [Channel Record]
Engagement -> Comments
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Engagement ->Number of Likes
Reach & Impressions by Channel -> [Channel Record]
Engagement -> Likes
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Engagement ->Number of Clicks
Reach & Impressions by Channel -> [Channel Record]
Engagement -> Clicks
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Engagement ->Number of Shares
Reach & Impressions by Channel -> [Channel Record]
Engagement -> Shares
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
Engagement ->Engagement Score
Reach & Impressions by Channel -> [Channel Record]
Engagement -> Engagement Score
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.
This channel directs the audience to a website (e.g., via QR code or a link)
Reach & Impressions by Channel -> [Channel Record]
Directs Audience to Website (e.g., via QR Code)
Project Results-> [Project Record]-> Social Marketing-> [Social Marketing Campaign Record]-> Impressions, Reach, & Engagement
Each matching channel and related information from PEARS will be imported into the corresponding channel in N-PEARS.