Custom fields
Custom fields let you create metrics and dimensions that match your business logic, instead of being limited to the fields each platform provides. Define a calculation once, and reuse it everywhere.
A custom field can be a formula (like CPA or ROAS), a conditional rule (label a value based on what it contains), a blend of the same field across several connectors, or text split out of a naming convention. Custom fields are saved to your team and become available in the field pickers across your dashboards and goals.
What you can do
- Create custom metrics (numeric) and custom dimensions (text or categories)
- Build calculations from fields, numbers, and math operators
- Apply conditional rules to categorize, label, or transform values
- Blend one field across multiple connectors into a single unified field
- Split a dimension by a delimiter and extract just the part you need
- Preview results against real account data before saving
- Reuse every custom field across your dashboards and goals
Metrics vs. dimensions
Custom fields come in two kinds. Each kind has its own tab on the Custom fields page:
- Custom metrics are numbers you measure and can do math on, for example cost per acquisition, return on ad spend, or a blended spend total.
- Custom dimensions are text or categories you group and filter by, for example a channel grouping, a cleaned-up campaign label, or a region extracted from a campaign name.
Build methods
The methods available depend on the kind of field you're creating:
- Custom metrics can use Formula or Blending.
- Custom dimensions can use Formula, Blending, or Split text.
| Method | Metrics | Dimensions | Use it to |
|---|---|---|---|
| Formula | Yes | Yes | Metrics: do math on fields. Dimensions: combine fields and text into a label. |
| Blending | Yes | Yes | Map one field per connector into a single unified field |
| Split text | No | Yes | Split a value by a delimiter and extract a specific fragment |
Formula works differently for each kind. For a metric, it's an arithmetic expression with math operators (+ - * / % ^ and parentheses), for example Spend / Conversions. For a dimension, there are no math operators. You combine fields and text into a label instead.
Conditional rules are not a separate method. They're an option you turn on inside a Formula field (metric or dimension) to return a value only when conditions match, for example "when the campaign name contains 'brand', then…". See Formulas and conditions for details.
Built-in fields
Alongside the fields you create, the Custom fields page lists built-in fields under Built-in fields. These are fields Two Minute Reports provides that combine data across connectors, such as CTR, CPC, and ROAS. You can open them to see how they're defined, but they're read-only. You can't edit or delete them.
Built-in fields include metrics and dimensions. For example, Campaign name and Campaign ID show the campaign names and IDs of all your ad connectors in one column. In the Google Sheets add-on, the same fields are under Common Fields in the field list.
Explore custom fields
Next steps
- Create your first custom field - Walk through the builder
- Use custom fields in dashboards - Add them to charts and tables
- Track goals with custom metrics - Set targets on your own KPIs