Previewing data extracts

This guide explains how to view and download your data extracts.

When you have collected your data, you can view the data extract in the datastream overview page. The data extract shows the data after enrichments have been applied. To view the data in a raw state, disable any enrichments applied to the datastream and run the fetch again.

Previewing data extracts

To preview the collected data, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Activity.

  2. In the All tasks tab, in the list of tasks, find the data fetch whose data you want to preview, and click Show extracts.

  3. In the list, find the data extract you want to preview, and click the hyperlinked element.

  4. You are then navigated to the data extract, which is displayed in a table containing the data that you have fetched.

The header row of the table shows the field names contained in the data extract. These names are displayed with a gray background. If a source field is mapped to a target field, the name of the mapped target field is also displayed in the header row. Dimensions have a blue background and metrics have a green background. In the header row, you can map an unmapped source field to a target field, or change the target field to which a source field is mapped. To do so, see Mapping target fields in the Data Extract preview.

One of the possible tags displayed on your Data Extract is the Overwritten tag. This means there is a newer version of the same data included in another task. If you refetch data for the same task, the Overwritten tag is displayed on your old data extract. This tag can be more frequent for the Unique by day setting in Local Data Retention. If Unique by day is enabled for your datastream, data from each day of the date range is entered into a separate data extract. If you refetch data for the same date, the data on the overlapping days is overwritten. To configure a Unique by day data collection, see Configuring unique by day data collection.

Downloading data extracts

To download a data extract, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Activity.

  2. In the All tasks tab, find the task whose data you want to preview, and click Show extracts.

    Reminder: A task is a data fetch.

  3. In the list, find the data extract you want to download, and click the hyperlinked element.

  4. In the row of options above the data extract, click Download .

  5. Choose one of the following options:

    • Download Raw File - Click this option to download the file containing the data as it was collected.

    • Convert to CSV (.csv)

    • Convert to JSON (.json)

    • Convert to Excel (.xlsx)

As a result, you have downloaded a copy of your data extract in the selected format.

Configuring unique by day data collection

To fetch data uniquely by day, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  1. Select the Connector Name datastream.

  1. In the top navigation panel, click Local Data Retention.

  2. In the Extract Filenames section, select Unique by day.

  3. Click Save.

As a result, you can now collect your data and a data extract is created for each day of the date range for the data fetch.