Two Minute Reports Logo
Custom Fields

Split Text

Split a dimension value by a delimiter and extract a specific fragment, ideal for pulling region, channel, or strategy out of a campaign naming convention.

Many teams encode information in campaign names, like US_Brand_Search_2024. The Split Text method pulls a specific part out of a value so you can group and report on it. Split Text is available for custom dimensions only.

What You Can Do

  • Split a dimension value by a delimiter (like _ or -)
  • Extract a specific fragment by position
  • Optionally remap the extracted values to friendlier labels

How Split Text Works

You point Split Text at a source dimension, tell it how the value is delimited, and which piece to keep.

Configure:

  • Source Dimension - the field to split (for example, Campaign Name)
  • Delimiter - the character the value is split on (defaults to _)
  • Fragment Position - which piece to keep, counted from 1

For US_Brand_Search_2024 split on _:

PositionValue
1US
2Brand
3Search
42024

So Fragment Position 2 extracts Brand.

Value Mapping (Optional)

The extracted fragments are often codes rather than readable labels. Use the optional Value Mapping table to rename them, mapping each Original Value to a New Value.

For example, map US → United States, UK → United Kingdom, so your reports show clean, presentable labels instead of raw codes.

Value mapping is also handy for consolidating variants, map br, brand, and Brand all to a single "Branded" label.

Setting It Up

Choose the Method

In the dimension builder, pick Split Text.

Configure the Split

Select the source dimension, set the delimiter, and choose the fragment position.

Map Values (Optional)

Add rows to the value mapping table to turn extracted codes into readable labels.

Preview and Save

Use the live preview to confirm the right fragment is extracted, then save.

If a value doesn't contain the requested fragment position, the row uses the field's fallback value.

Next Steps

Copyright © 2026