ReportProductActivity
Provides campaign performance data linked to e-commerce product interactions.
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 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 | Integer | The total number of units of this product purchased by recipients who interacted with the campaign. |
| TotalRevenue | Integer | The total revenue generated from purchases of this product that can be attributed to the campaign. |