ReportingFacebookAds
Lists performance reports for Facebook ad campaigns managed through Mailchimp.
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 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. |