SiteVideoPlays
Query the SiteVideoPlays in Wordpress.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- Date supports the '=' comparison.
- Period supports the '=' comparison.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side.
SELECT * FROM SiteVideoPlays where Date='2025-05-08'
SELECT * FROM SiteVideoPlays where Period='day'
Columns
| Name | Type | References | Description |
| Date | Date | The most recent date for which video play statistics are returned. | |
| DaysAggregate | String | A collection of daily video play data showing how many times videos were played on specific days. | |
| period | String | The reporting interval for which statistics are returned, such as day, week, or month. |
Pseudo-Columns
Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.
| Name | Type | Description | |
| NumofPeriods | Int | The number of reporting periods included in the results. |