ReportingLandingPages
Get reports of your landing pages.
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 ReportingLandingPages; SELECT * FROM ReportingLandingPages where Id='2';
Columns
| Name | Type | Description |
| Id | String | The unique identifier for the landing page. |
| Clicks | Integer | Total clicks for the landing page. |
| ConversionRate | Decimal | The conversion rate for the landing page. |
| ListId | String | The unique id for the list. |
| ListName | String | The name of the list. |
| Name | String | The name of the landing page. |
| PublishedAt | Datetime | The time the landing page was published. |
| SignupTags | String | The signup tags for the landing page. |
| Status | String | The status of the landing page. |
| Subscribes | Integer | The number of subscribes for the landing page. |
| TimeseriesDailyStatsClicks | String | Daily statistics for clicks. |
| TimeseriesDailyStatsUniqueVisits | String | Daily statistics for unique visits. |
| TimeseriesDailyStatsVisits | String | Daily statistics for visits. |
| TimeseriesWeeklyStatsClicks | String | Weekly statistics for clicks. |
| TimeseriesWeeklyStatsUniqueVisits | String | Weekly statistics for unique visits. |
| TimeseriesWeeklyStatsVisits | String | Weekly statistics for visits. |
| Title | String | The title of the landing page. |
| UniqueVisits | Integer | The number of unique visits for the landing page. |
| UnpublishedAt | Datetime | The time the landing page was unpublished. |
| Url | String | The URL of the landing page. |
| Visits | Integer | The number of visits for the landing page. |
| WebId | Integer | The web ID of the landing page. |
| EcommerceAverageOrderRevenue | Decimal | The average order revenue for the landing page. |
| EcommerceCurrencyCode | String | The currency code for ecommerce transactions. |
| EcommerceTotalOrders | Integer | The total number of orders for the landing page. |
| EcommerceTotalRevenue | Decimal | The total revenue for the landing page. |