Supermetrics includes a wide variety of advanced settings for Google Sheets.
Add any advanced setting to your query by navigating to Options and then Advanced settings in the Supermetrics sidebar.
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. |
| BLANKS_TO_ZEROS | Replace blank or null values with zeroes. |
| 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. |
| GET_PROMOTABLE_POSTS | Identify posts that can be promoted on Facebook. |
| INCLUDE_ALL_PUBLISHED_POSTS | Fetch all Facebook Insights posts that match the query. |
| INCLUDE_UNPUBLISHED_PROMOTABLE_POSTS | Fetch Facebook “dark posts,” which are targeted ads on social media that don’t appear on a timeline. |
| 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. |
| 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. |
| 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. |