---
title: "About Supermetrics advanced settings for Google Sheets"
slug: "about-supermetrics-advanced-settings-for-google-sheets"
description: "Learn more about the advanced settings Supermetrics provides for Google Sheets users."
updated: 2026-09-04T12:26:19Z
published: 2026-09-04T12:26:19Z
canonical: "docs.supermetrics.com/about-supermetrics-advanced-settings-for-google-sheets"
---

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

# About Supermetrics advanced settings for Google Sheets

Supermetrics includes a wide variety of advanced settings for Google Sheets.

Add any advanced setting to your query by navigating to **Options** in the Google Sheets sidebar and then adding the setting to the **Advanced settings** field.If you're using multiple advanced settings at once, separate each one with a comma with no whitespace on either side (,).

Note that these settings may not work with all data source connectors.

| Advanced setting | Description |
| --- | --- |
| `APPEND_RESULTS` | Combine new data with old data without updating the old results, and add a "Fetch data" column. [Learn more about the APPEND_RESULTS setting](/v1/docs/how-to-use-the-append-results-setting-in-google-sheets-queries). |
| `BLANKS_TO_ZEROS` | Replace blank or null values with zeroes. This setting is also available as the **Replace blank metric values with zeros** checkbox. |
| `DATES_NOTE` | Displays the query date range (and comparison date range, if used) above the results table.Example: `DATE RANGE: 2024-12-01 to 2024-12-31` |
| `DIMENSIONS_MAX_LENGTH_X` | Shorten dimension values to X length. |
| `DISABLE_DIMENSION_AUTOFORMAT` | Prevent Google Sheets from applying any automatic formatting. |
| `INCLUDE_ZERO_IMPRESSIONS` | Display all campaigns with zero impressions in Google Ads, including ads that aren’t yet active. |
| `KEEP_RESULTS_ON_REFRESH_ERROR` | Store old results even when a newer query refresh includes an error.This setting is also available as the **Keep previous results on refresh error** checkbox. |
| `NO_DIMENSIONS` | Remove dimensions from results. |
| `NO_METRIC_HEADER_COLUMN` | Facebook Ads only: Remove row headers in queries that don’t include dimensions. |
| `RETURN_NO_DATA_RESULT` | Store queries even if they don’t return data. |
| `RETURN_ZEROS_WHEN_NO_DATA` | Will return "0" instead of "No data found" when a query doesn't find data. Note that this setting may not work with all connectors. |
| `ROUND_METRICS_TO_X` | Round numbers to the decimal point you want. Replace “X” with your chosen value.For example, `ROUND_METRICS_TO_4 `will give results in the format 12,3456 instead of the usual 12,35. |
| `SKIP_QUERY_REFRESH` | Disables query refresh (either manual refresh or with a [scheduled refresh](/v1/docs/how-to-create-and-manage-scheduled-refreshes-in-google-sheets)). |
| `STORE_ERROR_QUERY` | Store queries that contain errors. |
| `TIME_DIMENSION_FORMAT_m-y` | Allows replacing the dimension "m-y" with the format that you want. With "m-y" the result will be in a month-year format (mm-yy), for example 12-24. If you change the setting to `TIME_DIMENSION_FORMAT_M d Y` the result will be Dec 24 2024. [Learn more about this setting and when to use it](/v1/docs/about-image-date-and-blank-result-formatting-in-google-sheets). |
| `TIME_DISP_START_DATE` | Show the start date of a month or week. |