SiteSearchTerms
Query the SiteSearchTerms in Wordpress.
Table Specific Information
SELECT
The server uses the WordPress API to process some of the filters.
- Period supports the '=' comparison.
- Date supports the '=' comparison.
- Summarize supports the '=' comparison.
The server processes other filters client-side within the server.
For example, the following queries are processed server side.
SELECT * FROM SiteSearchTerms WHERE Period='day'
Columns
| Name | Type | References | Description |
| Period | String | The reporting period covered by the returned search statistics (for example, day, week, or month). | |
| SummaryEncryptedSearchTerms | Int | The total count of encrypted or anonymized search terms, representing searches where the original keywords are not available. | |
| SummarySearchTerms | String | A list of the top search terms entered by site visitors during the reporting period. | |
| SummaryOtherSearchTerms | Int | The number of less-frequent search terms grouped under 'Other' in the summary results. | |
| SummaryTotalSearchTerms | Int | The total number of unique search terms recorded for the period, including summarized and encrypted terms. | |
| DaysAggregate | String | An array showing daily search activity and corresponding search terms for each date (omitted when summarize=true). | |
| Date | Date | The most recent date for which search term statistics are available. |
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 results are summarized instead of showing detailed daily data. | |
| NumofPeriods | Int | Specifies how many reporting periods are included in the returned results. |