FacebookAds
Lists Facebook ads configured and managed through Mailchimp's integrated advertising feature.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| Id | = |
SELECT * FROM FacebookAds
SELECT * FROM FacebookAds WHERE Id = '2'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier assigned to the Facebook ad within the Mailchimp account. | |
| Name | String | The display name of the Facebook ad as defined in the campaign configuration. | |
| Type | String | The ad format or type, such as image, carousel, or video. | |
| Status | String | The current delivery status of the Facebook ad, for example active, paused, canceled, or completed. | |
| CreateTime | Datetime | The date and time when the Facebook ad was first created in Mailchimp. | |
| UpdatedAt | Datetime | The date and time when the Facebook ad details were last modified. | |
| StartTime | Datetime | The scheduled or actual start time for the ad's delivery. | |
| EndTime | Datetime | The scheduled or actual end time for the ad's delivery. | |
| PausedAt | Datetime | The date and time when the ad was paused manually or automatically. | |
| CanceledAt | Datetime | The date and time when the ad was canceled and stopped running. | |
| PublishedTime | Datetime | The date and time when the ad was published or made live. | |
| WebId | Integer | The unique web identifier for the Facebook ad used within the Mailchimp interface. | |
| HasAudience | Boolean | If the value is 'true', the Facebook ad has an assigned target audience. | |
| HasContent | Boolean | If the value is 'true', the ad contains creative content such as text, links, or images. | |
| HasSegment | Boolean | If the value is 'true', the ad targets a specific segment of an audience. | |
| IsConnected | Boolean | If the value is 'true', the ad is connected to an active Facebook Ad account. | |
| NeedsAttention | Boolean | If the value is 'true', the ad requires review or updates due to configuration or performance issues. | |
| ShowReport | Boolean | If the value is 'true', a performance report is available for this ad. | |
| WasCanceledByFacebook | Boolean | If the value is 'true', the ad was canceled automatically by Facebook due to a policy or technical issue. | |
| Thumbnail | String | The URL of the thumbnail image representing the ad's creative. | |
| EmailSourceName | String | The name of the email source linked to the Facebook ad. | |
| AudienceEmailSourceIsSegment | Boolean | If the value is 'true', the audience email source is based on a Mailchimp segment. | |
| AudienceEmailSourceListName | String | The name of the Mailchimp audience list used as the source for the ad. | |
| AudienceEmailSourceName | String | The display name of the email audience source connected to the ad. | |
| AudienceEmailSourceSegmentType | String | The type of Mailchimp segment used as the source audience for the ad. | |
| AudienceEmailSourceType | String | The data source type used to build the audience, such as list or saved segment. | |
| AudienceIncludeSourceInTarget | Boolean | If the value is 'true', the audience source is included in the targeting configuration. | |
| AudienceLookalikeCountryCode | String | The two-letter ISO 3166 country code specifying the location used for lookalike audience targeting. | |
| AudienceSourceType | String | The origin or method used to create the audience, such as custom audience or lookalike audience. | |
| AudienceTargetingSpecsGender | Integer | The gender value used for audience targeting (for example, 1 for male, 2 for female). | |
| AudienceTargetingSpecsInterests | String | The list of interest categories used for audience targeting. | |
| AudienceTargetingSpecsLocationsCities | String | The cities specified for geographic targeting of the ad. | |
| AudienceTargetingSpecsLocationsCountries | String | The countries specified for geographic targeting of the ad. | |
| AudienceTargetingSpecsLocationsRegions | String | The regions specified for geographic targeting of the ad. | |
| AudienceTargetingSpecsLocationsZips | String | The postal codes or ZIP ranges specified for the audience's geographic targeting. | |
| AudienceTargetingSpecsMaxAge | Integer | The maximum age value used in audience targeting. | |
| AudienceTargetingSpecsMinAge | Integer | The minimum age value used in audience targeting. | |
| AudienceType | String | The overall audience classification, such as custom, lookalike, or saved segment. | |
| BudgetCurrencyCode | String | The three-letter ISO 4217 currency code used for the ad budget. | |
| BudgetDuration | Integer | The duration of the ad's budget, usually defined in days. | |
| BudgetTotalAmount | Integer | The total allocated budget amount for the Facebook ad. | |
| ChannelFbPlacementAudience | Boolean | If the value is 'true', the ad is placed in the Facebook Audience Network. | |
| ChannelFbPlacementFeed | Boolean | If the value is 'true', the ad appears in the Facebook feed. | |
| ChannelIgPlacementFeed | Boolean | If the value is 'true', the ad appears in the Instagram feed. | |
| ContentAttachments | String | A list of attachments included in the ad creative, such as images or videos. | |
| ContentCallToAction | String | The call-to-action text or button displayed in the ad, such as 'Shop Now' or 'Learn More'. | |
| ContentDescription | String | A short description or summary of the ad's content. | |
| ContentImageUrl | String | The URL of the primary image used in the Facebook ad. | |
| ContentLinkUrl | String | The destination URL where users are directed when clicking on the ad. | |
| ContentMessage | String | The main message or caption text used in the ad creative. | |
| ContentTitle | String | The headline or title of the ad as it appears in Facebook placements. | |
| FeedbackAudience | String | Feedback or system notes related to the audience configuration of the ad. | |
| FeedbackBudget | String | Feedback or recommendations regarding the ad's budget configuration. | |
| FeedbackCompliance | String | Feedback related to compliance with Facebook advertising policies. | |
| FeedbackContent | String | Feedback or notes related to the content or creative of the ad. | |
| RecipientsListId | String | The unique identifier of the Mailchimp audience list used to create or target recipients. | |
| RecipientsListIsActive | Boolean | If the value is 'true', the associated audience list is active and available for targeting. | |
| RecipientsListName | String | The name of the Mailchimp audience list associated with the ad. | |
| RecipientsRecipientCount | Integer | The total number of recipients targeted by the ad. | |
| RecipientsSegmentOptsConditions | String | The conditions that define how recipients are segmented for targeting. | |
| RecipientsSegmentOptsMatch | String | The logic operator used to match segment conditions (for example, 'any' or 'all'). | |
| RecipientsSegmentOptsPrebuiltSegmentId | String | The unique identifier of a prebuilt Mailchimp segment used for recipient targeting. | |
| RecipientsSegmentOptsSavedSegmentId | Integer | The ID of a saved Mailchimp segment used in the ad configuration. | |
| RecipientsSegmentText | String | A human-readable description of the segment configuration used for the ad. | |
| ReportSummaryClickRate | Integer | The percentage of clicks compared to total impressions, as recorded in the report summary. | |
| ReportSummaryClicks | Integer | The total number of user clicks recorded in the report summary. | |
| ReportSummaryConversionRate | Integer | The conversion rate percentage based on post-click actions. | |
| ReportSummaryEcommerceAverageOrderRevenue | Integer | The average order value attributed to the ad's e-commerce activity. | |
| ReportSummaryEcommerceCurrencyCode | String | The three-letter ISO 4217 currency code used for e-commerce reporting metrics. | |
| ReportSummaryEcommerceTotalRevenue | Integer | The total e-commerce revenue generated from the Facebook ad. | |
| ReportSummaryEngagements | Integer | The number of engagements (likes, shares, comments) recorded for the ad. | |
| ReportSummaryImpressions | Integer | The total number of times the ad was displayed to users. | |
| ReportSummaryOpenRate | Integer | The open rate percentage if the ad is linked to an email-based campaign. | |
| ReportSummaryOpens | Integer | The total number of opens recorded for email-linked ad campaigns. | |
| ReportSummaryProxyExcludedOpenRate | Integer | The open rate excluding proxy opens (for example, those generated by email security filters). | |
| ReportSummaryProxyExcludedOpens | Integer | The total number of opens excluding proxy-generated events. | |
| ReportSummaryProxyExcludedUniqueOpens | Integer | The total number of unique opens excluding proxy activity. | |
| ReportSummaryReach | Integer | The total number of unique users who saw the ad at least once. | |
| ReportSummarySubscriberClicks | Integer | The total number of clicks generated by subscribers targeted through the ad. | |
| ReportSummarySubscribes | Integer | The total number of new subscribers gained as a result of the ad campaign. | |
| ReportSummaryTotalSent | Integer | The total number of ad impressions or deliveries completed. | |
| ReportSummaryUniqueOpens | Integer | The number of unique opens recorded in the report summary. | |
| ReportSummaryUniqueVisits | Integer | The total number of unique visits to linked destinations from the ad. | |
| ReportSummaryVisits | Integer | The total number of visits generated by the ad. | |
| SiteId | Integer | The unique identifier of the connected site linked to this Facebook ad. | |
| SiteName | String | The display name of the connected site associated with the ad. | |
| SiteUrl | String | The URL of the connected site or landing page where ad traffic is directed. |