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. |
| 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. |
| 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. |
| SKIP_QUERY_REFRESH | Don't update this query when you refresh this report (either manually or with a scheduled refresh). |
| 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. Learn more about this setting and when to use it. |
| TIME_DISP_START_DATE | Show the start date of a month or week. |