Supermetrics features a wide range of advanced settings for reports created in Excel. This reference list describes the settings and what they allow you to do.
To enable any of these settings, open the Supermetrics sidebar, click Options, navigate to the Advanced setting field, and write the advanced setting's name (with no extra whitespace) in the field.
The settings you choose will only be applied to the query you selected before clicking into Options.
Replaces blank metric values with zeroes.
Recommended when your query results in formulas.
|DIMENSIONS_MAX_LENGTH_X||Shortens the dimension value to X length (added by default in Google Sheets to truncate long values from dimensions to avoid errors).|
|GET_PROMOTABLE_POSTS||Identifies only the posts that are eligible for promoting on Facebook.|
|INCLUDE_ALL_PUBLISHED_POSTS||Fetches all Facebook Insights posts that match the query. Learn more about this setting and why it’s useful.|
|INCLUDE_PUBLISHER_NETWORK||Includes Twitter Audience Network in the query.|
|INCLUDE_ZERO_IMPRESSIONS||Display all campaigns with zero impressions in Google Ads, including campaigns that haven’t started yet.|
|NO_DIMENSIONS||Will display dimensions without their headers.|
|NO_METRIC_HEADER_COLUMN||When fetching only metrics in a query with Facebook Ads, it does not include row headers in the result set.|
|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.|
|RETURN_ZEROES_WHEN_NO_DATA||Will return "0" instead of "No data found" when a query doesn't find data.|
|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.|
Allows replacing the dimension "m-y" with the format that you want. Learn more about this setting and when to use it.
Shows the start date of a month or week. Use this if you want to make reports where the starting date of a week or month is displayed instead of the week/month number.