SiteTopPostsStats
Query the SiteTopPostsStats in Wordpress.
Table Specific Information
SELECT
The 本製品 uses the WordPress API to process some of the filters.
- Date supports the '=' comparison.
- Period supports the '=' comparison.
- Summarize supports the '=' comparison.
The 本製品 processes other filters client-side within the 本製品.
For example, the following queries are processed server side.
SELECT * FROM SiteTopPostsStats WHERE Date='2025-05-08' AND Period='day'
Columns
| Name | Type | References | Description |
| Date | Date | The most recent date for which post view statistics are available. | |
| DaysAggregate | String | A collection of daily post view data, showing how many views each post received on specific days (omitted when summarize=true). | |
| SummaryAggregate | String | A summary of post view totals aggregated across the selected reporting period (omitted when summarize=false). | |
| Period | String | The reporting interval for which statistics are returned, such as day, week, or month. |
Pseudo-Columns
疑似カラムフィールドはSELECT ステートメントのWHERE 句で使用され、操作によって返されるデータをより細かく制御することができます。
| Name | Type | Description | |
| HasSummarize | Boolean | Indicates whether the SiteTopPostsStats results include summarized data. | |
| NumofPeriods | Int | The number of reporting periods included in the returned statistics. |