The CData Python Connector for Facebook Ads models Facebook Ads APIs as relational Tables, Views, and Stored Procedures. The connector uses the Facebook Ads API to process supported filters. The connector processes other filters client-side within the connector.

Views

Views describes the available views. Two types of views are made available:

• Base Views are statically defined to model Ad Accounts, Campaigns, Businesses, Lead Values, and more. They are used to create your custom reports instead of being used standalone. By default. these views return data from all time aggregated into a single row.
• Predefined Report Views are a set of standard reports that mimic exactly what you see in the Facebook UI. All Predefined Report Views have "report" appended to their name. By default, these views return data from all time with a daily breakdown.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Querying Facebook Ads Data

The connector supports filtering Facebook Ads views in several unique ways, such as by ad level, breakdown, time range, action collection, or action attribution. Also, many views require a target to be specified in queries. See Querying Facebook Ads Data for more information.

Insight Reports

The connector offers a selection of pre-built report views representing common reporting scenarios. Queries to these views are simpler than queries to AdInsights and AdInsightsActions. This is because querying each report view is equivalent to a more complex query containing the breakdowns and action collections associated with that reporting scenario, removing the need to specify them manually.

See Using Pre-Built Reports for a list of these pre-built reports, as well as instructions for defining additional report views.