FacebookAds
List of Facebook ads configured in Mailchimp.
Table Specific Information
Select
The connector 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 connector.
- 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. |