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 rename the extracted values to friendlier labels

How split text works

You point Split text at a source dimension. Then you 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

You can also select a segment in the preview to use its position.

For US_Brand_Search_2024 split on _:

PositionValue
1US
2Brand
3Search
42024

So Fragment position 2 extracts Brand.

Rename values (optional)

The extracted fragments are often codes rather than readable labels. Use the optional Rename values table to rename them. Map each Original value to a New value.

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

Renaming values is also useful to combine variants. Map br, brand, and Brand all to a single "Branded" label.

Set it up

Choose the method

In the dimension builder, select Split text. Then select Next.

Configure the split

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

Rename values (optional)

Select Add to add a row to the Rename values table. Enter an extracted code and the label to show instead.

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