ReportingLandingPages
Get reports of your landing pages.
Table Specific Information
Select
The 本製品 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 本製品.
- 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. |