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.


Advanced settingDescription
APPEND_RESULTSCombine new data with old data without updating the old results, and add a "Fetch data" column.
BLANKS_TO_ZEROES

Replace blank or null values with zeroes.

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 dimension headers.
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.
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.
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.