LinkedIn Ads API Connector

📝 Summary

The LinkedIn Ads Data Feed pulls delivery, conversion, and metadata from the LinkedIn Ads API. It consists of two main jobs:

Data Import – delivers core performance and conversion data.
Meta Refresh – keeps entity metadata (accounts, campaigns, creatives) up-to-date.

This data is processed daily with a 5-day lookback for performance and a 1-day lookback for metadata. Metrics are aggregated with support for calculated KPIs (CTR, CPC, VTR, etc.). Metadata joins are applied via bright_custom_* fields to enrich reporting.

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

1. 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`

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

3. 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`