linkedin_ad_metrics contains daily performance metrics for individual LinkedIn Ads, providing detailed visibility into campaign groups, campaigns, and creatives. The table includes spend, impressions, clicks, engagement metrics, conversions, and return-on-ad-spend (ROAS), enabling comprehensive analysis of LinkedIn advertising performance and audience engagement. It supports campaign optimization, budget tracking, and measurement of marketing effectiveness across LinkedIn ad programs.
Table | linkedin_ad_metrics |
Description | Contains ad-level daily metrics for LinkedIn campaigns |
Granularity (Composite key that uniquely identifies a row) | ad_id, campaign_id, date |
Column Details:
Column Name | Description | Data Type |
date | Date for which the ad metrics correspond to | DATE |
account_name | Name of the LinkedIn Ads account (connection name from Firestore) | STRING |
currency | Currency code for cost values (e.g. USD) | STRING |
campaign_group_id | Campaign Group ID as found in LinkedIn | STRING |
campaign_group_name | Campaign Group Name as found in LinkedIn | STRING |
campaign_group_status | Campaign Group Status (e.g. ACTIVE, PAUSED) | STRING |
campaign_group_start_date | Start date of the campaign group | DATE |
campaign_group_end_date | End date of the campaign group | DATE |
campaign_group_total_budget | Total budget set for the campaign group. Standardized to reporting currency | NUMERIC |
campaign_id | Campaign ID as found in the source system | STRING |
campaign_name | Campaign Name as found in the source system | STRING |
campaign_objective | Campaign Objective (e.g. LEAD_GENERATION, BRAND_AWARENESS) | STRING |
campaign_type | Campaign Type (e.g. DYNAMIC, SPONSORED_UPDATES) | STRING |
campaign_status | Campaign Status (e.g. ACTIVE, PAUSED) | STRING |
cost_type | Cost type for the campaign (e.g. CPM, CPC) | STRING |
daily_budget | Daily budget set for the campaign. Standardized to reporting currency | NUMERIC |
total_budget | Total/lifetime budget set for the campaign. Standardized to reporting currency | NUMERIC |
campaign_start_date | Start date of the campaign | DATE |
campaign_end_date | End date of the campaign | DATE |
creative_name | Creative/post name from LinkedIn (posts.name) | STRING |
ad_id | Ad/Creative ID as found in the source system | STRING |
creative_status | Creative Status (e.g. ACTIVE, PAUSED) | STRING |
ad_headline | Ad headline text (from adContext.dscName). May be NULL on some records | STRING |
dsc_name | Direct Sponsored Content name (from adContext.dscName). May be NULL on some records | STRING |
total_spent | Amount spent on the ad for the date. Standardized to reporting currency (USD) | NUMERIC |
impressions | Number of ad impressions for the date | NUMERIC |
clicks | Number of ad clicks for the date | NUMERIC |
click_through_rate | Ratio of clicks to impressions (clicks / impressions) | FLOAT |
average_cpm | Average cost per 1000 impressions (total_spent / impressions * 1000) | FLOAT |
average_cpc | Average cost per click (total_spent / clicks) | FLOAT |
reactions | Number of reactions (likes) on the ad for the date | NUMERIC |
comments | Number of comments on the ad for the date | NUMERIC |
shares | Number of shares of the ad for the date | NUMERIC |
follows | Number of follows generated by the ad for the date | NUMERIC |
total_engagements | Total engagements on the ad (clicks + reactions + comments + shares + follows) | NUMERIC |
sends | Number of InMail/message sends for the date (Sponsored Messaging) | NUMERIC |
opens | Number of InMail/message opens for the date (Sponsored Messaging) | NUMERIC |
conversions | Number of conversions attributed to the ad for the date | NUMERIC |
post_click_conversions | Number of post-click conversions for the date | NUMERIC |
view_through_conversions | Number of view-through conversions for the date | NUMERIC |
conversion_rate | Ratio of conversions to clicks (conversions / clicks) | FLOAT |
cost_per_conversion | Average cost per conversion (total_spent / conversions) | FLOAT |
total_conversion_value | Total monetary value of conversions in local currency | NUMERIC |
return_on_ad_spend | Return on ad spend (total_conversion_value / total_spent) | FLOAT |
created_at | Time at which the record was created in UTC | TIMESTAMP |
updated_at | Time at which the record was last updated UTC | TIMESTAMP |