ReportingLandingPages
Provides engagement and conversion metrics for landing pages published through Mailchimp.
View-Specific Information
Select
The provider 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 provider.
| Column | Supported Operators |
| Id | = |
SELECT * FROM ReportingLandingPages
SELECT * FROM ReportingLandingPages WHERE Id = '2'
Columns
| Name | Type | References | 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. |