Book the exclusive demo launch to experience the OWOX BI analytics

LinkedIn → Google BigQuery: data schema

 Field name  Data type  Description
 date  DATE  All metrics are grouped by date, which is shown by this column.
 ad_id  INTEGER  AdId/CreativeID (LinkedIn uses CreativeID and AdId interchangeably in documentation and 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 displayed alongside the Sponsored InMail. Sponsored InMail only.
 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 which 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  
 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 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 identifying the 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  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  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  
 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  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.