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. 

Google BigQuery

Data sources

Free Linkedin Ads Connector to Google BigQuery

Download template

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.

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.

💡Check out this quick and clear video walkthrough on setting up the free LinkedIn Ads to BigQuery connector. It shows how to automate your ad data elegantly—from setup to execution.

Step-by-Step: Import LinkedIn Ads Data to BigQuery with OWOX Community Apps Script Edition

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.

‍

Step-by-Step: Import LinkedIn Ads Data to BigQuery with the OWOX Community Edition

Set up a fully self-managed, SaaS-free pipeline to import LinkedIn Ads data directly into BigQuery using the OWOX Community Edition 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 the Community Edition 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 Ads data mart in OWOX.

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

• Click ‘New Storage’

• Choose ‘Google BigQuery’

• Fill in the following: 
  
  • Title: e.g., “LinkedIn Ads Storage”
  • Project ID: Your Google Cloud project ID
  • Region: Must match your BigQuery dataset region

• Create and paste your Service Account JSON Key.
  
  • Go to Google Cloud Console → IAM → Service Accounts

• Create a new service account or choose an existing one:
  
  • Click Create Service Account
  • Fill in the Service Account Name, ID, and optionally a Description
  • Click Create and Continue
•  Assign the following roles to the service account:
  
  • BigQuery Data Editor
  • BigQuery Job User
• Generate a new authentication key:
  
  • On the Service Accounts page, select your service account
  • Go to the Keys tab
  • Click Add Key → Create new key
  • Select JSON format
  • Click Create to download the file
  • Open the downloaded JSON file in a text editor (e.g., Notepad, VS Code)
  • Copy the entire contents and paste it into the ‘OWOX Service Account JSON Field’
  • Don’t forget to click Save

• 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 Ads’, as the data source
• Choose the storage named ‘LinkedIn Ads Storage’ you just created
• Click ‘Create Data Mart’.

Now we will do the Data Setup

• Go to the Data Setup Tab and then select Connector

• Click on Setup Connector and Choose LinkedIn Ads Connector

‍

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

To connect your LinkedIn Ads account, you’ll need an access token. 

• Access Token: Repeat the steps from Step 3 of the Community Apps Script setup to generate your token, or use the same one if it's still valid.

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

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

• Paste the Access Token

• Account URN: You can find this on your LinkedIn Ads homepage, look for it directly in the account interface.

• Paste the Account URN

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

• Further Specify the Fields with the Following Parameters:
  
  • ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
  • MaxFetchingDays: Max number of days to fetch per run (default: 31)
  • EndDate: The final date up to which data should be fetched.
  • CleanUpToKeepWindow: Number of days of data to retain during cleanup; older data is removed.
  • Max Fields Per Request: Sets the maximum number of fields to be included in each API request.
  • API Version: Specifies the version of the LinkedIn Marketing API to use when making requests. 
  • BaseUrl: The base URL used to make requests to the LinkedIn Graph API.
  • MaxFetchRetries: Number of retry attempts allowed if a data fetch fails.
  • InitialRetryDelay: Time delay before making the first retry attempt after a failure.

• Click Next

‍

• Endpoint: Choose the following valid endpoints:
  
  • Ad Accounts

• Fields: Select all available fields or choose specific metrics like currency, name, servingStatus, status and type based on your reporting needs.

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

• Click Finish

In the Data Setup Tab

•  Click 'Save'.

• Click 'Publish'.

• Click 'Manual Run' or use the 3-dot menu → 'Run Now'.

• Go to 'Run History' and confirm the message: 'Import is finished'.

Step 5: View Imported Data in BigQuery ( ~1 min)

Check that your LinkedIn Ads data is now available in BigQuery.

•  Go to https://console.cloud.google.com/bigquery.

‍

• Open the specified project and dataset.

‍

• Click the Hamburger Menu in the top-left corner of Google Cloud Console to open the navigation panel. From there, go to Cloud Overview and then proceed to Welcome → BigQuery.

‍

• Click the table that was created.
• Use the 'Preview' tab or run SQL queries to inspect your data.

‍

Step 6: Schedule Automated Imports ( ~1 min)

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

• Go to the 'Triggers' tab.
• Click 'Add Trigger'.

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

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

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

📊 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