--- title: "linkedin_ad_metrics" slug: "linkedin-ad-metrics" updated: 2026-09-17T06:32:20Z published: 2026-09-17T06:33:10Z canonical: "documents.revsure.ai/linkedin-ad-metrics" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revsure.ai/llms.txt > Use this file to discover all available pages before exploring further. # linkedin_ad_metrics **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](http://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 |