ReportProductActivity
Provides campaign performance data linked to e-commerce product interactions.
Table Specific Information
Select
The connector 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 connector.
- 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. |