> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/linkedin/linkedin-supported-columns.md). # LinkedIn - Supported Columns Every column the LinkedIn connector can download. These are the columns available to a LinkedIn connector. The recommended template uses a small subset of them, listed on the [LinkedIn](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/linkedin.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates. ## Dimensions | Column | Type | Description | | ------------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `dateRange` | DateTime | Date range covered by the report data point. Date is specified in UTC. Start and end date are inclusive. Start date is required. End date is optional and defaults to today. | | `pivotValues` | String | The value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/conversion combination. The pivotValues contain serialized URNs for the specific creative and conversion for a record. | | `CampaignName` | String | Name of the campaign. | | `CampaignGroupName` | String | Name of the campaign group. | ## Metrics | Column | Type | Description | | ------------------------------------------ | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `actionClicks` | Decimal | The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only. | | `adUnitClicks` | Decimal | The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only. | | `approximateUniqueImpressions` | Decimal | DEPRECATED - The approximate reach of the campaign. The number of instances where a unique user viewed an ad served to them by LinkedIn. This metric is not returned by default. It must be explicitly requested in the projection parameter to be returned. | | `approximateMemberReach` | Long | Non-demographic pivots only (i.e. not MEMBER\_). The estimated number of unique member accounts with at least one impression. This metric is an updated and more accurate version of legacy metric approximateUniqueImpressions. This metric is only available when the number of days in the date range is less than or equal to 92 days. This metric is fully launched in Jan 2024. | | `cardClicks` | Decimal | Non-demographic pivots only. The number of clicks for each card of a carousel ad. The first card click of the carousel ad results in an immediate cardClick and click, whereas scrolling to other cards and clicking will count as additional cardClick. | | `cardImpressions` | Decimal | Non-demographic pivots only. The number of impressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate cardImpression and impression, whereas scrolling to other cards will count as additional cardImpressions. | | `clicks` | Decimal | The count of chargeable clicks. Despite not charging for clicks for CPM campaigns, this field still represents those clicks for which we would otherwise charge advertisers (for example, clicks to view the landing page or company page). | | `commentLikes` | Decimal | The count of likes of a comment. Sponsored Updates only. | | `comments` | Decimal | The count of comments. Sponsored Updates only. | | `companyPageClicks` | Decimal | The count of clicks to view the company page. | | `conversionValueInLocalCurrency` | Decimal | Non-demographic pivots only. Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range. | | `costInLocalCurrency` | Decimal | Cost in the account's local currency based on the pivot and timeGranularity. For example, this would be spend by member company size per month if the pivot is MEMBER\_COMPANY\_SIZE and timeGranularity is MONTHLY. Cost is not adjusted for overdelivery when a member demographic pivot is specified in the request. | | `costInUsd` | Decimal | Cost in USD based on the pivot and timeGranularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY. Cost is not adjusted for overdelivery when a member demographic pivot is specified in the request. | | `costPerQualifiedLead` | Decimal | How much money was spent per qualified lead. Ratio is costInLocalCurrency / qualifiedLeads. | | `documentCompletions` | Long | The number of times users reached 100% of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. | | `documentFirstQuartileCompletions` | Long | The number of times users reached the first quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. | | `documentMidpointCompletions` | Long | The number of times users reached the second quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. | | `documentThirdQuartileCompletions` | Long | The number of times users reached the third quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. | | `downloadClicks` | Long | The number of times users have indicated the intent to download the media in an ad by clicking the download icon. This may or may not result in an actual download (e.g. if the user rejects a browser download prompt). This metric is only available for ad formats supporting media downloads | | `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 Updates only. | | `fullScreenPlays` | Long | The count of taps on the video, going into video view mode. | | `headlineClicks` | Long | The number of times members clicked on the headline of conversation ads. | | `headlineImpressions` | Long | The number of times members were shown the headline of conversation ads. | | `impressions` | Long | This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails. | | `jobApplications` | Decimal | The number of times a member completed a job application after viewing or clicking on an ad. Currently, this metric is broken down into postViewJobApplications (if the member applied after viewing the ad) and postClickJobApplications (if the member applied after clicking the ad). | | `jobApplyClicks` | Decimal | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing or clicking on an ad which has a LinkedIn job landing page. Currently, this metric is broken down into postViewJobApplyClicks (if the member performed the action after viewing the ad) and postClickJobApplyClicks (if the member performed the action after clicking the ad). | | `landingPageClicks` | Long | The count of clicks which take the user to the creative landing page. | | `leadGenerationMailContactInfoShares` | Long | The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only. | | `leadGenerationMailInterestedClicks` | Long | The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only. | | `likes` | Long | The count of likes. Sponsored Updates only. | | `oneClickLeadFormOpens` | Long | The count of times users 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. Sponsored InMail only. | | `otherEngagements` | Long | The count of user interactions with the ad unit that do not fit into any other more specific category. | | `postClickJobApplications` | Decimal | The number of times a member completed a job application after clicking on an ad. See also 'jobApplications'. | | `postClickJobApplyClicks` | Decimal | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after clicking on an ad which has a LinkedIn job landing page. See also 'jobApplyClicks'. | | `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. This includes gross registrations and does not account for a user unregistering. | | `postViewJobApplications` | Decimal | The number of times a member completed a job application after viewing an ad. See also 'jobApplications'. | | `postViewJobApplyClicks` | Decimal | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after clicking an ad which has a LinkedIn job landing page. See also 'jobApplyClicks'. | | `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. This includes gross registrations and does not account for a user unregistering. See also 'registrations'. | | `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. | | `reactions` | Long | The count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses. | | `registrations` | Decimal | The number of times a member has registered for an event or seminar after viewing or clicking on an ad which has a LinkedIn event landing page. This includes gross registrations and does not account for a user unregistering. | | `sends` | Long | The count of sends of Sponsored InMail. Sponsored InMail only. | | `shares` | Long | The count of shares. Sponsored Updates only. | | `subscriptionClicks` | Long | The count of clicks to subscribe to a series, such as a Newsletter. | | `talentLeads` | Long | Number of leads captured through a talent media campaign. | | `textUrlClicks` | Long | The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only. | | `totalEngagements` | Long | The count of all user interactions with the ad unit. | | `validWorkEmailLeads` | Long | The count of leads with a valid work email that does not use an established free or personal email domain. | | `videoCompletions` | Long | The count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON\_SITE. | | `videoFirstQuartileCompletions` | Long | The count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON\_SITE. | | `videoMidpointCompletions` | Long | The count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON\_SITE. | | `videoStarts` | Long | The count of video ads that were started by users. | | `videoThirdQuartileCompletions` | Long | The count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON\_SITE. | | `videoViews` | Long | A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view. | | `viralCardClicks` | Long | Non-demographic pivots only. The number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick. | | `viralCardImpressions` | Long | Non-demographic pivots only. The number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viralCardImpressions. | | `viralClicks` | Long | The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only. | | `viralCommentLikes` | Long | The count of likes on comments from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralComments` | Long | The count of comments from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralCompanyPageClicks` | Long | The count of clicks to view the company page from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralDocumentCompletions` | Long | The number of times users reached 100% of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. | | `viralDocumentFirstQuartileCompletions` | Long | The number of times users reached the first quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. | | `viralDocumentMidpointCompletions` | Long | The number of times users reached the second quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. | | `viralDocumentThirdQuartileCompletions` | Long | The number of times users reached the third quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. | | `viralDownloadClicks` | Long | The number of times users have indicated the intent to download the media in a viral ad by clicking the download icon. This may or may not result in an actual download (e.g. if the user rejects a browser download prompt). Only available for ads supporting media downloads. | | `viralExternalWebsiteConversions` | Long | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. See viral impressions definition. | | `viralExternalWebsitePostClickConversions` | Long | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click. See viral impressions definition. | | `viralExternalWebsitePostViewConversions` | Long | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression. See viral impressions definition. | | `viralFollows` | Long | The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralFullScreenPlays` | Long | The count of taps on the video, going into video view mode. See viralImpressions definition. | | `viralImpressions` | Long | The count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions. Sponsored Updates only. | | `viralJobApplications` | Decimal | The number of times a member completed a job application after viewing or clicking on a viral ad. Currently, this metric is broken down into viralPostViewJobApplications (if the member performed the action after viewing the viral ad) and viralPostClickJobApplications (if the member performed the action after clicking the viral ad). | | `viralJobApplyClicks` | Decimal | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing or clicking on a viral ad which has a LinkedIn job landing page during the date range.Currently, this metric is broken down into viralPostViewJobApplyClicks (if the member performed the action after viewing the viral ad) and viralPostClickJobApplyClicks (if the member performed the action after clicking the viral ad). | | `viralLandingPageClicks` | Long | The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only. | | `viralLikes` | Long | The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralOneClickLeadFormOpens` | Long | The count of times users opened the lead form for viral impressions from a Lead Gen campaign. See viral impressions definition. | | `viralOneClickLeads` | Long | The count of leads generated through One Click Lead Gen from viral impressions for this activity. See viral impressions definition. | | `viralOtherEngagements` | Long | The count of user interactions with viral impressions that do not fit into any other more specific category. See viral impressions definition. Sponsored Updates only. | | `viralPostViewJobApplications` | Decimal | The number of times a member completed a job application after viewing a viral ad. | | `viralPostViewJobApplyClicks` | Decimal | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing a viral ad which has a LinkedIn job landing page. | | `viralPostViewRegistrations` | Decimal | The number of times a member has registered for an event or seminar after viewing a viral ad which has a LinkedIn event landing page. See viralImpressions definition. This includes gross registrations and does not account for a user unregistering. | | `viralReactions` | Long | The count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses. See viral impressions definition for details on viral engagements. | | `viralRegistrations` | Decimal | The number of times a member has registered for an event or seminar after viewing or clicking on a viral ad which has a LinkedIn event landing page. See viralImpressions definition. This includes gross registrations and does not account for a user unregistering. | | `viralShares` | Long | The count of shares from viral impressions for this activity. See viral impressions definition. Sponsored Updates only. | | `viralSubscriptionClicks` | Long | The count of viral clicks to subscribe to a series, such as a Newsletter. | | `viralTotalEngagements` | Long | The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only. | | `viralVideoCompletions` | Long | The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point. See viralImpressions definition. | | `viralVideoFirstQuartileCompletions` | Long | The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point. See viralImpressions definition. | | `viralVideoMidpointCompletions` | Long | The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point. See viralImpressions definition. | | `viralVideoStarts` | Long | The count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON\_SITE, this will be the same as viralImpressions if the servingLocation is ON\_SITE. | | `viralVideoThirdQuartileCompletions` | Long | The count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point. See viralImpressions definition | | `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. An interaction with the video (like going to full screen mode) does not count as a view. See viralImpressions definition. | ## Other columns | Column | Type | Description | | -------------- | ------ | ------------------------------------------------------------------------------ | | `CurrencyCode` | String | The 3 character standard currency code such as 'USD' for United States Dollar. |