技能创建器
skill-creator
创建、改进和评估自定义技能,把专业流程转化为可重复使用的 AI 能力。
39-content-audit-global【数据与研究】Use when published content has to be audited — pull channel data, classify winners and losers by percentile across pillar, format, and hook, find the pattern behind performance, and decide what to keep, kill, or scale. Trigger on 'content audit', 'which posts are working', 'content performance review', 'why did that one go viral', 'our reach is dropp…
独立 GitHub 快照 · 自动分类 · 以原作者文档为准
name: 39-content-audit-global
description: "Use when published content has to be audited — pull channel data, classify winners and losers by percentile across pillar, format, and hook, find the pattern behind performance, and decide what to keep, kill, or scale. Trigger on 'content audit', 'which posts are working', 'content performance review', 'why did that one go viral', 'our reach is dropping', 'evaluate what we posted last month'. Also use when the user only says content does not seem to work anymore. Not for — the plan for next period built on these findings, see 40-next-content-plan-global; paid ad account review, see 21-ads-audit-global; the stakeholder report, see 07-marketing-report-global."
metadata:
version: 1.0.1
category: content
license: MIT
triggers:
An audit is not a judgment of the past. It is how you replicate winners and retire losers with evidence behind the decision. Every recommendation must attach to a specific action — never a general observation. Run it at least monthly; do not wait for the quarter to close.
Ask up to 4 questions before starting:
Without post-level data there is no audit. Walk the user through the exports in step 1 first.
| Channel | Source | Metrics to export |
|---|---|---|
| Instagram professional account insights or Meta Business Suite, post level | Reach, accounts engaged, saves, shares, profile visits, link clicks | |
| Meta Business Suite, post level export | Reach, engagement, link clicks, shares, negative feedback | |
| TikTok | TikTok Analytics, Content tab | Views, average watch time, completion rate, shares, follows from video |
| LinkedIn page or creator analytics | Impressions, engagement rate, click-through, follower gain, reposts | |
| YouTube | YouTube Studio | Views, average view duration, impressions click-through rate, subscribers gained |
| X | X analytics | Impressions, engagement rate, link clicks, profile visits |
| Blog / site | GA4 — Explore report by landing page and source/medium | Sessions, engagement rate, average engagement time, key events, assisted conversions |
| Klaviyo, Mailchimp, or equivalent campaign report | Open rate, CTR, click-to-open rate, placed-order rate, unsubscribe rate | |
| Leads and revenue | CRM (HubSpot, Pipedrive) or store (Shopify) | Leads and orders attributed to content, by source |
One row per post: publish date, channel, format, pillar, funnel stage, hook type, primary metric, secondary metrics. If the classification columns (pillar, format, hook type) are missing, backfill them by hand from the content calendar (01-content-calendar-global).
Apply the split per channel and per group. A cross-channel ranking measures the channel, not the content.
For the winner set and the loser set separately, look for what they share:
| Axis | Question |
|---|---|
| Pillar | Which pillar do the winners concentrate in? Which pillar produced no winner at all? |
| Format | Video, carousel, static, text, long-form — which format wins on which channel? |
| Hook type | Pain, curiosity, number, contrarian, result-first — which one holds attention? |
| Publish time | Which slots produce winners? |
| Length | Short or long — and does the answer differ by channel? |
Two or three sentences answering why the pattern works, checked against the customer insight file (09-customer-insight-global). Example of the right shape: "Videos with a number in the hook and a real face on camera hold completion far better than carousels — this audience trusts a person more than a designed asset."
A finding is a hypothesis grounded in data, not an impression.
40-next-content-plan-global and 19-ab-test-setup-global.For each metric record: this period / prior period / baseline / verdict.
Baselines to use:
references/benchmarks-global.md).references/benchmarks-global.md, adjusted for region tier, industry, and season before comparing.File name: content-audit-[brand]-[YYYYMMDD].md
# Content Audit — [Period] — [Channels]
## I. Period overview
| Item | Figure |
|------|--------|
| Posts published | |
| Total reach / impressions | |
| Average engagement rate | |
| Leads attributed to content | |
| Revenue attributed to content | |
## II. Classification
### WINNERS — top 20%
| Post | Channel | Format | Pillar | Hook type | Standout metric | Why it worked (hypothesis) |
|------|---------|--------|--------|-----------|-----------------|----------------------------|
| | | | | | | |
### LOSERS — bottom 20%
| Post | Channel | Format | Pillar | Hook type | Weak metric | Why it failed (hypothesis) |
|------|---------|--------|--------|-----------|-------------|----------------------------|
| | | | | | | |
### AVERAGE — middle 60%
[2-3 sentences of general observation]
## III. Pattern analysis
**Winner pattern:** [recurring pillar / format / hook / time / length]
**Loser pattern:** [what the failures share]
**Core finding:** [2-3 sentences — why it works, checked against customer insight]
## IV. Recommendations
**Do now (next week):**
1. [Action + expected impact]
**Stop:**
1. [What to retire — data reason]
**Test next:**
1. [Hypothesis + how it will be measured]
## V. KPI comparison
| Metric | This period | Prior period | Baseline | Verdict |
|--------|-------------|--------------|----------|---------|
| Instagram reach per post | | | trailing 3-month median | |
| TikTok average completion rate | | | trailing 3-month median | |
| LinkedIn engagement rate | | | trailing 3-month median | |
| Email open rate | | | 22-27% median | |
| Email CTR | | | 2.5-3.5% median | |
| Leads from content | | | | |
13-data-analysis-global: pulling and cleaning the data before the audit, including connector and MCP setup.03-performance-eval-global: paid media evaluation — this audit covers organic.07-marketing-report-global: the audit result is an input to the monthly report.40-next-content-plan-global: run immediately after. An audit that does not produce a new plan was wasted effort.01-content-calendar-global: winners return to the calendar as base templates.09-customer-insight-global: check patterns against insight to explain why something worked.40-next-content-plan-global scheduled to run immediately after.