LINKEDIN ADS

BIGQUERY

Connect LinkedIn Ads to BigQuery .
100% no-code.

The AI-native connector for marketers, not engineers.

✓

Prompt your queries and custom fields in natural language
✓

Auto-blend LinkedIn Ads with 20+ sources
✓

Create, preview, and publish in 15 minutes
✓

14-day free trial + free-forever plan

Book a demo

We’ll set up your first sync, free

14-day free trial

No credit card required

1,500+ marketing teams and agencies

1

Export LinkedIn Ads to BigQuery—or anywhere

Under one subscription, send LinkedIn Ads data to BigQuery, Looker Studio, Google Sheets, Slack, or Zapier. Build dashboards, reports, alerts, notifications, and AI workflows.

2

Connect multiple data sources

Select from 22 data sources: Google Ads, GA4, TikTok Ads, HubSpot, Shopify, and more. Porter maps UTMs, campaign names, and performance metrics across channels automatically. No SQL joins.

3

Consolidate multiple LinkedIn Ads accounts

Connect multiple LinkedIn profiles, select Ad Accounts for each organization. Consolidate dozens of accounts across brands, regions, or clients into one BigQuery table. Built for agencies and enterprise teams at scale.

Select multiple LinkedIn Ads accounts interface

4

Manage your data sources

Name, duplicate, delete connections, accounts, queries, and custom fields to manage multiple clients, brands, campaigns, or regions.

5

Three ways to connect to BigQuery

Google login: Sign in with Google and Porter auto-lists your BigQuery Project IDs. Select project, dataset location (US, EU, US-Central), name your dataset and table.
Service account (JSON): Upload your credentials. No Workspace admin approval needed.
New to BigQuery? Set up your first project automatically—no Google Cloud console, no billing, no technical setup. Create your report in Looker Studio directly.

6

Build your query with AI in natural language

The AI-native query builder. Describe what you need. No SQL, no complex forms.

Cross-channel fields: Select metrics and dimensions from LinkedIn Ads and any data source. No data mapping or joins needed.
Custom fields: Use AI prompts to create custom metrics (e.g., blended ROAS, cost per lead) and dimensions (e.g., brand, region, creative hook). Segment data using naming conventions from campaigns, ad sets, or ads.
Filters: Include or exclude by any field. Combine with AND/OR logic.
Date ranges: Dynamic (Month-to-date, Last quarter) or fixed (custom start and end).
Schedule: Prompt refreshes like “Every day at 5am except weekends.” Freely schedule by hour, day, week, weekday, or month.
Refresh mode: Append (add rows), Update (match and refresh), or Overwrite (replace table).
Live preview: Preview your data before syncing to BigQuery. Catch errors before they cost you.

AI query builder interface with custom fields

7

Scale data refreshes in natural language

Schedule refreshes in minutes, not hours. Real-time API data or stored BigQuery data—switch between both in the same connection. Refresh as frequently as LinkedIn’s API allows. If you hit Meta’s rate limits, Porter automatically switches to BigQuery backups. Never blocked from accessing your data.

Schedule data refreshes interface in natural language

8

Monitor every LinkedIn Ads sync to BigQuery

Track all queries in the Query Manager: name, data sources, last run at a glance. Open execution history—timestamp, success or failure. Toggle pipelines on/off anytime. Fix issues before they reach your reports, team, or clients.

Query monitoring dashboard for LinkedIn Ads syncs

Area

Other marketing ETL tools

Porter Metrics

Integrations

300+ general purpose

22 focused: Ads, CRM, Social, GA4, Commerce

Setup

Separate screens for queries, tables, joins, schemas, transfers

One flow: connect → prompt → preview → publish

Data model

Export raw datasets. Transform in BigQuery after.

Export finished queries. Connect table to report. Done.

No-code

No-code transfer, but SQL required in BigQuery to transform, join, or filter.

No-code from source to report. Zero SQL, zero BigQuery management.

Custom fields

Formula builders, functions, lookups, conditions

Prompt any metric or dimension in natural language

Data blending

SQL joins or configure data mapping

Auto-mapped: UTMs, campaign names, metrics

Scheduling

Fixed intervals. Faster rates on higher tiers.

Natural language. Any rate, any plan.

BigQuery auth

Google login or service account. Manual setup.

Google login, service account, or auto-create project

Refresh frequency

Hourly or daily depending on tier

Minutes. Real-time or storage.

Best for

Teams with devs, analysts, or ETL infrastructure

Marketers with no dev support

+500 fields

Access every LinkedIn Ads field—over 500 in total—including Spend, Conversions, Lead Gen Forms, CTR, and professional audience metrics. Plus calculated metrics like CPL, conversion rate, and cost per MQL.

See all LinkedIn Ads fields documentation

All aggregations

Track post-click and post-view conversions with platform-specific aggregations. Break down by conversion type, action count, and custom conversion events defined in your LinkedIn campaigns.

Ad previews and creatives

Porter retrieves ad creative thumbnails and sponsored content previews alongside performance data. Connect creative performance with professional audience engagement metrics.

Full granularity

Segment data by campaign, ad group, ad unit, audience demographics (job title, seniority, company), location, and time. Analyze B2B performance at any level of detail.

Conversion tracking

Access post-click and post-view conversion data. LinkedIn uses its own conversion tracking system rather than configurable attribution windows like Meta.

Marketer-friendly naming

Fields named exactly as in Ads Manager. Campaigns, ad sets, and ads are familiar to marketers. Standardized for blending with PPC platforms, GA4, and CRM data.

Unlimited historical data

Access your entire LinkedIn Ads history without limitations. Porter stores all your historical data for trends and performance analysis over any time period.

Transparent accuracy

Your data matches Ads Manager exactly. Porter doesn’t manipulate or transform your data—what you see is exactly what Meta reports.

Revenue

Total Spend

ROAS

Cost per Result

Budget

Bid

Revenue

Estimated Total

Conversions

Post-Click Conv

Post-View Conv

Conv. Rate

Cost per Conv

Lead Forms

Form Opens

Engagement

Clicks

CTR

Viral Clicks

Social Likes

Comments

Shares

Follows

Visibility

Impressions

Reach

CPM

Viral Impressions

Average Frequency

Viewability

Audience Reach %

Campaign

Campaign Name

Campaign ID

Objective

Status

Ad Unit

Creative

Ad Name

Creative ID

Title

Description

Image URL

Destination URL

Creative Type

Audience

Job Title

Seniority

Company Name

Industry

Location

Age

Gender

Time

Date

Start Date

End Date

Week

Month

Quarter

Year

Custom

UET Tag

Page ID

Account ID

Pivot

Partner ID

Creative Status

External Reference

See all fields

Complete field documentation

Faster Looker Studio reports

Direct connectors take 10+ seconds to load, time out, and break. BigQuery loads in 2 seconds, every time. No more broken dashboards before client calls.

Data blending

Combine LinkedIn Ads with CRM, GA4, Shopify, Google Ads in one warehouse. Measure real profit, not platform ROAS. Calculate blended CAC across all channels.

Connect BigQuery to any BI tool

Connect to Looker Studio for instant dashboards. Or plug into Power BI, Tableau, any BI tool. Unlock multi-touch attribution with raw GA4 data.

Multi-touch attribution

Join LinkedIn Ads with raw GA4 event data. Trace the full user path from ad click to conversion.

Source of truth

Define what “conversion” means for your company. Compare Meta vs. GA4 vs. HubSpot. Pick one source for CAC, ROAS, and CPA. End the “which number is right” debate.

Company-wide access without platform permissions

Managing permissions across platforms is a pain. With BigQuery, anyone can access marketing data without accounts or roles in each platform. One permission model, all data.

Make data available for AI

AI needs clean, structured data with context. Every AI tool feels siloed. Integrating sources is complicated. With BigQuery as your universal warehouse, any AI tool can access your marketing data. No custom integrations. No complicated setup.

Scale across accounts, clients, and brands

Reports break when you connect too many accounts. BigQuery has no limits. Agencies with dozens of clients, franchises with dozens of LinkedIn Ads accounts, chains with multiple brands and locations—consolidate everything into one table. One report, one connection.

LinkedIn Ads creative dashboard

Get this template for free

Custom

Google Sheets

Ads

Social Media

CRM

E-Commerce

SEO

Web Analytics

Google Analytics 4

Frequently Asked Questions

How does the free trial work? +

Full proof of concept. Includes tool access, support, and migration assistance. No day limit—ends when you validate Porter meets your needs.

How much does Porter cost? +

Start with a 14-day free trial with full access. Free-forever plan available: up to 3 ad accounts, unlimited reports, 30-day historical data. For larger implementations, pricing starts at $500-$1,000/month based on support needed. Get a quote on a call.

Can I cancel anytime? +

Yes. Monthly or annual billing (2 months free with annual). Cancel anytime, no paperwork, immediate cancellation.

How much does BigQuery cost? +

Most clients operate within Google’s free tier. High-volume clients: $20-$30/month. See Google BigQuery pricing for details.

Can I use my own BigQuery or does Porter manage it? +

Both. Use your own project or Porter manages one for you. Your data is always yours.

How fresh is the data? +

Automatic refresh every 12 hours by default. Configurable to hours or minutes depending on LinkedIn’s API limits. Direct API access available for real-time data.

Are there limits on rows, queries, or accounts? +

Porter has no limits. Limits depend on BigQuery and Meta.

Do you help migrate from another provider? +

Yes. 100% assisted migration by implementation and development team. Typical time: within the same week.

What support is included? +

Direct Slack access to support team, developers, and founders. Chat, scheduled video calls, email. Response in minutes or hours (Americas timezone).

How do you handle security? +

Google-only login (OAuth 2.0). No passwords stored. Data goes directly to your BigQuery.

Google-only login (OAuth 2.0). No passwords to create or store.
Your existing Google security applies: 2FA, suspicious login detection, session management.
One identity for BigQuery, Looker Studio, Sheets, and Porter.

Ready to connect LinkedIn Ads to BigQuery?

We’ll set up your first sync, free

14 days, no credit card required

Connect LinkedIn Ads to BigQuery . 100% no-code.

How It Works

Export LinkedIn Ads to BigQuery—or anywhere

Connect multiple data sources

Consolidate multiple LinkedIn Ads accounts

Manage your data sources

Three ways to connect to BigQuery

Build your query with AI in natural language

Scale data refreshes in natural language

Monitor every LinkedIn Ads sync to BigQuery

Why Marketers Choose Porter

What LinkedIn Ads Data Can You Export

+500 fields

All aggregations

Ad previews and creatives

Full granularity

Conversion tracking

Marketer-friendly naming

Unlimited historical data

Transparent accuracy

Revenue

Conversions

Engagement

Visibility

Campaign

Creative

Audience

Time

Custom

Why Marketers Move LinkedIn Ads Data to BigQuery

Faster Looker Studio reports

Data blending

Connect BigQuery to any BI tool

Multi-touch attribution

Source of truth

Company-wide access without platform permissions

Make data available for AI

Scale across accounts, clients, and brands

LinkedIn Ads Templates for BigQuery + Looker Studio

LinkedIn Ads creative dashboard

Integrations

Custom

Ads

Social Media

CRM

E-Commerce

SEO

Web Analytics

Testimonials

Frequently Asked Questions

Security

Ready to connect LinkedIn Ads to BigQuery?

Connect LinkedIn Ads to BigQuery .
100% no-code.