Open navigation

How to use custom fields in your reporting

You can use custom fields in your reporting in the same way as you'd use any other data source. Learn more about use cases for custom fields and the transformations you can apply to them.


If your custom field isn't showing up, refresh the list of available fields.


Instructions

Add a custom field to your report

Google Sheets
  1. Open the Supermetrics sidebar in Google Sheets.
  2. Select the data source you've created the custom field for.
  3. Select the custom field  — find it under Select metrics or Split by in the Custom fields section, depending on the type of field you've created.
  4. Select other query options.
  5. Click Get data to table.
Excel
  1. Open the Supermetrics sidebar in Excel.
  2. Select the data source you've created the custom field for.
  3. Select the custom field  — find it under Select metrics or Split by in the Custom fields section, depending on the type of field you've created.
  4. Select other query options.
  5. Click Get data.
Looker Studio
  1. On Looker Studio, click Add data to add the data source you've created the custom field for. If necessary, connect to the data source. Take a look at our connection guides for more information.
  2. Select the data source. 
  3. Under Custom fields, select the field you've created.
  4. Select other query options and chart type.
The Supermetrics API (Query Manager)
  1. On the Supermetrics Hub, go to API.
  2. Select the data source you've created the custom field for and a connection to use.
  3. From the Query sidebar, select the custom field — find it under Select metrics or Split by in the Custom fields section, depending on the type of field you've created.
  4. Select other query options.
  5. Click Run to run the query.
Data warehouse

To use a custom field with data warehouse destinations, use the Query Manager to create a custom table group that includes the custom field. Learn more about creating custom table groups.


Modify a custom field

  1. On the Supermetrics Hub, go to TransformCustom fields
  2. In the list of custom fields, click the 3-dot menu under Actions, and click Modify.
  3. Expand the custom field details by clicking the chevron icon.
  4. Make your adjustments, and click Done.
  5. Click Done to save your changes.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.