SiteStatsReferrers
Query the SiteStatsReferrers in Worpress.
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.
- Summarize 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 SiteStatsReferrers WHERE Date='2025-05-14'
SELECT * FROM SiteStatsReferrers WHERE Period='month';
Columns
| Name | Type | References | Description |
| Date | Date | The most recent date for which referrer statistics are available. | |
| GroupsAggregate | String | A list of referrer groups, where each entry represents a referring website, platform, or source domain that directed traffic to the site. | |
| OtherViews | Int | The total number of views from referrers not included in the main groups, such as uncommon or unidentified traffic sources. | |
| TotalViews | Int | The total number of views generated from all referrers, including both grouped and uncategorized sources. | |
| DaysAggregate | String | A collection of daily referral data showing how views changed over time (omitted when summarize=true). | |
| Period | String | The reporting period covered by the returned statistics, 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 | |
| HasSummarize | Boolean | Indicates whether the summarize parameter is supported for this dataset. | |
| NumofPeriods | Int | Specifies how many time periods are included in the result set. |