ListFacebookEcommerceReport
List the breakdown of product activity for an outreach in 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.
- 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. |