Lucen syncs your LinkedIn Page data (Social) to your warehouse and models it into the tables below. You connect LinkedIn Page with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
History starts on the first collection run and cannot be backfilled before it. Your plan sets how much history the first sync loads, see pricing.
Follower counts by function, industry, seniority, country, region, association type and company size (top 100 values per facet)
gold_linkedin_page_followers
Grain
organization_id / date
Use for
Followers gained per day (organic and paid)
gold_linkedin_page_followers_snapshot
Grain
organization_id / snapshot_date
Use for
Total followers as of each day we synced (a level, not a gain)
gold_linkedin_page_post_stats_snapshot
Grain
organization_id / snapshot_date / post_urn
Use for
Cumulative per-post counters (cumulative_impressions, cumulative_unique_impressions, cumulative_clicks, cumulative_likes, cumulative_comments, cumulative_shares) as of each sync day
gold_linkedin_page_posts
Grain
organization_id / post_urn
Use for
The Page's currently published organic posts (the latest sync only; deleted posts disappear)
gold_linkedin_page_share_stats
Grain
organization_id / date
Use for
Impressions, unique impressions, clicks, likes, comments, shares and engagement for the Page's organic posts, aggregated per day
gold_linkedin_page_stats
Grain
organization_id / date
Use for
Page views and unique views by page section (overview, about, people, jobs, careers, life, insights, products), desktop and mobile, button clicks
Column names match your warehouse exactly. Descriptions come from dbt.
gold_linkedin_page_follower_demographics columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
snapshot_date
Snapshot date
DATE
UTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
facet
Facet
STRING
Demographic dimension: association_type, function, geo_country, seniority, staff_count_range, industry or geo.
facet_value
Facet value
STRING
Raw LinkedIn value for the facet (URN or enum).
facet_value_name
Facet value name
STRING
Readable name for facet_value; NULL when it could not be resolved.
follower_count
Follower count
FLOAT64
Followers in this facet value (organic and paid combined) as observed at the snapshot. Facets overlap: each facet breaks down the same followers, so do not add counts across facets. Do not SUM across snapshot dates. Use the latest available snapshot per organization for as-of reporting, or the difference between two snapshot dates for change. History starts at the first collection run: LinkedIn exposes no historical values for this measure, so snapshots before collection started cannot be backfilled.
data_updated_at
Data updated at
TIMESTAMP
As-of timestamp: when the values in this row were observed, i.e. the fetch time of the completed snapshot (the marker's fetched_at).
gold_linkedin_page_followers columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
date
Date
DATE
UTC calendar date of the metric.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
organic_follower_gain
Organic follower gain
FLOAT64
New organic followers gained that day.
paid_follower_gain
Paid follower gain
FLOAT64
New followers gained through paid promotion that day.
is_provisional
Is provisional
BOOL
TRUE for the most recent days (the last 2 days before the model was built), which LinkedIn may still restate: they can show zeros or partial values and are replaced by later runs. Exclude provisional days from week-over-week comparisons.
data_updated_at
Data updated at
TIMESTAMP
Timestamp of the fetch that produced the row.
gold_linkedin_page_followers_snapshot columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
snapshot_date
Snapshot date
DATE
UTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
total_followers
Total followers
FLOAT64
Total followers of the Page as observed at the snapshot (a level, not a daily gain). Do not add today's total to yesterday's. Do not SUM across snapshot dates. Use the latest available snapshot per organization for as-of reporting, or the difference between two snapshot dates for change. History starts at the first collection run: LinkedIn exposes no historical values for this measure, so snapshots before collection started cannot be backfilled. Daily gains live in gold_linkedin_page_followers.
net_change
Net change
FLOAT64
Change in total followers since the previous snapshot (previous_snapshot_date): total_followers minus the previous row's total_followers. NULL on the first snapshot. It is a difference between two as-of values, not a daily flow: do not SUM it across a range you did not select consecutively, and it covers only the days we synced. Gains alone are in gold_linkedin_page_followers; losses are not exposed by LinkedIn and can only be implied (gains minus net change) over consecutive daily snapshots.
previous_snapshot_date
Previous snapshot date
DATE
Snapshot date of the row net_change is measured against; NULL on the first snapshot.
data_updated_at
Data updated at
TIMESTAMP
As-of timestamp: when the values in this row were observed, i.e. the fetch time of the completed snapshot (the marker's fetched_at).
gold_linkedin_page_post_stats_snapshot columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
snapshot_date
Snapshot date
DATE
UTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
post_urn
Post urn
STRING
LinkedIn post URN (urn:li:share or urn:li:ugcPost).
cumulative_impressions
Cumulative impressions
FLOAT64
Cumulative organic impressions for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
cumulative_unique_impressions
Cumulative unique impressions
FLOAT64
Cumulative organic unique impressions for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
cumulative_clicks
Cumulative clicks
FLOAT64
Cumulative organic clicks for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
cumulative_likes
Cumulative likes
FLOAT64
Cumulative organic reactions (likes) for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
cumulative_comments
Cumulative comments
FLOAT64
Cumulative organic comments for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
cumulative_shares
Cumulative shares
FLOAT64
Cumulative organic reshares for this post, as observed at data_updated_at. Use the latest available snapshot per organization and post for as-of reporting; do not SUM across snapshot dates (each snapshot already contains all earlier activity). NULL when stats_returned is FALSE. Daily activity per organization lives in gold_linkedin_page_share_stats.
engagement
Engagement
FLOAT64
Cumulative engagement rate (a ratio, not a count) for this post as observed at the snapshot. Not additive: never SUM or AVG it across posts or snapshot dates; recompute from the cumulative counts instead.
stats_returned
Stats returned
BOOL
True when LinkedIn returned statistics for the post; False when counts are NULL because the post is outside the stats window.
data_updated_at
Data updated at
TIMESTAMP
As-of timestamp: when the values in this row were observed, i.e. the fetch time of the completed snapshot (the marker's fetched_at).
gold_linkedin_page_posts columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
snapshot_date
Snapshot date
DATE
UTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
post_urn
Post urn
STRING
LinkedIn post URN (urn:li:share or urn:li:ugcPost).
author_urn
Author urn
STRING
URN of the post author (the organization).
created_at
Created at
TIMESTAMP
When the post was created.
published_at
Published at
TIMESTAMP
When the post was published.
last_modified_at
Last modified at
TIMESTAMP
When the post was last modified.
lifecycle_state
Lifecycle state
STRING
Post lifecycle state (e.g. PUBLISHED).
visibility
Visibility
STRING
Post visibility.
content_type
Content type
STRING
Kind of post content (article, media, multiImage, poll,... or text).
commentary
Commentary
STRING
Post text with person mentions replaced by @member.
is_reshare
Is reshare
BOOL
True when the post is a reshare of another post.
data_updated_at
Data updated at
TIMESTAMP
As-of timestamp: when the values in this row were observed, i.e. the fetch time of the completed snapshot (the marker's fetched_at).
gold_linkedin_page_share_stats columns
ID
Name
Type
Description
client_id
Client id
STRING
Org slug the row belongs to.
organization_id
Organization id
STRING
Numeric LinkedIn organization (Page) id.
date
Date
DATE
UTC calendar date of the metric.
connection_alias
Connection alias
STRING
Portal connection alias that loaded the row.
impressions
Impressions
FLOAT64
Impressions.
unique_impressions
Unique impressions
FLOAT64
Unique impressions.
clicks
Clicks
FLOAT64
Clicks.
likes
Likes
FLOAT64
Reactions (likes).
comments
Comments
FLOAT64
Comments.
shares
Shares
FLOAT64
Reshares.
engagement
Engagement
FLOAT64
Engagement rate as returned by LinkedIn.
is_provisional
Is provisional
BOOL
TRUE for the most recent days (the last 2 days before the model was built), which LinkedIn may still restate: they can show zeros or partial values and are replaced by later runs. Exclude provisional days from week-over-week comparisons.
How many people visited the Page and which section?
gold_linkedin_page_stats
Prompt to try
How did our posts perform per day?
gold_linkedin_page_share_stats
Prompt to try
Who follows us (industry, seniority, country)?
gold_linkedin_page_follower_demographics
Prompt to try
Which posts are live and what do they say?
gold_linkedin_page_posts
Prompt to try
Which post performs best so far?
gold_linkedin_page_post_stats_snapshotlatest snapshot per post
Starter queries
sql
SELECT date, organization_id, organic_follower_gain, paid_follower_gain, is_provisional
FROM `your-project.your_org_gold.gold_linkedin_page_followers`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT snapshot_date, organization_id, total_followers, net_change, previous_snapshot_date
FROM `your-project.your_org_gold.gold_linkedin_page_followers_snapshot`
WHERE snapshot_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY snapshot_date DESC
LIMIT 100;
sql
SELECT date, organization_id, all_page_views, all_unique_page_views, all_desktop_page_views
FROM `your-project.your_org_gold.gold_linkedin_page_stats`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, organization_id, impressions, unique_impressions, clicks
FROM `your-project.your_org_gold.gold_linkedin_page_share_stats`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;