Supermetrics Support Forum

Advanced Settings for Google Sheets

This guide gives you a list of the advanced settings available for Google Sheets. This list is not exhaustive but will be updated over time to include all the advanced settings we support. 


To enable the advanced settings, please click on "Advanced Settings" under "Options", as in the screenshot below. 



Custom OptionsDescription
Use CasesReferences
BLANKS_TO_ZEROES
Replaces blank metric values with zeroes.
Recommended when your query results in formulas.
DISABLE_DIMENSION_AUTOFORMAT
Prevents Google from applying any automatic formatting.
Recommended when there is a problem with
big numbers being converted to exponent expressions, for example with 1.23833E+15 when the actual number is 1238327606297850.

GET_PROMOTABLE_POSTS
Identifies only the posts that are eligible for promoting on Facebook.
Recommended for fetching posts that can be promoted. 
INCLUDE_ALL_PUBLISHED_POSTS
Fetches all Facebook Insights posts that match the query.
Recommended if you encounter post level discrepancies. More information can be found here
INCLUDE_UNPUBLISHED_PROMOTABLE_POSTS
Fetches the Facebook dark posts. Dark posts are targeted ads on social media. Unlike boosted and organic posts, though, they don't appear on your timeline.
Recommended if you want to make targeted ads. 
INCLUDE_ZERO_IMPRESSIONS
Display all the campaigns with zero impressions in Google Ads.
Recommended if you want to look up for ads that are not yet active.

NO_DIMENSIONS
Does not display dimension headers.
Recommended if you want to create a query without headers, or for example, it allows you to insert custom headers in a different language than English.

NO_METRIC_HEADER_COLUMNWhen fetching only metrics in the query with Facebook Ads, it does not include row headers in the result set.
Recommended if you don't want to have headers in your report where you fetch only metrics without dimensions. 
RETURN_NO_DATA_RESULT
Stores queries even if no data is returned.
Recommended if you want to create a query with campaigns that have no data but could change and evolve in the future.More information can be found here
ROUND_METRICS_TO_XRounds the numbers to the amount of decimals you want, for example, 0 or 2. Inserts a number instead of X.  
Recommended if you want to have a more appealing and visual report with your choice of decimals. 
STORE_ERROR_QUERY
Stores the query even with errors to the sheet.
Recommended if you want to save a query even if errors are present. 
TIME_DIMENSION_FORMAT_m-y
Allows replacing the dimension "m-y" with the format that you want.
Recommended if you want a specific format in the dimension. More information can be found here
TIME_DISP_START_DATE
Shows the start date of a month or week instead of for example m|Y.Recommended if you want to make reports where the starting date of a week or month is displayed instead of the week/month number. 
KEEP_RESULTS_ON_REFRESH_ERROR
Keeps the old results in a sheet when the query throws an error.Recommended for keeping old results in your queries instead of displaying an error message. 
DIMENSIONS_MAX_LENGTH_X
Shortens the dimension value to X length (added by default to truncate long values from dimensions to avoid errors by the 50K cell character limit in Google Sheets).
Recommended if you want to avoid errors from any data response including more than 50k characters would cause.
APPEND_RESULTS
Combines new data with old data without updating the old results. It also adds "Fetch data" column. Recommended for rolling reports with metrics that are incompatible with time dimensions, for example, Instagram followers.


Did you find it helpful? Yes No

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