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.
|APPEND_RESULTS||Combine new data with old data without updating the old results, and add a "Fetch data" column.|
Replace blank or null values with zeroes.
|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 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.|
Show the start date of a month or week.