Advertising
LinkedIn Ads schema
SightShark syncs LinkedIn Ads into a data warehouse you own. It creates 48 tables, with field lists for 41 of them, refreshed daily. Account, campaign group, campaign and creative history, daily and monthly analytics, and the same analytics broken out by member company, industry, seniority, job title, function, country and region.
48 tables / 1428 fields / Tables from the production sync
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
ad_analytics_by_campaign
16 fields
- campaign_id
- day
- cost_in_local_currency
- cost_in_usd
- impressions
- clicks
- landing_page_clicks
- external_website_conversions
- one_click_leads
- total_engagements
- follows
- video_views
- video_completions
- viral_impressions
- viral_clicks
- approximate_member_reach
daily_ad_analytics_by_member_industry
7 fields
- account_id
- day
- member_industry
- impressions
- clicks
- cost_in_local_currency
- one_click_leads
snapshots_campaign_history
15 fields
- id
- campaign_group_id
- account_id
- name
- objective_type
- cost_type
- type
- format
- optimization_target_type
- daily_budget_amount
- unit_cost_amount
- audience_expansion_enabled
- offsite_delivery_enabled
- run_schedule_start
- last_modified_time
snapshots_targeting_criteria_include_history
3 fields
- campaign_id
- facet_name
- facet_value
snapshots_account_history
13 fields, documented schema
- id
- last_modified_time
- created_time
- currency
- name
- notified_on_campaign_optimization
- notified_on_creative_approval
- notified_on_creative_rejection
- notified_on_end_of_campaign
- reference
- status
- type
- version_tag
snapshots_account_serving_status_history
3 fields, documented schema
- status
- account_id
- account_last_modified_time
snapshots_account_user_history
5 fields, documented schema
- account_id
- id
- last_modified_time
- created_time
- role
snapshots_campaign_group_history
16 fields, documented schema
- id
- last_modified_time
- account_id
- backfilled
- budget_optimization_bid_strategy
- budget_optimization_budget_optimization_strategy
- created_time
- daily_budget
- name
- objective_type
- run_schedule_end
- run_schedule_start
- status
- test
- total_budget_amount
- total_budget_currency_code
snapshots_campaign_group_serving_status_history
3 fields, documented schema
- status
- campaign_group_id
- campaign_group_last_modified_time
snapshots_campaign_serving_status_history
3 fields, documented schema
- status
- campaign_id
- campaign_last_modified_time
snapshots_targeting_criteria_exclude_history
4 fields, documented schema
- facet_name
- facet_value
- campaign_id
- campaign_last_modified_time
snapshots_creative_history
39 fields, documented schema
- id
- last_modified_at
- leadgen_call_to_action_destination
- account_id
- campaign_id
- created_at
- created_by
- document_ad_gated_leadgen_preview_page_count
- document_ad_reference
- event_ad_direct_sponsored_content
- event_ad_event
- event_ad_hide_preview_video
- event_ad_post
- follower_call_to_action
- follower_logo
- follower_organization_name
- follower_show_member_profile_photo
- inline_content
- intended_status
- is_serving
- jobs_logo
- jobs_organization_name
- jobs_show_member_profile_photo
- last_modified_by
- leadgen_call_to_action_label
- name
- reference
- review_status
- spotlight_call_to_action
- spotlight_description
- spotlight_headline
- spotlight_landing_page
- spotlight_logo
- spotlight_organization_name
- spotlight_show_member_profile_photo
- text_ad_description
- text_ad_headline
- text_ad_image
- text_ad_landing_page
snapshots_creative_serving_status_history
3 fields, documented schema
- status
- creative_id
- creative_last_modified_time
snapshots_in_mail_content_history
18 fields, documented schema
- id
- last_modified_at
- creative_id
- account
- created_at
- created_by
- html_body
- last_modified_by
- name
- sender
- sub_content_formcall_to_action_text
- sub_content_formright_rail_ad_picture
- sub_content_guided_repliesright_rail_ad_picture
- sub_content_guided_repliessponsored_conversation
- sub_content_regularcall_to_action_landing_page_url
- sub_content_regularcall_to_action_text
- sub_content_regularright_rail_ad_picture
- subject
snapshots_organization
27 fields, documented schema
- id
- default_locale_country
- default_locale_language
- description_localized
- description_preferred_locale_country
- description_preferred_locale_language
- localized_description
- localized_name
- localized_website
- logo_v_2_crop_info_height
- logo_v_2_crop_info_width
- logo_v_2_crop_info_x
- logo_v_2_crop_info_y
- logo_v_2_cropped
- logo_v_2_original
- name_localized
- name_preferred_locale_country
- name_preferred_locale_language
- organization_status
- organization_type
- primary_organization_type
- staff_count_range
- vanity_name
- version_tag
- website_localized
- website_preferred_locale_country
- website_preferred_locale_language
snapshots_title
4 fields, documented schema
- id
- name_localized
- name_preferred_locale_country
- name_preferred_locale_language
snapshots_function
2 fields, documented schema
- id
- name
snapshots_seniority
2 fields, documented schema
- id
- name
snapshots_industry
2 fields, documented schema
- id
- name
snapshots_geo
2 fields, documented schema
- id
- value
snapshots_post_history
20 fields, documented schema
- id
- last_modified_time
- author
- commentary
- container_entity
- content_call_to_action_label
- content_landing_page
- created_time
- distribution_external_distribution_channels
- distribution_feed_distribution
- first_published_at
- is_reshare_disabled_by_author
- lifecycle_state
- lifecycle_state_info_content_status
- lifecycle_state_info_is_edited_by_author
- lifecycle_state_info_review_status
- response_context_parent
- response_context_root
- type
- visibility
snapshots_content
14 fields, documented schema
- post_id
- carousel_id
- media_alt_text
- media_id
- media_title
- multi_image_alt_text
- poll_question
- poll_settings_duration
- poll_settings_is_voter_visible_to_author
- poll_settings_vote_selection_type
- poll_unique_voters_count
- reference_id
- type
- type_of_content
snapshots_carousel_card
5 fields, documented schema
- media_id
- landing_page
- media_alt_text
- media_title
- type
snapshots_multi_image
4 fields, documented schema
- id
- alt_text
- title
- type
snapshots_content_poll_option
4 fields, documented schema
- text
- is_voted_by_viewer
- type
- vote_count
snapshots_distribution_target_seniority
4 fields, documented schema
- last_modified_time
- post_id
- seniority_id
- type
snapshots_distribution_target_industry
4 fields, documented schema
- industry_id
- last_modified_time
- post_id
- type
snapshots_distribution_target_location
4 fields, documented schema
- location
- last_modified_time
- post_id
- type
snapshots_distribution_target_interface_locale
5 fields, documented schema
- last_modified_time
- post_id
- country
- language
- type
snapshots_distribution_target_job_function
4 fields, documented schema
- function_id
- last_modified_time
- post_id
- type
snapshots_distribution_target_staff_count_range
4 fields, documented schema
- staff_count_range
- last_modified_time
- post_id
- type
ad_analytics_by_creative
116 fields, documented schema
- day
- creative_id
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
ad_analytics_by_creative_with_conversion_breakdown
117 fields, documented schema
- day
- conversion_id
- creative_id
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_company_size
117 fields, documented schema
- member_company_size
- month
- campaign_id
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_industry
117 fields, documented schema
- month
- campaign_id
- member_industry
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_seniority
117 fields, documented schema
- month
- campaign_id
- member_seniority
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_job_title
117 fields, documented schema
- month
- campaign_id
- member_job_title
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_job_function
117 fields, documented schema
- month
- campaign_id
- member_job_function
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_company
117 fields, documented schema
- month
- campaign_id
- member_organization
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_country
117 fields, documented schema
- month
- campaign_id
- member_country
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
monthly_ad_analytics_by_member_region
117 fields, documented schema
- month
- campaign_id
- member_region
- action_clicks
- ad_unit_clicks
- approximate_member_reach
- audience_penetration
- average_dwell_time
- average_event_watch_time
- average_event_watch_time_over_15_seconds
- average_event_watch_time_over_2_minutes
- average_event_watch_time_over_30_seconds
- average_video_watch_time
- card_clicks
- card_impressions
- clicks
- comment_likes
- comments
- company_page_clicks
- conversion_value_in_local_currency
- cost_in_local_currency
- cost_in_usd
- cost_per_event_view
- cost_per_event_view_over_15_seconds
- cost_per_event_view_over_2_minutes
- cost_per_event_view_over_30_seconds
- cost_per_qualified_lead
- document_completions
- document_first_quartile_completions
- document_midpoint_completions
- document_third_quartile_completions
- download_clicks
- event_views
- event_views_over_15_seconds
- event_views_over_2_minutes
- event_views_over_30_seconds
- event_watch_time
- external_website_conversions
- external_website_post_click_conversions
- external_website_post_view_conversions
- follows
- full_screen_plays
- headline_clicks
- headline_impressions
- impressions
- landing_page_clicks
- lead_generation_mail_contact_info_shares
- lead_generation_mail_interested_clicks
- likes
- one_click_lead_form_opens
- one_click_leads
- opens
- other_engagements
- post_click_job_applications
- post_click_job_apply_clicks
- post_click_registrations
- post_view_job_applications
- post_view_job_apply_clicks
- post_view_registrations
- qualified_leads
- reactions
- registrations
- sends
- shares
- subscription_clicks
- talent_leads
- text_url_clicks
- total_engagements
- valid_work_email_leads
- video_completions
- video_first_quartile_completions
- video_midpoint_completions
- video_starts
- video_third_quartile_completions
- video_views
- video_watch_time
- viral_card_clicks
- viral_card_impressions
- viral_clicks
- viral_comment_likes
- viral_comments
- viral_company_page_clicks
- viral_document_completions
- viral_document_first_quartile_completions
- viral_document_midpoint_completions
- viral_document_third_quartile_completions
- viral_download_clicks
- viral_external_website_conversions
- viral_external_website_post_click_conversions
- viral_external_website_post_view_conversions
- viral_follows
- viral_full_screen_plays
- viral_impressions
- viral_job_applications
- viral_job_apply_clicks
- viral_landing_page_clicks
- viral_likes
- viral_one_click_lead_form_opens
- viral_one_click_leads
- viral_other_engagements
- viral_post_click_job_applications
- viral_post_click_job_apply_clicks
- viral_post_click_registrations
- viral_post_view_job_applications
- viral_post_view_job_apply_clicks
- viral_post_view_registrations
- viral_reactions
- viral_registrations
- viral_shares
- viral_subscription_clicks
- viral_total_engagements
- viral_video_completions
- viral_video_first_quartile_completions
- viral_video_midpoint_completions
- viral_video_starts
- viral_video_third_quartile_completions
- viral_video_views
daily_ad_analytics_by_member_company
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_company_size
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_country
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_job_function
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_job_title
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_region
0 fields
Field list not published yet. Ask and we will send it.
daily_ad_analytics_by_member_seniority
0 fields
Field list not published yet. Ask and we will send it.
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from LinkedIn Ads?
48 tables, including ad_analytics_by_campaign, daily_ad_analytics_by_member_industry, snapshots_campaign_history. ad_analytics_by_campaign is one row per campaign, per day. Every one is listed on this page, with its fields where the list is published.
Which LinkedIn Ads fields can I get?
The 1428 fields on this page, table by table. Lists marked documented schema follow the published schema for LinkedIn Ads, and your own warehouse may carry a few more or fewer.
How often does LinkedIn Ads data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join LinkedIn Ads data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across LinkedIn Ads and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
Why ad platform numbers never match on the same campaign.
They are not measuring the same thing. Once you know what each one counts, the gap stops being a mystery.
Read it - 6 min read
Server-side vs client-side tracking, and what changes in client reports.
More conversions, a break in your trend line, and a new way to count one sale twice.
Read it - 6 min read
How to set up alerts across client accounts, and keep them worth reading.
An alert that fires every day becomes a filter rule. Four things are worth interrupting somebody for.
Read it
Get started
Want LinkedIn Ads in your own warehouse?
A call with someone who can answer the schema questions.