Two Minute Reports Logo
Custom Fields

Blending Across Sources

Map the same field from each of your data sources into a single unified custom field, summed for metrics or unified into one column for dimensions.

Every platform names its fields differently, "amount spent" on one, "cost" on another. The Blending method lets you map the equivalent field from each of your data sources into a single unified custom field, so a cross-platform chart or goal just works.

What You Can Do

  • Combine one field per data source into a single unified field
  • Build unified metrics like total Spend, Impressions, or Clicks across platforms
  • Build unified dimensions like a single Campaign Name, Ad Group, or Country column
  • Give each source its own field or its own formula

How Blending Works

When you choose Blending, you select the data sources to include, then tell the field which field to use for each source.

For each selected source, you can map either:

  • A single field - pick the equivalent field from that source, or
  • A formula - build a per-source calculation (and even add conditional rules for that source)

Metrics Are Summed

For a custom metric, the values from each source are added together into one total. Mapping "amount spent" from Meta, "cost" from Google, and "spend" from TikTok gives you a single blended Spend metric across all three.

Dimensions Are Unified

For a custom dimension, each source's mapped field flows into one unified column. Mapping each platform's campaign-name field produces a single "Campaign Name" dimension you can group by, regardless of which platform a row came from.

Blending is what makes cross-channel dashboards clean: one "Spend" metric and one "Campaign Name" dimension instead of a separate field per platform.

Setting It Up

Choose the Method

In the builder, pick Blending and continue to configuration.

Select Your Data Sources

Choose the data sources this field should span.

Map Each Source

For every selected source, map the field (or build a formula) that represents this value on that platform. Each selected source must be mapped before you can save.

Preview and Save

Use the live preview to confirm the blended values look right, then save.

A blended field only produces values for the sources you mapped. Rows from an unmapped source fall back to the field's fallback value.

Next Steps

Copyright © 2026