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 Options||Description||Use Cases||References|
|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_COLUMN||When 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_X||Rounds 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.|
|SAMPLING_RATE||If the Google Analytics query has been sampled, it will show what percentage of the data was sampled at the top of the data set. Otherwise, it will report as UNSAMPLED.||Recommended if you are unsure how aggressively the data was sampled, to help ensure accuracy and understanding of what the data represents.|