---
title: "How to set a custom conversion window in Facebook Ads queries"
slug: "how-to-set-a-custom-conversion-window-in-facebook-ads-queries"
description: "Learn how to set custom conversion windows in Supermetrics for Facebook Ads, optimizing your attribution settings for better campaign insights."
updated: 2026-07-13T11:40:11Z
published: 2026-07-13T11:40:11Z
canonical: "docs.supermetrics.com/how-to-set-a-custom-conversion-window-in-facebook-ads-queries"
---

> ## 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.

# How to set a custom conversion window in Facebook Ads queries

You can define a custom conversion window in a query by selecting some conversion metrics with specific windows, or configuring the query to use a specific window when calculating the results.

Note that while this is referred to as a conversion window in Supermetrics, it's called attribution setting in Facebook Ad Manager.

The attribution setting can be set at the Ad or Campaign level.

- If looking at the **Ad level**, it’ll show the same value as the Ad Set that ad belongs to.
- If looking at the **Campaign level**, it will show the value if all the linked Ad Sets are the same, or "Multiple Attribution Settings" if it's mixed.

## Instructions

****AI chats and Supermetrics MCP****

AI tools use the conversion window already set on the ad account/ad set in Facebook Ad Manager. There is no Supermetrics-side default, such as a 28-day click.

To change to a custom conversion window, name the window in your prompt, such as 7-day click, 28-day click, or 7-day click + 1-day view.

Example: "Pull Facebook Ads spend and conversions using a 7-day click attribution setting."

****Google Sheets and Excel****

1. Open the Supermetrics sidebar and create a new Facebook Ads query or select a Facebook Ads query to modify.
2. Navigate to **Options**.
3. Select the attribution setting in the **Conversion window** dropdown menu.
4. Repeat this for every query that you want to include a custom conversion window.

****Data Studio****

1. Click on any element in your report that's connected to the Facebook Ads data source to open the Supermetrics pane.
2. Navigate to **Data source** and click the **Edit icon** next to Facebook Ads to open the configuration page.
3. Click **Edit connection** in the top left.
4. Select the attribution setting in the **Conversion window** dropdown menu.

If you need multiple objects with different conversion window settings, you'll need to create multiple data source files, one for each conversion window.

Alternatively, enable the **Allow "conversion window" to be modified in reports** setting on the configuration page. This will allow you to modify this setting in different report charts.

****Power BI****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Power BI** under **Analyze**.
2. Select the query you'd like to modify.
3. Select a connection.
4. In the sidebar, click **Options**.
5. Select the attribution setting in the **Conversion window** dropdown menu.

****Query Manager (the Supermetrics API)****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Select the Facebook Ads data source.
3. Create a new Facebook Ads query or select a Facebook Ads query to modify.
4. Navigate to **Options**.
5. Select the attribution setting in the **Conversion window** dropdown menu.
6. Repeat this for every query that you want to include a custom conversion window.

****Data warehouse destinations****

Follow these instructions for data warehouse transfers from the Supermetrics Hub. For data warehouse transfers using BigQuery (marketplace), follow the instructions below.

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Data transfers** under **Manage**.
2. Click the 3-dot menu next to a Facebook Ads transfer and select **Edit transfer.** Alternatively, create a new transfer, and select the Facebook Ads data source.
3. In the transfer setup view, scroll down to the **Conversion window** dropdown menu under **General settings**.
4. Select the attribution setting to use in your transfer.
5. Save your transfer.

**BigQuery (marketplace)**

1. Create a new transfer for Facebook Ads, and set up the transfer details.
2. Click **Connect source**.
3. Select your accounts.
4. Under **General settings**, select the attribution setting in the **Conversion window** dropdown menu.
5. Click **Submit**.
6. Click **Save** to save your transfer.