SiteCountryViews
Query the SiteCountryViews in Wordpress.
Table Specific Information
SELECT
The provider uses the WordPress API to process some of the filters.
- Date supports the '=' comparison.
- NumofPeriods supports the '=' comparison.
- HasSummarize supports the '=' comparison.
- Period supports the '=' comparison.
The provider processes other filters client-side within the provider.
For example, the following queries are processed server side.
SELECT * FROM SiteCountryViews WHERE Date='2025-05-08'
Columns
| Name | Type | References | Description |
| CountryInfoAggregate | String | An array containing detailed information about each country that generated views for the site, including country codes and view counts. | |
| DaysAggregate | String | An array mapping each day to the number of country-specific views recorded on that date. | |
| Date | Date | The most recent date included in the site's country view statistics. |
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 | Specifies how many time periods to include in the results, such as days, weeks, or months. | |
| HasSummarize | Boolean | Indicates whether the SiteCountryViews results include summarized data. | |
| Period | String | The reporting interval for which statistics are returned, such as day, week, or month.
The allowed values are day, month, week, year. |