ReportingFacebookAds
Lists performance reports for Facebook ad campaigns managed through 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 ReportingFacebookAds; SELECT * FROM ReportingFacebookAds where Id='2';
Columns
| Name | Type | 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. |