SiteStatsSummary
Query the SiteStatsSummary in Wordpress.
Table Specific Information
SELECT
The component uses the WordPress API to process some of the filters.
- Date supports the '=' comparison.
- Period supports the '=' comparison.
- NumofPeriods supports the '=' comparison.
The component processes other filters client-side within the component.
For example, the following queries are processed server side.
SELECT * FROM SiteStatsSummary where Date='2025-05-08'
Columns
| Name | Type | References | Description |
| Comments | Int | The total number of comments received during the specified reporting period. | |
| Date | Date | The date marking the most recent point in the reporting period for which statistics are returned. | |
| Followers | Int | The cumulative number of users following the site. | |
| Likes | Int | The total number of likes recorded during the specified reporting period. | |
| Period | String | The time range covered by the statistics, such as day, week, or month.
The allowed values are day, month, week, year. | |
| Reblogs | Int | The total number of times posts were reblogged during the specified reporting period. | |
| Views | Int | The total number of views recorded during the specified reporting period, up to the given date. | |
| Visitors | Int | The total number of unique visitors who accessed the site during the specified reporting period, up to the given date. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| NumofPeriods | Int | Determines how many reporting periods to include in the returned results. |