Sometimes, only a subset of the data available in a Facebook Ads entity is needed. You can define any such subset using a custom SQL query.

Connecting to a Custom SQL Query

To create visualizations from a subset of the data available in a Facebook Ads entity, it will be necessary to author a unique SQL query. This can be done as follows:

1. After you have connected to Facebook Ads, navigate to the Data Source tab.
2. In the left pane, select your Database and Schema.
3. Instead of selecting one of the available tables, click the New Custom SQL button.
4. You will then be prompted for your query. Provide any filters aggregates or joins you want here.
5. Click OK.

With your custom SQL query provided, you can now proceed to Visualizing Data as if the selection were a normal table.