LinkedIn Ads

LinkedIn Ads

This document provides instructions for integrating LinkedIn Ads data into Panoply. The following items will be covered:

LinkedIn Ads Data Integration

To integrate LinkedIn Ads data into Panoply, complete the following steps.

  1. Click Data Sources in the Navigation Menu.
  2. Click the Add Data Source button. add data source
  3. In the Data Sources - Choose Source Type window, select LinkedIn Ads. LinkedIn Ads is listed under APIs. most popular data sources
  4. In the Data Sources - LinkedIn Ads screen, click Login.
  5. Click Authorize to allow Panoply to access your LinkedIn Ads data. LinkedIn Ads - authorize
  6. Select the Account to extract data for.
  7. Select the Reporting Pivot to group each report data point by. These are the available pivots:
    • COMPANY - Group results by advertiser’s company.
    • ACCOUNT - Group results by account.
    • SHARE - Group results by sponsored share.
    • CAMPAIGN - Group results by campaign.
    • CREATIVE - Group results by creative.
    • CAMPAIGN_GROUP - Group results by campaign group.
    • CONVERSION - Group results by conversion.
    • SERVING_LOCATION - Group results by serving location, onsite or offsite.
    • MEMBER_COMPANY_SIZE - Group results by member company size.
    • MEMBER_INDUSTRY - Group results by member industry.
    • MEMBER_SENIORITY - Group results by member seniority.
    • MEMBER_JOB_TITLE - Group results by member job title.
    • MEMBER_JOB_FUNCTION - Group results by member job function.
    • MEMBER_COUNTRY - Group results by member country.
    • MEMBER_REGION - Group results by member region.
    • MEMBER_COMPANY - Group results by member company.
    • CARD_INDEX - Group results by the index of where a card appears in a carousel ad creative. Metrics are based on the index of the card at the time when the user’s action (impression, click, etc.) happened on the creative (Carousel creatives only).
  8. Select a Date Range covered by the report analytics. Available options are affected by your selected Reporting Pivot. LinkedIn Ads - collect
  9. (Optional) To customize the ingestion from your data source, review the advanced options.
  10. Click Collect.

The LinkedIn Ads Data Source will appear grayed out while the data integration is pending. A small green progress bar appears below LinkedIn Ads.

You will be prompted to set up the integration of another data source. You can set up multiple data integrations without impacting the ingestion of the already scheduled or pending data integrations.

From the Data Sources main menu, you can monitor the data ingestion status of the scheduled and pending data integrations. After the data ingestion is complete, you can clean or transform your data in the Tables menu.

Advanced Options

Clicking Show next to Advanced will expand the Data Sources - LinkedIn Ads window to include Destination, Primary Key, Exclude, Parse string, and Truncate table.

  • Destination - Default is linkedin-ads_{pivot}, where pivot is the reporting pivot. See the Data Schema section for more detail about each table.
  • Primary Key - Default is {accountId}-{pivot}-{pivotValue}-{startDate}-{endDate}.

advanced options

Data Schema

The schema for this data source creates one table: the table associated with the selected reporting pivot. This is because the data in Panoply is built by accessing the https://api.linkedin.com/v2/adAnalyticsV2 LinkedIn Ads Reporting API endpoint with the pivot={PIVOT-NAME} query parameter (and other parameters) for the selected pivot.

The following sections identify the data schema for each reporting pivot. But, again, you should only expect to see one of these tables in your Panoply database for each configured LinkedIn Ads data source.

For more information about the LinkedIn Ads Reporting API, consult the LinkedIn Ads Reporting API documentation.

Additionally, Panoply includes these metadata columns in each table: __tablename, __senttime, and __updatetime.

Company

The Company pivot groups the report data results by advertiser’s company. In Panoply, the default company table is linkedin-ads_company, which includes the following fields:

Column Data Type Description
id varchar Primary key.
landingpageclicks number The count of clicks which take the user to the creative landing page.
viralvideoviews number 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.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
accountid number The ID of the account selected in Panoply when setting up the data source.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralimpressions number 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.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
pivot_value_id number The ID of this pivot value.
pivot text The selected reporting pivot for this data source.
pivot_value_optimization_target_type text The organization target type of this pivot value
cardimpressions number 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
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
videostarts number The count of video ads that were started by users
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
viralvideostarts number The count of viral video ads that were started by users.
pivot_value_objective_type text The objective type of this pivot value.
pivotvalue text 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.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralfullscreenplays number The count of taps on the video, going into video view mode.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
totalengagements number The count of all user interactions with the ad unit.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
pivot_value_creative_selection varchar The creative selection of this pivot value.
comments number The count of comments. Sponsored Updates only.
clicks number The count of chargeable clicks.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
companypageclicks number The count of clicks to view the company page.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
pivot_value_type text The type of this pivot value.
commentlikes number The count of likes of a comment. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
pivot_value_cost_type text The cost type of this pivot value.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
follows number The count of follows. Sponsored Updates only.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
oneclickleads number The count of leads generated through One Click Lead Gen.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
startdate date Represents the inclusive start time range of the analytics
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
shares number The count of shares. Sponsored Updates only.
cardclicks number 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.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
enddate date Represents the inclusive end time range of the analytics.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
videocompletions number The count of video ads that played 97-100% of the video.
pivot_value_name text The name of this pivot value.
likes number The count of likes. Sponsored Updates only.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.

Account

The Account pivot groups the report data results by account. In Panoply, the default account table is linkedin-ads_account, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
follows number The count of follows. Sponsored Updates only.
pivotvalue text 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.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
clicks number The count of chargeable clicks.
companypageclicks number The count of clicks to view the company page.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
likes number The count of likes. Sponsored Updates only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralvideoviews number 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.
oneclickleads number The count of leads generated through One Click Lead Gen.
costinusd number Cost in USD based on the pivot and timeGranularity.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
cardclicks number 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.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
viralvideostarts number The count of viral video ads that were started by users.
viralfullscreenplays number The count of taps on the video, going into video view mode.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
startdate date Represents the inclusive start time range of the analytics
commentlikes number The count of likes of a comment. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
enddate date Represents the inclusive end time range of the analytics.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
accountid number The ID of the account selected in Panoply when setting up the data source.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
cardimpressions number 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
shares number The count of shares. Sponsored Updates only.
viralimpressions number 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.
totalengagements number The count of all user interactions with the ad unit.
fullscreenplays number The count of taps on the video, going into video view mode.
landingpageclicks number The count of clicks which take the user to the creative landing page.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
comments number The count of comments. Sponsored Updates only.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
videostarts number The count of video ads that were started by users
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
pivot text The selected reporting pivot for this data source.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
viralcardclicks number The number of viralClicks for each card of a carousel ad.

Share

The Share pivot groups the report data results by sponsored share. In Panoply, the default Share table is linkedin-ads_share, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
clicks number The count of chargeable clicks.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
shares number The count of shares. Sponsored Updates only.
cardclicks number 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.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
pivot text The selected reporting pivot for this data source.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
videostarts number The count of video ads that were started by users
viralcardclicks number The number of viralClicks for each card of a carousel ad.
fullscreenplays number The count of taps on the video, going into video view mode.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
cardimpressions number 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
follows number The count of follows. Sponsored Updates only.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
pivotvalue text 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.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
startdate date Represents the inclusive start time range of the analytics
totalengagements number The count of all user interactions with the ad unit.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralvideostarts number The count of viral video ads that were started by users.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
costinusd number Cost in USD based on the pivot and timeGranularity.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
accountid number The ID of the account selected in Panoply when setting up the data source.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralfullscreenplays number The count of taps on the video, going into video view mode.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
enddate date Represents the inclusive end time range of the analytics.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
oneclickleads number The count of leads generated through One Click Lead Gen.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
pivot_value_content_title text The content title of this pivot value.
viralvideoviews number 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.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
landingpageclicks number The count of clicks which take the user to the creative landing page.
comments number The count of comments. Sponsored Updates only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
viralimpressions number 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.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
likes number The count of likes. Sponsored Updates only.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
companypageclicks number The count of clicks to view the company page.
pivot_value_id number The ID of this pivot value.
pivot_value_subject text The subject of this pivot value.

Campaign

The Campaign pivot groups the report data results by campaign. In Panoply, the default campaign table is linkedin-ads_campaign, which includes the following fields:

Column Data Type Description
id varchar Primary key.
landingpageclicks number The count of clicks which take the user to the creative landing page.
viralvideoviews number 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.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
accountid number The ID of the account selected in Panoply when setting up the data source.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralimpressions number 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.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
pivot_value_id number The ID of this pivot value.
pivot text The selected reporting pivot for this data source.
pivot_value_optimization_target_type text The optimization target type of this pivot value.
cardimpressions number 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
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
videostarts number The count of video ads that were started by users
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
viralvideostarts number The count of viral video ads that were started by users.
pivot_value_objective_type text The objective type of this pivot value.
pivotvalue text 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.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralfullscreenplays number The count of taps on the video, going into video view mode.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
totalengagements number The count of all user interactions with the ad unit.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
pivot_value_creative_selection text The creative selection of this pivot value.
comments number The count of comments. Sponsored Updates only.
clicks number The count of chargeable clicks.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
companypageclicks number The count of clicks to view the company page.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
pivot_value_type text The type of this pivot value.
commentlikes number The count of likes of a comment. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
pivot_value_cost_type text The cost type of this pivot value.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
follows number The count of follows. Sponsored Updates only.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
oneclickleads number The count of leads generated through One Click Lead Gen.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
startdate date Represents the inclusive start time range of the analytics
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
shares number The count of shares. Sponsored Updates only.
cardclicks number 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.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
enddate date Represents the inclusive end time range of the analytics.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
videocompletions number The count of video ads that played 97-100% of the video.
pivot_value_name text The name of this pivot value.
likes number The count of likes. Sponsored Updates only.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.

Creative

The Creative pivot groups the report data results by creative. In Panoply, the default creative table is linkedin-ads_creative, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
costinusd number Cost in USD based on the pivot and timeGranularity.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
pivot_value_status text The status of this pivot value.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
follows number The count of follows. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
oneclickleads number The count of leads generated through One Click Lead Gen.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
shares number The count of shares. Sponsored Updates only.
viralimpressions number 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.
videocompletions number The count of video ads that played 97-100% of the video.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
pivot_value_type text The type of this pivot value.
pivotvalue text 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.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
companypageclicks number The count of clicks to view the company page.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
videostarts number The count of video ads that were started by users
totalengagements number The count of all user interactions with the ad unit.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
comments number The count of comments. Sponsored Updates only.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
pivot text The selected reporting pivot for this data source.
clicks number The count of chargeable clicks.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
startdate date Represents the inclusive start time range of the analytics
enddate date Represents the inclusive end time range of the analytics.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
fullscreenplays number The count of taps on the video, going into video view mode.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
pivot_value_id number The ID of this pivot value.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
viralvideostarts number The count of viral video ads that were started by users.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
accountid number The ID of the account selected in Panoply when setting up the data source.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
likes number The count of likes. Sponsored Updates only.
viralfullscreenplays number The count of taps on the video, going into video view mode.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
cardimpressions number 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
cardclicks number 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.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viralvideoviews number 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.

Campaign Group

The Campaign Group pivot groups the report data results by campaign group. In Panoply, the default campaign group table is linkedin-ads_campaign_group, which includes the following fields:

Column Data Type Description
id varchar Primary key.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralimpressions number 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.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
pivot_value_id number The ID of this pivot value.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
comments number The count of comments. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
viralfullscreenplays number The count of taps on the video, going into video view mode.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
videostarts number The count of video ads that were started by users
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralvideostarts number The count of viral video ads that were started by users.
likes number The count of likes. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
oneclickleads number The count of leads generated through One Click Lead Gen.
fullscreenplays number The count of taps on the video, going into video view mode.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
pivot text The selected reporting pivot for this data source.
viralvideoviews number 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.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
companypageclicks number The count of clicks to view the company page.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
cardclicks number 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.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
follows number The count of follows. Sponsored Updates only.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
clicks number The count of chargeable clicks.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
accountid number The ID of the account selected in Panoply when setting up the data source.
pivot_value_status text The status of this pivot value.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
cardimpressions number 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
shares number The count of shares. Sponsored Updates only.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
startdate date Represents the inclusive start time range of the analytics
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viraloneclickleadformopens date The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
totalengagements number The count of all user interactions with the ad unit.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
pivotvalue text 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.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
conversionvalueinlocalcurrency date Value of the conversions in the account’s local currency based on rules defined by the advertiser.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
enddate number Represents the inclusive end time range of the analytics.
pivot_value_name text The name of this pivot value.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.

Conversion

The Conversion pivot groups the report data results by conversion. In Panoply, the default conversion table is linkedin-ads_conversion, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
totalengagements number The count of all user interactions with the ad unit.
enddate date Represents the inclusive end time range of the analytics.
videostarts number The count of video ads that were started by users
videocompletions number The count of video ads that played 97-100% of the video.
viralvideostarts number The count of viral video ads that were started by users.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
likes number The count of likes. Sponsored Updates only.
viralimpressions number 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.
clicks number The count of chargeable clicks.
shares number The count of shares. Sponsored Updates only.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
follows number The count of follows. Sponsored Updates only.
accountid number The ID of the account selected in Panoply when setting up the data source.
landingpageclicks number The count of clicks which take the user to the creative landing page.
comments number The count of comments. Sponsored Updates only.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
cardimpressions number 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
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
companypageclicks number The count of clicks to view the company page.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
pivotvalue text 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.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralfullscreenplays number The count of taps on the video, going into video view mode.
oneclickleads number The count of leads generated through One Click Lead Gen.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
cardclicks number 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.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
costinusd number Cost in USD based on the pivot and timeGranularity.
commentlikes number The count of likes of a comment. Sponsored Updates only.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
viralvideoviews number 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.
startdate date Represents the inclusive start time range of the analytics
pivot text The selected reporting pivot for this data source.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
fullscreenplays number The count of taps on the video, going into video view mode.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.

Serving Location

The Serving Location pivot groups the report data results by serving location (onsite or offsite). In Panoply, the default serving location table is linkedin-ads_serving_location, which contains the following fields:

Column Data Type Description
id varchar Primary key.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
enddate date Represents the inclusive end time range of the analytics.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
follows number The count of follows. Sponsored Updates only.
pivot text The selected reporting pivot for this data source.
viralvideostarts number The count of viral video ads that were started by users.
fullscreenplays number The count of taps on the video, going into video view mode.
viralvideoviews number 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.
cardimpressions number 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
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
likes number The count of likes. Sponsored Updates only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
comments number The count of comments. Sponsored Updates only.
viralimpressions number 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.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
pivotvalue text 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.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
accountid number The ID of the account selected in Panoply when setting up the data source.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
videostarts number The count of video ads that were started by users
cardclicks number 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.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
oneclickleads number The count of leads generated through One Click Lead Gen.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
clicks number The count of chargeable clicks.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
viralfullscreenplays number The count of taps on the video, going into video view mode.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
companypageclicks number The count of clicks to view the company page.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
startdate date Represents the inclusive start time range of the analytics
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
shares number The count of shares. Sponsored Updates only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
totalengagements number The count of all user interactions with the ad unit.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.

Member Company Size

The Member Company Size pivot groups the report data results by member company size. In Panoply, the default member company size table is linkedin-ads_member_company_size, which includes the following fields:

Column Data Type Description
id varchar Primary key.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
comments number The count of comments. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
companypageclicks number The count of clicks to view the company page.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
viralimpressions number The count of viral impressions for this activity.
cardclicks number 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.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
landingpageclicks number The count of clicks which take the user to the creative landing page.
accountid number The ID of the account selected in Panoply when setting up the data source.
costinusd number Cost in USD based on the pivot and timeGranularity.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
startdate date Represents the inclusive start time range of the analytics
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
enddate date Represents the inclusive end time range of the analytics.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
cardimpressions number 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
totalengagements number The count of all user interactions with the ad unit.
viralfullscreenplays number The count of taps on the video, going into video view mode.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
pivot text The selected reporting pivot for this data source.
viralvideostarts number The count of viral video ads that were started by users.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
oneclickleads number The count of leads generated through One Click Lead Gen.
likes number The count of likes. Sponsored Updates only.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
pivotvalue text 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.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
videocompletions number The count of video ads that played 97-100% of the video.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
clicks number The count of chargeable clicks.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viralvideoviews number 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.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
follows number The count of follows. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
shares number The count of shares. Sponsored Updates only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
videostarts number The count of video ads that were started by users
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.

Member Industry

The Member Industry pivot groups the report data results by member industry. In Panoply, the default member industry table is linkedin-ads_member_industry, which includes the following fields:

Column Data Type Description
id varchar Primary key.
totalengagements number The count of all user interactions with the ad unit.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
viralfullscreenplays number The count of taps on the video, going into video view mode.
videocompletions number The count of video ads that played 97-100% of the video.
pivot_value_name_value text The name value of this pivot value.
pivot text The selected reporting pivot for this data source.
comments number The count of comments. Sponsored Updates only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
pivot_value_name_key text The name key of this pivot value.
likes number The count of likes. Sponsored Updates only.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
accountid number The ID of the account selected in Panoply when setting up the data source.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
videomidpointcompletions date The count of video ads that played through the midpoint of the video.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralimpressions number 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.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
videostarts number The count of video ads that were started by users
enddate date Represents the inclusive end time range of the analytics.
shares number The count of shares. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
pivot_value_name_type text The name type of this pivot value.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
companypageclicks number The count of clicks to view the company page.
viralvideoviews number 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.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
startdate date Represents the inclusive start time range of the analytics
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
oneclickleads number The count of leads generated through One Click Lead Gen.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viralvideostarts number The count of viral video ads that were started by users.
follows number The count of follows. Sponsored Updates only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
pivotvalue text 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.
costinusd number Cost in USD based on the pivot and timeGranularity.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
pivot_value_id number The ID of this pivot value.
cardimpressions number 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 number The count of chargeable clicks.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
cardclicks number 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.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.

Member Seniority

The Member Seniority pivot groups the report data results by member seniority. In Panoply, the default member seniority table is linkedin-ads_member_seniority, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
comments number The count of comments. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
viralvideostarts number The count of viral video ads that were started by users.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
pivot_value_id number The ID of this pivot value.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
likes number The count of likes. Sponsored Updates only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
pivotvalue text 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.
pivot_value_name_value text The name value of this pivot value.
startdate date Represents the inclusive start time range of the analytics
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
costinusd number Cost in USD based on the pivot and timeGranularity.
follows number The count of follows. Sponsored Updates only.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
videostarts number The count of video ads that were started by users
viralvideoviews number 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.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
pivot text The selected reporting pivot for this data source.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralfullscreenplays number The count of taps on the video, going into video view mode.
accountid number The ID of the account selected in Panoply when setting up the data source.
shares number The count of shares. Sponsored Updates only.
oneclickleads number The count of leads generated through One Click Lead Gen.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
viralcardclicks text The number of viralClicks for each card of a carousel ad.
companypageclicks number The count of clicks to view the company page.
viralimpressions number 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.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
pivot_value_name_key text The name key of this pivot value.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
clicks number The count of chargeable clicks.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only.
totalengagements number The count of all user interactions with the ad unit.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
videocompletions number The count of video ads that played 97-100% of the video.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
cardclicks number 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.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
pivot_value_name_type text The name type of this pivot value.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
enddate date Represents the inclusive end time range of the analytics.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
cardimpressions number 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
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.

Member Job Title

The Member Job Title pivot groups the report data results by member job title. In Panoply, the default member job title table is linkedin-ads_member_job_title, which includes the following fields:

Column Data Type Description
id varchar Primary key.
videostarts number The count of video ads that were started by users
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
clicks number The count of chargeable clicks.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
pivot_value_id number The ID of this pivot value.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
fullscreenplays number The count of taps on the video, going into video view mode.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
follows number The count of follows. Sponsored Updates only.
comments number The count of comments. Sponsored Updates only.
cardimpressions number 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
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
pivot_value_name_value text The name value of this pivot value.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
landingpageclicks number Total number of views created by clicking a link in the ad
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
shares number The count of shares. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
pivot_value_name_type text The name type of this pivot value.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
oneclickleads text The count of leads generated through One Click Lead Gen.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
cardclicks number 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.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. Sponsored Updates only.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
likes number The count of likes. Sponsored Updates only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
startdate date Represents the inclusive start time range of the analytics
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
pivot_value_name_key text The name key of this pivot value.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
pivot text The selected reporting pivot for this data source.
commentlikes number The count of likes of a comment. Sponsored Updates only.
enddate date Represents the inclusive end time range of the analytics.
companypageclicks number The count of clicks to view the company page.
totalengagements number The count of all user interactions with the ad unit.
viralfullscreenplays number The count of taps on the video, going into video view mode.
viralimpressions number 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.
pivotvalue text 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.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viralvideoviews number 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.
accountid number The ID of the account selected in Panoply when setting up the data source.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viralvideostarts number The count of viral video ads that were started by users.

Member Job Function

The Member Job Function pivot groups the report data results by member job function. In Panoply, the default member job function table is linkedin-ads_member_job_function, which includes the following fields:

Column Data Type Description
id varchar Primary key.
accountid number The ID of the account selected in Panoply when setting up the data source.
costinusd number Cost in USD based on the pivot and timeGranularity.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
videocompletions number The count of video ads that played 97-100% of the video.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
pivot text The selected reporting pivot for this data source.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralfullscreenplays number The count of taps on the video, going into video view mode.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
pivotvalue text 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.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
totalengagements number The count of all user interactions with the ad unit.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
companypageclicks number The count of clicks to view the company page.
oneclickleads number The count of leads generated through One Click Lead Gen.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
videostarts number The count of video ads that were started by users
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
pivot_value_name_type text The name type of this pivot value.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. Sponsored Updates only.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
cardclicks number 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.
pivot_value_name_key text The name key of this pivot value.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
comments number The count of comments. Sponsored Updates only.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
cardimpressions number 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
viralcardclicks number The number of viralClicks for each card of a carousel ad.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
likes number The count of likes. Sponsored Updates only.
follows number The count of follows. Sponsored Updates only.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralimpressions number 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.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
enddate date Represents the inclusive end time range of the analytics.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
pivot_value_name_value text The name value of this pivot value.
startdate date Represents the inclusive start time range of the analytics
shares number The count of shares. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralvideoviews number 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.
landingpageclicks number The count of clicks which take the user to the creative landing page.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
clicks number The count of chargeable clicks.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
pivot_value_id number The ID of this pivot value.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viralvideostarts number The count of viral video ads that were started by users.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.

Member Country

The Member Country pivot groups the report data results by member country. In Panoply, the default member country table is linkedin-ads_member_country, which includes the following fields:

Column Data Type Description
id varchar Primary key.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralimpressions number 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.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
cardclicks number 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.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
landingpageclicks number The count of clicks which take the user to the creative landing page.
likes number The count of likes. Sponsored Updates only.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
pivot_value_name text The name of this pivot value.
viralfullscreenplays number The count of taps on the video, going into video view mode.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
startdate date Represents the inclusive start time range of the analytics
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
follows number The count of follows. Sponsored Updates only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
shares number The count of shares. Sponsored Updates only.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
oneclickleads number The count of leads generated through One Click Lead Gen.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
viralvideoviews number 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.
pivotvalue text 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.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralvideostarts number The count of viral video ads that were started by users.
commentlikes number The count of likes of a comment. Sponsored Updates only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
videostarts number The count of video ads that were started by users
pivot_value_country_code number The country code of this pivot value.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
companypageclicks number The count of clicks to view the company page.
costinusd number Cost in USD based on the pivot and timeGranularity.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
videocompletions number The count of video ads that played 97-100% of the video.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
clicks number The count of chargeable clicks.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
comments number The count of comments. Sponsored Updates only.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
fullscreenplays number The count of taps on the video, going into video view mode.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
totalengagements number The count of all user interactions with the ad unit.
accountid number The ID of the account selected in Panoply when setting up the data source.
cardimpressions number 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
pivot text The selected reporting pivot for this data source.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
enddate date Represents the inclusive end time range of the analytics.

Member Region

The Member Region pivot groups the report data results by member region. In Panoply, the default member region table is linkedin-ads_member_region, which includes the following fields:

Column Data Type Description
id varchar Primary key.
videostarts number The count of video ads that were started by users
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
cardclicks number 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.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
clicks number The count of chargeable clicks.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
startdate date Represents the inclusive start time range of the analytics
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
totalengagements number The count of all user interactions with the ad unit.
pivotvalue text 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.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
costinusd number Cost in USD based on the pivot and timeGranularity.
enddate date Represents the inclusive end time range of the analytics.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralvideostarts number The count of viral video ads that were started by users.
comments number The count of comments. Sponsored Updates only.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
likes number The count of likes. Sponsored Updates only.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
shares number The count of shares. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
pivot text The selected reporting pivot for this data source.
cardimpressions number 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
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
accountid number The ID of the account selected in Panoply when setting up the data source.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
viralfullscreenplays number The count of taps on the video, going into video view mode.
follows number The count of follows. Sponsored Updates only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralvideoviews number 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.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
oneclickleads number The count of leads generated through One Click Lead Gen.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
fullscreenplays number The count of taps on the video, going into video view mode.
landingpageclicks number The count of clicks which take the user to the creative landing page.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
viralimpressions number 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.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
pivot_value_name text The name of this pivot value.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
pivot_value_id number The ID of this pivot value.
videocompletions number The count of video ads that played 97-100% of the video.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
companypageclicks number The count of clicks to view the company page.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.

Member Company

The Member Company pivot groups the report data results by member company. In Panoply, the default member company table is linkedin-ads_member_company, which includes the following fields:

Column Data Type Description
id varchar Primary key.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
accountid number The ID of the account selected in Panoply when setting up the data source.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
oneclickleads number The count of leads generated through One Click Lead Gen.
videostarts number The count of video ads that were started by users
viralimpressions number 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.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
follows number The count of follows. Sponsored Updates only.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
likes number The count of likes. Sponsored Updates only.
pivot text The selected reporting pivot for this data source.
fullscreenplays number The count of taps on the video, going into video view mode.
landingpageclicks number The count of clicks which take the user to the creative landing page.
commentlikes number The count of likes of a comment. Sponsored Updates only.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
cardimpressions number The number of impressions shown for each card of a carousel ad.
totalengagements number The count of all user interactions with the ad unit.
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
viralfullscreenplays number The count of taps on the video, going into video view mode.
startdate date Represents the inclusive start time range of the analytics
viralvideoviews number 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.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
pivotvalue text 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.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
pivot_value_universal_name text The universal name of this pivot value.
enddate date Represents the inclusive end time range of the analytics.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
cardclicks number 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.
comments number The count of comments. Sponsored Updates only.
clicks number The count of chargeable clicks.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralvideostarts number The count of viral video ads that were started by users.
costinusd number Cost in USD based on the pivot and timeGranularity.
videocompletions number The count of video ads that played 97-100% of the video.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
companypageclicks number The count of clicks to view the company page.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
shares number The count of shares. Sponsored Updates only.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
pivot_value_company_id number The company ID of this pivot value.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.

Card Index

The Card Index pivot groups the report data results by the index of where a card appears in a carousel ad creative. Metrics are based in the index of the card at the time when the user’s action (impression, click, etc.) happened on the creative. In Panoply, the default card index table is linkedin-ads_card_index, which includes the following fields:

Column Data Type Description
id varchar Primary key.
accountid number The ID of the account selected in Panoply when setting up the data source.
actionclicks number The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
adunitclicks number The count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
cardclicks number 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 number The number of impressions shown for each card of a carousel ad.
clicks number The count of chargeable clicks.
commentlikes number The count of likes of a comment. Sponsored Updates only.
comments number The count of comments. Sponsored Updates only.
companypageclicks number The count of clicks to view the company page.
conversionvalueinlocalcurrency number Value of the conversions in the account’s local currency based on rules defined by the advertiser.
costinlocalcurrency number Cost in the account’s local currency based on the pivot and timeGranularity.
costinusd number Cost in USD based on the pivot and timeGranularity.
enddate date Represents the inclusive end time range of the analytics.
externalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website.
externalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website.
externalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website.
follows number The count of follows. Sponsored Updates only.
fullscreenplays number The count of taps on the video, going into video view mode.
impressions number This is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.
landingpageclicks number The count of clicks which take the user to the creative landing page.
leadgenerationmailcontactinfoshares number The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
leadgenerationmailinterestedclicks number The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
likes number The count of likes. Sponsored Updates only.
oneclickleadformopens number The count of times users opened the lead form for a One Click Lead Gen campaign.
oneclickleads number The count of leads generated through One Click Lead Gen.
opens number The count of opens of Sponsored InMail. Sponsored InMail only.
otherengagements number The count of user interactions with the ad unit that do not fit into any other more specific category.
pivot text The selected reporting pivot for this data source.
pivotvalue text 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.
shares number The count of shares. Sponsored Updates only.
startdate date Represents the inclusive start time range of the analytics
texturlclicks number The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
totalengagements number The count of all user interactions with the ad unit.
videocompletions number The count of video ads that played 97-100% of the video.
videofirstquartilecompletions number The count of video ads that played through the first quartile of the video.
videomidpointcompletions number The count of video ads that played through the midpoint of the video.
videostarts number The count of video ads that were started by users
videothirdquartilecompletions number The count of video ads that played through the third quartile of the video.
videoviews number A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first.
viralcardclicks number The number of viralClicks for each card of a carousel ad.
viralcardimpressions number The number of viralImpressions shown for each card of a carousel ad.
viralclicks number The count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
viralcomments number The count of comments from viral impressions for this activity. Sponsored Updates only.
viralcompanypageclicks number The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only.
viralexternalwebsiteconversions number The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
viralexternalwebsitepostclickconversions number The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
viralexternalwebsitepostviewconversions number The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
viralfollows number The count of follows from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viralfullscreenplays number The count of taps on the video, going into video view mode.
viralimpressions number 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.
virallandingpageclicks number The count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only
virallikes number The count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
viraloneclickleadformopens number The count of times users opened the lead form for viral impressions from a Lead Gen campaign.
viraloneclickleads number The count of leads generated through One Click Lead Gen from viral impressions for this activity.
viralotherengagements number The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only.
viralshares number The count of shares from viral impressions for this activity. Sponsored Updates only.
viraltotalengagements number The count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
viralvideocompletions number The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
viralvideofirstquartilecompletions number The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
viralvideomidpointcompletions number The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
viralvideostarts number The count of viral video ads that were started by users.
viralvideothirdquartilecompletions number The count of viral video ads that played through the third quartile of the video.
viralvideoviews number 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.
Getting started is easy! Get all your data in one place in minutes.
Try Free