CampaignVariateContents
Retrieves the HTML and plain-text variations for A/B testing campaigns, enabling comparison of different content versions.
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.
The CamapignId can be retrieved by selecting the Campaigns table.
- CamapaignId supports the '=' operator.
SELECT * FROM CampaignVariateContents; SELECT * FROM CampaignVariateContents where CampaignId='381b6f0c90';
Columns
| Name | Type | Description |
| CampaignId | String | The unique identifier of the campaign that includes variate content options. |
| ContentLabel | String | A descriptive label used to distinguish between different content variations in the campaign. |
| PlainText | String | The plain-text version of the campaign content. If no plain-text content is provided, Mailchimp automatically generates it from the HTML version. |
| Html | String | The full HTML content of the campaign variation, including layout, text, and images. |