Lucen

LinkedIn Ads data reference

Advertising
1 table
52 columns

Lucen syncs your LinkedIn Ads data (Advertising) to your warehouse and models it into the tables below. You connect LinkedIn Ads with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.

Your plan sets how much history the first sync loads, see pricing.

Send LinkedIn Ads data to

Tables

gold_linkedin_ads_performance

Grain
campaign (or served pivot) / day
Use for
The pack's LinkedIn delivery fact

Columns

Column names match your warehouse exactly. Descriptions come from dbt.

gold_linkedin_ads_performance columns

52

Typical questions

Prompt to try
Campaign spend / CTR

gold_linkedin_ads_performance

Starter queries

sql
SELECT date, campaign_id, campaign_name, status, campaign_status
FROM `your-project.your_org_gold.gold_linkedin_ads_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;

Integration page