| Field name | Data type | Description |
|---|---|---|
date |
DATE | All metrics are grouped by date, which is shown in this column. |
ad_id |
INTEGER | AdId/CreativeID (LinkedIn uses CreativeID and AdId interchangeably in the documentation and the user interface) |
ad_account |
STRING | The ID of the ad account that this ad belongs to. |
action_clicks |
INTEGER | The count of clicks on the action button of the Sponsored InMail. Sponsored InMail only. |
ad_unit_clicks |
INTEGER | The count of clicks on the ad unit is displayed alongside the Sponsored InMail. Sponsored InMail only. |
approximate_member_reach |
INTEGER |
Non-demographic pivots only (i.e. not MEMBER_). The estimated number of unique member accounts with at least one impression. This metric is an updated and more accurate version of the legacy metric approximateUniqueImpressions. This metric is only available when the number of days in the date range is less than or equal to 92 days. |
clicks |
INTEGER | The count of chargeable clicks. |
comments |
INTEGER | The count of comments. Sponsored Updates only. |
company_page_clicks |
INTEGER | The count of clicks to view the company page. |
conversion_value_in_local_currency |
FLOAT | Non-demographic pivots only. Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level and aggregated across the query time range. |
cost_in_local_currency |
FLOAT | Cost in the account's local currency based on the pivot and timeGranularity. For example, this would be spent by member company size per month if the pivot is MEMBER_COMPANY_SIZE and timeGranularity is MONTHLY. |
cost_in_usd |
FLOAT | Cost in USD based on the pivot and timeGranularity. For example, this would be spent by a campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY. |
local_currency |
STRING | Local currency |
external_website_conversions |
INTEGER | The count of conversions indicated by pixel loads on an external advertiser website. |
external_website_post_click_conversions |
INTEGER | The count of post-click conversions indicated by pixel loads on an external advertiser website. |
external_website_post_view_conversions |
INTEGER | The count of post-view conversions indicated by pixel loads on an external advertiser website. |
follows |
INTEGER | The count of follows. Sponsored Updates only. |
impressions |
INTEGER | The count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails. |
landing_page_clicks |
INTEGER | The count of clicks that take the user to the creative landing page. |
lead_generation_mail_contact_info_shares |
INTEGER | The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only. |
lead_generation_mail_interested_clicks |
INTEGER | The count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only. |
likes |
INTEGER | The count of likes. Sponsored Updates only. |
one_click_lead_form_opens |
INTEGER | The count of times users opened the lead form for a One Click Lead Gen campaign. |
one_click_leads |
INTEGER | The count of leads generated through One Click Lead Gen. |
opens |
INTEGER | The count of opens of Sponsored InMail. Sponsored InMail only. |
other_engagements |
INTEGER | The count of user interactions with the ad unit that do not fit into any other more specific category. |
reactions |
INTEGER | The count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses. |
sends |
INTEGER | The count of sends of Sponsored InMail. Sponsored InMail only. |
shares |
INTEGER | The count of shares. Sponsored Updates only. |
text_url_clicks |
INTEGER | The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only. |
total_engagements |
INTEGER | The count of all user interactions with the ad unit. |
utm_content |
STRING | |
utm_campaign |
STRING | |
utm_medium |
STRING | |
utm_term |
STRING | |
utm_source |
STRING | |
utm_id |
STRING | What is UTM ID |
campaign_id |
INTEGER | ID of the ad campaign that contains this ad. |
campaign_name |
STRING | The name of the campaign. |
campaign_type |
STRING | Type of campaign, e.g. TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC |
campaign_status |
STRING | Status of the campaign. |
campaign_format |
STRING | The ad format on the campaign level, e.g. CAROUSEL, TEXT_AD |
campaign_cost_type |
STRING | Cost type, e.g. CPM, CPC, CPV |
campaign_objective_type |
STRING | Objective type of the campaign. |
campaign_group |
STRING | URN identifies the campaign group associated with the campaign. |
campaign_group_status |
STRING | Status of campaign group associated with the campaign. |
campaign_group_name |
STRING | Name of campaign group associated with the campaign. |
campaign_unit_cost |
RECORD | Amount to bid per click, impression, or other event depending on the pricing model. |
campaign_unit_cost.amount |
FLOAT | |
campaign_unit_cost.currency_code |
STRING | |
campaign_daily_budget |
RECORD | Maximum amount to spend per day UTC. |
campaign_daily_budget.amount |
FLOAT | |
campaign_daily_budget.currency_code |
STRING | |
campaign_total_budget |
RECORD | The maximum amount to spend over the life of the campaign. |
campaign_total_budget.amount |
STRING | |
campaign_total_budget.currency_code |
STRING | |
locale_country |
STRING | Locale of the campaign. An uppercase two-letter country code as defined by ISO-3166. |
locale_language |
STRING | Locale of the campaign. A lowercase two-letter language code as defined by ISO-639. |
creative_id |
INTEGER | The unique numerical identifier for the ad creative. |
creative_status |
STRING | Status of the creative. |
creative_type |
STRING | Type of the creative, e.g. TEXT_AD, SPONSORED_STATUS_UPDATE |
creative_reference |
STRING | A reference URN for this object to an external system, with semantics varying based on the creative type |
creative_click_uri |
STRING | Destination URL of the creative. Required when creative type is TEXT_AD |
creative_title |
STRING | Title of the creative. |
creative_text |
STRING | Body text of the creative. |
share_id |
INTEGER | Unique ID for the share. |
share_subject |
STRING | Share subject. |
share_text |
STRING | The content text. |
share_content |
RECORD | Referenced content such as articles and images. |
share_content.title |
STRING | Content title. |
share_content.description |
STRING | Content description. |
share_content.media_category |
STRING | The type of media represented by contentEntities, e.g. ARTICLE, IMAGE |
share_content.landing_page_url |
STRING | URL of the page with the content. |
share_content.content_entities |
RECORD | Details of content being shared. |
share_content.content_entities.title |
STRING | |
share_content.content_entities.description |
STRING | |
share_content.content_entities.entity_location |
STRING | URL of the content being shared. |
share_content.content_entities.landing_page_url |
STRING | |
share_content.content_entities.landing_page_title |
STRING | |
ugc_post_id |
STRING | Unique urn for the ugc post. |
ugc_post_lifecycle_state |
STRING | The state of this content. |
ugc_post_content_certification_record |
STRING | The content certification record associated with this content. Used to maintain information about the content's visibility and spam status. |
post_ad_context |
RECORD | The advertising context representing the ads specific metadata (which is related to ads or viral tracking, rendering, etc.), associated with the post. |
post_ad_context.is_dsc |
BOOLEAN | Whether or not this post is DSC. A posted DSC is created for the sole purpose of sponsorship. Read-only |
post_ad_context.dsc_ad_type |
STRING | The type of DSC (e.g. VIDEO, STANDARD, CAROUSEL, etc.). Read-only |
post_ad_context.dsc_name |
STRING | Plain text name of the DSC post. Only applicable for DSC. If isDSC is true and dscName is empty, it has an optional name |
post_ad_context.dsc_status |
STRING | The status of the advertising company content. Representing whether the content is usable from the advertiser's perspective as a DSC. |
ugc_post_content |
RECORD | Details of content ugc post. |
ugc_post_content.share_commentary |
RECORD | The message content of this share. |
ugc_post_content.share_commentary.inferred_locale |
STRING | The locale that may have be inferred for this text. |
ugc_post_content.share_commentary.text |
STRING | The text content that may be attributed. Defaults to "". Note the text has a limit of 1,300 characters. |
ugc_post_content.media |
RECORD | The media shared in this share. |
ugc_post_content.media.media |
STRING | The URN of the media shared. |
ugc_post_content.media.status |
STRING | The status of the availability of this media. |
ugc_post_content.media.title |
STRING | The title of this media. |
ugc_post_content.media.landing_page_title |
STRING | If present, this content entity will be rendered as a CTA with landingPageTitle as the CTA text and landingPageUrl as the click through url. |
ugc_post_content.media.landing_page_url |
STRING | The click through url. |
viral_clicks |
INTEGER | The count of clicks on viral impressions. Sponsored Updates only. |
viral_comments |
INTEGER | The count of comments from viral impressions for this activity. Sponsored Updates only. |
viral_comment_likes |
INTEGER | The count of likes on comments from viral impressions for this activity. Sponsored Updates only. |
viral_company_page_clicks |
INTEGER | The count of clicks to view the company page from viral impressions for this activity. Sponsored Updates only. |
viral_external_website_conversions |
INTEGER | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. |
viral_external_website_post_click_conversions |
INTEGER | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click. |
viral_external_website_post_view_conversions |
INTEGER | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression. |
viral_follows |
INTEGER | The count of follows from viral impressions for this activity. Sponsored Updates only. |
viral_impressions |
INTEGER | 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. |
viral_landing_page_clicks |
INTEGER | The count of clicks on viral impressions to take the user to the creative landing page. Sponsored Updates only. |
viral_likes |
INTEGER | The count of likes from viral impressions for this activity. Sponsored Updates only. |
viral_one_click_lead_form_opens |
INTEGER | The count of times users opened the lead form for viral impressions from a Lead Gen campaign. |
viral_one_click_leads |
INTEGER | The count of leads generated through One Click Lead Gen from viral impressions for this activity. |
viral_other_engagements |
INTEGER | The count of user interactions with viral impressions that do not fit into any other more specific category. Sponsored Updates only. |
viral_reactions |
INTEGER | The count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses. |
viral_shares |
INTEGER | The count of shares from viral impressions for this activity. Sponsored Updates only. |
viral_total_engagements |
INTEGER | The count of all user interactions with a viral ad unit. Sponsored Updates only. |
debug_info |
RECORD | Debug information for the OWOX BI pipeline maintenance. |
debug_info.PipelineId |
STRING | |
debug_info.Source |
STRING |
LinkedIn → Google BigQuery: data schema
Have more questions? Submit a request
Please sign in to leave a comment.
0 Comments