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 define target fields for all source fields that you intend to work with later in a Destination like Explore & Present. Only source fields for which you define 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. Adverity applies the field name costs for both.

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. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the Facebook Ads Datastream.

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

In the Schema Mapping, the Name column displays the original names of the source fields. The Target 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 Name column displays the original names of the source fields. The Target column displays the new field names. When you apply the Schema Mapping, Adverity maps the source fields to the target fields.

The colors in the Target column indicate the following:

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

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

  • An empty value in the Target 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. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the Facebook Ads Datastream.

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

  1. Click Restore Defaults.

  2. Click Save Mapping.

Applying custom Schema Mapping

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

  1. Click the Connect element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. Select the Facebook Ads Datastream.

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

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

    Name

    Target

    campaign_name

    campaign_name

    date_start

    day

    impressions

    impressions

    spend

    costs

  2. Click Save Mapping.

What’s next?

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