ReportProductActivity
Provides campaign performance data linked to e-commerce product interactions.
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 |
| CampaignId | = |
SELECT * FROM ReportProductActivity
SELECT * FROM ReportProductActivity WHERE CampaignId = '1121'
Columns
| Name | Type | References | Description |
| CampaignId | String |
Reports.Id | The unique identifier of the campaign associated with this product activity report. It is used to link product performance metrics back to the originating email campaign. |
| CurrencyCode | String | The three-letter ISO 4217 code representing the currency in which product revenue and totals are reported. | |
| ImageUrl | String | The URL of the product image used in the campaign or report. This helps visually identify the promoted item. | |
| RecommendationPurchased | Integer | The number of times this product was purchased as a result of a campaign recommendation. It reflects the product's success within personalized recommendations. | |
| RecommendationTotal | Integer | The total number of times this product was recommended across all campaign recipients. | |
| Sku | String | The stock keeping unit (SKU) that uniquely identifies the product in the store or catalog system. | |
| Title | String | The name or title of the product as it appears in the campaign or catalog. | |
| TotalPurchased | Decimal | The total number of units of this product purchased by recipients who interacted with the campaign. | |
| TotalRevenue | Decimal | The total revenue generated from purchases of this product that can be attributed to the campaign. |