---
title: "About Supermetrics advanced settings for Excel"
slug: "about-supermetrics-advanced-settings-for-excel"
description: "Learn more about the advanced settings Supermetrics provides for Excel s users."
updated: 2025-09-05T12:49:26Z
published: 2025-09-05T12:49:26Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# About Supermetrics advanced settings for 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 |
| --- | --- |
| 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. |
| 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_ZEROS_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. |
| TIME_DIMENSION_FORMAT_m-y | Allows custom date formats. |
| 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. |