SiteStats
Query the SiteStats in Wordpress.
Table Specific Information
SELECT
The connector processes all the filters client-side within the connector.
SELECT * FROM SiteStats
Columns
| Name | Type | References | Description |
| Date | Date | The date the statistics snapshot was taken. | |
| StatsCategories | Int | The total number of distinct categories created in the site. | |
| StatsComments | Int | The total number of comments posted across all site content. | |
| StatsCommentsMostActiveRecentDay | String | The most recent day when the site received the highest number of comments. | |
| StatsCommentsMostActiveTime | String | The time of day when the site typically receives the most comments. | |
| StatsCommentsPerMonth | Int | The average number of comments received each month. | |
| StatsCommentsSpam | Int | The total number of comments flagged as spam. | |
| StatsFollowersBlog | Int | The number of followers subscribed to the blog. | |
| StatsFollowersComments | Int | The number of comments made by followers. | |
| StatsPosts | Int | The total number of posts published on the site. | |
| StatsShares | Int | The total number of content shares across all supported platforms. | |
| StatsSharesFacebook | Int | The number of times content was shared on Facebook. | |
| StatsSharesPressThis | Int | The number of times content was shared using the WordPress Press This bookmarklet. | |
| StatsSharesTwitter | Int | The number of times content was shared on Twitter. | |
| StatsTags | Int | The total number of unique tags applied to posts. | |
| StatsViews | Int | The cumulative number of views across all posts and pages on the site. | |
| StatsViewsBestDay | String | The date when the site received the highest number of views in a single day. | |
| StatsViewsBestDayTotal | Int | The total number of views recorded on the site's best-performing day. | |
| StatsViewsToday | Int | The total number of views recorded so far today. | |
| StatsViewsYesterday | Int | The total number of views recorded on the previous day. | |
| StatsVisitors | Int | The cumulative number of unique visitors who have accessed the site. | |
| StatsVisitorsToday | Int | The number of unique visitors who have accessed the site today. | |
| StatsVisitorsYesterday | Int | The number of unique visitors who accessed the site on the previous day. | |
| VisitsDataAggregate | String | A collection of daily visitor and view counts, used to analyze traffic trends over time. | |
| VisitsDate | Date | The specific date for which the visit data is reported. | |
| VisitsFieldsAggregate | String | The set of metrics tracked for each recorded visit, such as views and visitors. | |
| VisitsUnit | String | The time unit used for reporting visit data, typically measured on a daily basis. |