Analytics
Delivers performance insights at the account, campaign, and creative levels, including metrics such as impressions, clicks, and engagement.
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 | Groups the analytics results by the advertiser company associated with the campaign data. | |
| Account | String | Groups the analytics results by the advertising account. | |
| Share | String | Groups the analytics results by the sponsored share that generated engagement. | |
| Campaign | String | Groups the analytics results by campaign to enable campaign-level performance analysis. | |
| Creative | String | Groups the analytics results by creative asset to measure individual ad performance. | |
| CampaignGroup | String | Groups the analytics results by campaign group for aggregated reporting. | |
| Conversion | String | Groups the analytics results by conversion type to analyze performance by conversion action. | |
| ServingLocation | String | Groups the analytics results by the ad's serving location, such as LinkedIn feed or partner network. | |
| CardIndex | String | Groups the analytics results by the index of each carousel card to measure engagement by card. | |
| MemberCompanySize | String | Groups the analytics results by the company size of the engaged member. | |
| MemberIndustry | String | Groups the analytics results by the member's industry, based on LinkedIn profile data. | |
| MemberSeniority | String | Groups the analytics results by the seniority level of the engaged member. | |
| MemberJobTitle | String | Groups the analytics results by the job title of the engaged member. | |
| MemberJobFunction | String | Groups the analytics results by the job function of the engaged member. | |
| MemberCountry | String | Groups the analytics results by the member's country. | |
| MemberRegion | String | Groups the analytics results by the member's region. | |
| MemberCounty | String | Groups the analytics results by the member's county. | |
| MemberCompany | String | Groups the analytics results by the company where the engaged member works. | |
| PlacementName | String | Groups the analytics results by placement name, representing where the ad appeared. | |
| ImpressionDeviceType | String | Groups the analytics results by the device type used to view the ad. | |
| CampaignType | String | Groups the analytics results by campaign type for comparative performance insights.
The allowed values are TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC. | |
| Granularity | String | Specifies the time granularity of results.
The allowed values are DAILY, MONTHLY, YEARLY, ALL. The default value is MONTHLY. | |
| FinderMethod | String | Identifies the query method used to retrieve analytics data. Supported values are 'analytics' and 'statistics'.
The allowed values are analytics, statistics. The default value is analytics. | |
| ReportStartTime | String | Specifies the start date and time for the reporting period. | |
| ReportEndTime | String | Specifies the end date and time for the reporting period. | |
| EventStage | String | Groups results by stage of a live event to analyze engagement throughout the event lifecycle. | |
| ActionClicks | Long | Number of clicks on the action button within Sponsored InMail messages. | |
| AdUnitClicks | Long | Number of clicks on the ad unit displayed alongside a Sponsored InMail message. | |
| CardClicks | Long | Number of clicks received by individual cards within a carousel ad. | |
| CardImpressions | Long | Number of impressions shown for each card in a carousel ad. | |
| Clicks | Long | Total number of chargeable clicks recorded for the ad. | |
| CommentLikes | Long | Number of likes on comments associated with the ad. | |
| Comments | Long | Number of comments posted in response to the ad. | |
| CompanyPageClicks | Long | Number of clicks to view the advertiser's LinkedIn company page. | |
| ConversionValueInLocalCurrency | Decimal | Total conversion value in the account's local currency, calculated according to advertiser-defined rules. | |
| CostInLocalCurrency | Decimal | Total advertising cost in the account's local currency, aggregated by pivot and time granularity. | |
| CostInUsd | Decimal | Total advertising cost in USD, aggregated by pivot and time granularity. | |
| UsageStartTime | String | Start date for the period covered by the data point. | |
| UsageEndTime | String | End date for the period covered by the data point. | |
| ExternalWebsiteConversions | Long | Number of conversions recorded on an external advertiser website through pixel tracking. | |
| ExternalWebsitePostClickConversions | Long | Number of post-click conversions recorded on an external advertiser website through pixel tracking. | |
| ExternalWebsitePostViewConversions | Long | Number of post-view conversions recorded on an external advertiser website through pixel tracking. | |
| Follows | Long | Number of new followers gained through sponsored content. | |
| FullScreenPlays | Long | Number of times a user tapped a video to enter full-screen viewing mode. | |
| Impressions | Long | Total number of impressions for Direct Ads and Sponsored Updates, or 'sends' for InMail campaigns. | |
| LandingPageClicks | Long | Number of clicks that directed users to the creative's landing page. | |
| LeadGenerationMailContactInfoShares | Long | Number of times a user shared their contact information through a one-click Lead Gen form in Sponsored InMail. | |
| LeadGenerationMailInterestedClicks | Long | Number of clicks indicating user interest in a Sponsored InMail lead generation message. | |
| Likes | Long | Total number of likes received on the ad. | |
| OneClickLeadFormOpens | Long | Number of times users opened a one-click Lead Gen form during a campaign. | |
| OneClickLeads | Long | Number of leads generated through one-click Lead Gen submissions. | |
| Opens | Long | Number of times Sponsored InMail messages were opened by recipients. | |
| OtherEngagements | Long | Number of user interactions with the ad that do not fall into other defined engagement types. | |
| Shares | Long | Number of times the ad was shared by users. | |
| TextUrlClicks | Long | Number of clicks on text links included within the body of Sponsored InMail messages. | |
| TotalEngagements | Long | Total number of user interactions with the ad unit across all engagement types. | |
| VideoCompletions | Long | Number of video ads that played at least 97–100% of their duration. | |
| VideoFirstQuartileCompletions | Long | Number of video ads that played through the first 25% of their duration. | |
| VideoMidpointCompletions | Long | Number of video ads that played through 50% of their duration. | |
| VideoStarts | Long | Number of times users started playing a video ad. | |
| VideoThirdQuartileCompletions | Long | Number of video ads that played through 75% of their duration. | |
| VideoViews | Long | Number of video ads viewed for at least two continuous seconds while 50% visible, or when a call-to-action (CTA) click occurs first. | |
| ViralCardClicks | Long | Number of clicks on viral carousel cards that spread through organic sharing. | |
| ViralCardImpressions | Long | Number of viral impressions shown for each card in a carousel ad. | |
| ViralClicks | Long | Number of clicks on viral impressions generated by organic distribution. | |
| ViralComments | Long | Number of comments originating from viral impressions of this ad. | |
| ViralCompanyPageClicks | Long | Number of clicks to view the advertiser's company page from viral impressions. | |
| ViralExternalWebsiteConversions | Long | Number of conversions on external websites driven by viral impressions. | |
| ViralExternalWebsitePostClickConversions | Long | Number of post-click conversions on external websites driven by viral engagement. | |
| ViralExternalWebsitePostViewConversions | Long | Number of post-view conversions on external websites driven by viral engagement. | |
| ViralFollows | Long | Number of followers gained through viral impressions. | |
| ViralFullScreenPlays | Long | Number of times users opened a viral video in full-screen mode. | |
| ViralImpressions | Long | Total number of viral impressions generated by organic sharing. | |
| ViralLandingPageClicks | Long | Number of clicks on viral impressions that led users to the ad's landing page. | |
| ViralLikes | Long | Number of likes generated from viral impressions. | |
| ViralOneClickLeadFormOpens | Long | Number of times users opened a lead form through viral impressions in a Lead Gen campaign. | |
| ViralOneClickLeads | Long | Number of leads generated through one-click Lead Gen submissions from viral impressions. | |
| ViralOtherEngagements | Long | Number of user interactions with viral impressions not categorized elsewhere. | |
| ViralShares | Long | Number of shares generated from viral impressions. | |
| ViralTotalEngagements | Long | Total number of user interactions recorded for viral ad units. | |
| ViralVideoCompletions | Long | Number of viral video ads that played at least 97–100% of their duration. | |
| ViralVideoFirstQuartileCompletions | Long | Number of viral video ads that played through the first 25% of their duration. | |
| ViralVideoMidpointCompletions | Long | Number of viral video ads that played through 50% of their duration. | |
| ViralVideoStarts | Long | Number of times users started playing a viral video ad. | |
| ViralVideoThirdQuartileCompletions | Long | Number of viral video ads that played through 75% of their duration. | |
| ViralVideoViews | Long | Number of viral video ads viewed for at least two continuous seconds while 50% visible, or when a CTA click occurs first. | |
| AverageDailyReachMetricsApproximateReach | Decimal | Average daily reach, representing unique member accounts with at least one impression per day. | |
| AverageDailyReachMetricsApproximateFrequency | Decimal | Average number of impressions shown per member account reached per day. | |
| AverageDailyReachMetricsApproximateCost | Decimal | Average daily advertising spend per 1,000 member accounts reached. | |
| AveragePreviousSevenDayReachMetricsApproximateReach | Decimal | Average reach for the previous 7 days, representing unique member accounts with at least one impression. | |
| AveragePreviousSevenDayReachMetricsApproximateFrequency | Decimal | Average number of impressions shown per member account reached over the last 7 days. | |
| AveragePreviousSevenDayReachMetricsApproximateCost | Decimal | Average advertising spend per 1,000 member accounts reached during the last 7 days. | |
| AveragePreviousThirtyDayReachMetricsApproximateReach | Decimal | Average reach for the previous 30 days, representing unique member accounts with at least one impression. | |
| AveragePreviousThirtyDayReachMetricsApproximateFrequency | Decimal | Average number of impressions shown per member account reached over the last 30 days. | |
| AveragePreviousThirtyDayReachMetricsApproximateCost | Decimal | Average advertising spend per 1,000 member accounts reached during the last 30 days. | |
| ApproximateMemberReach | Long | Estimated number of unique member accounts with at least one impression, available for reporting periods up to 92 days and excluding the current UTC day. | |
| ValidWorkEmailLeads | Long | Number of leads containing a valid work email address that does not belong to a free or personal domain. | |
| PostClickRegistrations | Decimal | Number of event or seminar registrations completed after a user clicked an ad with a LinkedIn landing page. | |
| PostViewRegistrations | Decimal | Number of event or seminar registrations completed after a user viewed an ad with a LinkedIn event landing page. | |
| DownloadClicks | Long | Number of times users clicked the download icon in an ad to indicate intent to download media or content. | |
| QualifiedLeads | Long | Number of qualified leads determined by the advertiser as having a higher likelihood of becoming customers based on engagement and fit. | |
| CostPerQualifiedLead | Decimal | Average cost spent per qualified lead, calculated as cost in local currency divided by number of qualified leads. | |
| MessagingAdvertSendCount | Long | Number of Sponsored Messaging ads sent to recipients. | |
| MessagingAdvertOpenCount | Long | Number of Sponsored Messaging ads opened by recipients. | |
| AudiencePenetration | Decimal | Ratio of unique members reached to the total target audience size. Available only for date ranges up to 92 days and supported for the 'CAMPAIGN' pivot with 'MONTHLY' granularity excluded. | |
| AverageDwellTime | Long | Average time in seconds that more than 50% of an ad's pixels remained visible on screen, indicating user attention duration. | |
| DocumentCompletions | Long | Number of times users viewed 100% of a document's length, including those who skipped directly to the end. |