ListFacebookEcommerceReport
Returns the breakdown of ecommerce product activity for a Facebook ad in 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 |
| ReportingFacebookAdId | = |
SELECT * FROM ListFacebookEcommerceReport
SELECT * FROM ListFacebookEcommerceReport WHERE ReportingFacebookAdId = '12345'
Columns
| Name | Type | References | Description |
| ReportingFacebookAdId | String | A unique identifier for the Facebook ad report. | |
| Title | String | The title of the product. | |
| Sku | String | The SKU of the product. | |
| ImageUrl | String | The image URL of the product. | |
| TotalRevenue | Decimal | The total revenue of the product. | |
| TotalPurchased | Decimal | The total number of units purchased. | |
| CurrencyCode | String | The currency code for the product's revenue. | |
| RecommendationTotal | Integer | The total number of product recommendations. | |
| RecommendationPurchased | Integer | The number of recommended products that were purchased. |