Free LinkedIn Pages to BigQuery Connector by OWOX: Own Your Organic Page Insights

Tracking engagement on your LinkedIn Page is simple. But getting that organic data into BigQuery for scalable reporting? That’s where things get messy.

If you’ve ever tried exporting LinkedIn Page insights to BigQuery, you know the pain – limited API endpoints, manual workarounds, and tools that restrict what data you can access or how often you can refresh it.

That’s exactly why we created this.

With this 100% free, no-code connector from OWOX, digital and marketing analysts can easily move raw LinkedIn Pages data to BigQuery – no ETL tools, no dev resources, no platform lock-in. You decide what gets imported, how it’s structured, and when it syncs.

Why We Made This Free Connector

At OWOX, we believe your LinkedIn Page data should be easy to access, use, and analyze – without jumping through hoops. That’s why we built OWOX Data Marts and made it completely free. No subscriptions, no locked features, and no limits on what you can extract or automate.

Purpose-built for sending LinkedIn organic insights to BigQuery, this connector empowers analysts to move past rigid tools and take full control of how their page data is accessed, structured, and activated.

Whether you're building reporting workflows, joining Page insights with CRM data, or just want to skip the pain of manual exports, this tool puts the data in your hands, on your terms.

💡 Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of data and marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further. 

Why Bring LinkedIn Pages Data into BigQuery?  

If you’ve ever tried reporting on LinkedIn Page performance at scale, you’ve probably run into common blockers:
❌ Native LinkedIn dashboards don’t support detailed exports or historical insights
❌ Manual CSV downloads are tedious and prone to errors
❌ Most ETL platforms limit your control and charge based on data volume

BigQuery changes all of that – and this connector makes it easy:
✅ Stream raw LinkedIn Page data (followers, updates, engagement) directly into BigQuery tables
✅ Blend Page insights with CRM and content attribution data for unified analysis
✅ Automate updates and eliminate complex pipelines or third-party tools

With OWOX, your LinkedIn Page metrics land directly in BigQuery – ready for SQL queries, modeling, and real-time dashboards.

Check out our other free connectors:
Liking the freedom of custom reports? Take it further with these plug-and-play integrations:
‍
LinkedIn Page → Sheets
LinkedIn Ads → BigQuery
Facebook Ads → BigQuery
Criteo Ads → BigQuery
‍
No fees, no code—only faster, smarter reporting across every ad channel.

Why Choose OWOX Free Connector for LinkedIn Pages to BigQuery  

Many tools that promise LinkedIn Pages reporting fall short, offering limited metrics, fixed exports, and dashboards that aren’t built for flexible analysis. You’re often boxed into someone else’s schema or forced to rely on dashboards that can’t scale with your team’s needs.

This OWOX Data Marts takes a different approach, giving you the structure and flexibility to shape LinkedIn Page data to match your reporting goals.

• 100% free and open-source: no costs, hidden limits, or pricing tiers. This connector is available on GitHub as part of OWOX Data Marts.
• No platform lock-in: you own the setup. No signup required, no hosted environment, and no risk of vendor lockout.
• Full visibility: unlike black-box tools, the OWOX connector is fully transparent. You can inspect, modify, and extend every part of the pipeline.
• Field-level control: choose only the LinkedIn Pages Insights fields you need. Avoid bloated schemas and unnecessary syncing.
• Direct LinkedIn Pages → BigQuery flow: skips CSVs, staging layers, and third-party services.
• Schema control: define your destination table schema, apply clear field aliases, and adapt the structure to your reporting needs.

Instead of being confined by vendor-defined pipelines, this connector gives you direct control over your LinkedIn Pages data – how it’s fetched, how often it updates, and how it fuels your reporting, without limitations.

How the Connector Works  

This LinkedIn Pages to BigQuery connector delivers what most tools can’t: full flexibility without added complexity.
It runs entirely in your own environment with OWOX Data Marts, built on open-source code, no extra platforms or costly middleware required.

Here’s what it lets you do:

• Connects directly to the LinkedIn Pages API to pull data on posts, followers, engagement, and page metrics
• Sends that data straight into your BigQuery tables – no CSV exports or third-party sync tools required
• Offers full transparency and control – adjust configurations, adapt the logic, and scale reporting to match your business needs.

If you're looking to bypass expensive ETL tools and build a reporting pipeline you actually control, this connector is made for you.

Step-by-Step: Import LinkedIn Pages Data to BigQuery with OWOX Data Marts

Set up a fully self-managed, SaaS-free pipeline to import LinkedIn Pages data directly into BigQuery using the OWOX Data Marts and a local server.

Step 1: Install Node.js and OWOX CLI ( ~2 min)

To run OWOX Data Mart locally, you’ll need to install Node.js and the OWOX CLI. This setup allows you to start a local server and work with OWOX Data marts effectively.

To get started, install the LTS version of Node.js from nodejs.org and use a version manager like nvm or nvm-windows to avoid permission issues. Once Node.js is set up, you can install the OWOX CLI globally and run ‘owox serve’ to launch the local server. 

💡 For detailed setup instructions and troubleshooting, check the official documentation.

Step 2: Connect Google BigQuery and Set Up Your Data Mart ( ~3 min)

Set up BigQuery as your destination and link it to a new LinkedIn Pages data mart in OWOX.

1. Open your browser and go to http://localhost:3000.

💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.

2. Create your Service Account JSON Key.

• Follow our guide to create your service account JSON Key.

3. Paste it into the ‘OWOX Service Account JSON Field’

• Don’t forget to click Save

4. Once storage is added, click on the Data Mart Tab then on ‘New Data Mart’

• Now create the Data Mart, name the title as ‘LinkedIn Pages Data’, as the data source.
• Choose the storage named ‘LinkedIn Pages Storage’ you just created
• Click ‘Create Data Mart’.

Now we will do the Data Setup

5. Set up your Data Mart

• Go to Data Setup Tab and then select Connector

• Click on Setup Connector and Choose LinkedIn Pages Connector

Step 3: Get a LinkedIn Access Token ( ~30 seconds)

Generate an OAuth access token from the LinkedIn Developer Portal to authorize the connector and enable data transfer into BigQuery.

Prerequisites

• A LinkedIn Developer account with permission to create apps.
• A LinkedIn Page (company profile) where you have admin rights.
• A newly created and verified LinkedIn App connected to your company page.
• Requested and approved access to the following APIs in the Developer Portal:
  
  • Share on LinkedIn
  • Community Management API
• A valid Access Token generated via OAuth 2.0 with the required scopes:

Steps to Obtain Credentials

To authorize the connector, you’ll need a valid LinkedIn Pages API access token. Here’s how to generate one safely:

1. Visit the LinkedIn Developer portal.

• Navigate to: https://www.linkedin.com/developers/
  

2. Create a new app:

• Click the Create App button.

• Enter your App Name.
• Paste the link to your company’s LinkedIn page in the LinkedIn Page field.

• Upload your company logo.
• Accept the legal agreement and click Create App.

3. Verify your app:

• Go to the Settings tab.
• Click the Verify button. 

The admin of your LinkedIn company page will receive a request to approve the app.

• Copy the Verification URL.

• Make sure your LinkedIn app shows as “Verified” under App Settings.

4. Request Access to API:

• Once your app is verified, navigate to the Products tab in the LinkedIn Developer Portal.
• Find the necessary APIs and submit your access request.

Note: To access LinkedIn Page data-such as posts, followers, reactions, comments, shares, and engagement metrics for organic content, you must request access to both of the following APIs:

• Share on LinkedIn
• Community Management API

‍

Note: Approval may take up to 24 hours. You’ll receive an email once approved.

• Once approved, the Share on LinkedIn and Community Management API will appear under the Added Products section.

5. Generate an access token:

• Go to the Auth tab.
• Click OAuth 2.0 Tools on the right-hand panel.

• Click the Create Token button.

6. Configure scopes:

• If you see the error: "There aren't any scopes available for this app…", it means the Advertising API access has not been granted yet.

• Ensure the required scopes are selected:

r_organization_social

r_organization_followers

r_social_engagement

• Then click Request access token.

7. Authorize and copy the token:

• On the next screen, click Allow to approve access.

• Your access token will be created and ready to use. 
• Copy and securely store the token – you’ll use it to authorize the OWOX template.

Note: Make sure you are copying the Access Token, not the Refresh Token. The Access Token is located at the top of the page.

Security Notes

• Keep your Client ID, Client Secret, and Access Token private, never expose them in public repos or docs.
• Store tokens securely using environment variables or a secrets manager.
• LinkedIn Access Tokens expire after a set period; monitor expiry and refresh them when required.
• Always request only the scopes you need to minimize risk.
• Rotate or revoke credentials if you suspect any unauthorized use.

Step 4: Configure LinkedIn Pages Connector and Run Your First Import ( ~2 min)

Now that you’ve retrieved your LinkedIn Pages access token, it’s time to configure the connector in OWOX.

1. Paste the Access Token

2. Paste the Organization URN

3. Start Date: Set the reporting start date (e.g., 2025-07-01). This determines how far back data will be fetched.

4. When you scroll down, you’ll see some more fields with parameters. For your first run, they are optional, and you can always come back and adjust them later.
   
   
5. Click Next

6. Endpoint: Choose the following valid endpoints:

• LinkedIn Follower Statistics: Provides overall follower insights such as total follower count, demographics, and audience composition for your LinkedIn Page.
• LinkedIn Time-Bound Follower Statistics: Delivers follower growth trends over specific time periods, helping you track increases or decreases in your audience.

👉 Tip for first-time setup: If you’re just getting started, begin with LinkedIn Follower Statistics. It gives you a clear overview of your audience size and demographics, which most teams use as a baseline. Later, you can add Time-Bound Follower Statistics to analyze trends and measure how your audience evolves over time.

7. Select Fields for the chosen endpoint. 

• Select all available fields or choose specific metrics based on your reporting needs.

8. Dataset Name: 

• Enter the BigQuery dataset name where the imported data should be stored.

Note: If the dataset doesn't exist, OWOX will create it automatically during the import process.

9. Click Finish
   
   

10. In the Data Setup Tab, click 'Save'.

11. Click 'Publish Data Mart'.

12. Click 'Manual Run' button or use the 3-dot menu.

13. A configuration panel will appear to choose a Run Type. Select Backfill or Incremental Load. Then add the required start and end dates, then click Run to load the data. 

Please Note: If you are setting up this connector for the first time, you need to go with the Backfill Run Type.

14. Go to 'Run History' and see the message: 'Success'.

Step 5: Schedule Automated Imports ( ~1 min)

Set up a trigger to pull data on a recurring schedule.

1. Go to the 'Triggers' tab in the new Data Mart

• Click 'Add Trigger'.

2. Configure:

• Choose the Trigger Type as Connector Run and the Schedule Settings: Daily / Weekly / Monthly / Interval.
• Set the Time (hour, minute, or second), days of the week, and choose your time zone.

3. Click 'Create Trigger'. Your data will now refresh automatically.

4. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

What’s Next? 

The free LinkedIn Pages to BigQuery connector in OWOX Data Marts is part of our ongoing effort to make data ownership simple, transparent, and accessible for everyone.

Here are more resources to explore:

🔗 More free connectors – including Microsoft Ads, Reddit Ads Connector for BigQuery, and more

🎥 Step-by-step video walkthroughs – to simplify setup and usage

📊 Ready-made dashboard – deliver data instantly into Google Sheets and Looker Studio for faster, more insightful reporting.

Check out our GitHub repo, give us a ⭐ star, and join us in building a more open, transparent future for marketing analytics.