Free LinkedIn Ads to BigQuery Connector by OWOX: Own Your B2B Ad Data with Confidence

Running campaigns on LinkedIn Ads is straightforward. But sending that data from LinkedIn to BigQuery in a clean, structured format? That’s where things get complicated.

If you’ve ever tried moving LinkedIn Ads to Google BigQuery for reporting, you’ve likely hit roadblocks – from rigid APIs and manual export workarounds to expensive tools that restrict your field access or delay your refresh schedules.

That’s exactly why we built this. 

With this 100% free, no-code connector from OWOX, digital and marketing analysts can easily send raw LinkedIn Ads data to BigQuery – no ETL tools, no engineering support, and no vendor lock-in. You control what’s pulled, how it’s structured, and when it updates.

Why We Made This Free Connector

At OWOX, we believe your LinkedIn Ads data should work for you, not the other way around.

That’s why we built this LinkedIn Ads to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) and made it 100% free. No paid tiers, no feature restrictions, and no limits on what you can extract, analyze, or automate.

Built specifically for sending LinkedIn Ads to Google BigQuery, this connector helps analysts move beyond black-box tools and regain control over how their campaign data is accessed, structured, and used. You decide what comes in, how it’s modeled, and where it goes.

Whether you’re managing reporting workflows, blending data from BigQuery to LinkedIn insights, or just tired of ETL platforms dictating your schema, this tool gives you full ownership.

💡 Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of open 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 Ads Data into BigQuery?

If you’ve worked with LinkedIn Ads Manager, you know the challenges:

❌ Native LinkedIn dashboards are rigid and offer limited export capabilities
❌ CSV files and manual downloads lead to outdated, error-prone workflows
❌ Many ETL tools charge by volume and still restrict field selection

Here’s how BigQuery changes that – and how this connector makes it simple:

✅ Load raw LinkedIn Ads data into BigQuery tables for flexible, SQL-based reporting
✅ Join with data from Salesforce, GA4, HubSpot, or offline lead tracking
✅ Automate refreshes and skip the costly data pipelines altogether

With OWOX, your LinkedIn campaign metrics live where your models do – in BigQuery. 

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

Google BigQuery

Data sources

Free Linkedin Ads Connector to Google BigQuery

Download template

Why Choose OWOX Free Connector for LinkedIn Ads to BigQuery

Most LinkedIn Ads to BigQuery tools claim to “simplify” your reporting, but they often lock you into rigid schemas, predefined field sets, or proprietary syncing methods. You’re left digging through someone else’s structure just to build the reports your team actually needs.

The OWOX connector takes a different route. It’s built for teams that want full transparency and the power to manage LinkedIn Ads data on their own terms.

• Specifically designed for exporting LinkedIn Ads into BigQuery – not part of a generic all-in-one connector with one-size-fits-all logic
• Imports detailed LinkedIn objects like Campaign Groups, Sponsored Posts, Creatives, and Ad Accounts – not just top-level summaries
• Uses a clear, editable Apps Script setup – so you always know how URNs, tokens, and scopes are applied
• Flexible enough to support any data load schedule – run daily updates, weekly refreshes, or on-demand pulls
• Entirely open-source – with version history, GitHub visibility, and no dependency on third-party platforms

This isn’t just a data sync tool. It’s your framework for modeling LinkedIn Ads data in BigQuery, the way your reporting strategy demands.

How the Connector Works

This LinkedIn Ads to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) gives you exactly what other tools don't – flexibility without the complexity.

It runs fully on a Google Sheets powered by open-source Apps Script – no extra tools or platforms involved.

Here’s what it does:

• Connects to the LinkedIn Marketing API to pull data like campaigns, ads, accounts, and performance metrics
• Loads that data directly into your BigQuery tables – no CSVs, no middle layers
• Gives you full control: edit the script, customize your logic, and scale reporting on your terms

And yes, it’s 100% free – no usage limits, no locked features.

If you want to skip expensive ETL tools and own your LinkedIn Ads reporting stack, this connector is built for you.

Step-by-Step: Import LinkedIn Ads Data to BigQuery

This connector makes it easy to bring your LinkedIn Ads and Pages data into BigQuery. No code, no extra platforms – just clean results in minutes.

Let’s walk through the setup.

Step 1: Copy the BigQuery Template ( ~1 min)

Begin with a pre-built BigQuery template tailored for LinkedIn Ads – no setup from scratch required.

1. Open and copy the ”LinkedIn Ads → Google BigQuery. Template” provided by OWOX.
2. Rename the copy as desired.

Master LinkedIn Ads to BigQuery Reporting With Our Free Template!

Skip manual exports and complex setup – this ready-to-use BigQuery template lets you import LinkedIn Ads data in just a few clicks.

Download your FREE template today!

Step 2: Configure the Template ( ~1 min)

Configure your data import settings directly in the BigQuery template.

• Set the Start Date

• Go to the Config sheet.
• Enter the desired Start Date for importing historical LinkedIn Ads data.

Note: Avoid selecting a long range, as it may cause the import to fail due to high data volume.

• Add Your LinkedIn Ads Account URNs
  
  • Visit your LinkedIn Ads homepage.

• Locate the Account URN in the interface. 

• Paste the URN into the “Account URNs” field on the Config sheet.

• You can include multiple Account URNs, separated by commas, to import data from several ad accounts.

• Select the Data Fields
  
  • Go to the Fields tab in the template.
  • Check the boxes for each metric, breakdown, or dimension you want to include in the import.

Note: Some fields may be preselected by default.

• Configure the BigQuery destination fields:
  - Enter your Destination Dataset ID in this format: projectid.datasetid
  - Specify the Destination Location (e.g., US, EU) 

If the specified dataset doesn’t exist yet, it will be created automatically when you run the import.

Further Specify the Fields with the Following Parameters:

• MaxFetchingDays: Max number of days to fetch per run (default: 30)
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)

This ensures your LinkedIn Ads to BigQuery data flow has a proper landing zone - clean, structured, and ready for analysis. 

Step 3: Get a LinkedIn Access Token ( ~1 min)

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

• Visit the LinkedIn Developer portal.
  
  
  • Navigate to: https://www.linkedin.com/developers/
    
• 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.

• 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.

• Next, request access to the LinkedIn Advertising API:
  
  
  • Go to the Products tab of your app.
  • Request access to the Advertising API. 

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

• Once approved, the Advertising API will appear under the Added Products section.

• Generate an access token:
  
  
  • Go to the Auth tab.
  • Click OAuth 2.0 Tools on the right-hand panel.

• Click the Create Token button.

• 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 these two scopes are selected:

r_ads
r_ads_reporting

• Then click Request access token.

• 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.

‍

Step 4: Input Access Token into the Template ( ~1 min) 

After generating your LinkedIn Ads access token, enter it into the OWOX template to enable data imports.

• In your copied BigQuery template, go to the top menu and click:
  → OWOX → Manage Credentials

• In the credentials window:
  
  
  • Paste your access token into the designated field
  • Click OK to save and apply the token

Step 5: Run the Connector & Import Your Data ( ~1 min)

After setting up your credentials and configurations, you're ready to bring LinkedIn Ads data.

• Open the Import Menu
  
  • In the spreadsheet menu, click: OWOX → Import New Data

• Once the import completes, the Logs sheet will show “Import is finished”.
• The imported data will be stored in the dataset you defined earlier in the configuration settings.

📊 Real-Time Reporting with OWOX Reports

Looking to make your LinkedIn Ads data in BigQuery more actionable?

The OWOX Reports Extension for Google Sheets makes it easy to bring that data into dashboards, without touching SQL or using tools like Looker Studio. 

With OWOX Reports, you can:
📥 Pull LinkedIn Ads data from BigQuery straight into Google Sheets
📊 Create shareable dashboards that update with a single click
✅ Give your team live access to performance insights – no technical setup needed

No code. No wait. Just clear, customizable reporting from BigQuery to Sheets

What’s Next?

This free LinkedIn Ads to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) moves us closer to making data ownership simple, transparent, and accessible to all.

Explore more resources below:
🔗 More free connectors – like Criteo Ads, and Reddit Ads Connector for BigQuery
🎥 In-depth video tutorials – guiding you through setup and best practices
📊 Pre-built dashboard templates – so you can get reporting insights instantly

Explore our GitHub repo, drop us a ⭐ star, and help us shape a more open and transparent future for marketing analytics.

Google BigQuery

Data sources

Free Linkedin Ads Connector to Google BigQuery

Download template