Transferring data to Explore & Present

This guide explains how to transfer data to Explore & Present to store and further process information.

Introduction

Explore & Present is an Active Destination. After you set Explore & Present as the Destination of a Datastream, data is transferred to Explore & Present each time data is fetched for the Datastream. For more information, see Destination types.

You can assign multiple Destinations to a Datastream. For more information on possible limitations, see Assigning multiple Destinations to a Datastream.

To transfer data from a Datastream to Explore & Present, choose one of the following options:

  • Transfer data to one Workspace. All data from the Datastream Workspace is transferred to the same Explore & PresentWorkspace. This is the default and easiest option explained in this guide.

  • Transfer data to multiple Workspaces. Rows from the Datastream Workspace are transferred to many different Explore & Present Workspaces.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a Datastream whose data you want to transfer to Explore & Present. For more information on creating a Datastream, see Introduction to collecting data.

  • Make sure the length of each field name in the Data Extract is no longer than 60 characters.

  • Make sure the length of each dimension value in the Data Extract is no longer than 2,700 characters.

  • In Schema Mapping, perform the following actions:

    • Map at least one dimension to a target field.

    • Map at least one metric to a target field.

    • Map exactly one field with the data type Date to the target field day. Ensure the dates in this field use the ISO 8601 format YYYY-MM-DD. Ensure no other fields are mapped with the data type Date. For more information on mapping a data type to a target field, see Mapping a source field to a target field.

    • Ensure there are no fields mapped to the data type DateTime. Explore & Present does not support the data type DateTime. To transfer fields with date data to Explore & Present (for example, campaign start date), map these fields to the data type String. For more information on how to change a field's data type, see Editing a target field.

Procedure

To transfer data from a Datastream to one Explore & Present Workspace, follow these steps:

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

  1. Select the chosen Datastream.

  1. In the Destinations section, click + Add Destination.

  2. Click Assign Existing Destinations.

  1. Select the Explore & Present checkbox in the list.

  2. Click Save.

  1. In the Destinations section, find the Explore & Present Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. In the Explore & Present Workspace field, select the Workspace that you use in Explore & Present.

    You can only select Workspaces in Explore & Present. You cannot select Workspace Groups because they do not store data. For more information on managing Workspaces in Explore & Present, see Creating and configuring Workspace Groups.

  1. Click Save.

  1. In the list in the Destinations section, find the Explore & Present Destination, and enable the toggle.

  2. In the All tasks tab, find the top element, and click Requeue for Import on the right.

Configuring transfer settings

To configure transfer settings, follow these steps:

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

  1. Select the chosen Datastream.

  1. In the Destinations section, find the Explore & Present Destination in the list, and click on the right.

  2. Click Destination Settings.

  1. Fill in the following fields:

    Date Range

    Select the column in your Data Extract that contains the dates.

    Mediaplan

    Select this checkbox to treat Data Extracts as media plans in Explore & Present. This option is only available if Explore & Present is the only Destination assigned to the Datastream. For more information, see Using the Plan page.

    Filename

    Select this checkbox to overwrite the relevant data in the Destination if a Data Extract with the same filename already exists in the Destination.

    Key Columns

    Select this checkbox to overwrite data in the Destination based on the key columns defined in the Schema Mapping of the Datastream. Adverity executes this overwrite option after all the other overwrite options. When you select this checkbox, the configuration to overwrite data based on dates does not have an effect.

  2. Click Save.