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