Returns a list of landing pages for the account.

Table-Specific Information

Select

The driver uses 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.

Column	Supported Operators
Id	=

For example, the following queries are processed server-side:

SELECT * FROM LandingPages
SELECT * FROM LandingPages WHERE Id = '2'

Insert

The Type column is required for INSERT operations. Optional insertable columns include Name, Title, Description, TemplateId, ListId, StoreId, TrackingTrackWithMailchimp, and TrackingEnableRestrictedDataProcessing.

INSERT INTO LandingPages (Name, Title, Description, Type, ListId) VALUES ('Summer Sale', 'Summer Sale 2025', 'Our biggest sale of the year', 'signup', 'd24310a638')

Update

The Id column is required in the WHERE clause for UPDATE operations. Updatable columns include Name, Title, Description, ListId, StoreId, TrackingTrackWithMailchimp, and TrackingEnableRestrictedDataProcessing.

UPDATE LandingPages SET Name = 'Winter Sale', Title = 'Winter Sale 2025' WHERE Id = '2'

Delete

The following is an example of a DELETE operation:

DELETE FROM LandingPages WHERE Id = '2'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the landing page.
Name	String	False		The name of the landing page.
Title	String	False		The title of the landing page.
Description	String	False		The description of the landing page.
TemplateId	Integer	False		The Id of the template used to create the landing page.
Status	String	True		The status of the landing page. The allowed values are published, unpublished, draft.
ListId	String	False	Lists.Id	The Id of the list associated with the landing page.
StoreId	String	False	EcommerceStores.Id	The Id of the store associated with the landing page.
Type	String	False		The type of template the landing page uses. Valid only for INSERT. The allowed values are signup, product.
WebId	Integer	True		The Id used in the Mailchimp web application.
CreatedAt	Datetime	True		The date and time the landing page was created.
UpdatedAt	Datetime	True		The date and time the landing page was last updated.
PublishedAt	Datetime	True		The date and time the landing page was published.
UnpublishedAt	Datetime	True		The date and time the landing page was unpublished.
CreatedBySource	String	True		The source from which the landing page was created.
TrackingTrackWithMailchimp	Boolean	False		Indicates whether clicks in links are tracked.
TrackingEnableRestrictedDataProcessing	Boolean	False		Indicates whether restricted data processing is enabled.
Url	String	True		The URL for the landing page.