How to connect LinkedIn Pages to BigQuery with OWOX Data Marts
LinkedIn Pages to Google BigQuery in OWOX Data Marts takes six steps: create a Data Mart, choose the LinkedIn Pages connector, sign in with LinkedIn, pick the data, publish, add a trigger. From then on it refreshes on its own.
LinkedIn shows a company page’s analytics inside LinkedIn and lets you download a file. If you want follower growth and post engagement next to your ad spend and your pipeline, the page data has to live in Google BigQuery and refresh on its own.
In OWOX Data Marts the setup takes six steps. You sign in with LinkedIn, enter the page, choose what to load, publish, and set a schedule. There is no LinkedIn developer app to create and no API access to wait for. This guide walks through it on OWOX Cloud.
This connector loads organic page data. For paid campaigns use the LinkedIn Ads connector.
What you need
- An OWOX Cloud account. Sign up if you do not have one.
- A Google BigQuery storage in OWOX Data Marts. Add it under Storages, or create it while you set up the Data Mart. More on Google BigQuery as a storage.
- A LinkedIn user who is an admin of the company page.
- The organization ID of the page. It is the number in the address of the page’s admin view.
Step 1: Create the Data Mart
Click New Data Mart, give it a title, choose your Google BigQuery storage and click Create Data Mart. If you have no storage yet, pick Create new storage in the same dropdown.
OWOX Data Marts
See your first report built in real time. 15 minutes.
- Connect your data warehouse
- Pick your metrics
- Get a live Google Sheets report
In the time it takes to write a ticket. Then imagine never writing that ticket again.
Book a DemoWe'll use your actual use case
Step 2: Choose the LinkedIn Pages connector
Step 2: Choose the LinkedIn Pages connector
On the Data Setup tab, set Input Source to Connector and click Setup Connector. Choose LinkedIn Pages in the list and click Next.
Step 3: Sign in with LinkedIn
Click Continue with LinkedIn and sign in with the LinkedIn user that administers the page. Then enter the page in Organization URNs.
If you would rather use your own LinkedIn app, choose Manually and paste a Client ID, Primary Client Secret and Refresh Token. That route needs an app verified by a page admin and approved for LinkedIn’s Community Management API. The credentials guide shows each step. Most people do not need it.
Step 4: Choose what to load
Pick the data you want. Each option in the list has a one-line description. Each Data Mart loads one of them, so create another Data Mart for each extra one.
Keep the default fields or add more. The key fields stay selected.
Name the dataset and the table. Both are created on the first run if they do not exist yet.
Click Save.
Step 5: Publish and run
Click Publish & Run Data Mart. The first run can take a few minutes.
To load older history, use Manual Run on the same screen and choose the dates. Run History shows every run and its status.
Step 6: Keep it fresh
Open Triggers, add a trigger, choose Connector Run and set how often it runs: daily at a time and time zone you pick, weekdays, hourly or every few hours. Click Create trigger.
From here the table updates on its own.
What to do with the data
The table is raw LinkedIn Pages data. Two things usually come next:
- Join it with the rest of your marketing data in SQL: paid LinkedIn spend, site sessions, pipeline. Organic numbers mean more next to what they led to.
- Publish it where people read it. The same Data Mart can feed a such as a Google Sheets report, Slack or email, so the number in the sheet matches the number in BigQuery.
OWOX Data Marts loads the data and publishes what you build on it. The SQL that turns it into metrics stays yours.
Not on BigQuery?
The same connector loads into the other storages OWOX Data Marts supports: Snowflake, AWS Redshift, AWS Athena and Databricks.
OWOX Data Marts is also open source. If you run it yourself, connect LinkedIn with the manual credentials described in Step 3.
Turn your data into decisions.
Governed data marts give you the clean foundation ML needs to actually work.
- No AI hallucinations
- Analyst-governed definitions
- Every number traces to SQL
Frequently Asked Questions
Can I choose which LinkedIn Pages fields are loaded?
Yes. After you pick the data, you keep the default fields or select your own. The key fields stay selected so that rows are matched correctly on later runs.
Is the LinkedIn Pages to BigQuery connector free?
The connector is open source and free to run yourself with the open-source edition of OWOX Data Marts. You pay Google for BigQuery storage and queries. The same connector is available on OWOX Cloud, where there is no server to maintain.
How often does the LinkedIn Pages data refresh?
As often as the trigger you add on the Triggers tab: daily at a time you choose, on weekdays, hourly or every few hours. You can also start a run by hand at any time with Manual Run.
Do I need a LinkedIn developer app to connect LinkedIn Pages?
No. On OWOX Cloud you click Continue with LinkedIn and sign in with a user who is an admin of the page. A LinkedIn app with Community Management API access is only needed if you choose to connect manually, for example on a self-managed install.
Which LinkedIn Pages data can I load into BigQuery?
Organic page data: posts, followers and engagement such as reactions, comments and shares. Each Data Mart loads one kind of data. Paid campaign data comes from the separate LinkedIn Ads connector.
