Harmonizing data

This guide explains how to harmonize your data so that it conforms to Adverity's unified naming and formatting conventions.

Introduction

Apply Schema Mapping to a Datastream to map source fields to target fields that conform to Adverity’s unified naming and formatting conventions.

Ensure that you map all source fields that you intend to work with later in a Destination like Explore & Present to target fields. Only source fields that you map to a target field are transferred to the Destination.

This guide uses the example of a Facebook Ads Datastream. The procedure described below is similar in all other Datastreams.

This guide explains how to configure basic Schema Mapping for your Datastreams. For more information on configuring advanced Schema Mapping, see Configuring advanced Schema Mapping.

Concept

The data you collect from different sources often follow different naming and formatting conventions, and use different names for the same thing. This difference in format makes it difficult to make sense of your data.

Adverity harmonizes data from different sources by applying unified naming and formatting conventions. Adverity maps source fields, which often have different names for the same concept, to target fields, which have a specific meaning in Adverity. This is called Schema Mapping in Adverity.

For example, total cost is called spend in Facebook Ads and cost in Google Ads. You can create the costs target field in Adverity and map both source fields to this target field. As a result, both of these source fields will be displayed using the field name costs in Adverity.

Schema Mapping also defines if a field is a metric or a dimension. For more information on metrics and dimensions, see Managing tables.

Prerequisites

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

Viewing current Schema Mapping

To view the Schema Mapping currently applied for your Facebook Ads Datastream, follow these steps:

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

  1. Select the Facebook Ads Datastream.

  1. In the top navigation panel, click Schema Mapping.

In the Schema Mapping, the Source fields column displays the original names of the source fields. The Target fields column displays the field names you want to choose instead of the source field names. When you apply the Schema Mapping, Adverity maps the source fields to the target fields.

The colors in the Target fields column indicate the following:

  • A green value in the Target fields column means that the source field is mapped to a metric.

  • A blue value in the Target fields column means that the source field is mapped to a dimension.

  • An empty value in the Target fields column means that the source field is unmapped. Adverity does not transfer unmapped fields to the Destination.

Applying Adverity's default Schema Mapping

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

To apply Adverity's default Schema Mapping for your Facebook Ads Datastream, follow these steps:

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

  1. Select the Facebook Ads Datastream.

  1. In the top navigation panel, click Schema Mapping.

  1. Click Restore Defaults.

The schema mapping changes are saved automatically.

Applying custom Schema Mapping

To apply custom Schema Mapping for your Facebook Ads Datastream, follow these steps:

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

  1. Select the Facebook Ads Datastream.

  1. In the top navigation panel, click Schema Mapping.

  1. For each cell of the Target fields column, write the value displayed in the Target fields column in the table below, and select that value from the drop-down list.

    In the Target fields column, some fields may already be populated. If this happens, replace the value in the Target fields column with the relevant value from the table below.

    Source fields

    Target fields

    campaign_name

    campaign_name

    date_start

    day

    impressions

    impressions

    spend

    costs

The schema mapping changes are saved automatically.

What’s next?

After collecting and harmonizing your data, transfer it to a Destination to store and further process the data.