SitePostViews
Query the SitePostViews in Wordpress.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- PostId supports the '=' comparison.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM SitePostViews WHERE PostID=21
Columns
| Name | Type | References | Description |
| PostID [KEY] | Int | The unique identifier of the post for which view statistics are returned. | |
| Date | Date | The most recent date for which post view statistics are available. | |
| PostAuthor | String | The unique identifier of the post author. | |
| PostName | String | The URL-friendly slug used to identify the post in its permalink. | |
| PostParent | Int | The ID of the parent post, if the post is part of a hierarchy (for example, a page with subpages). | |
| PostPassword | String | The password protecting the post, if it is password-protected; otherwise empty. | |
| PostStatus | String | The publication status of the post, such as publish, draft, pending, private, or trash. | |
| PostTitle | String | The title of the post. | |
| Views | Int | The total number of times the post has been viewed. | |
| PostType | String | The post type, such as post, page, or a registered custom type. | |
| HighestDayAverage | Int | The highest daily average number of views recorded for this post. | |
| HighestMonth | Int | The month during which the post achieved the highest average views. | |
| HighestWeekAverage | Int | The highest weekly average number of views recorded for this post. | |
| YearsAggregate | String | A dataset showing the total views for the post, grouped by year and month. | |
| AveragesAggregate | String | A dataset showing per-day average views, grouped by year and month. | |
| WeeksAggregate | String | Daily view counts for recent weeks, useful for short-term performance trends. | |
| FieldsAggregate | String | Defines the schema for each field in the aggregated view data. | |
| DataAggregate | String | A flattened array of daily view data, containing counts and timestamps for each day. | |
| PostCommentCount | String | The total number of comments associated with the post. | |
| PostCommentStatus | String | Specifies whether comments are allowed (open) or closed for the post. | |
| PostFilter | String | The content filter applied when retrieving post data (for example, raw or formatted). | |
| PostGuid | String | The globally unique identifier (GUID) for the post, typically a permanent link reference. | |
| PostMenuOrder | Int | The menu order value used for hierarchical post types to control display order. | |
| PostPermalink | String | The full public permalink URL for the post. | |
| PostPingStatus | String | Indicates whether pingbacks and trackbacks are enabled for the post. | |
| PostPinged | String | A list of services that have already been pinged for the post. | |
| PostContent | String | The full HTML or text content body of the post. | |
| PostContentFiltered | String | An internal field used to store filtered versions of the post content. | |
| PostDate | Datetime | The local date and time when the post was first published. | |
| PostDateGmt | Datetime | The UTC date and time when the post was first published. | |
| PostExcerpt | String | An optional short summary or excerpt of the post content. | |
| PostMimeType | String | The MIME type of the post, if the post represents a media file attachment. | |
| PostModified | Datetime | The local date and time when the post was last modified. | |
| PostModifiedGmt | Datetime | The UTC date and time when the post was last modified. | |
| PostToPing | String | A legacy field listing URLs to notify (ping) when the post is published. |