XHS Analytics Reporting Template: How to Build, Download & Customize One for Your Brand
Date Published
Table Of Contents
1. Why Xiaohongshu Reporting Looks Different From Other Platforms
2. What a Strong XHS Analytics Reporting Template Includes
3. The Core Metrics Every XHS Report Should Track
4. How to Structure Your Template by Reporting Cadence
5. Customizing Your Template by Marketing Objective
6. KOL and KOC Campaign Reporting: A Tab You Cannot Skip
7. Common Mistakes Brands Make in XHS Reporting
8. Download and Customize Your XHS Analytics Template
Most international brands entering Xiaohongshu already have a reporting system they trust — a Google Sheets dashboard, a slide deck template, a Looker Studio build. Then they start pulling XHS data and quickly realize those frameworks do not translate. The metrics have different names, the algorithm logic is different, and half the engagement signals that matter most on this platform (like save rate) do not even have a direct equivalent in Western social analytics.
This guide is designed to solve that problem. Whether you are building your first Xiaohongshu analytics reporting template from scratch or adapting an existing social media report, you will find a practical framework here — covering exactly which metrics to track, how to structure your reporting by cadence and objective, how to handle KOL and KOC campaign tracking, and how to customize the whole thing for your specific brand goals.
As the leading English-language resource hub for international brands marketing on Xiaohongshu, AllXHS has helped brands across beauty, fashion, F&B, and 20+ other verticals build measurement systems that actually reflect platform reality. What follows is distilled from that experience.
Why Xiaohongshu Reporting Looks Different From Other Platforms {#why-xhs-reporting-is-different}
Before downloading any template, it is worth understanding why XHS analytics require their own framework rather than a simple adaptation of an Instagram or TikTok report. The difference is not cosmetic — it is structural.
Xiaohongshu functions as a social search engine as much as a social feed. Users arrive with purchase intent, search for product reviews, save posts to reference during buying decisions, and often complete their purchase on a completely different platform. That discovery-to-purchase journey means the metrics that carry the most signal — and the ones that belong in your report — are often different from what you are used to tracking elsewhere. An impression count that looks strong may mean very little if save rate is low; a post with modest views but a 6% save rate is telling you something far more valuable about purchase consideration.
Xiaohongshu's algorithm also weights content engagement differently. Saves and substantive comments carry heavier algorithmic weight than passive likes, which means your reporting template needs to reflect those priorities rather than simply importing an engagement-rate formula from another platform. If your current report just tracks likes and comments as equal signals, you are looking at an incomplete picture of how your content is actually performing.
Finally, content lifespan on XHS is longer than most brands expect. A well-optimized post with strong keyword alignment can continue driving search traffic for months after publication, which means your reporting window and the way you calculate cumulative content ROI needs to account for that evergreen potential.
---
What a Strong XHS Analytics Reporting Template Includes {#what-a-strong-template-includes}
A well-designed XHS analytics reporting template is not a single tab of numbers — it is a layered document that lets you zoom in on individual posts, zoom out to account-level trends, and connect both to your actual business objectives. Think of it as having four distinct layers that feed into one coherent view.
Layer 1: Account Overview. This is the executive summary of your XHS presence. It captures top-line numbers across a defined period: total impressions, follower count and growth rate, overall engagement rate, and traffic source breakdown (search vs. discovery). This layer is what you share with leadership or clients who need the 30-second version.
Layer 2: Content Performance. This is the working layer of your template — a post-by-post breakdown of every note published in the reporting period. Each row should capture: publish date, content format (image carousel, short video, long video), title, impressions, views, likes, comments, saves, shares, save rate, engagement rate, and traffic source split. Over time, this tab becomes one of your most valuable strategic assets because you can sort by save rate or engagement rate to identify your highest-performing content types and replication patterns.
Layer 3: Audience Insights. Your reporting template should have a dedicated section for audience demographic data pulled from the native analytics dashboard: age distribution, city tier breakdown (Tier-1 vs. Tier-2/3 cities), gender split, and peak active hours. This layer is especially important for brands adjusting their content calendar or assessing whether their XHS audience matches their target customer profile.
Layer 4: Conversion and Business Outcomes. This is the hardest layer to populate but the most important for demonstrating ROI. Track clicks from product tags, external link referrals, promotion code redemptions, and any post-purchase survey data attributing sales to XHS discovery. Even partial data here is better than none — it anchors the rest of the report to business reality rather than leaving it as a collection of platform vanity metrics.
For brands that want a ready-to-use version of this framework, AllXHS offers 25+ tools and templates built specifically for Xiaohongshu marketing, including analytics resources designed for international brands who are navigating the platform in English.
---
The Core Metrics Every XHS Report Should Track {#core-metrics-to-track}
Not every number in the native analytics dashboard deserves a column in your report. Here are the metrics that genuinely belong in a working XHS analytics template, along with the formulas and benchmarks you need to interpret them correctly.
Engagement Rate
On Xiaohongshu, engagement rate is calculated as total interactions divided by total views, not by follower count. The formula is: (Likes + Comments + Saves + Shares) ÷ Total Views × 100. This view-based calculation matters because it reflects how compelling your content is to people who actually saw it, rather than being diluted by a large, inactive follower base. A healthy benchmark for brand content falls between 3–5%; KOL-led content typically performs between 7–12%.
Save Rate (收藏率)
This is arguably the single most important metric on Xiaohongshu, and it is often the one international brands underestimate. Save rate measures the percentage of viewers who bookmark your content for future reference: Total Saves ÷ Total Views × 100. Users on XHS routinely save posts they are actively researching before making a purchase, which means a high save rate is a direct signal of commercial intent. For general content, average save rates fall between 0.5% and 2%; tutorial posts, buying guides, ingredient breakdowns, and comparison content regularly achieve 5% or higher. If your save rate is low, the fix is usually to make content more informative and reference-worthy — not more promotional.
Traffic Source Split (Search vs. Discovery)
Your native XHS dashboard shows what percentage of your content's views came from search (users actively looking for relevant keywords) versus discovery (the algorithm proactively serving your content in feeds). Content with a search traffic share above 40% has strong keyword alignment and evergreen value — it will continue attracting views long after the publish date. Discovery-heavy content suggests the algorithm is rewarding your engagement signals, but without keyword foundations it may fade quickly. Your reporting template should capture this split for every post, because over time it tells you which content types are building lasting organic visibility versus which are riding short-term algorithmic waves.
Follower Growth Rate
Calculated as net new followers divided by total followers, measured monthly. A healthy growth rate for established international brands typically sits between 3–8% per month. Track this metric alongside content volume to identify whether specific content pushes are driving meaningful audience growth, or whether your follower base is expanding through paid amplification alone.
KOL/KOC-Specific Metrics
For influencer content, two additional metrics belong in your reporting template. Cost Per Reading (CPR) measures reach efficiency: KOL post cost divided by number of views. A CPR below ¥1 is considered good; below ¥0.5 is excellent. Cost Per Engagement (CPE) measures interest quality: KOL post cost divided by total engagements. A CPE below ¥10 is good; below ¥5 is excellent. These calculations give you a standardized way to compare influencer partnerships across different tiers and categories.
---
How to Structure Your Template by Reporting Cadence {#reporting-cadence}
A single static template rarely serves all your reporting needs. International brands operating on Xiaohongshu typically need at least two versions of their analytics report, each built for a different audience and decision-making rhythm.
Weekly Reports are for the internal marketing team during active campaign periods. They should be lean and operational — covering the previous week's content performance, flagging any posts that outperformed or underperformed benchmarks, and tracking pacing against campaign targets. The audience for this report is the team managing day-to-day execution, so it prioritizes speed and actionability over narrative depth. A simple spreadsheet with conditional formatting on your key metrics works better here than a polished presentation.
Monthly Reports are for stakeholder communication — leadership, agency partners, or brand headquarters. These reports zoom out from individual posts and focus on trend lines: how is account engagement rate moving month over month, is follower growth accelerating or plateauing, which content formats are consistently outperforming, and what is the cumulative reach and estimated audience value delivered in the period. This version needs more narrative context alongside the numbers, because the audience is making budget and strategic decisions, not optimization calls.
Campaign Wrap Reports are one-off documents produced at the end of a defined campaign — a product launch, a seasonal push, a KOL activation wave. They should connect all four template layers: reach and visibility delivered, engagement quality, content highlights with performance callouts, influencer ROI calculations, and any attributable conversion data. This is the report that justifies the investment and informs the next brief.
---
Customizing Your Template by Marketing Objective {#customizing-by-objective}
A Xiaohongshu analytics template built for a brand awareness objective looks meaningfully different from one built to drive direct conversions. The core structure stays the same, but the KPIs you weight most heavily — and the benchmarks you measure against — need to reflect what you are actually trying to achieve.
For Brand Awareness: Lead with impressions growth, search volume for your brand name on XHS, and follower growth rate. Track how many unique users are seeing your content for the first time each month, and pay attention to whether your audience demographics are shifting toward your target profile. Content format analysis matters here because awareness campaigns often live or die by visual impact and algorithm reach.
For Community Building: Prioritize engagement rate, comment quality, user-generated content volume (how many users are creating their own posts featuring your brand), and save rate as a proxy for how much your content is becoming reference material within your niche. Brands building genuine community on XHS tend to see slower follower growth but higher comment depth and stronger save rates than pure awareness plays.
For Direct Conversion: Weight your template heavily toward click-through rate from product tags, external link visits, promotion code redemptions, and Cost Per Acquisition calculated across your total XHS spend. Connect these numbers directly to GMV or revenue data where you can, and track the time lag between first XHS exposure and eventual purchase — Chinese consumer journeys often involve multiple touchpoints over several days or weeks before conversion.
For brands unsure which objectives and KPI mix fit their category and growth stage, AllXHS provides industry-specific Xiaohongshu marketing strategies across 20+ verticals including beauty, fashion, F&B, and mother and baby — each with platform-relevant benchmarks and measurement guidance.
---
KOL and KOC Campaign Reporting: A Tab You Cannot Skip {#kol-koc-reporting}
Influencer marketing is central to most brands' XHS strategies, and it deserves its own dedicated tab in your analytics reporting template rather than being folded into the general content performance sheet. Mixing organic brand content metrics with paid influencer metrics creates a distorted picture of both.
Your KOL/KOC reporting tab should include one row per creator post and capture the following: creator name, tier (Mega/Macro/Micro/KOC), post date, content format, fee or product value, views, likes, comments, saves, shares, engagement rate, CPR, CPE, and any tracked conversions (code redemptions or UTM-attributed clicks). Over multiple campaigns, this tab becomes a performance database that lets you compare creator efficiency across tiers and categories — which is enormously valuable when briefing future campaigns.
One often-missed addition: a viral post rate column. This metric (number of viral posts divided by total posts published in the campaign) gives you a quick read on overall campaign effectiveness. A viral post rate above 20% is generally considered a successful campaign threshold. If you are running multiple creators across a single campaign wave, this rate helps you identify which creators and content styles are driving outsized reach — and which are delivering views but no amplification.
When evaluating creator partnerships, it is also worth noting that the most meaningful engagement signal on XHS is the combined likes-plus-saves count, not raw like totals. A creator whose audience saves frequently is more commercially valuable than one with more likes but minimal save behavior, because saves indicate that their community is actively researching and considering the products they feature.
---
Common Mistakes Brands Make in XHS Reporting {#common-mistakes}
Even brands with solid analytics habits on other platforms tend to make a few consistent errors when they first start building XHS reports. Knowing these pitfalls in advance will save you from drawing the wrong conclusions from your data.
Importing an Instagram-style engagement formula. If you are calculating engagement rate as interactions divided by followers (the standard Instagram method), you are producing a number that means nothing in the XHS context. Always use view-based engagement rate on this platform. The denominator matters enormously.
Closing the measurement window too early. Unlike Instagram or TikTok where content visibility drops sharply after 24–72 hours, XHS posts with strong keyword alignment continue driving search-driven views for months. If you assess a post's performance after one week and declare it underperforming, you may be writing off content that has real long-term value. Build a 6–12 month rolling performance view for key evergreen posts.
Tracking impressions without traffic source context. A post with 50,000 impressions where 60% came from search is a fundamentally different asset from one with 50,000 impressions where 90% came from discovery. The first has keyword authority and will keep generating views; the second may be a one-time algorithmic spike. Always capture traffic source split alongside impression volume.
Ignoring the discovery-to-purchase gap. Many users discover a product on XHS but complete their purchase on Tmall, JD.com, WeChat, or in a physical store. If your reporting only counts in-app conversions, you are systematically undervaluing the platform's influence. Promotion codes and post-purchase surveys are low-tech but highly effective ways to capture this attribution gap.
Treating all saves as equal. Save rate benchmarks vary significantly by content type. A 1% save rate on a brand announcement post tells a very different story from a 1% save rate on a step-by-step tutorial. Build content-type benchmarks into your template so you are comparing like with like.
---
Download and Customize Your XHS Analytics Template {#download-and-customize}
Building an effective XHS analytics reporting template does not require starting from a blank spreadsheet. The framework described in this article — four layers, post-level content tracking, audience insights, KOL/KOC tab, and business outcomes — is the same structure used by brands that generate consistent, measurable results on Xiaohongshu.
For international brands who want a ready-to-use starting point, AllXHS offers a library of free Xiaohongshu resources including tools, templates, and guides built specifically for non-Chinese brands navigating the platform. These resources are designed to work in English, which matters when your team is operating across markets and cannot rely on the native Chinese-language dashboard alone.
When customizing any template for your brand, the most important configuration decisions are: which objective layer to weight most heavily in your executive summary, which content types to track separately (because benchmarks differ), and whether your measurement window reflects the evergreen content lifespan that XHS allows. Get those three things right, and the rest of the template will surface genuinely actionable insights rather than a wall of numbers that no one acts on.
If your brand is ready to move beyond self-serve reporting and wants expert support structuring a full XHS measurement and optimization system, the AllXHS team offers hands-on Xiaohongshu marketing services tailored to your industry, market stage, and commercial objectives.
Building a Reporting Template That Actually Drives Decisions
The best XHS analytics reporting template is not the one with the most metrics — it is the one your team actually uses every week to make better decisions. That means stripping out the noise, weighting the signals that matter most on this specific platform (save rate, traffic source split, view-based engagement), building in the right measurement window for evergreen content, and structuring the whole document around the objectives your brand is actually pursuing.
Xiaohongshu rewards brands that understand their data. The platform's algorithm, its community culture, and the purchase behaviors of its 300+ million monthly active users all create a signal-rich environment — but only if you know what to look for. A well-built reporting template is how you turn that environment into a consistent competitive advantage.
Start with the four-layer framework outlined above, customize it to your objective, and review it at the right cadence. That process — more than any single tactic or content format — is what separates brands that grow predictably on XHS from those that are still guessing.
---
Ready to build a smarter Xiaohongshu marketing system?
AllXHS is the #1 English-language resource hub for international brands on Xiaohongshu, with 25+ ready-to-use tools and templates, 378+ industry reports, and expert consultation tailored to your brand's goals.