ReportingLandingPages

Provides engagement and conversion metrics for landing pages published through Mailchimp.

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.

For example:

SELECT * FROM ReportingLandingPages;
SELECT * FROM ReportingLandingPages where Id='2';

Columns


Name	Type	Description
Id	String	The unique identifier assigned to the landing page within Mailchimp.
Clicks	Integer	The total number of clicks recorded on the landing page, including all link interactions.
ConversionRate	Decimal	The percentage of visitors who completed a desired action, such as subscribing or purchasing, on the landing page.
ListId	String	The unique identifier of the audience (list) associated with the landing page.
ListName	String	The name of the audience (list) that collects subscriber information from the landing page.
Name	String	The name assigned to the landing page for identification within Mailchimp.
PublishedAt	Datetime	The date and time when the landing page was published and became publicly accessible.
SignupTags	String	Tags automatically applied to subscribers who sign up through the landing page, useful for segmentation or automation.
Status	String	The current publication status of the landing page, such as 'draft', 'published', or 'unpublished'.
Subscribes	Integer	The total number of new subscriptions generated through the landing page.
TimeseriesDailyStatsClicks	String	A time series dataset showing the number of clicks per day for the landing page.
TimeseriesDailyStatsUniqueVisits	String	A time series dataset showing the number of unique daily visitors to the landing page.
TimeseriesDailyStatsVisits	String	A time series dataset showing the total number of daily visits, including repeat visits, to the landing page.
TimeseriesWeeklyStatsClicks	String	A time series dataset showing the number of clicks per week for the landing page.
TimeseriesWeeklyStatsUniqueVisits	String	A time series dataset showing the number of unique weekly visitors to the landing page.
TimeseriesWeeklyStatsVisits	String	A time series dataset showing the total number of weekly visits, including repeat visits, to the landing page.
Title	String	The title of the landing page as displayed to visitors in the browser or on the page header.
UniqueVisits	Integer	The number of distinct visitors who accessed the landing page, excluding repeat visits.
UnpublishedAt	Datetime	The date and time when the landing page was unpublished and removed from public access.
Url	String	The direct web address (URL) where the landing page is hosted.
Visits	Integer	The total number of visits to the landing page, including multiple visits by the same user.
WebId	Integer	The internal web identifier used by Mailchimp to reference the landing page.
EcommerceAverageOrderRevenue	Decimal	The average revenue per e-commerce order generated through the landing page.
EcommerceCurrencyCode	String	The three-letter ISO 4217 currency code used for e-commerce transactions related to the landing page.
EcommerceTotalOrders	Integer	The total number of e-commerce orders placed through or attributed to the landing page.
EcommerceTotalRevenue	Decimal	The total revenue generated from e-commerce transactions linked to the landing page.

Excel Add-In for Mailchimp

ReportingLandingPages

Table Specific Information

Select

Columns