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
- Open the Supermetrics sidebar in Google Sheets.
- Click Create new query.
- Select the data source you've created the custom field for.
- 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.
- Select other query options.
- Click Get data.
Excel
- Open the Supermetrics sidebar in Excel.
- Select the data source you've created the custom field for.
- 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.
- Select other query options.
- Click Get data.
Looker Studio
- 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.
- Select the data source.
- Under Custom fields, select the field you've created.
- Select other query options and chart type.
Power BI
- On the Supermetrics Hub, go to Destinations → Power BI.
- Click New query or select an existing query to modify.
- Select the data source you've created the custom field for and a connection to use.
- In the sidebar, select the custom field — find it under Metrics or Dimensions in the Custom fields section, depending on the type of field you've created.
- Select other query options.
- Click Preview to test the query.
- Click Save to add the query to a query group.
The Supermetrics API (Query Manager)
- On the Supermetrics Hub, go to API.
- Select the data source you've created the custom field for and a connection to use.
- 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.
- Select other query options.
- 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
- On the Supermetrics Hub, go to Transform → Custom fields
- In the list of custom fields, select a custom field to modify.
- Make your adjustments, and click Review changes.
- Click Save custom field to save your changes.