Social
LinkedIn Organic schema
SightShark syncs LinkedIn Organic into a data warehouse you own. It creates 43 tables, with field lists for 32 of them, refreshed daily. Page and post data for an organisation: follower counts by six dimensions, page views by tab, post content, share statistics, reactions, comments and video analytics.
43 tables / 394 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.
reports_total_follower_statistic
3 fields
- account_id
- org_urn
- first_degree_size
reports_time_bound_follower_statistic
5 fields
- account_id
- org_urn
- day
- follower_gains_organic_follower_gain
- follower_gains_gain
snapshots_followers_by_industry
6 fields
- account_id
- org_urn
- industry
- industry_name
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_post_history
13 fields
- account_id
- org_urn
- post_id
- author
- commentary
- visibility
- lifecycle_state
- created_at
- published_at
- last_modified_at
- is_reshare_disabled
- feed_distribution
- content_type
snapshots_post_content
10 fields
- post_id
- article_source
- article_title
- article_description
- article_thumbnail
- media_id
- media_alt
- poll_question
- poll_unique_voters_count
- landing_page
reports_reactions
5 fields
- entity_urn
- reaction_id
- reaction_type
- actor_urn
- created_time
snapshots_industry
2 fields, documented schema
- id
- name
snapshots_function
2 fields, documented schema
- id
- name
snapshots_seniority
2 fields, documented schema
- id
- name
snapshots_geo
2 fields, documented schema
- id
- value
snapshots_organizations
0 fields
Field list not published yet. Ask and we will send it.
snapshots_organization_details
0 fields
Field list not published yet. Ask and we will send it.
snapshots_member_profile
0 fields
Field list not published yet. Ask and we will send it.
snapshots_followers_by_geo_country
3 fields, documented schema
- geo
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_followers_by_geo
3 fields, documented schema
- geo
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_followers_by_function
3 fields, documented schema
- function_id
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_followers_by_association_type
3 fields, documented schema
- association_type
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_followers_by_seniority
3 fields, documented schema
- seniority_id
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
snapshots_followers_by_staff_count_range
3 fields, documented schema
- follower_counts_organic_follower_count
- follower_counts_paid_follower_count
- staff_count_range
snapshots_page_statistic_by_geo_country
28 fields, documented schema
- geo_id
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_page_statistic_by_geo
28 fields, documented schema
- geo_id
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_page_statistic_by_association_type
0 fields
Field list not published yet. Ask and we will send it.
snapshots_page_statistic_by_function
28 fields, documented schema
- function_id
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_page_statistic_by_industry
28 fields, documented schema
- industry_id
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_page_statistic_by_seniority
28 fields, documented schema
- seniority_id
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_page_statistic_by_staff_count_range
28 fields, documented schema
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
- staff_count_range
snapshots_total_page_statistic
34 fields, documented schema
- about_page_views
- all_desktop_page_views
- all_mobile_page_views
- all_page_views
- careers_page_banner_promo_clicks
- careers_page_employees_clicks
- careers_page_jobs_clicks
- careers_page_promo_links_clicks
- careers_page_views
- desktop_about_page_views
- desktop_careers_page_views
- desktop_insights_page_views
- desktop_jobs_page_views
- desktop_life_at_page_views
- desktop_overview_page_views
- desktop_people_page_views
- desktop_products_page_views
- insights_page_views
- jobs_page_views
- life_at_page_views
- mobile_about_page_views
- mobile_careers_page_employees_clicks
- mobile_careers_page_jobs_clicks
- mobile_careers_page_promo_links_clicks
- mobile_careers_page_views
- mobile_insights_page_views
- mobile_jobs_page_views
- mobile_life_at_page_views
- mobile_overview_page_views
- mobile_people_page_views
- mobile_products_page_views
- overview_page_views
- people_page_views
- products_page_views
snapshots_post_multi_image
3 fields, documented schema
- id
- alt_text
- title
snapshots_post_carousel_card
4 fields, documented schema
- media_id
- landing_page
- media_alt_text
- media_title
snapshots_post_poll_option
3 fields, documented schema
- text
- is_voted_by_viewer
- vote_count
snapshots_post_distribution_targets
0 fields
Field list not published yet. Ask and we will send it.
reports_time_bound_page_statistic
63 fields, documented schema
- day
- about_page_views
- about_unique_page_views
- all_desktop_page_views
- all_desktop_unique_page_views
- all_mobile_page_views
- all_mobile_unique_page_views
- all_page_views
- all_unique_page_views
- careers_page_banner_promo_clicks
- careers_page_employees_clicks
- careers_page_jobs_clicks
- careers_page_promo_links_clicks
- careers_page_views
- careers_unique_page_views
- desktop_about_page_views
- desktop_about_unique_page_views
- desktop_careers_page_views
- desktop_careers_unique_page_views
- desktop_insights_page_views
- desktop_insights_unique_page_views
- desktop_jobs_page_views
- desktop_jobs_unique_page_views
- desktop_life_at_page_views
- desktop_life_at_unique_page_views
- desktop_overview_page_views
- desktop_overview_unique_page_views
- desktop_people_page_views
- desktop_people_unique_page_views
- desktop_products_page_views
- desktop_products_unique_page_views
- insights_page_views
- insights_unique_page_views
- jobs_page_views
- jobs_unique_page_views
- life_at_page_views
- life_at_unique_page_views
- mobile_about_page_views
- mobile_about_unique_page_views
- mobile_careers_page_employees_clicks
- mobile_careers_page_jobs_clicks
- mobile_careers_page_promo_links_clicks
- mobile_careers_page_views
- mobile_careers_unique_page_views
- mobile_insights_page_views
- mobile_insights_unique_page_views
- mobile_jobs_page_views
- mobile_jobs_unique_page_views
- mobile_life_at_page_views
- mobile_life_at_unique_page_views
- mobile_overview_page_views
- mobile_overview_unique_page_views
- mobile_people_page_views
- mobile_people_unique_page_views
- mobile_products_page_views
- mobile_products_unique_page_views
- organization_entity
- overview_page_views
- overview_unique_page_views
- people_page_views
- people_unique_page_views
- products_page_views
- products_unique_page_views
reports_video_analytics
0 fields
Field list not published yet. Ask and we will send it.
reports_member_post_statistics_single
0 fields
Field list not published yet. Ask and we will send it.
reports_member_post_statistics_aggregated
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
Organic numbers live behind a different login from paid, so the two halves of the same channel are usually reported separately and never add up.
Questions people ask
What tables does SightShark create from LinkedIn Organic?
43 tables, including reports_total_follower_statistic, reports_time_bound_follower_statistic, snapshots_followers_by_industry. reports_total_follower_statistic is one row per page. Every one is listed on this page, with its fields where the list is published.
Which LinkedIn Organic fields can I get?
The 394 fields on this page, table by table. Lists marked documented schema follow the published schema for LinkedIn Organic, and your own warehouse may carry a few more or fewer.
How often does LinkedIn Organic 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 Organic 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 Organic and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What happens when a platform changes its API.
A pipeline that stops gets fixed today. A pipeline that keeps returning rows can be wrong for a month.
Read it - 6 min read
How to write metric definitions that hold across clients.
Most arguments about a number are arguments about what the number means. Write it down once.
Read it - 7 min read
How far back a new client's marketing data goes.
Further than you expect in places, and gone for good in others. Worth knowing before the day you need it.
Read it
Get started
Want LinkedIn Organic in your own warehouse?
A call with someone who can answer the schema questions.