Skip to main content

LinkedIn Ads API Connector

Updated this week
Download LinkedIn Logo in SVG Vector or PNG File Format - Logo.wine

Overview

The LinkedIn Ads API provides programmatic access to campaign management, creative performance, audience targeting, and reporting metrics across LinkedIn advertising campaigns. It supports sponsored content, text ads, dynamic ads, message ads, and video ads, allowing marketers to integrate LinkedIn data into dashboards, BI tools, and optimisation workflows.

This connector focuses on paid LinkedIn advertising performance, targeting, and creative-level insights.

Data handled by the integration:

Account & Campaign Data

  • LinkedIn Ads accounts (organization ID, account ID)

  • Campaign groups and campaigns

  • Objectives (awareness, consideration, conversions)

  • Budget, bid, and pacing configurations

  • Campaign status (active, paused, completed)

Ad Group & Creative Data

  • Ad groups (if used)

  • Ads / creatives metadata

    • Ad type (single image, video, carousel, text, message)

    • Creative ID, name, and approval status

    • URLs, media assets, call-to-action

    • Associated campaigns and ad groups

Performance Metrics

  • Impressions, clicks, CTR

  • Cost, CPC, CPM, spend

  • Conversions & conversion value

  • Engagement metrics (likes, shares, comments, video views)

  • Follower metrics (for sponsored content promoting company pages)

Audience & Targeting

  • Demographics: age, gender, location, job title, company size, industry

  • Company followers / audience segments

  • Matched audiences (first-party lists, website retargeting)

  • Interest and behaviour targeting

Metadata & Reference Tables

  • Account & campaign hierarchy

  • Objective and ad format definitions

  • Geographic and demographic mappings

  • Engagement types and conversion actions

Granularity:

This integration retrieves data at: Account, Campaign, Ad group, Demographic, Geographic and Device level breakdown.

Purpose:

  • Monitor LinkedIn ad campaign performance

  • Analyse creative-level and campaign-level metrics

  • Optimise targeting and bidding strategies

  • Track conversions and ROI

  • Build dashboards combining LinkedIn Ads with other media channels

  • Conduct historical performance audits

  • Understand audience engagement and demographic trends

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

For more information on this integration, please follow the link here.

Feed Details

Key

Value

Feed

linkedin

Status

1 (active)

Job Label

LinkedIn - Data Import, LinkedIn Ads - Meta Refresh

Lookback

5 days (Data Import), 1 day (Meta Refresh)

First Run

03:00 (Data Import), 01:00 (Meta Refresh)

Frequency

24h

Lookback Window

0

Jobs

LinkedIn - Data Import

Field

Value

Type

data

Table

linkedinads_data_aggregate

Description

LinkedIn Ads - Delivery Data

Update Mode

append

Create Target

true

Date Column

bright_custom_date

LinkedIn - Conversion Data

Field

Value

Type

data

Table

linkedinads_data_conversions

Description

LinkedIn Ads - Conversion Data

Update Mode

append

Create Target

true

Date Column

bright_custom_date

Options:

  • pivot (hidden): ACCOUNT,CAMPAIGN,CAMPAIGN_GROUP,CREATIVE,CONVERSION

LinkedIn Ads - Meta Refresh

Field

Value

Type

lookup (4 tables)

Tables

linkedinads_meta_account

linkedinads_meta_campaign

linkedinads_meta_campaigngroup

linkedinads_meta_creative

Update Mode

refresh

Create Target

true

Connection Configuration

Key

Type

Description

linkedin_account_ids

text

Comma-delimited list of account IDs

Dimensions

Name

Source Field

Account [LI]

linkedinads_meta_account.name

Campaign [LI]

linkedinads_meta_campaign.name

Campaign Group [LI]

linkedinads_meta_campaigngroup.name

Creative [LI]

linkedinads_meta_creative.inmail_name

Base Metrics

Name

Formula

Spend [LI]

SUM({linkedinads_data_aggregate.costInLocalCurrency})

Impressions [LI]

SUM({linkedinads_data_aggregate.impressions})

Clicks [LI]

SUM({linkedinads_data_aggregate.clicks})

Likes [LI]

SUM({linkedinads_data_aggregate.likes})

Follows [LI]

SUM({linkedinads_data_aggregate.follows})

Comments [LI]

SUM({linkedinads_data_aggregate.comments})

Comments Likes [LI]

SUM({linkedinads_data_aggregate.commentLikes})

Reactions [LI]

SUM({linkedinads_data_aggregate.reactions})

Shares [LI]

SUM({linkedinads_data_aggregate.shares})

Sends [LI]

SUM({linkedinads_data_aggregate.sends})

Opens [LI]

SUM({linkedinads_data_aggregate.opens})

Landing Page Clicks [LI]

SUM({linkedinads_data_aggregate.landingPageClicks})

Total Engagements [LI]

SUM({linkedinads_data_aggregate.totalEngagements})

Leads [LI]

SUM({linkedinads_data_aggregate.oneClickLeads})

Video Views Quartile - 25% [LI]

SUM({linkedinads_data_aggregate.videoFirstQuartileCompletions})

Video Views Quartile - 50% [LI]

SUM({linkedinads_data_aggregate.videoMidpointCompletions})

Video Views Quartile - 75% [LI]

SUM({linkedinads_data_aggregate.videoThirdQuartileCompletions})

Video Completes [LI]

SUM({linkedinads_data_aggregate.videoCompletions})

Video Views [LI]

SUM({linkedinads_data_aggregate.videoViews})

Conversions [LI]

SUM({linkedinads_data_conversions.externalWebsiteConversions})

Composite Metrics

Name

Formula

CTR [LI]

({Clicks [LI]}/{Impressions [LI]})*100

CPC [LI]

{Spend [LI]} / {Clicks [LI]}

VTR [LI]

({Video Completes [LI]} / {Impressions [LI]}) * 100

VCR [LI]

({Video Completes [LI]} / {Video Views [LI]}) * 100

CPV [LI]

{Spend [LI]} / {Video Views [LI]}

CPCV [LI]

{Spend [LI]} / {Video Completes [LI]}

Data Source Joins

For linkedinads_data_aggregate and linkedinads_data_conversions:

LHS Field

RHS Field

bright_custom_account_id

linkedinads_meta_account.id

bright_custom_campaigngroup_id

linkedinads_meta_campaigngroup.id

bright_custom_campaign_id

linkedinads_meta_campaign.id

bright_custom_creative_id

linkedinads_meta_creative.id

Did this answer your question?