Connector

Collect LinkedIn Pages data in Google BigQuery

Load your company page's follower statistics into your own BigQuery tables with OWOX Data Marts: followers by seniority, industry, function and location, and daily follower gains split into organic and paid. Set them beside ad spend, web analytics and CRM to see what the page brings.

LinkedIn PagesConnectedFollower Statist…Time-Bound Follo…
Data MartPublishedone definition
Google BigQueryOrgan…TimeTimeDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

The LinkedIn Pages follower count goes up, but whether pipeline follows stays unknown without the data in Google BigQuery.

Paste this into your AI assistant. It creates a LinkedIn Pages Data Mart on your Google BigQuery storage and loads followers by segment and organic and paid gains into your own tables, ready to join with your CRM.

The prompt

load LinkedIn Pages follower statistics into Google BigQuery daily and build a Data Mart that sets monthly follower gains from our target industries next to new CRM opportunities

Endpoints

S00 · Why

Why join LinkedIn Pages with ad spend and your CRM

LinkedIn shows how many people followed your page. It does not show whether the right people followed, what paid growth cost, or whether pipeline grew in the same industries. For that, page statistics, ad spend and CRM records have to sit in one data warehouse.

  • Track organic and paid follower gain day by day, not only the total
  • See who follows you by seniority, industry, function and location
  • Set paid follower gain against what you spent on LinkedIn Ads
LinkedIn PagesPage followers
LinkedIn AdsSpend
CRMPipeline
Your data warehouseBigQueryFollowersAd spendPipelineJoined by idFollower gainedPipeline growsOne query links growth to spend.

S01 · Step 1

Step 1: Connect LinkedIn Pages and pick the fields

Create a Data Mart, choose LinkedIn Pages as the data source, authorize once, open an endpoint and tick only the fields you need.

  • Two endpoints and 18 fields to choose from
  • Time-Bound Follower Statistics holds the daily organic and paid gains
New Data MartChoose a sourceLinkedIn AdsLinkedIn PagesFacebook AdsAuthorizeConnectedEndpointTime-Bound Follow…Follower Statisti…
Time-Bound Follow…12 fieldsorganization_urntime_range_starttime_range_endorganic_follower_gainpaid_follower_gain

S02 · Step 2

Step 2: Load LinkedIn Pages into a BigQuery table

The dataset and table in your data storage are pre-filled, and you can change them. Run it and the first load lands in your own BigQuery project.

  • Each endpoint gets its own table: the current follower breakdown and the daily gains stay apart
  • Every run is logged in Run History
DestinationBigQueryDatasetlinkedin_pagesTablefollower_statistics_time_boundRun
Run HistoryPendingRunningSuccessIncremental load
Tablelinkedin_pages.follower_stati…

S03 · Step 3

Step 3: Get a business-friendly output schema

After the first run you get the output schema: every field with a readable description. Your data quality checks can read it too.

  • Descriptions say what a field holds, for example the number of organic followers gained in the period
  • Anyone on the team can read the table
linkedin_pages.follower_statistics_time…Output schemaFieldDescriptionorganization_urnOrganization URNtime_range_startStart timestamp of the time rangetime_range_endEnd timestamp of the time rangeorganic_follower_gainNumber of organic followers…paid_follower_gainNumber of paid followers gained…

S04 · Step 4

Step 4: Keep the page tables linked

Follower Statistics and Time-Bound Follower Statistics are separate tables that share the organization URN. Joined, they show who follows the page and how fast it grows.

  • Join on organization_urn, the page's organization identifier
  • Add ad spend and CRM tables to the same data model
Follower Statisti…organization_urnsegment_namesegment_valuepaid_follower_co…
Time-Bound Follow…organization_urntime_range_startorganic_follower…paid_follower_ga…

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A daily scheduled refresh adds each new period of follower gains, and a manual backfill loads a past period.

  • Daily runs with no pipeline to maintain
  • Backfill history the first time you connect
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same table everywhere

One table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Define the numbers once
  • Every report reads the same table
LinkedIn Pa…Data MartPublished
Your data model
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for LinkedIn Pages in BigQuery

Hand-built API scripts and a generic ETL tool each get the numbers out. OWOX also keeps them yours, readable and ready to model.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • A business-friendly schema. Readable field names and descriptions, not API identifiers.
  • Ready for a data model. Separate tables per endpoint, joined by the organization URN, ready to set beside ad spend and CRM by date.
  • Maintained for you. No scripts to fix when LinkedIn changes its API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers