Default Data Mapping

This guide provides an overview of Adverity's Default Data Mapping and how to apply it to your datastreams.

Introduction

Default Data Mapping automatically maps source fields to target fields. Adverity provides Default Data Mapping for the most commonly used source fields for a number of connectors. You can configure Default Data Mapping for any source field that you have fetched in Adverity.

This saves you time when creating new datastreams and ensures that all datastreams that fetch data from the same data source use the same Data Mapping.

Viewing your Default Data Mapping

To view your Default Data Mapping, follow these steps:

1. Go to the Data Dictionary page.

2. Under the page heading, click Default Data Mapping.

Configuring your Default Data Mapping

After you have successfully created a datastream and fetched data from a data source in Adverity, a column named after the data source will appear in the Default Data Mapping. This column contains the source fields you have fetched from this data source.

To configure Default Data Mapping for this data source, follow these steps:

1. Go to the Data Dictionary page.

2. Under the page heading, click Default Data Mapping.

3. In your chosen data source's column and in the row containing the target field for which you want to define Default Data Mapping, click Select.....

4. In the drop-down menu, select the source field that you want Adverity to automatically map to this target field in future.

As a result, you have successfully mapped your selected source field to the target field in this row.

For example, if you select the source field views in the column for Wikipedia and the row containing the full_views target field, Adverity will automatically map views to full_views in all future Wikipedia datastreams that contain this source field.

Importing Default Data Mapping

To set the Default Data Mapping for multiple columns at once, import your Default Data Mapping from a file.

To import Default Data Mapping, follow these steps:

1. Go to the Data Dictionary page.

2. Under the page heading, click Default Data Mapping.

3. Click Actions .

4. Click Import Default Data Mapping.

5. In the pop-up window, download a sample file and add your Data Mapping to it. For more information about the required file format, see Creating a Default Data Mapping import file.

6. Select the file that you want to import.

7. Once the file import is completed, you will get one of the following results:

   • Default Data Mapping imported successfully

     Upon successful import, the new Default Data Mapping will be automatically applied to all new datastreams.

     However, it will not affect the existing datastreams by default. To apply the imported Default Data Mapping to existing datastreams, click Restore defaults in the datastream's Data Mapping settings.

   • Default Data Mapping import failed

     Default Data Mapping import might fail because of errors in the uploaded file. All detected issues are added to your imported file in the Conflict column.

     To continue, follow these steps:

     1. Click Download file.

     2. Fix the errors marked in the file.

     3. Delete the Conflict column.

     4. Upload the corrected file again.

Creating a Default Data Mapping import file

The Default Data Mapping import file should contain new target fields and new configurations for Default Data Mapping. The contents of the file should not modify the existing target fields and Default Data Mapping.

When creating a Default Data Mapping import file, follow these rules:

• Download a sample xlsx file.

• Define new target fields in the Schema tab using the following columns:

  Adverity Data Mapping	Enter the name of your target field.
  Data Type	Enter the data type of your target field. For more information, see Data types used in Adverity.
  Measure	Enter the measure for your target field or leave this column empty. For more information, see Measures used for metrics in Adverity.

  It is possible to add existing target fields to the file, however, their data type and measure should match their configuration in the Data Dictionary. Target fields cannot be modified during Default Data Mapping import. Adding an existing target field with incorrect configuration will result in an error.

• Define new Default Data Mapping configuration for data sources in the Mappings tab using the following columns:

  Source	Enter the name of the data source for which you are defining the Data Mapping.
  Adverity Source Column	Enter the name of the source field that you want to map.
  Adverity Data Mapping	Enter the name of the target field to which you want to map the source field.
  Adverity Source	Enter the abbreviation of the data source name used in Adverity.

  The Default Data Mapping import will fail in the following cases:

  • Adding an existing Default Data Mapping configuration.

  • Setting the mapping to a target field that does not exist.

  • Adding new Default Data Mapping for a source or target column for which a different Data Mapping already exists.

Applying Adverity's Default Data Mapping to a datastream

Adverity's Default Data Mapping maps source fields to target fields in a way that works for most Adverity users. Using the Default Data Mapping, you do not need to map source fields to target fields manually.

To apply Adverity's Default Data Mapping to a datastream, follow these steps:

1. Go to the Datastreams page.

2. Select the datastream to which you want to apply the Default Data Mapping.

3. In the top navigation panel, click Data Mapping.

4. Click Restore defaults.

As a result, any changes you have made in the Data Mapping tab will be replaced with Adverity's Default Data Mapping.