What a LinkedIn report has to join
The LinkedIn for B2B hub sets the rules this report puts into practice: the CRM is the source of truthThe system whose figure is treated as authoritative for a given number, such as billing for revenue or the CRM for pipeline, with other tools reconciled to it. and the LinkedIn figures are inputs to it; lag must be allowed for, because a lead captured this month becomes an opportunity later; and attribution needs care, because LinkedIn's reporting credits conversions under its own attribution settings and sees only the touches it delivered. Research from LinkedIn's B2B Institute, cited in the sources, makes the point the B2B guides on this site build on: most buyers in a category are not in market at any moment, so the effect of reaching them shows up later. A monthly report that ignores this judges reach on a window too short to see its result.
The figures sit in separate places, each described by an existing guide.
| Source | What it shows | Where this site explains it |
|---|---|---|
| Company page analytics | Visitors, followers, content and competitor views | Company pages guide |
| Post and profile analytics | Impressions, reactions, comments, reposts and who engaged, for each person who posts | Personal branding guide |
| Campaign Manager | Spend, delivery, clicks, leads and conversions by campaign group, campaign and ad | LinkedIn Ads hub |
| Company engagement report | Engagement level and source for each target account | ABM guide |
| Revenue attribution report | Campaigns matched to CRM opportunities, where the CRM connection is set up | ABM guide |
| Web analytics | Sessions and on-site actions from tagged LinkedIn links | Platform and analytics discrepancies |
| The CRM | Leads, their stages, opportunities and revenue | B2B measurement |
The organic side is reported across platforms in the social media reporting guide, and the whole-marketing pack in the monthly marketing report template; this tutorial builds the LinkedIn section that feeds both. The monthly TikTok report does the same job for another platform, and readers running both can keep the two workbooks in the same shape.
Before you start
- The Insight Tag and conversions set up and recorded, as the Insight Tag and conversions tutorial describes, with a register of each conversion's definition and attribution settings.
- Access to page analytics, Campaign Manager reporting, web analytics and CRM reports, or named people who can export each.
- A CRM field that records LinkedIn as a lead's source, including leads from Lead Gen Forms, with the campaign where it is known.
- Tagged links: every LinkedIn link to the site carries UTMURL tags identifying traffic source. parameters under a written convention.
- An enquiry log or a "how did you hear about us" field, so conversations that start on LinkedIn without a click are recorded.
- The target account list, if the business runs an account-based programme.
- A workbook with a tab for each source and one for the summary, kept where the business controls it.
The steps
Write the questions the report answers
Start from the readers, not the data. A leadership team usually wants to know whether LinkedIn is producing pipeline, whether the money is going to the campaigns that produce it, whether the right people are paying attention and what will change. Write those questions at the top of the workbook, with the single KPIA metric tied directly to an objective. the channel is judged on, such as cost per accepted lead in the first months and cost per opportunity once sales cycles complete, as the B2B hub suggests. Everything later in the report should answer one of the questions or explain a movement in the KPI; a figure that does neither is a Vanity MetricsMetrics that look impressive but do not inform a decision or track a business outcome. candidate and stays out of the summary.
Fix the period, the conversion settings and the owner of each figure
Use the calendar month, and pull every source for the same dates. Record the conversion definitions and attribution settings in force, from the conversion register, and note any change made during the month, because a changed window or a new conversion breaks the comparison with earlier months. Name the owner of each figure: who exports the page analytics, who exports Campaign Manager, who runs the CRM report and who writes the commentary. The monthly reporting pack SOP sets out the pull, reconciliation, review and archive in order for the whole pack.
Pull page analytics for visitors, followers and content
From the company page's analytics, pull the views the company pages guide describes: visitor demographics, follower gains and their source, and the content view with each post's impressions, clicks, reactions, comments and reposts. Read the demographics against the target: whether visitors and new followers are in the job functions, seniority and industries the business sells to. Group posts by theme, so the report can say which themes drew the right people, rather than listing every post. The competitors view is context, not a target.
Pull the people's posts and the enquiry log
On LinkedIn much of the attention a B2B business earns comes through its people. Ask each person who posts for the business for their post analytics for the month, as the personal branding guide describes them, including the demographics of who engaged, and add the entries from the enquiry log: inbound messages, meetings booked and enquiries where the person named LinkedIn or a named post. The self-reported attribution guide explains how to code those answers consistently. Keep people's figures separate from the page's, because they describe different audiences.
Pull Campaign Manager by group, campaign and ad
Export Campaign Manager for the month at each level of the account: campaign groups for the plan's chapters, campaigns for each stage and audience, and ads for creative. Include spend, impressions, clicks, leads from forms and website conversions under the recorded settings. If the account follows a naming convention, as the guide to structuring a LinkedIn Ads account recommends, the export can be grouped by stage, market or offer without retyping. Run the monthly paid media review checklist beside this step, so tracking health, pacing and spend are checked before anyone interprets the results. If the same weaknesses keep appearing month after month, score the whole account with the LinkedIn Ads account audit scorecard and work its ranked fix list.
Add analytics sessions from tagged links
From web analytics, pull sessions and on-site actions for LinkedIn traffic, split by the campaign and content values in the tags, and put organic and paid on separate lines. Expect these figures to differ from Campaign Manager's clicks and conversions; the guide to why platforms and analytics disagree explains the counting units, attribution and consent differences, and the report should state the difference rather than force the numbers to match. Sessions show what LinkedIn visitors did on the site, which the platform cannot see.
Join leads to their CRM stages
This is the step that turns platform activity into pipeline. From the CRM, pull every lead whose source is LinkedIn, with its campaign, the date it arrived and its current stage: accepted as a Sales-Qualified LeadA lead that sales has reviewed and accepted as a genuine opportunity to pursue. or at the stage the business uses, opportunity, won or lost. Count each lead once, by the CRM's record, and never add the platform's conversion total to it. Where the CRM connection is set up, the revenue attribution report the ABM guide describes can sit beside this as a second view, but the CRM's own report is the figure of record. Calculate cost per accepted lead and cost per opportunity from LinkedIn spend and these counts with the CPA calculator. When Campaign Manager shows many more conversions than the CRM, the diagnosis page for LinkedIn conversions higher than the CRM separates the causes before the report explains the gap.
Read engagement for the target account list
If the business runs an account-based programme, add the company engagement report: each target account's engagement level and whether it came from ads or organic activity, as the ABM guide describes. Report coverage and movement, how many accounts were reached and how many moved up an engagement level or a pipeline stage, rather than the totals for the whole audience. Put the accounts that moved beside the CRM's view of them, so sales can see where engagement is turning into conversations and where it is not. The share of opportunities that are Marketing-Sourced PipelineValue of sales opportunities whose original source was a marketing activity. from list accounts belongs here too, labelled with the attribution rule used.
Compare against the account's own months
Compare the month with earlier months of the same account, not with rates from elsewhere. Align the comparison as the guide to comparing periods explains, with working days, holidays, partial periods and tracking changes noted. Allow for Conversion LagThe time between an ad interaction and the conversion it leads to, which leaves the most recent reporting days incomplete.: recent months will gain opportunities as leads mature, so mark them as incomplete, compare each with earlier months at the same age and restate them next month. Where counts are small, as opportunities usually are, quote the count beside every rate and read the movement as a range, as the guide to reading small numbers advises.
Write what happened, why it matters and what changes
Close with the what, so what, now what framework. What happened: the few movements that matter, stated plainly with their counts. So what: what each means for pipeline, using the CRM's figures and the lag allowance. Now what: the decisions for next month, each with an owner and the figure the next report will use to judge it. Keep the close short enough to read in a meeting; the tabs hold the detail for anyone who wants it.
Keep the workbook for next month
Save the month's workbook with its exports, the conversion register as it stood, the change logA dated record of changes made to tracking, accounts, reports, lists or rules, with who made each and why, so later movements in the figures can be traced. and the commentary, and copy the structure forward. Next month starts by restating the maturing months with the CRM's new counts and checking whether last month's decisions were carried out. Over a year the workbook becomes the account's own history, which is the only fair baseline the report has.
The report on a page
The summary a leadership team reads fits on one page. The tabs behind it hold every export.
| Section | What it shows | Source |
|---|---|---|
| The questions and the KPI | What the report answers and the measure the channel is judged on | Written once, reviewed quarterly |
| Pipeline | Leads from LinkedIn, accepted leads, opportunities and their value, cost per accepted lead and per opportunity, with recent months marked incomplete | The CRM and Campaign Manager spend |
| Paid performance | Spend and results by campaign group and the campaigns that moved most | Campaign Manager |
| Organic and people | Which themes and which people drew engagement from target roles; enquiries naming LinkedIn | Page and post analytics, enquiry log |
| Target accounts | Coverage and accounts that moved up a level or a stage | Company engagement report and the CRM |
| Site behaviour | Sessions and on-site actions from LinkedIn, organic and paid | Web analytics |
| Decisions | What changes, who owns it and how the next report will judge it | The commentary |
A laundry equipment supplier's month (illustrative)
Brontavik Laundry Systems reports March to its leadership team
Brontavik Laundry Systems, an invented supplier of commercial laundry equipment to hotels, care homes and hospitals, reports its LinkedIn month to the directors. The KPI is cost per opportunity, with cost per accepted lead as the early measure.
| Measure | March | Average of the previous three months |
|---|---|---|
| Page followers gained | 38 | 41 |
| Comments from facilities and operations roles on the two engineers' posts | 64 | 29 |
| Campaign Manager spend | £6,200 | £5,900 |
| Leads from LinkedIn in the CRM | 47 | 44 |
| Accepted by sales | 19 | 15 |
| Opportunities so far | 3 (incomplete: March leads are still maturing) | 7 |
| Cost per accepted lead | £326 | £393 |
| Target accounts moving up an engagement level | 22 of 300 | 14 of 300 |
Page followers are flat, while the two service engineers' posts on machine downtime drew more than twice the usual comments from target roles. Campaign Manager shows 71 conversions against 47 leads in the CRM, so the report uses the CRM's count and refers the gap to the conversion register. March's opportunities are marked incomplete; the January cohort, now old enough to compare, has produced 9.
The report closes with three decisions. The marketing manager will turn the engineers' downtime posts into thought leader ads for the care home campaign. The sales director will have the 22 accounts that moved called within two weeks. The agency will move a fifth of the awareness budget to the hospital audience, judged on accepted leads in the May report.
Common mistakes
- Reporting what is easy to export. Impressions and followers lead the report because they are first on the screen, not because anyone decides anything from them.
- Adding Campaign Manager conversions to CRM leads. The two count overlapping things under different rules; the CRM is the figure of record.
- Judging the latest month on unfinished counts. Opportunities lag leads; mark recent months as incomplete and restate them.
- Comparing with rates from elsewhere. The account's own months are the only fair baseline.
- Leaving people out. On LinkedIn, the posts of the people who speak for the business are often where the right attention comes from.
- Changing conversion settings without a note. The comparison with earlier months breaks silently.
- Rates without counts. A rate built on a handful of opportunities moves a lot and means little on its own.
- No decisions, or decisions with no owner. The report exists to change what happens next month.
