Connector

Collect LinkedIn Ads data in Google BigQuery

Load LinkedIn Ads into your own BigQuery tables with OWOX Data Marts: one table per endpoint, a business-friendly schema, refreshed on a schedule. Join it with web analytics and CRM to see which ads become deals.

LinkedIn AdsConnectedAd AccountsAd AnalyticsAd Analytics by…Ad Analytics by…
Data MartPublishedone definition
Google BigQueryDateCostClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

LinkedIn Ads reports cost and leads in its own account, so the pipeline it built never shows up in Google BigQuery.

Paste this into your AI assistant. It creates a LinkedIn Ads Data Mart on your Google BigQuery storage, loads ad analytics into your own tables on a schedule, and joins spend to web analytics and CRM.

The prompt

load LinkedIn Ads ad analytics into Google BigQuery every day and build a Data Mart with cost, website conversions and CRM pipeline by campaign and month

Endpoints

S00 · Why

Why join LinkedIn Ads with your web analytics and CRM

LinkedIn Ads shows what an ad cost. It cannot show which ad led to a deal that closed a year later. For that, ad spend, website touch points and CRM deals have to sit in one data warehouse.

  • Compare spend across LinkedIn, Facebook, Google and Microsoft Ads in one table
  • Connect ad clicks and form submits to the deals they became
  • Keep the data in your own tables, not inside an ad account
LinkedIn AdsAd spend
Web analyticsClicks, form fills
CRMDeals
Your data warehouseBigQueryAdTouch pointDealJoined by idAd clickedDeal months laterOne query links the ad to the deal.

S01 · Step 1

Step 1: Connect LinkedIn Ads and pick the fields

Create a Data Mart, choose LinkedIn Ads as the data source, authorize once, open an endpoint and tick only the fields you need.

  • Five endpoints and 175 fields to choose from
  • Ad Analytics alone has 104 fields: spend, impressions, clicks, conversions, leads
New Data MartChoose a sourceFacebook AdsLinkedIn AdsGoogle AdsAuthorizeConnectedEndpointAd AnalyticsAd AccountsAd Analytics by C…Ad Analytics by C…
Ad Analytics104 fieldsdateRangeStartcostInUsdimpressionsclicksexternalWebsiteConversionsoneClickLeads

S02 · Step 2

Step 2: Load LinkedIn Ads into a BigQuery table

The dataset and table in your data storage are pre-filled, and you can change them. Run it and the first load lands in your own BigQuery project.

  • Each endpoint gets its own table, not one 300-column table
  • Every run is logged in Run History
DestinationBigQueryDatasetlinkedin_adsTablead_analyticsRun
Run HistoryPendingRunningSuccessIncremental load
Tablelinkedin_ads.ad_analytics

S03 · Step 3

Step 3: Get a business-friendly output schema

After the first run you get the output schema: every field with a readable description, not an API identifier. Your data quality checks can read it too.

  • Field descriptions come from the LinkedIn Ads documentation
  • Anyone on the team can read the table
linkedin_ads.ad_analyticsOutput schemaFieldDescriptiondateRangeStartStart date of the report data…costInUsdCost in USD based on the pivot…impressionsThis is the count of…clicksThe count of chargeable clicks…externalWebsiteConversionsTotal number of times users…oneClickLeadsThe count of leads generated…

S04 · Step 4

Step 4: Keep the LinkedIn Ads tables linked

Campaign groups, campaigns, creatives and ad analytics stay separate tables, joined by ids. Together they become one LinkedIn Ads data model.

  • LinkedIn stores links as URNs such as urn:li:sponsoredAccount:{id}; extract the id to join
  • Join the model to web analytics and CRM tables
Campaign Groupsnameaccountid
CampaignsidnamecampaignGroup
CreativesidcampaignisServing
Ad AnalyticscostInUsdpivotValues

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A daily scheduled refresh keeps the tables current, and a manual backfill loads any past period.

  • Daily runs with no pipeline to maintain
  • Backfill history the first time you connect
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same table everywhere

One table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Define the numbers once
  • Every report reads the same table
LinkedIn AdsData MartPublished
Your data model
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for LinkedIn Ads in BigQuery

Hand-built API scripts, a native transfer or a generic ETL tool each get the data in. OWOX also keeps it yours, readable and ready to model.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • A business-friendly schema. Readable field names and descriptions, not API identifiers.
  • Ready for a data model. Separate tables per endpoint, joined by ids, built to connect to web analytics and CRM.
  • Maintained for you. No scripts to fix when LinkedIn changes its API.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers