Analytics
The Analytics API provides account, campaign, and creative level insights on click intelligence numbers.
Table Specific Information
Select
The Analytics view provides account, campaign, and creative level insights on click intelligence numbers. Examples of these insights include clicks, shares, and impressions.
The connector uses the LinkedIn Marketing Solutions API to process search criteria. The connector processes other filters client-side within the connector. For example, the following queries are processed server side:
SELECT ReportStartTime, ReportEndTime, Clicks, Impressions, Follows, TotalEngagements FROM Analytics WHERE ReportStartTime = '07/20/2016' AND Account = '123456789' AND Granularity = 'MONTHLY'
Select Rules
Dimensions
Analytics reports provide performance metrics that help evaluate and optimize campaigns. They also require certain mandatory dimensions to be defined. At a minimum, you must specify:
- ReportStartTime
- Granularity
Additionally, there are optional dimensions that can be included to refine the report. For example:
- ReportEndTime
- CampaignType
The dimensions available depend on the value of FinderMethod, which can be either Analytics or Statistics. This setting defines which dimensions are required, which optional dimensions are available, and how filters and metrics can be combined in the query.
- If FinderMethod = Analytics (default), then you may select up to 1 dimension (default: Campaign) from the following options: Company, Account, Share, Campaign, CampaignGroup, Creative, Conversion, ServingLocation, CardIndex, MemberCompanySize, MemberIndustry, MemberSeniority, MemberJobTitle, MemberJobFunction, MemberCountry, MemberRegion, or MemberCompany.
- If FinderMethod = Statistics, then you may select up to 2 dimensions (default: Campaign) from the following options: Company, Account, Share, Campaign, CampaignGroup, Creative, Conversion, ServingLocation, or CardIndex.
Metrics
Analytics reports need at least one metric specified, such as Engagement or Conversions, to track campaign performance.
The metrics include:
Impression & Reach Metrics
- Impressions, CardImpressions, ApproximateMemberReach, AverageDailyReachMetricsApproximateReach, AverageDailyReachMetricsApproximateFrequency, AverageDailyReachMetricsApproximateCost, AveragePreviousSevenDayReachMetricsApproximateReach, AveragePreviousSevenDayReachMetricsApproximateFrequency, AveragePreviousSevenDayReachMetricsApproximateCost,
AveragePreviousThirtyDayReachMetricsApproximateReach, AveragePreviousThirtyDayReachMetricsApproximateFrequency, AveragePreviousThirtyDayReachMetricsApproximateCost
Click Metrics
- Clicks, ActionClicks, AdUnitClicks, LandingPageClicks, CardClicks, TextUrlClicks, DownloadClicks
Engagement Metrics
- Likes, Shares, Comments, CommentLikes, Follows, Opens, TotalEngagements, OtherEngagements, CompanyPageClicks
Video Metrics
- VideoStats, VideoViews, VideoCompletions, VideoFirstQuartileCompletions, VideoMidpointCompletions, VideoThirdQuartileCompletions, FullScreenPlays
Viral Metrics
- ViralClicks, ViralImpressions, ViralLikes, ViralShares, ViralComments, ViralTotalEngagements, ViralCompanyPageClicks, ViralLandingPageClicks, ViralOtherEngagements, ViralFullScreenPlays, ViralVideoStarts, ViralVideoViews, ViralVideoCompletions, ViralVideoFirstQuartileCompletions, ViralVideoMidpointCompletions, ViralVideoThirdQuartileCompletions, ViralExternalWebsiteConversions, ViralExternalWebsitePostClickConversions, ViralExternalWebsitePostViewConversions, ViralFollows, ViralOneClickLeadFormOpens, ViralOneClickLeads, ViralCardClicks, ViralCardImpressions
Conversion & Lead Metrics
- ExternalWebsiteConversions, ExternalWebsitePostClickConversions, ExternalWebsitePostViewConversions, PostClickRegistrations, PostViewRegistrations, OneClickLeadFormOpens, OneClickLeads, QualifiedLeads, ValidWorkEmailLeads, LeadGenerationMailContactInfoShares, LeadGenerationMailInterestedClicks, ConversionValueInLocalCurrency
Cost Metrics
- CostInLocalCurrency, CostInUsd, CostPerQualifiedLead
Other Metrics
- MessagingAdvertSendCount, MessagingAdvertOpenCount, DocumentCompletions, AudiencePenetration, AverageDwellTime
Filters
Filters refine which data is returned in the report and must be valid. If no explicit filters are specified, the report will filter on all the accounts that belong to the user.
The valid filters include:
- Account
- Campaign
- Creative
The Analytics table requires a query structure based on the FinderMethod and the selected Dimensions, Filters, and Metrics. For example:
If FinderMethod = Analytics (only required dimensions + 1 filter + 1 metric):
SELECT ReportStartTime, Granularity, Clicks
FROM Analytics
WHERE FinderMethod = 'Analytics'
AND ReportStartTime = '2024-08-01'
AND Granularity = 'MONTHLY'
AND Account = '123456789';
If FinderMethod = Analytics (required + optional dimensions + multiple metrics and filters):
SELECT ReportStartTime, ReportEndTime, Granularity, CampaignType, Clicks, Impressions, TotalEngagements
FROM Analytics
WHERE FinderMethod = 'Analytics'
AND ReportStartTime = '2024-08-01'
AND ReportEndTime = '2024-08-31'
AND Granularity = 'MONTHLY'
AND CampaignType = 'SponsoredContent'
AND Campaign = '987654321';
If FinderMethod = Statistics (required + 2 optional dimensions + multiple metrics):
SELECT ReportStartTime, Granularity, Campaign, Creative, Impressions, Follows
FROM Analytics
WHERE FinderMethod = 'Statistics'
AND ReportStartTime = '2024-08-01'
AND Granularity = 'MONTHLY'
AND Campaign = '987654321'
AND Creative = '555888999';
Columns
| Name | Type | References | Description |
| Company | String | Pivot value which groups the result by advertiser's company. | |
| Account | String | Pivot value which groups the result by account. | |
| Share | String | Pivot value which groups the result by sponsored share. | |
| Campaign | String | Pivot value which groups the result by campaign. | |
| Creative | String | Pivot value which groups the result by creative. | |
| CampaignGroup | String | Pivot value which groups the result by campaign group. | |
| Conversion | String | Pivot value which groups the result by conversion. | |
| ServingLocation | String | Pivot value which groups the result by serving location. | |
| CardIndex | String | Pivot value which groups the result by card index. | |
| MemberCompanySize | String | Pivot value which groups the result by member company size. | |
| MemberIndustry | String | Pivot value which groups the result by member industry. | |
| MemberSeniority | String | Pivot value which groups the result by member seniority. | |
| MemberJobTitle | String | Pivot value which groups the result by member job title. | |
| MemberJobFunction | String | Pivot value which groups the result by member job function. | |
| MemberCountry | String | Pivot value which groups the result by member country. | |
| MemberRegion | String | Pivot value which groups the result by member region. | |
| MemberCounty | String | Pivot value which groups the result by member county. | |
| MemberCompany | String | Pivot value which groups the result by member company. | |
| PlacementName | String | Pivot value which groups the result by member company. | |
| ImpressionDeviceType | String | Pivot value which groups the result by member company. | |
| CampaignType | String | Match result by campaign type.
使用できる値は次のとおりです。TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC | |
| Granularity | String | Time granularity of results.
使用できる値は次のとおりです。DAILY, MONTHLY, YEARLY, ALL デフォルト値はMONTHLYです。 | |
| FinderMethod | String | Designates the query finder. The only allowed values are analytics or statistics.
使用できる値は次のとおりです。analytics, statistics デフォルト値はanalyticsです。 | |
| ReportStartTime | String | The start time of the period. | |
| ReportEndTime | String | The end time of the period. | |
| EventStage | String | Organize results based on the stage of the live event. | |
| ActionClicks | Long | The count of clicks on the action button of the Sponsored InMail. | |
| AdUnitClicks | Long | The count of clicks on the ad unit displayed alongside the Sponsored InMail. | |
| CardClicks | Long | The number of clicks for each card of a carousel ad. | |
| CardImpressions | Long | The number of impressions shown for each card of a carousel ad. | |
| Clicks | Long | The count of chargeable clicks. | |
| CommentLikes | Long | The count of likes of a comment. | |
| Comments | Long | The count of comments. Sponsored. | |
| CompanyPageClicks | Long | The count of clicks to view the company page. | |
| ConversionValueInLocalCurrency | Decimal | Value of the conversions in the account's local currency based on rules defined by the advertiser. | |
| CostInLocalCurrency | Decimal | Cost in the account's local currency based on the pivot and timeGranularity. | |
| CostInUsd | Decimal | Cost in USD based on the pivot and timeGranularity. | |
| UsageStartTime | String | Date start covered by the report data point. | |
| UsageEndTime | String | Date end covered by the report data point. | |
| ExternalWebsiteConversions | Long | The count of conversions indicated by pixel loads on an external advertiser website. | |
| ExternalWebsitePostClickConversions | Long | The count of post-click conversions indicated by pixel loads on an external advertiser website. | |
| ExternalWebsitePostViewConversions | Long | The count of post-view conversions indicated by pixel loads on an external advertiser website. | |
| Follows | Long | The count of follows. Sponsored. | |
| FullScreenPlays | Long | A user taps on the video, going into video view mode. | |
| Impressions | Long | This is the count of 'impressions' for Direct Ads and Sponsored Updates and 'sends' for InMails. | |
| LandingPageClicks | Long | The count of clicks which take the user to the creative landing page. | |
| LeadGenerationMailContactInfoShares | Long | The number of times a user shared contact info through the One Click Lead Gen for Sponsored InMail. | |
| LeadGenerationMailInterestedClicks | Long | The count of InMail recipients showing interest. | |
| Likes | Long | The count of likes. | |
| OneClickLeadFormOpens | Long | The count of times a user opened the lead form for a One Click Lead Gen campaign. | |
| OneClickLeads | Long | The count of leads generated through One Click Lead Gen. | |
| Opens | Long | The count of opens of Sponsored InMail. | |
| OtherEngagements | Long | The count of user interactions with the ad unit that do not fit into any other more specific category. | |
| Shares | Long | The count of shares. | |
| TextUrlClicks | Long | The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. | |
| TotalEngagements | Long | The count of all user interactions with the ad unit. | |
| VideoCompletions | Long | The count of video ads that played 97-100% of the video. | |
| VideoFirstQuartileCompletions | Long | The count of video ads that played through the first quartile of the video. | |
| VideoMidpointCompletions | Long | The count of video ads that played through the midpoint of the video. | |
| VideoStarts | Long | The count of video ads that were started by a user. | |
| VideoThirdQuartileCompletions | Long | The count of video ads that played through the third quartile of the video. | |
| VideoViews | Long | A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. | |
| ViralCardClicks | Long | The number of viralClicks for each card of a carousel ad. | |
| ViralCardImpressions | Long | The number of viralImpressions shown for each card of a carousel ad. | |
| ViralClicks | Long | The count of clicks on viral impressions. | |
| ViralComments | Long | The count of comments from viral impressions for this activity. | |
| ViralCompanyPageClicks | Long | The count of clicks to view the company page from viral impressions for this activity. | |
| ViralExternalWebsiteConversions | Long | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. | |
| ViralExternalWebsitePostClickConversions | Long | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click. | |
| ViralExternalWebsitePostViewConversions | Long | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression. | |
| ViralFollows | Long | The count of follows from viral impressions for this activity. | |
| ViralFullScreenPlays | Long | A user taps on the video, going into video view mode. | |
| ViralImpressions | Long | The count of viral impressions for this activity. | |
| ViralLandingPageClicks | Long | The count of clicks on viral impressions to take the user to the creative landing page. | |
| ViralLikes | Long | The count of likes from viral impressions for this activity. | |
| ViralOneClickLeadFormOpens | Long | The count of times a user opened the lead form for viral impressions from a Lead Gen campaign. | |
| ViralOneClickLeads | Long | The count of leads generated through One Click Lead Gen from viral impressions for this activity. | |
| ViralOtherEngagements | Long | The count of user interactions with viral impressions that do not fit into any other more specific category. | |
| ViralShares | Long | The count of shares from viral impressions for this activity. | |
| ViralTotalEngagements | Long | The count of all user interactions with a viral ad unit. | |
| ViralVideoCompletions | Long | The count of viral video ads that played 97-100% of the video. | |
| ViralVideoFirstQuartileCompletions | Long | The count of viral video ads that played through the first quartile of the video. | |
| ViralVideoMidpointCompletions | Long | The count of viral video ads that played through the midpoint of the video. | |
| ViralVideoStarts | Long | The count of viral video ads that were started by a user. | |
| ViralVideoThirdQuartileCompletions | Long | The count of viral video ads that played through the third quartile of the video. | |
| ViralVideoViews | Long | A viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. | |
| AverageDailyReachMetricsApproximateReach | Decimal | The average reach, or unique member accounts with at least one impression (daily). | |
| AverageDailyReachMetricsApproximateFrequency | Decimal | The average of impressions shown to each member account that received at least one impression (daily). | |
| AverageDailyReachMetricsApproximateCost | Decimal | The average of spend on your ads, divided by member accounts reached, multiplied by 1,000 (daily). | |
| AveragePreviousSevenDayReachMetricsApproximateReach | Decimal | The average reach, or unique member accounts with at least one impression (last 7 days). | |
| AveragePreviousSevenDayReachMetricsApproximateFrequency | Decimal | The average of impressions shown to each member account that received at least one impression (last 7 days). | |
| AveragePreviousSevenDayReachMetricsApproximateCost | Decimal | The average of spend on your ads, divided by member accounts reached, multiplied by 1,000 (last 7 days). | |
| AveragePreviousThirtyDayReachMetricsApproximateReach | Decimal | The average reach, or unique member accounts with at least one impression (last 30 days). | |
| AveragePreviousThirtyDayReachMetricsApproximateFrequency | Decimal | The average of impressions shown to each member account that received at least one impression (last 30 days). | |
| AveragePreviousThirtyDayReachMetricsApproximateCost | Decimal | The average of spend on your ads, divided by member accounts reached, multiplied by 1,000 (last 30 days). | |
| ApproximateMemberReach | Long | The estimated number of unique member accounts with at least one impression. This metric is only available when the number of days in the date range is less than or equal to 92 days. It will be returned only if the following pivots/columns are specified in the query: Creative, Campaign, CampaignGroup, CampaignType and/or ServingLocation. Additionally, it will not be available for the current UTC day. The expected delay for current UTC day will be 24-48 hours. If the present day is specified in ReportEndTime, the date range will only return reach for days where data exists. | |
| ValidWorkEmailLeads | Long | The count of leads with a valid work email that does not use an established free or personal email domain. | |
| PostClickRegistrations | Decimal | The number of times a member has registered for an event or seminar after clicking on an ad which has a LinkedIn landing page. | |
| PostViewRegistrations | Decimal | The number of times a member has registered for an event or seminar after viewing an ad which has a LinkedIn event landing page. | |
| DownloadClicks | Long | The number of times users have indicated the intent to download the media in an ad by clicking the download icon. | |
| QualifiedLeads | Long | The count of qualified leads shared by the advertiser. Qualified lead is a lead that has been deemed more likely to become a customer compared to other leads, based on their engagement and fit. | |
| CostPerQualifiedLead | Decimal | How much money was spent per qualified lead. Ratio is costInLocalCurrency / qualifiedLeads. | |
| MessagingAdvertSendCount | Long | The count of sends of Sponsored Messaging ads. | |
| MessagingAdvertOpenCount | Long | The count of opens of Sponsored Messaging ads. | |
| AudiencePenetration | Decimal | The approximate number of unique members reached by the advertiser divided by the approximate total target audience size. The field will be null if the date range has more than 92 days. This metric only supports the 'CAMPAIGN' pivot. This metric is not returned when using 'MONTHLY' granularity. | |
| AverageDwellTime | Long | Average user dwell time (in seconds). It measures the duration for which more than 50% of the ad's pixels remain visible in the viewport. | |
| DocumentCompletions | Long | The number of times users reached 100% of the document’s length, including those that skipped to this point. |