FacebookAds
Lists Facebook ads configured and managed through Mailchimp's integrated advertising feature.
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 | 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. |