CampaignVariateContents
Get the the HTML and plain-text content for a campaign.
Table Specific Information
Select
The driver 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 driver.
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 id for the campaign. |
| ContentLabel | String | Label used to identify the content option. |
| PlainText | String | The plain-text portion of the campaign. If left unspecified, we'll generate this automatically. |
| Html | String | The raw HTML for the campaign. |