Open navigation

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 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 (,).


Advanced settingDescription
APPEND_RESULTSCombine 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_NOTEDisplays the query date range (and comparison date range, if used) above the results table.
DIMENSIONS_MAX_LENGTH_XShorten 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_DATAWill 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.
SAMPLING_RATE
Google Analytics only: Show what percentage of your data has been sampled. Returns “Unsampled” if Google Analytics hasn’t sampled any data.
SKIP_QUERY_REFRESHDon'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
Allow for custom date formats.
TIME_DISP_START_DATE

Show the start date of a month or week.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.