JDBC Driver for LinkedIn

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462