Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

LinkedIn Marketing › LinkedIn for B2B

Building a Monthly LinkedIn Report

A step-by-step monthly LinkedIn report joining page and post analytics, Campaign Manager and the CRM, allowing for lag and ending in decisions with owners.
Tutorialintermediate10 min readUpdated

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 truth 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.

SourceWhat it showsWhere this site explains it
Company page analyticsVisitors, followers, content and competitor viewsCompany pages guide
Post and profile analyticsImpressions, reactions, comments, reposts and who engaged, for each person who postsPersonal branding guide
Campaign ManagerSpend, delivery, clicks, leads and conversions by campaign group, campaign and adLinkedIn Ads hub
Company engagement reportEngagement level and source for each target accountABM guide
Revenue attribution reportCampaigns matched to CRM opportunities, where the CRM connection is set upABM guide
Web analyticsSessions and on-site actions from tagged LinkedIn linksPlatform and analytics discrepancies
The CRMLeads, their stages, opportunities and revenueB2B 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 UTM 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

  1. 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 KPI 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 Metrics candidate and stays out of the summary.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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 Lead 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.

  8. 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 Pipeline from list accounts belongs here too, labelled with the attribution rule used.

  9. 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 Lag: 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.

  10. 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.

  11. Keep the workbook for next month

    Save the month's workbook with its exports, the conversion register as it stood, the change log 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.

SectionWhat it showsSource
The questions and the KPIWhat the report answers and the measure the channel is judged onWritten once, reviewed quarterly
PipelineLeads from LinkedIn, accepted leads, opportunities and their value, cost per accepted lead and per opportunity, with recent months marked incompleteThe CRM and Campaign Manager spend
Paid performanceSpend and results by campaign group and the campaigns that moved mostCampaign Manager
Organic and peopleWhich themes and which people drew engagement from target roles; enquiries naming LinkedInPage and post analytics, enquiry log
Target accountsCoverage and accounts that moved up a level or a stageCompany engagement report and the CRM
Site behaviourSessions and on-site actions from LinkedIn, organic and paidWeb analytics
DecisionsWhat changes, who owns it and how the next report will judge itThe commentary

A laundry equipment supplier's month (illustrative)

Illustrative example — not a real result

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.

MeasureMarchAverage of the previous three months
Page followers gained3841
Comments from facilities and operations roles on the two engineers' posts6429
Campaign Manager spend£6,200£5,900
Leads from LinkedIn in the CRM4744
Accepted by sales1915
Opportunities so far3 (incomplete: March leads are still maturing)7
Cost per accepted lead£326£393
Target accounts moving up an engagement level22 of 30014 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.

Frequently asked questions

Should a monthly LinkedIn report use Campaign Manager's conversions or the CRM's figures?

Both, for different questions. The CRM answers how many leads the business received from LinkedIn and what they became: accepted leads, opportunities and revenue. Campaign Manager answers which campaigns, audiences and ads did better than one another, using its own attribution settings. Cost per accepted lead and cost per opportunity are calculated from LinkedIn spend and the CRM's counts, and the platform's conversion total is never added to the CRM's.

Why does last month's cost per opportunity always look bad?

Because opportunities arrive after the leads that produce them. A lead captured this month may become an opportunity weeks or months later, so the most recent months always show fewer opportunities than they will eventually have. Mark recent months as incomplete, compare each month with earlier months at the same age, and restate the figures as they mature rather than judging the latest month on an unfinished count.

What should a monthly LinkedIn report end with?

Decisions with owners. After stating what happened and why it matters, the report should name what changes next month, who will do it and how the next report will show whether it worked. A report that ends with figures and no decisions trains its readers to skim it, and a decision with no owner is rarely carried out.

Terms used on this page

Tools to try

Frameworks

Where this page is used

Also related

Sources

  1. LinkedIn Marketing Solutions Help — LinkedIn
  2. LinkedIn Pages — LinkedIn Marketing Solutions
  3. The B2B Institute — LinkedIn

Related