FacebookAds
List of Facebook ads configured 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 FacebookAds; SELECT * FROM FacebookAds where Id='2';
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the Facebook ad. |
| Name | String | The name of the Facebook ad. |
| Type | String | The type of the Facebook ad. |
| Status | String | The status of the Facebook ad. |
| CreateTime | Datetime | The date and time the Facebook ad was created. |
| UpdatedAt | Datetime | The date and time the Facebook ad was last updated. |
| StartTime | Datetime | The start time of the Facebook ad. |
| EndTime | Datetime | The end time of the Facebook ad. |
| PausedAt | Datetime | The date and time the Facebook ad was paused. |
| CanceledAt | Datetime | The date and time the Facebook ad was canceled. |
| PublishedTime | Datetime | The date and time the Facebook ad was published. |
| WebId | Integer | The web ID of the Facebook ad. |
| HasAudience | Boolean | Whether the Facebook ad has an audience. |
| HasContent | Boolean | Whether the Facebook ad has content. |
| HasSegment | Boolean | Whether the Facebook ad has a segment. |
| IsConnected | Boolean | Whether the Facebook ad is connected. |
| NeedsAttention | Boolean | Whether the Facebook ad needs attention. |
| ShowReport | Boolean | Whether the Facebook ad shows a report. |
| WasCanceledByFacebook | Boolean | Whether the Facebook ad was canceled by Facebook. |
| Thumbnail | String | The thumbnail image for the Facebook ad. |
| EmailSourceName | String | The name of the email source for the Facebook ad. |
| 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. |
| BudgetCurrencyCode | String | The currency code for the budget. |
| BudgetDuration | Integer | The duration of the budget. |
| BudgetTotalAmount | Integer | The total amount of the budget. |
| 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. |
| ContentAttachments | String | The attachments for the Facebook ad content. |
| ContentCallToAction | String | The call to action for the Facebook ad content. |
| ContentDescription | String | The description for the Facebook ad content. |
| ContentImageUrl | String | The image URL for the Facebook ad content. |
| ContentLinkUrl | String | The link URL for the Facebook ad content. |
| ContentMessage | String | The message for the Facebook ad content. |
| ContentTitle | String | The title for the Facebook ad content. |
| FeedbackAudience | String | The audience feedback for the Facebook ad. |
| FeedbackBudget | String | The budget feedback for the Facebook ad. |
| FeedbackCompliance | String | The compliance feedback for the Facebook ad. |
| FeedbackContent | String | The content feedback for the Facebook ad. |
| RecipientsListId | String | The list ID for the recipients of the Facebook ad. |
| RecipientsListIsActive | Boolean | Whether the recipients list is active for the Facebook ad. |
| RecipientsListName | String | The name of the recipients list for the Facebook ad. |
| RecipientsRecipientCount | Integer | The recipient count for the Facebook ad. |
| RecipientsSegmentOptsConditions | String | The segment options conditions for the recipients of the Facebook ad. |
| RecipientsSegmentOptsMatch | String | The segment options match for the recipients of the Facebook ad. |
| RecipientsSegmentOptsPrebuiltSegmentId | String | The prebuilt segment ID for the recipients of the Facebook ad. |
| RecipientsSegmentOptsSavedSegmentId | Integer | The saved segment ID for the recipients of the Facebook ad. |
| RecipientsSegmentText | String | The segment text for the recipients of the Facebook ad. |
| ReportSummaryClickRate | Integer | The click rate in the report summary for the Facebook ad. |
| ReportSummaryClicks | Integer | The number of clicks in the report summary for the Facebook ad. |
| ReportSummaryConversionRate | Integer | The conversion rate in the report summary for the Facebook ad. |
| ReportSummaryEcommerceAverageOrderRevenue | Integer | The average order revenue in the ecommerce report summary for the Facebook ad. |
| ReportSummaryEcommerceCurrencyCode | String | The currency code in the ecommerce report summary for the Facebook ad. |
| ReportSummaryEcommerceTotalRevenue | Integer | The total revenue in the ecommerce report summary for the Facebook ad. |
| ReportSummaryEngagements | Integer | The number of engagements in the report summary for the Facebook ad. |
| ReportSummaryImpressions | Integer | The number of impressions in the report summary for the Facebook ad. |
| ReportSummaryOpenRate | Integer | The open rate in the report summary for the Facebook ad. |
| ReportSummaryOpens | Integer | The number of opens in the report summary for the Facebook ad. |
| ReportSummaryProxyExcludedOpenRate | Integer | The proxy excluded open rate in the report summary for the Facebook ad. |
| ReportSummaryProxyExcludedOpens | Integer | The number of proxy excluded opens in the report summary for the Facebook ad. |
| ReportSummaryProxyExcludedUniqueOpens | Integer | The number of proxy excluded unique opens in the report summary for the Facebook ad. |
| ReportSummaryReach | Integer | The reach in the report summary for the Facebook ad. |
| ReportSummarySubscriberClicks | Integer | The number of subscriber clicks in the report summary for the Facebook ad. |
| ReportSummarySubscribes | Integer | The number of subscribes in the report summary for the Facebook ad. |
| ReportSummaryTotalSent | Integer | The total number of sent items in the report summary for the Facebook ad. |
| ReportSummaryUniqueOpens | Integer | The number of unique opens in the report summary for the Facebook ad. |
| ReportSummaryUniqueVisits | Integer | The number of unique visits in the report summary for the Facebook ad. |
| ReportSummaryVisits | Integer | The number of visits in the report summary for the Facebook ad. |
| SiteId | Integer | The site ID for the Facebook ad. |
| SiteName | String | The site name for the Facebook ad. |
| SiteUrl | String | The site URL for the Facebook ad. |