Social Media Analytics Report
Agent Skill that turns Instagram, Facebook, TikTok, YouTube and LinkedIn CSV exports into a clear report: formats, days and times, top posts, rhythm and before/after tests.
About Social Media Analytics Report
Most platforms let you export your post data, but a spreadsheet of 60 rows doesn't tell you what to do next. Paid analytics tools cost a monthly fee and often compare you with "industry averages" that don't fit your niche.
This skill reads the CSV exports you already have from Meta Business Suite (Instagram and Facebook), TikTok Studio, YouTube Studio or LinkedIn, one file or several. A bundled script finds the columns by their common names and normalizes every post into one table. It reports totals and medians per platform, with engagement rate by reach or by views (labelled). It breaks performance down by format, by day of the week and by time of day, with post counts so small groups aren't over-read. It lists top and bottom posts within each platform and shows your posting rhythm and longest gaps. A before/after comparison around any date tests a new schedule or format. Then the AI explains what's working, what isn't and two or three things to try next, using only your numbers.
Inside: SKILL.md, the report script (Node.js, no packages), a metrics guide with export steps, and invented Instagram and TikTok exports with the saved report, a walkthrough and test runs.
For small businesses, creators and social media managers preparing monthly or client reports.
Limitations: it doesn't connect to any platform and has no industry benchmarks, on purpose. Column names in exports change; a --map option handles that. Platforms define views differently, so it compares within each platform.
Scanned: no issues found
Release v1.0.0 reviewed by AgentLoomX™ · 13 files · 25.1 KB
This package can
- Create, change or delete files
What's inside (13 files)
- social-analytics-report/CHANGELOG.md
- social-analytics-report/examples/instagram-posts.csv
- social-analytics-report/examples/output/posts-normalized.csv
- social-analytics-report/examples/output/report.md
- social-analytics-report/examples/test-runs.md
- social-analytics-report/examples/tiktok-videos.csv
- social-analytics-report/examples/walkthrough.md
- social-analytics-report/LICENSE.txt
- social-analytics-report/README.md
- social-analytics-report/references/metrics-guide.md
- social-analytics-report/scripts/analytics.mjs
- social-analytics-report/scripts/lib.mjs
- social-analytics-report/SKILL.md
Read the skill's instructions social-analytics-report/SKILL.md
--- name: social-analytics-report description: Turns post-level CSV exports from Instagram and Facebook (Meta Business Suite), TikTok Studio, YouTube Studio or LinkedIn into one normalized table and a plain-English performance report. It covers totals and medians per platform, engagement rate (by reach or views, labelled), performance by format, day of week and time of day, top and bottom posts within each platform, posting rhythm and gaps, and a before/after comparison around a date. Use when the user says things like "what's working on my Instagram", "make a monthly social media report", "analyze my TikTok export", "which posts did best", "best time to post for my account", "did our new schedule help", or uploads analytics CSVs. It only uses the data in the exports; it doesn't connect to any platform. --- # Social Media Analytics Report Read the exports, normalize them, compute the report, then explain what it means and what to try next. Rules you never break: 1. **Only the user's data.** No benchmark statistics, "industry average engagement rates" or claims about the algorithm. Compare the account with itself. 2. **Medians and sample sizes.** Lead with medians. Say when a group has too few posts to mean anything. 3. **Compare like with like.** Views differ by platform. Rank and compare within each one. ## Bundled files | File | When to use it | |---|---| | `scripts/analytics.mjs` | Step 2. Reads one or more CSV exports and prints the report. With `--out-dir`, it also …
The full file is included with your purchase.
SHA-256 b2ef565426f284e1eb06a1327401c0210054c9add1910d42e3bdd2572e429200
Signed with Ed25519 key a9c62a7921065aa9. Public keys
Scans catch known risky patterns; they are not a guarantee. Report anything that looks wrong to support.
Highlights
- Reads Meta, TikTok, YouTube, LinkedIn CSVs
- Medians and engagement rate per platform
- Results by format, weekday and time of day
- Top and bottom posts within each platform
- Before/after test around any date
- Normalized CSV of every post for your files
- social media analytics
- tiktok
- reporting
- engagement rate
- content strategy
Keep exploring
More like this
Reseller Fee and Profit Calculator
by Marketplace Founder · Data Analysis & Visualization
Agent Skill that shows what you keep on eBay, eBay Live, Whatnot, Poshmark, Depop, Etsy and Facebook: fees, payout, profit, target and breakeven prices, from an editable fee file.
Resale Price Range Finder
by Marketplace Founder · Data Analysis & Visualization
Agent Skill that prices clothing, shoes, bags and home goods from your sold comps: range by condition, outliers set aside, sell-through and a list price with an offer floor.
Creator Rate Card Calculator
by Marketplace Founder · Data Analysis & Visualization
Agent Skill that builds a creator's rate card and itemized brand quotes from their own median views and CPM range, prices usage and exclusivity, and checks offers' effective CPM.