Open navigation

About Supermetrics advanced settings in Excel

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.


Advanced settings

Setting name
Function
BLANKS_TO_ZEROES

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.
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.
TIME_DIMENSION_FORMAT_m-y

Allows replacing the dimension "m-y" with the format that you want. Learn more about this setting and when to use it.

TIME_DISP_START_DATE

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.

Did you find it helpful? Yes No

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