CompanyUpdateStatistics
Query update statistics about a company. If the TimeRange filters are not specified, the default result set is for the last 12 months.
Select
The driver will use the LinkedIn API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- CompanyId supports the '=' comparisons.
- UGCPostId supports the '=,IN' comparisons.
For example, the following queries are processed server side:
SELECT * FROM CompanyUpdateStatistics WHERE CompanyId='183432'
SELECT * FROM CompanyUpdateStatistics WHERE UGCPostId='urn:li:ugcPost:1234'
SELECT * FROM CompanyUpdateStatistics WHERE UGCPostId IN ('urn:li:ugcPost:1234','urn:li:ugcPost:2345')
Columns
| Name | Type | Description |
| Clicks | Integer | Total clicks count. |
| Comments | Integer | Total comments count. |
| CommentMentions | Integer | Total comment mentions count. |
| Engagement | Double | Total engagement count. |
| Impressions | Integer | Total impressions count. |
| Likes | Integer | Total likes count. |
| Shares | Integer | Total shares count. |
| ShareMentions | Integer | Total share mentions count. |
| UniqueImpressions | Integer | Total share mentions count. |
| TimeRangeStart | Datetime | Exclusive starting datetime of when the query should begin. Queries from beginning of time when not set. |
| TimeRangeEnd | Datetime | Inclusive ending datetime of when the query should end. Queries until current time when not set. |
| TimeGranularity | String | Granularity of the statistics. Must be either DAY or MONTH. |
| UGCPostId | String | The ID of the UGC post. |
| ShareId | String | The ID of the share. |
| CompanyId | String | Id of the Company associated with the update statistics. |