--- title: "LinkedIn Pages to BigQuery with OWOX Data Marts" canonical: "https://www.owox.com/blog/articles/free-linkedin-pages-to-bigquery-connector" updated: "2026-10-26" --- # 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. [Data Integration](/blog/topics/data-integration) · Updated October 26, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 3 min read ![How to connect LinkedIn Pages to BigQuery with OWOX Data Marts](https://cdn.owox.com/www/content-marketing-article/free-linkedin-pages-to-bigquery-connector/thumbnail/1-u1p54j.png/public) 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](https://www.owox.com/app-signup) 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](/blog/articles/free-linkedin-ads-to-bigquery-connector). ## What you need * **An OWOX Cloud account.** [Sign up](https://www.owox.com/app-signup) 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](/data-storages/google-bigquery). * **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. ![The Create Data Mart form in OWOX Data Marts with a title and a Google BigQuery storage selected](https://cdn.owox.com/www/content-marketing-article/free-linkedin-pages-to-bigquery-connector/screens/1.png/public) ## The Turning Point OWOX Data Marts See your first report built in real time. _15 minutes._ 1. Connect your data warehouse 2. Pick your metrics 3. Get a live Google Sheets report In the time it takes to write a ticket. Then imagine never writing that ticket again. [Book a Demo](/book-a-call) We'll use your actual use case ## 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](https://docs.owox.com/packages/connectors/src/sources/linked-in-pages/credentials/) 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. ![The Manual Run dialog in OWOX Data Marts with Backfill (custom period) selected and empty Start Date and End Date fields](https://cdn.owox.com/www/content-marketing-article/free-linkedin-pages-to-bigquery-connector/screens/2.png/public) ## 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 [destination](/data-destinations) such as a [Google Sheets report](/blog/articles/free-linkedin-pages-to-google-sheets-connector), 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 [data storages](/data-storages) OWOX Data Marts supports: [Snowflake](/connectors/free-linkedin-pages-connector-to-snowflake), [AWS Redshift](/connectors/free-linkedin-pages-connector-to-aws-redshift), [AWS Athena](/connectors/free-linkedin-pages-connector-to-aws-athena) and [Databricks](/connectors/free-linkedin-pages-connector-to-databricks). OWOX Data Marts is also [open source](https://github.com/OWOX/owox-data-marts). If you run it yourself, connect LinkedIn with the manual credentials described in Step 3. ## Your New Normal 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 [Get started free](https://www.owox.com/app-signup) ## FAQ ## 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. ## Who wrote this ![Vadym Kramarenko](https://cdn.owox.com/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public) [Vadym Kramarenko](/team/vadym-kramarenko) Growth Marketing Manager Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks. [LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko) [Data Integration](/blog/topics/data-integration) ## Related articles [Data Integration · How to Connect Facebook Ads to Google Sheets with OWOX Data Marts · September 30, 2026](/blog/articles/free-facebook-ads-connector-to-google-sheets) [Google BigQuery · How to Connect BigQuery to Google Sheets: Three Ways · October 6, 2026](/blog/articles/bigquery-reports-in-google-sheets) [Data Integration · CRM and Digital Marketing Data Integration: A Practical Guide · September 30, 2026](/blog/articles/crm-and-online-data-integration-guide) [See all articles →](/blog/articles) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting ## Schedule in person meeting at Data Outpost San Francisco You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Data Integration](https://www.owox.com/blog/topics/data-integration) — /blog/topics/data-integration.md - [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md - [OWOX Data Marts](https://www.owox.com/app-signup) - [LinkedIn Ads connector](https://www.owox.com/blog/articles/free-linkedin-ads-to-bigquery-connector) — /blog/articles/free-linkedin-ads-to-bigquery-connector.md - [Google BigQuery as a storage](https://www.owox.com/data-storages/google-bigquery) — /data-storages/google-bigquery.md - [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md - [credentials guide](https://docs.owox.com/packages/connectors/src/sources/linked-in-pages/credentials) - [destination](https://www.owox.com/data-destinations) — /data-destinations.md - [Google Sheets report](https://www.owox.com/blog/articles/free-linkedin-pages-to-google-sheets-connector) — /blog/articles/free-linkedin-pages-to-google-sheets-connector.md - [data storages](https://www.owox.com/data-storages) — /data-storages.md - [Snowflake](https://www.owox.com/connectors/free-linkedin-pages-connector-to-snowflake) — /connectors/free-linkedin-pages-connector-to-snowflake.md - [AWS Redshift](https://www.owox.com/connectors/free-linkedin-pages-connector-to-aws-redshift) — /connectors/free-linkedin-pages-connector-to-aws-redshift.md - [AWS Athena](https://www.owox.com/connectors/free-linkedin-pages-connector-to-aws-athena) — /connectors/free-linkedin-pages-connector-to-aws-athena.md - [Databricks](https://www.owox.com/connectors/free-linkedin-pages-connector-to-databricks) — /connectors/free-linkedin-pages-connector-to-databricks.md - [Data Integration · How to Connect Facebook Ads to Google Sheets with OWOX Data Marts · September 30,…](https://www.owox.com/blog/articles/free-facebook-ads-connector-to-google-sheets) — /blog/articles/free-facebook-ads-connector-to-google-sheets.md - [Google BigQuery · How to Connect BigQuery to Google Sheets: Three Ways · October 6, 2026](https://www.owox.com/blog/articles/bigquery-reports-in-google-sheets) — /blog/articles/bigquery-reports-in-google-sheets.md - [Data Integration · CRM and Digital Marketing Data Integration: A Practical Guide · September 30,…](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide) — /blog/articles/crm-and-online-data-integration-guide.md - [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md