---
title: "How to use custom fields in your reporting"
slug: "how-to-use-custom-fields-in-your-reporting"
description: "Learn how to use custom fields in Supermetrics for Google Sheets, Excel, Looker Studio, Power BI, and more to enhance your reporting capabilities."
updated: 2026-05-06T11:47:17Z
published: 2026-05-06T13:30:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/v1/docs/about-supermetrics-custom-fields).

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. Click **Create new query**.
3. Select the data source you've created the custom field for.
4. 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.
5. Select other query options.
6. Click **Get data**.

****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**.

****Data Studio****

1. On Data 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 data source guides](/v1/docs/connect) 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.

****Power BI****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Power BI** under **Analyze**.
2. Click **New query** or select an existing query to modify.
3. Select the data source you've created the custom field for and a connection to use.
4. 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.
5. Select other query options.
6. Click **Preview** to test the query.
7. Click **Save** to add the query to a query group.

****The Supermetrics API (Query Manager)****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
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](/v1/docs/how-to-create-a-custom-table-group-formerly-custom-schema).

### Modify a custom field

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Custom fields** under **Manage**.
2. In the list of custom fields, select a custom field to modify.
3. Make your adjustments, and click **Review changes**.
4. Click **Save custom field** to save your changes.