Two Minute Reports Logo
Custom fields

Blending across connectors

Map the same field from each of your connectors 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 connectors into a single unified custom field. A cross-platform chart or goal can then use one field.

What you can do

  • Combine one field per connector 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 connector its own field or its own formula

How blending works

When you choose Blending, you select the connectors to include. Then you tell the field which field to use for each connector.

For each selected connector, you can map either:

  • A single field - pick the equivalent field from that connector, or
  • A formula - turn on Set formula to build a calculation for that connector (and even add conditional rules for it)

Metrics are summed

For a custom metric, the values from each connector 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 connector'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, whichever 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.

Set it up

Choose the method

In the builder, select Blending. Then select Next.

Select your connectors

Under Select connectors, choose the connectors this field should span.

Map each connector

For every selected connector, map the field (or build a formula) that represents this value on that platform. Each selected connector 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 connectors you mapped. Rows from a connector you didn't map fall back to the field's fallback value.

Next steps

Copyright © 2026