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;