Query update statistics about a company. If the TimeRange filters are not specified, the default result set is for the last 12 months.

Note: Requires the r_organization_admin scope.

Select

The component uses 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 component.

• CompanyId supports only the '=' operator.
• TimeGranularity supports only the '=' operator.
• TimeRangeStart supports only the '=' operator.
• TimeRangeEnd supports only the '=' operator.
• UGCPostId supports the '=,IN' comparisons.

For example, the following queries are processed server side:

SELECT * FROM CompanyUpdateStatistics WHERE TimeRangeStart = '2019-10-20' AND TimeRangeEnd = '2020-10-15'
SELECT * FROM CompanyUpdateStatistics WHERE TimeRangeStart = '2019-10-15' AND TimeGranularity = 'DAY'
SELECT * FROM CompanyUpdateStatistics WHERE TimeGranularity = 'MONTH' AND TimeRangeStart = '2019-10-15' AND TimeRangeEnd = '2020-10-15' AND CompanyId = '10904095'
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')

Time-Based Data Queries

The three inputs that control time-based data queries are TimeGranularity, TimeRangeStart, and TimeRangeEnd. TimeGranularity is not always required, but if it is specified you must also specify TimeRange Start, TimeRangeEnd, or both.

The behavior of TimeGranularity in a query depends on what other inputs are specified.

Inputs specified	Result
None	The driver returns all data from the time the company page was created until the present time, in one record.
TimeRangeStart only (no TimeRangeEnd or TimeGranularity)	The driver returns all data from the time specified in TimeRangeStart until the present time, in one record.
TimeRangeStart and TimeRangeEnd (no TimeRangeGranularity)	The driver returns all data from the time specified in TimeRangeStart until the time specified in TimeRangeEnd, in one record. If the value specified in TimeRangeStart is older than the time when the page was created, it retrieves all data from the time the page was created to the time specified in TimeRangeEnd.
TimeRangeEnd only (no TimeRangeStart or TimeGranularity)	The driver returns all data from the time the company page was created, until the time specified in TimeRangeEnd, in one record.
All	The driver breaks down the data into multiple records with different time intervals: one record for every day/month beginning from TimeRangeStart until TimeRangeEnd, depending on the value specified in TimeGranularity.

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. When not set, queries from the beginning of time.
TimeRangeEnd	Datetime	Inclusive ending datetime of when the query should end. When not set, queries until the current time.
TimeGranularity	String	Granularity of the statistics. Must be either DAY or MONTH. Requires TimeRangeStart and TimeRangeEnd.
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.
IntervalStartTime	Datetime	Date start covered by the report data point. For start date of the range covered by the complete report, see the TimeRangeStart column.
IntervalEndTime	Datetime	Date end covered by the report data point. For the end date of the range covered by the complete report, see the TimeRangeEnd column.