How-To: Update datasource dimensions and metrics

Overview

A dimension column, labeled in blue, will be a column you would like to keep in the database even when a new file is received.  Metrics will be updated as dimensions come in. This only applies to datasources that are set to “Add and update” in the Advanced Settings tab of a datasource. If the datasource is set to “Replace”, then only the newest file’s data will populate the datasource. To check if your datasource is set to Add and update:

To expand a little more with a few examples, a dimension is static and doesn’t change (ids, names, platform, device) and a metric is a thing that is updated with fresh data (like impressions, clicks, revenue).

For example:

Current Data

New File

When the dimensions are set as Campaign and Adgroup, Datawarehouse will merge the new file into the current table as follows:

Notice how PMG~TestCampaign~Prospecting stayed in the database unharmed, and the Evergreen campaign was updated to include the new 300 impressions number.

Related articles