Exporting Lists Tutorial

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

What You’ll Do

In this tutorial, you will:

  1. Export report data:

    1. Navigate to a report you would like to download.
    2. Specify file format, values, and limits.
    3. Enter the file name.
    4. Download the file.

  2. Follow steps to export specific types of report data.

Steps

Export Data

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

  1. Navigate to a report you would like to download.

  2. Click the gear icon and select Download….

  3. Specify Download Options.
    • File Format: The format of the download: TXT, Excel Spreadsheet, CSV, JSON, HTML, Markdown, or PNG (Image of Visualization).
    • 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.
  4. Click the Download button and save the file. If you’d like to view the data in the browser instead, click the Open in Browser button, and it will open in a new browser tab.

Notifications

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

  1. Navigate to the Messages dashboard.

  2. In the Top 50 Notifications sent report, locate the row for the Message you want to analyze, then click its value in the Direct Open Count column.

  3. Download the data as described in Export Data.

Rich App Pages

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

  1. Navigate 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 timezone.

  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.

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. Navigate to the Revenue dashboard.

  2. In the Custom Events Table report, locate the purchased row, then click its value in the Custom Events column.

  3. In the window that pops up, click the Explore From Here button.

  4. From 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 rows for Ad ID
    • Click the Filter button for Limit Ad Tracking Enabled to add the row to the Filters menu, then set the value of is equal to to “No.”
  5. Download the data as described in Export Data.

  6. Create a custom audience on Facebook. (Optional) Follow Facebook’s instructions 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 target specific users via Audience List. First, follow these steps to download a CSV of device identifiers. Second, follow the steps in the Uploaded List Tutorial, using the file you just downloaded.

This example downloads all your Daily Active Users,

  1. Navigate to the Overvue dashboard.

  2. In the Daily Active Users report, click the number.
  3. In the overlay that appears, click the Explore from Here button.
  4. Download the data as described in Export Data with these values:

    • File Format: CSV
    • Values: Unformatted
    • Limit: All Results