ListFacebookEcommerceReport
List the breakdown of product activity for an outreach in Mailchimp.
Table Specific Information
Select
The provider 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 provider.
- ReportingFacebookAdId supports the '=' operator.
SELECT * FROM ListFacebookEcommerceReport; SELECT * FROM ListFacebookEcommerceReport WHERE ReportingFacebookAdId = '12345';
Columns
| Name | Type | 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 | Total revenue of the product. |
| TotalPurchased | Decimal | The count of total products purchased. |
| CurrencyCode | String | The currency code. |
| RecommendationTotal | Integer | The recommendation total count. |
| RecommendationPurchased | Integer | The recommendation purchased count. |