Export
Export social marketing campaign data from PEARS as an Excel workbook.
The Social Marketing Campaigns export generates an Excel (.xlsx) workbook containing data from your social marketing campaigns. The export includes campaign details, collaborators, potential reach by market segment, reach by channel, and evaluations across multiple worksheets.
Getting Started
To export social marketing campaigns, navigate to the Social Marketing Campaigns list under the Engage menu and click the Export button. The export includes all campaigns matching your current filters.
TIP: Apply filters before exporting to limit the results to a specific reporting period, program area, or completion status. Large exports are processed in the background and you will receive an email when the file is ready to download.
Workbook Structure
The export workbook contains the following worksheets. Data can be linked across worksheets using the campaign_id column.
Codebook — Describes each column in the workbook and provides notes about the exported data.
Social Marketing Campaigns — One row per campaign with fields including name, reporting periods, organization, units, program areas, intervention topics, campaign stages (planning, developing, implementing, evaluating), launch date, languages, geographic scale, and timestamps.
Collaborators — One row per collaborator per campaign, including the user's name, access level, contributor status, and contribution description.
Reach by Market Segment — One row per market segment, including the segment name and estimated number of individuals.
Reach by Channel — One row per marketing channel, including the channel name, number of impressions, total reach, source of reach data, and engagement metrics (comments, likes, clicks, shares).
Evaluations — One row per evaluation, including the channel, market segment, assessment types and methods, number evaluated, and recall metrics.
Last updated