ReportingFacebookAds
List of Facebook ad reports in Mailchimp.
Table Specific Information
Select
The add-in 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 add-in.
- 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. |