ReportingFacebookAds
List of Facebook ad reports in Mailchimp.
Table Specific Information
Select
The driver will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.
- Id supports the '=' operator.
SELECT * FROM ReportingFacebookAds; SELECT * FROM ReportingFacebookAds where Id='2';
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the Facebook ad report. |
| AudienceEmailSourceIsSegment | Boolean | Whether the audience email source is a segment. |
| AudienceEmailSourceListName | String | The list name of the audience email source. |
| AudienceEmailSourceName | String | The name of the audience email source. |
| AudienceEmailSourceSegmentType | String | The segment type of the audience email source. |
| AudienceEmailSourceType | String | The type of the audience email source. |
| AudienceIncludeSourceInTarget | Boolean | Whether to include the source in the audience target. |
| AudienceLookalikeCountryCode | String | The lookalike country code for the audience. |
| AudienceSourceType | String | The source type of the audience. |
| AudienceTargetingSpecsGender | Integer | The gender targeting specification for the audience. |
| AudienceTargetingSpecsInterests | String | The interests targeting specification for the audience. |
| AudienceTargetingSpecsLocationsCities | String | The cities location targeting specification for the audience. |
| AudienceTargetingSpecsLocationsCountries | String | The countries location targeting specification for the audience. |
| AudienceTargetingSpecsLocationsRegions | String | The regions location targeting specification for the audience. |
| AudienceTargetingSpecsLocationsZips | String | The zip codes location targeting specification for the audience. |
| AudienceTargetingSpecsMaxAge | Integer | The maximum age targeting specification for the audience. |
| AudienceTargetingSpecsMinAge | Integer | The minimum age targeting specification for the audience. |
| AudienceType | String | The type of the audience. |
| AudienceActivityClicks | String | The number of clicks for the audience activity. |
| AudienceActivityImpressions | String | The number of impressions for the audience activity. |
| AudienceActivityRevenue | String | The revenue for the audience activity. |
| BudgetCurrencyCode | String | The currency code for the budget. |
| BudgetDuration | Integer | The duration of the budget. |
| BudgetTotalAmount | Integer | The total amount of the budget. |
| CanceledAt | Datetime | The date and time the Facebook ad was canceled. |
| ChannelFbPlacementAudience | Boolean | Whether the Facebook ad is placed in the Facebook audience. |
| ChannelFbPlacementFeed | Boolean | Whether the Facebook ad is placed in the Facebook feed. |
| ChannelIgPlacementFeed | Boolean | Whether the Facebook ad is placed in the Instagram feed. |
| CreateTime | Datetime | The date and time the Facebook ad report was created. |
| EmailSourceName | String | The name of the email source. |
| EndTime | Datetime | The end time of the Facebook ad report. |
| HasSegment | Boolean | Whether the Facebook ad report has a segment. |
| Name | String | The name of the Facebook ad report. |
| NeedsAttention | Boolean | Whether the Facebook ad report needs attention. |
| PausedAt | Datetime | The date and time the Facebook ad report was paused. |
| PublishedTime | Datetime | The date and time the Facebook ad report was published. |
| RecipientsListId | String | The list ID for the recipients of the Facebook ad report. |
| RecipientsListIsActive | Boolean | Whether the recipients list is active for the Facebook ad report. |
| RecipientsListName | String | The name of the recipients list for the Facebook ad report. |
| RecipientsRecipientCount | Integer | The recipient count for the Facebook ad report. |
| RecipientsSegmentOptsConditions | String | The segment options conditions for the recipients of the Facebook ad report. |
| RecipientsSegmentOptsMatch | String | The segment options match for the recipients of the Facebook ad report. |
| RecipientsSegmentOptsPrebuiltSegmentId | String | The prebuilt segment ID for the recipients of the Facebook ad report. |
| RecipientsSegmentOptsSavedSegmentId | Integer | The saved segment ID for the recipients of the Facebook ad report. |
| RecipientsSegmentText | String | The segment text for the recipients of the Facebook ad report. |
| ReportSummaryAverageDailyBudgetAmount | Integer | The average daily budget amount in the report summary. |
| ReportSummaryAverageDailyBudgetCurrencyCode | String | The currency code for the average daily budget in the report summary. |
| ReportSummaryAverageOrderAmountAmount | Integer | The average order amount in the report summary. |
| ReportSummaryAverageOrderAmountCurrencyCode | String | The currency code for the average order amount in the report summary. |
| ReportSummaryClickRate | Integer | The click rate in the report summary. |
| ReportSummaryClicks | Integer | The number of clicks in the report summary. |
| ReportSummaryComments | Integer | The number of comments in the report summary. |
| ReportSummaryConversionRate | Integer | The conversion rate in the report summary. |
| ReportSummaryCostPerClickAmount | Integer | The cost per click amount in the report summary. |
| ReportSummaryCostPerClickCurrencyCode | String | The currency code for the cost per click in the report summary. |
| ReportSummaryEcommerceAverageOrderRevenue | Integer | The average order revenue in the ecommerce report summary. |
| ReportSummaryEcommerceCurrencyCode | String | The currency code in the ecommerce report summary. |
| ReportSummaryEcommerceTotalRevenue | Integer | The total revenue in the ecommerce report summary. |
| ReportSummaryEngagements | Integer | The number of engagements in the report summary. |
| ReportSummaryExtendedAtDatetime | String | The extended at datetime in the report summary. |
| ReportSummaryExtendedAtTimezone | String | The extended at timezone in the report summary. |
| ReportSummaryFirstTimeBuyers | Integer | The number of first time buyers in the report summary. |
| ReportSummaryHasExtendedAdDuration | Boolean | Whether the report summary has extended ad duration. |
| ReportSummaryImpressions | Integer | The number of impressions in the report summary. |
| ReportSummaryLikes | Integer | The number of likes in the report summary. |
| ReportSummaryOpenRate | Integer | The open rate in the report summary. |
| ReportSummaryOpens | Integer | The number of opens in the report summary. |
| ReportSummaryProxyExcludedOpenRate | Integer | The proxy excluded open rate in the report summary. |
| ReportSummaryProxyExcludedOpens | Integer | The number of proxy excluded opens in the report summary. |
| ReportSummaryProxyExcludedUniqueOpens | Integer | The number of proxy excluded unique opens in the report summary. |
| ReportSummaryReach | Integer | The reach in the report summary. |
| ReportSummaryReturnOnInvestment | Integer | The return on investment in the report summary. |
| ReportSummaryShares | Integer | The number of shares in the report summary. |
| ReportSummarySubscriberClicks | Integer | The number of subscriber clicks in the report summary. |
| ReportSummarySubscribes | Integer | The number of subscribes in the report summary. |
| ReportSummaryTotalOrders | Integer | The total number of orders in the report summary. |
| ReportSummaryTotalProductsSold | Integer | The total number of products sold in the report summary. |
| ReportSummaryTotalSent | Integer | The total number of sent items in the report summary. |
| ReportSummaryUniqueClicks | Integer | The number of unique clicks in the report summary. |
| ReportSummaryUniqueOpens | Integer | The number of unique opens in the report summary. |
| ReportSummaryUniqueVisits | Integer | The number of unique visits in the report summary. |
| ReportSummaryVisits | Integer | The number of visits in the report summary. |
| ShowReport | Boolean | Whether the Facebook ad report shows a report. |
| StartTime | Datetime | The start time of the Facebook ad report. |
| Status | String | The status of the Facebook ad report. |
| Thumbnail | String | The thumbnail image for the Facebook ad report. |
| Type | String | The type of the Facebook ad report. |
| UpdatedAt | Datetime | The date and time the Facebook ad report was last updated. |
| WasCanceledByFacebook | Boolean | Whether the Facebook ad report was canceled by Facebook. |
| WebId | Integer | The web ID of the Facebook ad report. |