Lucen

LinkedIn Page data reference

Social
7 tables
97 columns

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.

Send LinkedIn Page data to

Tables

gold_linkedin_page_follower_demographics

Grain
organization_id / snapshot_date / facet / facet_value
Use for
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

Columns

Column names match your warehouse exactly. Descriptions come from dbt.

gold_linkedin_page_follower_demographics columns

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
snapshot_dateSnapshot dateDATEUTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
facetFacetSTRINGDemographic dimension: association_type, function, geo_country, seniority, staff_count_range, industry or geo.
facet_valueFacet valueSTRINGRaw LinkedIn value for the facet (URN or enum).
facet_value_nameFacet value nameSTRINGReadable name for facet_value; NULL when it could not be resolved.
follower_countFollower countFLOAT64Followers 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_atData updated atTIMESTAMPAs-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

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
dateDateDATEUTC calendar date of the metric.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
organic_follower_gainOrganic follower gainFLOAT64New organic followers gained that day.
paid_follower_gainPaid follower gainFLOAT64New followers gained through paid promotion that day.
is_provisionalIs provisionalBOOLTRUE 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_atData updated atTIMESTAMPTimestamp of the fetch that produced the row.

gold_linkedin_page_followers_snapshot columns

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
snapshot_dateSnapshot dateDATEUTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
total_followersTotal followersFLOAT64Total 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_changeNet changeFLOAT64Change 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_datePrevious snapshot dateDATESnapshot date of the row net_change is measured against; NULL on the first snapshot.
data_updated_atData updated atTIMESTAMPAs-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

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
snapshot_dateSnapshot dateDATEUTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
post_urnPost urnSTRINGLinkedIn post URN (urn:li:share or urn:li:ugcPost).
cumulative_impressionsCumulative impressionsFLOAT64Cumulative 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_impressionsCumulative unique impressionsFLOAT64Cumulative 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_clicksCumulative clicksFLOAT64Cumulative 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_likesCumulative likesFLOAT64Cumulative 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_commentsCumulative commentsFLOAT64Cumulative 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_sharesCumulative sharesFLOAT64Cumulative 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.
engagementEngagementFLOAT64Cumulative 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_returnedStats returnedBOOLTrue when LinkedIn returned statistics for the post; False when counts are NULL because the post is outside the stats window.
data_updated_atData updated atTIMESTAMPAs-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

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
snapshot_dateSnapshot dateDATEUTC date the snapshot was taken. Values are measured as of this date, not accumulated over it. Do not SUM metrics across snapshot dates.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
post_urnPost urnSTRINGLinkedIn post URN (urn:li:share or urn:li:ugcPost).
author_urnAuthor urnSTRINGURN of the post author (the organization).
created_atCreated atTIMESTAMPWhen the post was created.
published_atPublished atTIMESTAMPWhen the post was published.
last_modified_atLast modified atTIMESTAMPWhen the post was last modified.
lifecycle_stateLifecycle stateSTRINGPost lifecycle state (e.g. PUBLISHED).
visibilityVisibilitySTRINGPost visibility.
content_typeContent typeSTRINGKind of post content (article, media, multiImage, poll,... or text).
commentaryCommentarySTRINGPost text with person mentions replaced by @member.
is_reshareIs reshareBOOLTrue when the post is a reshare of another post.
data_updated_atData updated atTIMESTAMPAs-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

IDNameTypeDescription
client_idClient idSTRINGOrg slug the row belongs to.
organization_idOrganization idSTRINGNumeric LinkedIn organization (Page) id.
dateDateDATEUTC calendar date of the metric.
connection_aliasConnection aliasSTRINGPortal connection alias that loaded the row.
impressionsImpressionsFLOAT64Impressions.
unique_impressionsUnique impressionsFLOAT64Unique impressions.
clicksClicksFLOAT64Clicks.
likesLikesFLOAT64Reactions (likes).
commentsCommentsFLOAT64Comments.
sharesSharesFLOAT64Reshares.
engagementEngagementFLOAT64Engagement rate as returned by LinkedIn.
is_provisionalIs provisionalBOOLTRUE 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_atData updated atTIMESTAMPTimestamp of the fetch that produced the row.

gold_linkedin_page_stats columns

30

Typical questions

Prompt to try
How many followers did we gain last month?

gold_linkedin_page_followers

Prompt to try
What is our follower total over time?

gold_linkedin_page_followers_snapshot

Prompt to try
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;

Integration page