LinkedIn → Google BigQuery: data schema – OWOX Help Center

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
`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 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	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
`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

0 Comments

Related articles