Query statistics about followers for a particular company page.

Note: Requires the r_organization_admin OAuth scope.

Select

The connector 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 connector.

• CompanyId supports only the '=' operator.
• TimeGranularity supports only the '=' operator.
• ReportTimeRangeStart supports only the '=' operator.
• ReportTimeRangeEnd supports only the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM CompanyFollowerStatistics WHERE CompanyId = '183432'
SELECT * FROM CompanyFollowerStatistics WHERE ReportTimeRangeStart = '2019-10-20' AND ReportTimeRangeEnd = '2020-10-15'
SELECT * FROM CompanyFollowerStatistics WHERE ReportTimeRangeStart = '2019-10-15' AND TimeGranularity = 'DAY'
SELECT * FROM CompanyFollowerStatistics WHERE TimeGranularity = 'MONTH' AND ReportTimeRangeStart = '2019-10-15' AND ReportTimeRangeEnd = '2020-10-15' AND CompanyId = '10904095'

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
CompanyId	String	Id of the Company associated with the follow statistics in the following format urn:li:organization:{id}.
Category	String	The category of the followers.
Type	String	Type of the category.
OrganicFollowerCount	Integer	Total number of the organinc followers.
PaidFollowerCount	Integer	Total number of the paid followers.
TimeGranularity	String	Granularity of the statistics. Must be either DAY or MONTH.
ReportTimeRangeStart	Datetime	Exclusive starting timestamp of when the query should begin. Queries from beginning of time when not set.
ReportTimeRangeEnd	Datetime	Inclusive ending timestamp of when the query should end. Queries until current time when not set.
UsageStartTime	Datetime	Date start covered by the report data point. Refer to the ReportTimeRangeStart column for the start date of the range covered by the complete report.
UsageEndTime	Datetime	Date end covered by the report data point. Refer to the ReportTimeRangeEnd column for the end date of the range covered by the complete report.