Export Lists

All data in Performance Analytics can be exported in a number of formats via the download feature. In this document we’ll look at the general process of exporting Performance Analytics data, then we’ll examine the specific example of exporting a list of users that have directly opened a notification or rich message.

In this tutorial, you will first learn how to export report data, then follow steps to export specific types of report data.

Export Data

In this section we look at the general process of exporting Performance Analytics data.

  1. Go to Reports » Performance Analytics.
  2. Select a dashboard and find the report you would like to download.
  3. If you are on a default dashboard, click and select Download Data…. If you clicked the tile to open the report or opened the report from a Space, instead click Download Results.
  4. Specify Download Options:
    • File Format: The format of the download: TXT, Excel Spreadsheet, CSV, JSON, HTML, Markdown, or PNG (Image of Visualization).
    • Results: With visualization options applied or As displayed in the data table.
    • Values: Unformatted means special characters are truncated from values, and values will be rounded to the nearest integer, e.g., “1.13%” is rounded to “1%”. As a general rule, the Unformatted option is good for discrete values, e.g., a count of devices, while Formatted is a good option for non-discrete values, such as percentages.
    • Limit: Results in Table exports all results currently visible in the table. All Results exports every result fetched by the query. Select Custom, to define a cutoff row for the download, e.g., enter 5000 to download of the first 5,000 records.
    • Filename: Enter a descriptive filename.
  5. Click Download and save the file. If you’d like to view the data in the browser instead, click Open in Browser, and it will open in a new browser tab.

Notifications

Generate a list of users that directly opened a specific push notification.

  1. Go to Reports » Performance Analytics.
  2. Select the Revenue dashboard.
  3. In the Messages report, locate the row for the message you want to analyze, then click its value in the Direct Response Count column.
  4. Download the data as described in Export Data.

Rich Pages

Generate a list of users that directly opened a specific rich message.

  1. Go to the Messages dashboard.

  2. In the Top 50 Rich App Pages report, locate the row for the Message you want to analyze, then click its value in the Read Count column.

  3. Click the arrow next to Filters to display the full menu.

  4. Edit the Rich Pushes Occurred Date range, and set the value of is on or after to the day before the message send date:

    This configuration is necessary to ensure you capture rich message reads occurring in every time zone.

  5. Click the Run button to refresh the query.

  6. Download the data as described in Export Audience Lists.

Ad IDs

Generate a list of Ad IDs for users that made a purchase. Please visit our Ad IDs topic guide for use cases and technical details.

 Warning

Your app must:

  1. Send the limit ad tracking field from your app, and
  2. Not target users with ads who have limit ad tracking enabled. A value of Unknown or Limit Ad Tracking = Yes or Unknown means you cannot send ads to these users.

  1. Go to Reports » Performance Analytics.

  2. Select the Revenue dashboard.

  3. In the Custom Events Table report, locate the purchased row and click its value in the Event Count column.

  4. Click Explore from Here.

  5. Make these changes in the left side menu:

    • In Custom Events » Dimensions, click the row for Platform.
    • In User IDs » Dimensions, click the row for Device ID to unselect it, and click the row for Ad ID.
    • Click Filter for Limit Ad Tracking Enabled to add the row to the Filters menu, then set the value of is equal to to “No.”
  6. Download the data as described in Export Data.

  7. (Optional) Create a custom audience on Facebook. Follow Facebook’s instructions: Create a Customer List Custom Audience to create a Custom Audience or Lookalike Audience using the downloaded file. File must be in TXT or CSV format.

Export Audience Lists

You can segment your audience using an Uploaded ListA reusable audience list that you create. Uploaded lists are static and updatable. In the API, they are referred to as Static Lists.. First, follow these steps to download a CSV of device identifiers. Second, upload the list of users to your project, using the file you just downloaded.

This example downloads all your Daily Active Users,

  1. Go to Reports » Performance Analytics.
  2. Select the Overview dashboard.
  3. In the Daily Active Users report, click its value.
  4. Click Explore from Here.
  5. Download the data as described in Export Data, using these values:
    • File Format: CSV
    • Values: Unformatted
    • Limit: All Results