SiteFollowers
Query the SiteFollowers in Wordpress.
Table Specific Information
SELECT
The connector processes all the filters client-side within the connector.
SELECT * FROM SiteFollowers
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | The unique identifier of the follower associated with the site. | |
| Label | String | A display label or name representing the follower or subscription source. | |
| Login | String | The WordPress.com username of the follower, if available. | |
| ItemURL | String | The URL associated with the follower's profile or linked account. | |
| IsOwnerSubscribed | Boolean | Indicates whether the site owner is also subscribed to their own site. | |
| Page | Int | The current page number in the paginated results set. | |
| Pages | Int | The total number of pages available for the follower list. | |
| Total | Int | The total number of followers for the site. | |
| TotalEmail | Int | The total number of followers subscribed via email notifications only. | |
| TotalWpcom | Int | The total number of followers subscribed using WordPress.com accounts. | |
| Avatar | String | The URL of the follower's avatar image. | |
| DateSubscribed | Datetime | The date and time when the follower subscribed to the site. | |
| FollowDataAggregate | String | A JSON object containing detailed metadata about the follower, such as subscription type, source, or delivery method. |
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 | |
| Type | String | Specifies the subscription method: 'wpcom' for WordPress.com followers or 'email' for email-only subscribers. The default is 'wpcom'. |