Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData JDBC Driver for Facebook Ads Views
| Name | Description |
| Action_Canvas_Component_Report | Ad Report focusing on clicks and ROAS, broken down by canvas component. Accessing Ad Report information requires the ads_read permission. |
| Action_Carousel_Card_Report | Ad Report focusing on clicks and ROAS, broken down by carousel. Accessing Ad Report information requires the ads_read permission. |
| Action_Conversion_Device_Report | Ad Report focusing on clicks and ROAS, broken down by serving device and conversion device. Accessing Ad Report information requires the ads_read permission. |
| Action_Product_Id_Report | Ad Report focusing on clicks and ROAS, broken down by product id. Accessing Ad Report information requires the ads_read permission. |
| Action_Reactions_Report | Ad Report focusing on clicks and ROAS, broken down by reactions. Accessing Ad Report information requires the ads_read permission. |
| Action_Video_Sound_Report | Ad Report focusing on video consumption, broken down by sound status. Accessing Ad Report information requires the ads_read permission. |
| Action_Video_View_Type_Report | Ad Report focusing on video consumption, broken down by video type. Accessing Ad Report information requires the ads_read permission. |
| AdAccounts | Query the Ad Accounts available for a User. Accessing Ad Account information requires the ads_read permission. |
| AdCreatives | Query information about an Ad Creative or the Ad Creatives on a specific Ad Account, Ad Set, or Ad. Accessing Ad Creative information requires the ads_read permission. |
| AdImages | Images associated with an ad account |
| AdInsights | Queries an Ad Report. Accessing Ad Report information requires the ads_read permission. |
| AdInsightsActions | Query an Ad Report. Accessing Ad Report information requires the ads_read permission. |
| AdLabels | Query information about ad labels. Accessing Ad Information requires the ads_read permission. |
| Ads | Query information about an Ad or the Ads in a specific Ad Set, Campaign, or Ad Account. Accessing Ad Information requires the ads_read permission. |
| AdSets | Query information about an Ad Set or the Ad Sets on a specific Campaign or Ad Account. Accessing Ad Set information requires the ads_read permission. |
| Albums | Query Albums associated with a Target. Accessing Album information typically requires the user_photos permission. |
| AuthorizedAdAccounts | Ad Accounts authorized to run ads for your business on a specified app. This view requires that you have at least one business configured for your user id. |
| Basic_Ad_Report | Ad Report focused on ads, broken down by action type. Accessing Ad Report information requires the ads_read permission. |
| Basic_Ad_Set_Report | Ad Report focused on ad sets, broken down by action type. Accessing Ad Report information requires the ads_read permission. |
| Basic_All_Levels_Report | Ad Report focused on ads, broken down by action type. Accessing Ad Report information requires the ads_read permission. |
| Basic_Campaign_Report | Ad Report focused on ads and providing information on parent campaigns and ad sets, broken down by action type. Accessing Ad Report information requires the ads_read permission. |
| Businesses | Query the Businesses of a Facebook user. Accessing Business information requires the business_management permission. |
| Campaigns | Query information about a Campaign or the Campaigns on a specific Ad Account. Accessing Campaign information requires the ads_read permission. |
| Delivery_Device_Report | Ad Report focused on campaigns, broken down by device or platform used for viewing ad. Accessing Ad Report information requires the ads_read permission. |
| Delivery_Platform_And_Device_Report | Ad Report focused on campaigns, broken down by the Meta platform on which it was delivered. Accessing Ad Report information requires the ads_read permission. |
| Delivery_Platform_Report | Ad Report focused on campaigns, broken down by the Meta platform on which it was delivered. Accessing Ad Report information requires the ads_read permission. |
| Delivery_Purchase_Roas_Report | Ad Report focused on campaigns, broken down by the Meta platform on which it was delivered. Accessing Ad Report information requires the ads_read permission. |
| Demographic_Age_And_Gender_Report | Ad Report focused on campaigns, broken down by age and gender demographics. Accessing Ad Report information requires the ads_read permission. |
| Demographic_Age_Report | Ad Report focused on campaigns, broken down by age demographics. Accessing Ad Report information requires the ads_read permission. |
| Demographic_Country_Report | Ad Report focused on campaigns, broken down by country demographics. Accessing Ad Report information requires the ads_read permission. |
| Demographic_DMA_Region_Report | Ad Report focused on campaigns, broken down by Designated Market Area. Accessing Ad Report information requires the ads_read permission. |
| Demographic_Gender_Report | Ad Report focused on campaigns, broken down by gender. Accessing Ad Report information requires the ads_read permission. |
| Demographic_Region_Report | Ad Report focused on campaigns, broken down by sub-country geographic region. Accessing Ad Report information requires the ads_read permission. |
| LeadValues | Query information about a lead. Accessing Lead Information requires the ads_read permission. |
| Pages | Query the Pages based on the supplied Id. |
| Permissions | Query the Permissions the User has granted the current application. |