> For the complete documentation index, see [llms.txt](https://support.pears.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.pears.io/engage/social-marketing-campaigns/export.md).

# 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.

The arrow next to the **Export** button opens a menu of additional options. If your account has permission to export uploads, that menu includes **Export with Uploads**, which delivers the workbook together with an archive of the files attached to the exported records.

![Screenshot: The Social Marketing Campaigns list view with the Export button highlighted and filter options visible above the records table](https://2560412328-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff0820LrBGQ9ZA8SC4BR1%2Fuploads%2Fgit-blob-2f3b0eec50c27ec457e40c94c2f0de3982638edc%2Fsocial-marketing-campaigns-export-button.png?alt=media)

{% hint style="info" %}
**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.
{% endhint %}

## 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, primary topics, campaign stages (planning, developing, implementing, evaluating), launch date, languages, geographic scale, and timestamps. Primary topics and languages are included when the export covers reporting periods from 2023 onward; intervention topics are included when it covers earlier reporting periods.
* **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 per campaign, including the segment name and the total number of individuals, plus a SNAP-Ed eligible count when the export contains SNAP-Ed campaigns.
* **Reach by Channel** — One row per marketing channel per campaign, including the channel name, number of impressions, total reach, source of reach data, and engagement metrics (comments, likes, clicks, shares, and an engagement score). SNAP-Ed eligible reach is included when the export contains SNAP-Ed campaigns.
* **Evaluations** — One row per evaluation, including the channel, market segment, assessment types and methods, number evaluated, and recall metrics.