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

Looker Studio (formerly 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 in the configuration page. This will allow you to modify this setting in different report charts.

Google Sheets, Supermetrics API, and Query Manager

1. Open the Supermetrics sidebar.
2. Navigate to the Conversion window dropdown menu.
3. Select your attribution setting.
4. Repeat this for every query that you want to include a custom conversion window.

Excel

1. Open the Supermetrics sidebar.
2. Navigate to the Conversion window dropdown.
3. Click Add option.
4. Select the attribution setting you want to use.
5. Repeat this for every query that you want to include a custom conversion window.