Overview
Use this guide to build a dependable LinkedIn analytics report that stakeholders will actually use to make decisions. It covers a copyable field layout, exact KPI formulas, export steps from LinkedIn interfaces, a decision framework for choosing your reporting stack, and governance practices to prevent template drift.
Whether you report on LinkedIn Page performance, LinkedIn Ads, or both, each section is actionable. You do not need a paid connector or a data engineering background.
Platform details such as data retention windows and exact metric definitions can change. Verify the current state in the LinkedIn Help Center or the LinkedIn Marketing Developer Platform docs.
The essential sections of a LinkedIn analytics report template
Decide which decisions the report must support—audience growth, content effectiveness, lead generation, brand awareness, or a combination—before selecting metrics. A focused template is a structured argument about what is working, what is not, and what to do next. Metrics that do not inform those decisions add noise rather than direction.
Most well-structured LinkedIn templates cluster around four or five functional sections: a performance summary, audience and follower data, reach and impressions, engagement detail, and a content or conversion layer depending on goals. The sections below define each and explain when to include them.
Performance summary (KPIs vs goals)
Lead with a compact scorecard that answers one question: are we on track? Structure it as three columns — KPI name, current period value, and delta against target or prior period — so readers can scan results in under thirty seconds.
For a mid-size B2B Page, a practical scorecard might include eight rows: impressions, organic reach, engagement rate by impressions, follower growth, link clicks, lead form submissions, cost per lead, and one content-specific metric. Keep the scorecard to twelve rows or fewer and prune any metric that would not change what you plan to do next month.
Audience and follower growth
Track follower count together with audience composition: total followers at period end, net new followers during the period, and the split between organic and paid followers. Include the top two or three demographic categories most relevant to your ICP — job function, seniority, and industry are the most commonly useful. Do not export every dimension; the extra columns make the tab harder to read without improving decisions.
Measure follower growth rate with =(Net New Followers ÷ Followers at Start of Period) × 100. A small raw increase on a large base often signals a different strategic problem than the same percentage growth on a small base, so always pair the rate with the absolute count.
Reach, impressions, and clicks
Report reach when your goal is brand awareness and impressions when you need to analyze recirculation. Impressions count all displays including multiple views by the same person. Reach — sometimes labeled "unique impressions" in LinkedIn exports — counts distinct members who saw the content. Verify current labeling in the LinkedIn Help Center, as LinkedIn has adjusted terminology across product updates.
Break out clicks by type when possible: post clicks (expands, profile clicks), link clicks (off-platform), and follow clicks. A single aggregated "clicks" figure overstates intent and hides the true drivers of site traffic.
Engagement breakdown
Record reactions, comments, reposts, and clicks individually as well as in aggregate. Tracking them separately lets you distinguish high-reaction posts that generate no conversation from posts that spark threads — a meaningful creative signal.
Include a dedicated cell for the engagement-rate variant you use and document that variant in the template itself. Two main variants are engagement rate by impressions and engagement rate by followers. Choose the one appropriate to your analysis goal and keep it consistent across reporting periods.
Content-type insights (documents/carousels, video, posts)
Separate post formats because averaging them masks format-specific signals. Add a content-type breakdown grouping posts by format: document, video, image, text, link, and poll. For each format, record number of posts published, total impressions, total engagement, and average engagement rate.
Keep a post-level diagnostic table in a separate tab from the main summary. Executives then see the strategic picture while specialists retain the raw rows needed for decisions. For video, add view-based metrics alongside impressions, as LinkedIn tracks video-specific metrics through a separate pipeline.
Demographics and account signals
Use Website Demographics (requires the LinkedIn Insight Tag) to connect content activity to audience quality rather than just volume. Include a brief demographics snapshot showing the professional attributes of site visitors that matter to your pipeline — seniority level and job function are typically the most actionable pair.
For ABM programs, add a Company Engagement Report section to show engagement by target account, shifting the conversation from reach to account coverage. Verify feature availability in LinkedIn's Campaign Manager documentation, as eligibility requirements can change.
Build a simple LinkedIn analytics report in Google Sheets (no paid tools)
Build a fully functional report in Google Sheets using native LinkedIn exports. The first-time setup takes roughly 30 minutes. Monthly refreshes run under 30 minutes once structure is in place.
Worked example: You manage the LinkedIn Page for a 50-person B2B SaaS company. Goals for the month are to grow organic reach, maintain engagement rate above 2% by impressions, and generate at least 15 lead form submissions from LinkedIn Ads. You publish about 12 posts per month. With that context fixed, the steps below map directly to your situation — adjust the row counts if your volume is higher or lower.
Export the data from LinkedIn Page Analytics and Campaign Manager
Export these CSVs at the start of your monthly close:
- Page Analytics – Visitors: Page → Analytics → Visitor Analytics. Set the previous calendar month and export. Contains page views, unique visitor counts, and visitor demographics.
- Page Analytics – Followers: Analytics → Follower Analytics. Export for the same period to get new followers, total followers, and demographics.
- Page Analytics – Updates (Posts): Analytics → Content → Export. This post-level file includes impressions, clicks, reactions, comments, reposts, and engagement per post.
- Campaign Manager – Performance: Campaigns → select account → set date range → export performance CSV. Includes impressions, clicks, spend, conversions, and cost-per-conversion by campaign.
- Campaign Manager – Lead Gen Forms: Account Assets → Lead Gen Forms → select form → export submissions and performance data.
Confirm that Campaign Manager and Page Analytics timezones match before merging files. LinkedIn processes some metrics in UTC, and timezone mismatches can create small but confusing differences that are difficult to explain in review meetings.
Normalize and calculate KPIs (copyable formulas)
Paste each CSV into its own tab: raw_page_visitors, raw_page_followers, raw_posts, raw_ads, raw_lgf. Create a KPIs tab to calculate the scorecard by referencing the raw tabs. Keep each formula in a labeled row with a plain-English description beside it so future editors understand the definitions at a glance.
Common formulas (adjust cell references as needed):
- Follower growth rate: =(Followers_End - Followers_Start) / Followers_Start 100
Example: (4,250 - 4,100) / 4,100 × 100 = 3.66%
- Engagement rate by impressions: =(Reactions + Comments + Reposts + Clicks) / Impressions 100
Note: LinkedIn may include or exclude certain click types depending on the export version; verify in the Help Center.
- Engagement rate by followers: =(Reactions + Comments + Reposts) / Total_Followers 100
- Link CTR: =Link_Clicks / Impressions 100
- Lead form submission rate: =Submissions / Opens 100
Example: 38 ÷ 210 = 18.1%
- Cost per lead (CPL): =Total_Spend / Total_Submissions
Example: $680 ÷ 38 = $17.89
- Conversion rate (CVR): =Conversions / Clicks 100
Keep all formulas documented in a readme tab so the definitions survive staff changes and LinkedIn export updates.
Sample field layout and monthly close checklist
Structure the KPI tab columns as: Metric Name, Formula Type, Current Month Value, Prior Month Value, MoM Delta, Goal, vs Goal Delta, and Notes.
A minimal set of rows for a B2B Page running both content and ads:
1. Total Organic Impressions
2. Organic Reach (Unique Impressions)
3. Engagement Rate by Impressions (%)
4. Net New Followers
5. Follower Growth Rate (%)
6. Link Clicks (Organic)
7. Total Ad Impressions
8. Ad Link CTR (%)
9. Lead Form Submissions
10. Lead Form Submission Rate (%)
11. Cost per Lead ($)
12. Document Post Engagement Rate (%) — if used
Monthly close checklist:
- [ ] Exports pulled for the full calendar month
- [ ] Timezone alignment confirmed between Page Analytics and Campaign Manager
- [ ] Raw tabs pasted and headers matched to expected column names
- [ ] KPI formulas updated to reference new rows
- [ ] Prior month column updated with last month's values
- [ ] Goal column reflects updated targets
- [ ] Commentary cell updated with a 2–3 sentence narrative
- [ ] Change log entry added if any metric definition or formula changed
Decision framework: spreadsheet vs Looker Studio vs reporting suite
Choose the reporting tool your team will actually maintain consistently. The right choice depends on team size, reporting cadence, data literacy, and the capacity to absorb connector maintenance.
Spreadsheets are low-barrier but manual. BI dashboards automate refresh and data blending but introduce connector reliability and API rate-limit considerations. All-in-one reporting suites scale well for agencies but impose standardization pressure that can conflict with custom metric requirements.
When a spreadsheet template is enough
Use Google Sheets or Excel when you manage one or two accounts, report monthly or quarterly, and have a single person responsible for updates. Spreadsheets allow full formula customization, require no connector subscriptions, and are sustainable at small scale. Mitigate the main risk — LinkedIn occasionally changes CSV column order or labels — with a monthly QA check that compares exported headers to expected field names before running formulas.
When to move to BI dashboards
Move to tools like Looker Studio or Power BI when you manage multiple pages, report weekly, or need automated trend charts and blended data from other channels. BI removes the export-and-paste cycle but requires someone to own connector health. Add a "data last refreshed" timestamp to any automated dashboard so readers can immediately spot a stale feed. Catchr's overview of Looker Studio connectors for LinkedIn covers the tradeoffs between native reporting and connector-based approaches in more detail.
When to use an all-in-one reporting tool
All-in-one suites make sense for agencies managing five or more client accounts and teams that need white-label PDF output or scheduled delivery. Evaluate whether the tool allows custom metrics and formulas before committing — if it does not, you may be locked into a data model that does not match your goals, which creates workarounds that negate the time savings.
Unifying organic and paid LinkedIn data in one template
Combining Page analytics and Campaign Manager data gives a complete view, but inconsistent naming and attribution create contradictory stories. Consistent labeling is the foundation: every campaign and significant organic post series should follow naming conventions that enable grouping and filtering across both systems.
UTM conventions and naming hygiene
Apply UTMs to every URL shared in LinkedIn posts and ads. Use a consistent structure so LinkedIn-sourced traffic is identifiable in downstream analytics:
- utm_source=linkedin
- utm_medium=social for organic; utm_medium=cpc or utm_medium=paid-social for ads
- utm_campaign=[campaign-name] — reuse the campaign names from Campaign Manager exactly
- utm_content=[post-type-or-creative-variant] — for example, document-carousel or text-post
Use a campaign naming pattern in Campaign Manager that encodes objective, audience, format, and date. A pattern like LeadGen_EnterpriseITDirectors_DocumentAd_2024Q4 makes filtering by quarter or format straightforward without needing a lookup table. Document UTMs and naming conventions in a shared reference and enforce them as a pre-publish checklist step to avoid untagged traffic.
Aligning conversion windows and goals
LinkedIn Ads conversion windows — click-through and view-through — can differ from what Google Analytics attributes to the same LinkedIn traffic. That produces different conversion counts from two sources that are both technically correct.
Choose a single source of truth per conversion metric and document that choice in the methodology cell: commonly Campaign Manager for LinkedIn Ads conversions and CPL, and GA4 for website behavior post-click. Revisit this whenever you change Campaign Manager conversion window settings, and check the current options in Campaign Manager conversion documentation.
Executive vs specialist versions of the report
Build two views from the same data source: a lean executive summary for quick decisions and a detailed specialist view for diagnostics. Trying to serve both audiences with one layout usually satisfies neither.
Executive summary
Provide a single page or tab with this structure: context → performance vs goals → key driver → one recommendation. Include the reporting period and goals, four to six KPIs each with current value, goal, and delta, a one-paragraph summary, and one visual — a trend line or bar chart — showing the primary KPI over three to six months.
Keep post-level tables and raw ad rows out of the executive view entirely. Commentary prompts that make this section easier to write consistently:
- "This month, [primary KPI] was [X], which was [above/below] our goal of [Y] because..."
- "The main driver was [content type / campaign / audience segment]."
- "Next month, we will [test / scale / pause] [specific action] to [expected outcome]."
Channel specialist view
The specialist view includes the executive scorecard plus full diagnostic detail: content-type breakdown, top posts by engagement and reach, follower demographics, ads performance by campaign (CTR, CPL, CVR), Lead Gen Forms metrics, experiment log, and data health notes.
Use this layer for operational decisions and handoffs to content or ad specialists. Specialist commentary prompts:
- "Document carousel posts averaged [X]% engagement rate vs [Y]% for other formats."
- "Campaign [name] drove CPL down to $[Z] after [tactic]."
- "Follower demographic shift: [observation]; implication: [note]."
Metrics reference: definitions and formulas to use
Consistent metric definitions prevent conflicting interpretations between the person who built the template and the stakeholder reading it. Cross-reference the LinkedIn Help Center and the LinkedIn Marketing Solutions Blog for the latest definitions, as LinkedIn updates terminology periodically.
Engagement rate variants
Engagement rate by impressions measures how often people who saw a post interacted with it, normalizing for distribution volume. It is the more useful variant for post-level analysis because it controls for reach differences between posts.
Formula: Engagement Rate (by Impressions) = (Total Engagements ÷ Total Impressions) × 100
Example: 320 engagements ÷ 14,000 impressions = 2.29%
Engagement rate by followers measures resonance against total audience size. Formula: Engagement Rate (by Followers) = (Total Engagements ÷ Total Followers) × 100. Use the impressions-based variant for post-level analysis and the followers-based variant for account-level trend benchmarking. In both cases, document which interactions are counted in "total engagements" — some exports include click-type events that others exclude — and apply the same definition consistently.
CTR types
Differentiate click types because combining them overstates intent. Total CTR includes all post clicks: profile clicks, hashtag clicks, "see more" expansions, and link clicks. Link CTR counts only clicks to the URL attached to the post.
Formula: Link CTR = (Link Clicks ÷ Impressions) × 100
Use Link CTR for content strategy decisions and compare it against Total CTR to diagnose how much post interaction is translating to off-platform traffic.
Conversion metrics (CVR, CPL)
Conversion rate: CVR = (Conversions ÷ Clicks) × 100. This figure is only meaningful when conversions are precisely defined and tracking is verified as active in Campaign Manager.
Cost per lead: CPL = Total Ad Spend ÷ Total Lead Submissions (or Conversions). Use rolling three-month averages rather than single-month values to reduce noise and focus on directional trends.
Attribution setup essentials to make the template credible
Conversion and lead metrics require correct attribution infrastructure to be trustworthy. Without it, CPL and CVR figures can appear credible in the template while reflecting broken tracking rather than real performance.
LinkedIn Insight Tag and conversion actions
Install and verify the LinkedIn Insight Tag to power Website Demographics and conversion tracking. Verification steps:
1. Campaign Manager → Account Assets → Insight Tag — confirm status shows "Active" and the domain is verified.
2. If not installed, follow LinkedIn's installation instructions in Campaign Manager Help.
3. Create conversion actions under Account Assets → Conversions, define events precisely, and set attribution windows that match your sales cycle.
4. Assign a named owner — typically marketing operations — to monitor tag status monthly.
If your IT environment restricts third-party scripts, consult security teams and document attribution limitations explicitly in the template's methodology cell so readers understand the data's constraints.
Lead Gen Forms to CRM and offline conversions
Lead Gen Forms capture prospect data in LinkedIn but do not automatically flow to all CRMs. Use Campaign Manager CRM sync where supported, middleware, or scheduled manual exports to close the loop between form submissions and pipeline tracking.
In the report, record submissions and submission rate from Campaign Manager and note whether downstream CRM quality data has been reconciled with those numbers. If sales provides quality feedback on leads, include a "pipeline contribution" row in the specialist view to connect marketing metrics to revenue outcome — this row is often the most persuasive element in executive reviews.
Data governance, QA, and discrepancy resolution
Prevent bad data from eroding stakeholder trust by instituting clear QA, change logs, and data-health checks before every distribution.
Data freshness and lookback limits
LinkedIn data can update retroactively for a short window after the period ends. For monthly reporting, avoid pulling data for a period less than 48 hours old to reduce the risk of incomplete numbers. LinkedIn also limits historical access for some export types. Confirm current retention and lookback windows in the Help Center and build your reporting cadence around confirmed availability rather than assuming full history is always accessible.
Clicks vs sessions and other common mismatches
Expect LinkedIn-reported clicks and GA4 sessions attributed to LinkedIn to differ. Common causes include bot filtering, UTM stripping on redirect chains, same-session deduplication, and pre-fetch behavior. The gap is normal; the problem is leaving it unexplained.
Add a discrepancy note cell to the template: "LinkedIn link clicks: [X]. GA4 sessions (utm_source=linkedin): [Y]. Delta: [Z%]. Likely cause: [UTM stripping / redirect / other]." Surfacing this proactively prevents it from becoming a trust issue in review meetings.
Data health checks and change log
Run these checks before each distribution and log any changes that affect historical comparability:
- [ ] Exports cover the intended date range
- [ ] Total follower count in exports matches the LinkedIn Page UI
- [ ] Campaign Manager spend matches the billing statement
- [ ] KPI formulas return non-zero values (no broken references)
- [ ] Conversion tracking status shows "Active" in Campaign Manager
- [ ] No LinkedIn UI change notifications affecting metric definitions
- [ ] Change log entry added for any field, formula, or definition change
Log each event with Date, What changed, Who changed it, and Impact on historical comparability.
Edge cases and adaptations
Low-volume pages
For Pages with few followers or infrequent posts, single-post metrics are noisy enough to mislead. Use quarterly reporting or three-month rolling averages for rate-based KPIs. Replace monthly engagement rate with a rolling median across the last twelve posts, and always pair rates with absolute counts so readers understand the scale behind the percentage.
Multi-region or multi-language
When operating across regions or languages, add filters or sub-sections by geography or language rather than blending them into a single engagement rate. Ensure Campaign Manager separates campaigns by region when regional accountability is expected, and document aggregation logic explicitly — for example, "APAC roll-up includes Australia, Singapore, and India" — in the methodology notes.
ABM and Company Engagement Report
For ABM programs, include target-account engagement metrics: number of target accounts with any engagement, top engaged accounts, and engagement types observed. Combine this with Website Demographics to show which target account industries and seniority levels visit your site via LinkedIn. Verify Company Engagement Report eligibility in LinkedIn Marketing Solutions documentation, as access requirements are tied to account tier.
Recruitment-focused pages
For talent acquisition Pages, substitute KPIs to emphasize career-page views, job post clicks, application starts, and cost per application. If combining Page analytics with Talent Solutions data, treat them as separate sources requiring separate exports and a bridge section in the template that documents how the two datasets relate.
Minimum viable LinkedIn report you can maintain in 30 minutes/month
If you need a lightweight monthly deliverable, maintain a single tab with eight to twelve KPIs, a one-paragraph commentary, and a checklist that fits a 30-minute close.
Minimum viable scorecard for a content-focused B2B Page:
1. Total Organic Impressions (current vs prior)
2. Engagement Rate by Impressions (%) — current vs rolling 3-month average
3. Net New Followers
4. Link Clicks (Organic)
5. Top-performing post format by average engagement rate this month
6. Lead Form Submissions (if running ads)
7. CPL (if running ads)
8. One sentence: what to do differently next month
Monthly close checklist for the minimum viable report:
- [ ] Pull Page Analytics CSV for the month
- [ ] Pull Campaign Manager CSV (if ads running)
- [ ] Paste into raw tab and update KPI formulas in KPIs tab
- [ ] Write one-paragraph commentary using the executive summary prompts
- [ ] Update prior month column with current values
- [ ] Send or share
If the monthly update consistently exceeds thirty minutes, trim the template back to these core rows before adding tooling.
Template governance: versioning and ownership
Assign a single named owner to maintain formula integrity, run QA, update the change log, and communicate metric changes to stakeholders. Version the template by date-stamping filenames — for example, linkedin_report_template_v2_2024-10.xlsx — and keep at least two prior versions accessible for rollback and auditability.
Include a readme tab documenting each data export source, KPI formula definitions, known discrepancies between LinkedIn and GA4, and the last date the tab was reviewed against LinkedIn's current export format. The readme is essential for fast, accurate updates when LinkedIn changes CSV column names or metric definitions, and it reduces the onboarding time for anyone inheriting the template.
Worked example: one-month snapshot and commentary prompts
Use a repeatable narrative structure: context → results vs goals → drivers → next steps. The numbers below are fictional and illustrative, intended to show how the structure works in practice.
Context: 200-person B2B software company, October. Goals: grow organic reach +5% month-over-month and keep CPL below $20.
Performance snapshot:
- Organic impressions: 48,200 (September: 43,700 — +10.3%, exceeding the 5% goal)
- Engagement rate by impressions: 2.1% (September: 1.8%; rolling 3-month average: 1.9%)
- Net new followers: 142 (September: 98)
- Lead form submissions: 44 (September: 31)
- CPL: $16.40 (September: $21.80 — below the $20 goal)
Commentary: October's organic reach outperformed the goal primarily because of two document carousel posts, each of which exceeded 8,000 impressions. Both used a five-slide structure with a data insight on the opening slide and a tactical takeaway on the final slide. The content team will test that structure on two posts in November to assess whether the format or the specific topics drove the result.
CPL improved after narrowing targeting to Director-level and above at companies with 500 or more employees in financial services, which increased the lead form open rate from 14% to 22%. Isolating that targeting change as the probable driver is important before scaling spend.
Next steps:
- Publish two November posts using the five-slide document carousel format
- Hold CPL target at $20 and test one creative variant (video thumbnail versus document ad) within a single campaign
- Monitor follower seniority mix over the next two months to confirm the targeting refinement is attracting the intended audience
For teams that publish document carousels as a regular content format, tracking carousel-specific engagement in a dedicated row — separate from image and text posts — makes format performance visible and keeps month-over-month comparisons clean. Maintaining consistent visual structure across carousel posts also reduces variability that can otherwise make engagement trends harder to interpret. Tools that support repeatable carousel design inside Canva, such as Carousel Studio, can help standardize output and make format-level comparisons more reliable over time.
---
Building and maintaining a LinkedIn analytics report comes down to three decisions: which metrics genuinely inform your strategy, which tool your team will realistically maintain, and who owns the template when something breaks. Start with the minimum viable scorecard in this guide, ship one clean reporting cycle, and add complexity only where a missing metric would have changed a decision. If you reach a point where the monthly export-and-paste routine consumes more time than the analysis itself, that is the right moment to evaluate a BI connector or reporting suite — not before.