ODBC Driver for WordPress

Build 25.0.9434

SiteStatsReferrers

Query the SiteStatsReferrers in Worpress.

Table Specific Information

SELECT

The 本製品 uses the WordPress API to process some of the filters.

  • Date supports the '=' comparison.
  • Period supports the '=' comparison.
  • Summarize supports the '=' comparison.

The 本製品 processes other filters client-side within the 本製品.

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

疑似カラムフィールドはSELECT ステートメントのWHERE 句で使用され、操作によって返されるデータをより細かく制御することができます。

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434