BigQuery Connector

Sync LinkedIn Pages Data to BigQuery

Detrics loads LinkedIn Pages into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Get Started Free

*No credit card required

SELECT
  account_name,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks,
  SUM(likes) AS likes
FROM `your_project.marketing_data.linkedin_pages_daily_engagement_trend_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY account_name
ORDER BY impressions DESC
LIMIT 10

Why send LinkedIn Pages data to BigQuery?

Audience evolution

Store daily snapshots of followers and engagement to measure real long-term growth.

History without limits

Platform APIs cap how far back you can query. In BigQuery every LinkedIn Pages sync is stored across its 4 tables, so you accumulate years of your own history.

One warehouse for everything

Join LinkedIn Pages with the rest of your platforms in one place, without copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about LinkedIn Pages in plain language.

LinkedIn Pages tables in BigQuery

This is what Detrics creates for LinkedIn Pages: 4 preset tables with scheduled syncs, plus any custom one you define.

Page Analytics

engagement_overview

Overall content engagement metrics

account nameaccount IDimpressionsclickslikescomments+2

monthly_follower_growth_daily

Monthly organic and paid follower growth

account nameaccount IDorganic follower gainpaid follower gaintotal follower gain

daily_engagement_trend_daily

Per-day engagement, keyed on account + date — incremental-dedup-safe

account nameaccount IDimpressionsclickslikescomments+1

+1 more table in this group

HOW IT WORKS

From LinkedIn Pages to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 39+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Get started free

No credit card required.

Then ask Claude about it

With LinkedIn Pages in BigQuery, the Detrics MCP server lets you manage your warehouse and run queries in plain language. MCP access is included with every BigQuery plan.

Engagement dropped this month on LinkedIn Pages. Show me where.

How did my LinkedIn Pages audience grow this month?

Which LinkedIn Pages posts got the most engagement?

Explore the LinkedIn Pages MCP server

Every LinkedIn Pages field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

45 metrics

17 dimensions

View LinkedIn Pages Fields

Get LinkedIn Pages into your warehouse this week