Exporting Lists

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

General Process

In this section, we look at the general process of exporting Insight data. To begin, navigate to some report you wish to download.

  1. Click the Download Icon: Click on the small gear in the top right corner of the report, and select Download.

  2. Specify Download Options: You should now see this menu:

    You have four options to specify:

    • File Format: The format of the download. You can choose between CSV, HTML, JSON, Markdown, TXT, and Excel Spreadsheet.
    • Values: If you select Unformatted, special characters are truncated from values, and values will be rounded to the nearest integer. E.g., “1.13%” will turn into “1”. As a general rule, the Unformatted option is good for discrete values, like a count of devices, while Formatted is a good option for non-discrete values, such as percentages.
    • Limit: The Results in Table option exports all results currently visible in the table. All Results will export every result fetched by the query. By selecting Custom, you can define a cutoff row for the download, e.g., inputing 5000 for the Row option under Custom would result in a download of the first 5000 records.
    • Filename: The filename. We recommend choosing something as descriptive as possible.
  3. Download the File: Once you have specified the desired options, you can now download the file. Clicking Open In Browser will open a new tab containing the data in the specified format, while clicking Download will begin a download of the data.

  4. Upload to Audience Lists (Optional): Once you have downloaded the data, you may process or analyze it as you see fit. If you have downloaded a CSV of device identifiers, you may target those devices via our Audience List feature. For information on uploading a CSV for future targeting, please see our Audience List documentation.

Example: Export a List of Converted Users

In this section, we generate a list of users that either interacted with a notification or rich message.

Notifications

We are going to generate a list of users that directly opened a specific push notification.

  1. Select the Relevant Message: Navigate to the Top 50 Notifications sent report under the Messages Dashboard. Once there, find the message you wish to examine, right-click on the Direct Opens metric, and open the link in a new tab:
  2. Download the Data: From here, you can generate a downloadable file by following the process outlined above.

Rich App Pages

We are going to generate a list of users that directly opened a specific rich message.

  1. Select the Relevant Message: Navigate to the Messages Dashboard. Once there, scroll to the Top 50 Rich App Pages report, find the message you wish to analyze, right-click on the Rich Pushes Read Count metric, and open the link in a new tab:
  2. Edit the Date Range: Under the Filters section, you should see Rich Pushes Occurred Date. Set this to be on or after the day before the message send date, e.g.:

    This configuration is necessary if you would like to ensure you capture rich message reads occurring in every timezone. Click the Run button to refresh the query.

  3. Download the Data: Generate a downloadable file by following the process outlined above.

Ad IDs

Please visit our Ad IDs topic guide for use cases and technical details.

Your app must send the limit ad tracking field from your app and 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.

We are going to generate a list of Ad IDs for users that made a purchase.

  1. Select the purchase event: Navigate to the Revenue Dashboard. Once there, scroll to the bottom to the Custom Events Table report, right-click on the purchased count metric, and open the link in a new tab:
  2. Switch To Ad IDs: Add Platform from the Custom Event category, then under the User IDs category, you should see Ad ID and Limit Ad Tracking Enabled. Click on Device ID to unselect it, and click on Ad ID and Limit Ad Tracking Enabled to add them to the table. Make sure to filter Limit Ad Tracking Enabled to equal No for Ad related targeting. e.g.:
  3. Download the Data: Generate a downloadable file by following the process outlined above.

  4. Create a custom audience on Facebook: To create a look a like audience or custom audience you will need to upload the file from the previous step in to Facebook. Follow the instructions here.