Most LinkedIn Ads dashboards answer the wrong question. They show impressions, clicks, and spend by campaign, which is useful for the paid media manager but useless in a pipeline review. The CFO wants to know whether the money came back, how fast, and whether the channel deserves more budget next quarter. That gap between platform metrics and board-grade insight is where reporting breaks down.
The fix is not more dashboards. It is a reporting structure that connects ad spend to conversions by type, tracks efficiency over time, and surfaces the data in a format finance can interrogate. Supermetrics' LinkedIn Ads report building guide lays out the query configurations that make this possible. What follows is how to turn those configurations into reports that survive a forecast meeting.
The Baseline: Spend and Conversions on the Same Axis
The first query any LinkedIn Ads report needs is a 28-day time series showing total spend alongside conversions, split by date. This is not a vanity chart. It answers a specific question: are spend and conversion volume moving together, or is efficiency degrading?
According to Supermetrics' documentation, the "Total spent" metric reflects campaign cost in the currency of your advertising account, while "Conversions" counts pixel-load events. Plotting both on a combo chart reveals whether incremental spend is producing incremental results or just inflating cost per acquisition.
The trap here is treating this chart as a performance scorecard. It is not. It is a diagnostic. If spend rises and conversions flatten, you have an efficiency problem. If both rise in lockstep, you have a scaling opportunity. If conversions rise while spend holds, you have a channel that deserves reallocation from weaker performers. The chart does not tell you what to do; it tells you where to look next.
One operational note: ad spend comes through in the currency of your LinkedIn Ads account. If your finance team reports in a different currency, Supermetrics supports currency conversion in Google Sheets and Looker Studio. Do this conversion before the data hits your dashboard, not after. Inconsistent currency handling is the fastest way to lose credibility in a cross-functional review.
Conversion Type Breakdown: Where the Pipeline Actually Comes From
Aggregate conversion counts hide more than they reveal. A campaign generating 200 conversions sounds strong until you learn that 180 of them are content downloads and 20 are demo requests. The math on those two conversion types is completely different.
The year-to-date conversion breakdown by type, as outlined in the Supermetrics guide, splits conversions by the action that triggered them. This is where you start to see whether your LinkedIn investment is generating top-of-funnel awareness or actual pipeline.
For B2B companies with long sales cycles, this distinction matters more than total conversion volume. A demo request from a director-level buyer at a target account is worth more than fifty whitepaper downloads from students. Your reporting should reflect that hierarchy. If your conversion tracking does not distinguish between these actions, fix the tracking before you build the dashboard.
The practical application: use this breakdown to calculate cost per conversion by type, then map those costs against downstream conversion rates from your CRM. If demo requests cost three times as much as content downloads but convert to pipeline at ten times the rate, the higher cost per conversion is actually the more efficient spend.
Campaign-Level Granularity: Clicks, Impressions, Leads, and Spend
The table view showing clicks, impressions, leads, and spend by campaign is where optimization decisions happen. Windsor.ai's parallel guide recommends this configuration for weekly performance reviews, and the logic is sound: you need campaign-level data to reallocate budget, pause underperformers, and scale winners.
The "Leads" metric here specifically counts One Click Lead Gen form submissions, which is LinkedIn's native lead capture format. If you are running lead gen campaigns, this metric is your primary output. If you are running traffic or awareness campaigns, leads will be zero and you should focus on reach and frequency instead.
One pattern I see repeatedly: teams build campaign-level tables but never act on them. The table becomes a reporting artifact rather than a decision tool. To fix this, add a column for cost per lead and sort descending. The campaigns at the top of that list are your reallocation candidates. The campaigns at the bottom are your scaling opportunities. If you are not making at least one budget change per week based on this table, you are reporting without operating.
Reach as a Sanity Check
Reach metrics are often dismissed as vanity, but they serve a specific diagnostic purpose. The reach query shows approximate unique users exposed to your campaigns, which you can compare against impressions to calculate frequency.
High frequency against a small reach pool means you are saturating your audience. This is common in ABM campaigns with tight targeting, and it is not necessarily bad, but it does mean incremental spend will hit diminishing returns. Low frequency against a large reach pool means you are spreading budget too thin to build awareness. Neither pattern is visible from impressions alone.
Connecting LinkedIn Data to the Rest of Your Stack
The real value of a tool like Supermetrics is not the LinkedIn connector in isolation. It is the ability to pull LinkedIn data alongside Google Ads, Meta, and CRM data into a single reporting environment. LinkedIn's marketing partner page for Supermetrics highlights cross-channel reporting as a primary use case, and this is where the CFO-grade insight actually emerges.
When you can show cost per opportunity by channel, with LinkedIn alongside paid search and organic, you have a conversation about portfolio allocation rather than platform performance. That is the conversation that gets budget approved.
Supermetrics' Looker Studio integration supports blending LinkedIn Ads data with HubSpot or Salesforce pipeline metrics. This is not a nice-to-have. It is the difference between reporting on marketing activity and reporting on marketing contribution to revenue.
The Two-Week Pilot
If you are building LinkedIn Ads reporting from scratch, start with three queries: the 28-day spend-to-conversion time series, the year-to-date conversion breakdown by type, and the weekly campaign-level table with cost per lead. Run these for two weeks before adding complexity.
The goal is not a comprehensive dashboard. The goal is a reporting cadence that surfaces one actionable insight per week. If your reports are not changing decisions, they are not reports. They are decoration.
