ReportingFacebookAds
Lists performance reports for Facebook ad campaigns managed through Mailchimp.
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 ReportingFacebookAds
SELECT * FROM ReportingFacebookAds WHERE Id = '2'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the Facebook ad report. | |
| AudienceEmailSourceIsSegment | Boolean | A value of 'true' indicates that the audience email source is based on a segment. | |
| AudienceEmailSourceListName | String | The name of the mailing list used as the audience source for the Facebook ad report. | |
| AudienceEmailSourceName | String | The name assigned to the audience email source that defines the target group. | |
| AudienceEmailSourceSegmentType | String | The segment type used for the audience email source, such as static or dynamic. | |
| AudienceEmailSourceType | String | The type of audience email source, for example, a Mailchimp list or custom segment. | |
| AudienceIncludeSourceInTarget | Boolean | If the value is 'true', the original source in the target audience for the campaign is included. | |
| AudienceLookalikeCountryCode | String | The country code representing where lookalike audiences are targeted. | |
| AudienceSourceType | String | The classification of the audience source used to generate the ad report. | |
| AudienceTargetingSpecsGender | Integer | Specifies gender-based targeting criteria for the audience, if applicable. | |
| AudienceTargetingSpecsInterests | String | Defines the audience's targeting interests, such as hobbies or categories of engagement. | |
| AudienceTargetingSpecsLocationsCities | String | Lists the cities included in the location-based audience targeting. | |
| AudienceTargetingSpecsLocationsCountries | String | Lists the countries targeted by the Facebook ad campaign. | |
| AudienceTargetingSpecsLocationsRegions | String | Lists the regions targeted by the Facebook ad campaign. | |
| AudienceTargetingSpecsLocationsZips | String | Specifies the zip codes targeted by the Facebook ad campaign. | |
| AudienceTargetingSpecsMaxAge | Integer | The maximum age range defined in the audience targeting criteria. | |
| AudienceTargetingSpecsMinAge | Integer | The minimum age range defined in the audience targeting criteria. | |
| AudienceType | String | The type of audience, such as custom, lookalike, or saved. | |
| AudienceActivityClicks | String | The total number of clicks generated by audience activity. | |
| AudienceActivityImpressions | String | The total number of impressions recorded from audience activity. | |
| AudienceActivityRevenue | String | The total revenue attributed to audience interactions with the ad. | |
| BudgetCurrencyCode | String | The currency code used for the campaign's allocated budget. | |
| BudgetDuration | Integer | The total duration of the campaign's budget period, typically measured in days. | |
| BudgetTotalAmount | Integer | The total monetary amount allocated as the campaign's budget. | |
| CanceledAt | Datetime | The date and time when the Facebook ad campaign was canceled. | |
| ChannelFbPlacementAudience | Boolean | A value of 'true' indicates that the ad is placed in the Facebook Audience Network. | |
| ChannelFbPlacementFeed | Boolean | A value of 'true' indicates that the ad appears in the Facebook feed. | |
| ChannelIgPlacementFeed | Boolean | A value of 'true' indicates that the ad is displayed in the Instagram feed. | |
| CreateTime | Datetime | The date and time when the Facebook ad report was created. | |
| EmailSourceName | String | The name of the email source associated with the campaign. | |
| EndTime | Datetime | The date and time when the Facebook ad campaign ended. | |
| HasSegment | Boolean | A value of 'true' indicates that the ad report includes a defined audience segment. | |
| Name | String | The name assigned to the Facebook ad report. | |
| NeedsAttention | Boolean | A value of 'true' indicates that the Facebook ad report requires attention due to issues or alerts. | |
| PausedAt | Datetime | The date and time when the Facebook ad campaign was paused. | |
| PublishedTime | Datetime | The date and time when the Facebook ad campaign was published. | |
| RecipientsListId | String | The unique identifier of the recipient list used for the Facebook ad report. | |
| RecipientsListIsActive | Boolean | A value of 'true' indicates that the recipient list is active; 'false' if deleted or disabled. | |
| RecipientsListName | String | The name of the recipient list associated with the Facebook ad report. | |
| RecipientsRecipientCount | Integer | The total number of recipients included in the Facebook ad report. | |
| RecipientsSegmentOptsConditions | String | The logical conditions that define the segment options for the recipients. | |
| RecipientsSegmentOptsMatch | String | Specifies how segment conditions are matched, such as 'any' or 'all'. | |
| RecipientsSegmentOptsPrebuiltSegmentId | String | The identifier for a prebuilt segment used in the recipient configuration. | |
| RecipientsSegmentOptsSavedSegmentId | Integer | The identifier for a saved segment associated with the recipient list. | |
| RecipientsSegmentText | String | A textual representation of the segment definition used for recipient selection. | |
| ReportSummaryAverageDailyBudgetAmount | Integer | The average daily budget amount allocated to the Facebook ad campaign. | |
| ReportSummaryAverageDailyBudgetCurrencyCode | String | The currency code associated with the average daily budget amount. | |
| ReportSummaryAverageOrderAmountAmount | Integer | The average order value generated from ad-driven conversions. | |
| ReportSummaryAverageOrderAmountCurrencyCode | String | The currency code associated with the average order value. | |
| ReportSummaryClickRate | Integer | The overall click rate, expressed as a percentage of total impressions. | |
| ReportSummaryClicks | Integer | The total number of clicks recorded in the Facebook ad report. | |
| ReportSummaryComments | Integer | The number of comments generated through engagement with the ad. | |
| ReportSummaryConversionRate | Integer | The rate at which ad viewers completed desired actions, such as purchases or sign-ups. | |
| ReportSummaryCostPerClickAmount | Integer | The average cost incurred for each click on the ad. | |
| ReportSummaryCostPerClickCurrencyCode | String | The currency code used for the cost per click calculation. | |
| ReportSummaryEcommerceAverageOrderRevenue | Integer | The average revenue generated per e-commerce order associated with the ad. | |
| ReportSummaryEcommerceCurrencyCode | String | The currency code for e-commerce-related revenue metrics. | |
| ReportSummaryEcommerceTotalRevenue | Integer | The total e-commerce revenue attributed to the Facebook ad campaign. | |
| ReportSummaryEngagements | Integer | The total number of engagements, including clicks, likes, comments, and shares. | |
| ReportSummaryExtendedAtDatetime | String | The timestamp indicating when the campaign's duration was extended. | |
| ReportSummaryExtendedAtTimezone | String | The timezone used for the 'extended at' timestamp. | |
| ReportSummaryFirstTimeBuyers | Integer | The number of first-time customers acquired through the Facebook ad campaign. | |
| ReportSummaryHasExtendedAdDuration | Boolean | A value of 'true' indicates that the ad's duration was extended beyond its initial schedule. | |
| ReportSummaryImpressions | Integer | The total number of impressions recorded during the campaign. | |
| ReportSummaryLikes | Integer | The total number of likes the ad received on Facebook or Instagram. | |
| ReportSummaryOpenRate | Integer | The percentage of ad viewers or email recipients who opened the content. | |
| ReportSummaryOpens | Integer | The total number of opens recorded for the Facebook ad. | |
| ReportSummaryProxyExcludedOpenRate | Integer | The open rate excluding proxy-related traffic, for more accurate reporting. | |
| ReportSummaryProxyExcludedOpens | Integer | The total number of opens after excluding proxy-related activity. | |
| ReportSummaryProxyExcludedUniqueOpens | Integer | The count of unique opens excluding proxy-related traffic. | |
| ReportSummaryReach | Integer | The number of unique users who saw the Facebook ad at least once. | |
| ReportSummaryReturnOnInvestment | Integer | The overall return on investment (ROI) for the Facebook ad campaign. | |
| ReportSummaryShares | Integer | The number of times the ad was shared by viewers. | |
| ReportSummarySubscriberClicks | Integer | The total number of clicks generated by subscribers in the audience. | |
| ReportSummarySubscribes | Integer | The total number of new subscriptions generated through the ad. | |
| ReportSummaryTotalOrders | Integer | The total number of orders attributed to the ad campaign. | |
| ReportSummaryTotalProductsSold | Integer | The total number of products sold as a result of the campaign. | |
| ReportSummaryTotalSent | Integer | The total number of ad deliveries or sends during the campaign. | |
| ReportSummaryUniqueClicks | Integer | The number of unique users who clicked on the ad. | |
| ReportSummaryUniqueOpens | Integer | The number of unique users who opened the ad content. | |
| ReportSummaryUniqueVisits | Integer | The number of unique site visits generated by the campaign. | |
| ReportSummaryVisits | Integer | The total number of visits resulting from the campaign. | |
| ShowReport | Boolean | A value of 'true' indicates that the report is visible or enabled for display. | |
| StartTime | Datetime | The date and time when the Facebook ad campaign started running. | |
| Status | String | The current operational status of the Facebook ad report, such as active, paused, or completed. | |
| Thumbnail | String | The thumbnail image associated with the Facebook ad report for identification or preview. | |
| Type | String | The classification or type of Facebook ad report, such as conversion or engagement. | |
| UpdatedAt | Datetime | The date and time when the Facebook ad report was last updated. | |
| WasCanceledByFacebook | Boolean | A value of 'true' indicates that the ad campaign was canceled automatically by Facebook. | |
| WebId | Integer | The internal web identifier used for tracking the Facebook ad report within Mailchimp. |