Insights
Returns analytical data and performance insights for the WordPress site, including views, visitors, likes, and comments.
Table Specific Information
SELECT
The component processes all the filters client-side within the component.
SELECT * FROM Insights
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | The unique identifier of the WordPress site associated with the insights data. | |
| Name | String | The name or title of the WordPress site associated with the insights. | |
| HasCustom | Bool | Indicates whether the site has custom insights or analytics settings configured. | |
| TodayApiInsightsCommentsNumber | Int | The number of comments recorded on the site today according to API insights. | |
| TodayApiInsightsCommentsPercent | String | The percentage change in comment activity today compared to the previous period. | |
| TodayApiInsightsConnectionsNumber | Int | The total number of new site connections recorded today. | |
| TodayApiInsightsConnectionsPercent | String | The percentage change in new site connections today compared to the previous period. | |
| TodayApiInsightsLikesNumber | Int | The total number of likes recorded on the site today. | |
| TodayApiInsightsLikesPercent | String | The percentage change in likes today compared to the previous period. | |
| TodayApiInsightsPostsNumber | Int | The total number of posts published on the site today. | |
| TodayApiInsightsPostsPercent | String | The percentage change in post publishing activity today compared to the previous period. | |
| TodayRestApiCallsNumber | Int | The total number of REST API calls made to the WordPress site today. | |
| TodayRestApiCallsPercent | String | The percentage change in REST API call activity today compared to the previous period. | |
| TodayRestApiErrorsNumber | Int | The total number of REST API errors that occurred on the site today. | |
| TodayRestApiErrorsPercent | String | The percentage change in REST API errors today compared to the previous period. | |
| TodayRestApiReadsNumber | Int | The total number of REST API read (GET) requests made to the site today. | |
| TodayRestApiReadsPercent | String | The percentage change in REST API read (GET) requests today compared to the previous period. | |
| TodayRestApiWritesNumber | Int | The total number of REST API write (POST, PUT, DELETE) requests made to the site today. | |
| TodayRestApiWritesPercent | String | The percentage change in REST API write requests today compared to the previous period. |