LandingPages
Lists landing pages created in the account, including URLs, design information, and publishing status.
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.
- Id supports the '=' operator.
SELECT * FROM LandingPages; SELECT * FROM LandingPages where Id='2';
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier for the landing page, used to reference and manage it within Mailchimp's system or through API calls. |
| Name | String | The internal name of the landing page, helping users identify it within their Mailchimp account or organize multiple campaigns. |
| Title | String | The public title of the landing page, typically displayed to visitors and used in browser tabs or search engine previews. |
| Description | String | A short description of the landing page's purpose or content, often used for internal documentation or reporting. |
| TemplateId | Integer | The identifier of the design template applied to the landing page, determining its layout, structure, and styling. |
| Status | String | The current publishing state of the landing page.
The allowed values are published, unpublished, draft. |
| ListId | String | The unique identifier of the Mailchimp audience (list) linked to the landing page, defining where signups and collected contacts are stored. |
| StoreId | String | The unique identifier of the connected eCommerce store associated with the landing page, if applicable. |
| WebId | Integer | The Mailchimp web application ID used to access and manage the landing page directly from the account interface. |
| CreatedAt | Datetime | The date and time when the landing page was originally created, stored in ISO 8601 format for tracking and auditing. |
| UpdatedAt | Datetime | The date and time of the most recent modification to the landing page's content or settings. |
| PublishedAt | Datetime | The date and time when the landing page was made publicly accessible. |
| UnpublishedAt | Datetime | The date and time when the landing page was taken offline or reverted to draft status. |
| CreatedBySource | String | Indicates the origin of the landing page creation, such as through the Mailchimp editor, API, or a third-party integration. |
| TrackingTrackWithMailchimp | Boolean | If the value is 'true', Mailchimp's tracking is enabled to record link clicks and engagement data for performance analysis. |
| TrackingEnableRestrictedDataProcessing | Boolean | If the value is 'true', restricted data processing is enabled to comply with data protection regulations. |
| Url | String | The public-facing URL where the landing page is hosted and accessible to visitors. |