ReportProductActivity
Campaign product activity report.
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportProductActivity; SELECT * FROM ReportProductActivity where CampaignId='1121';
Columns
| Name | Type | Description |
| CampaignId | String | The unique id for the campaign. |
| CurrencyCode | String | CurrencyCode |
| ImageUrl | String | ImageUrl |
| RecommendationPurchased | Integer | RecommendationPurchased |
| RecommendationTotal | Integer | RecommendationTotal |
| Sku | String | Sku |
| Title | String | Title |
| TotalPurchased | Integer | TotalPurchased |
| TotalRevenue | Integer | TotalRevenue |