open-sheet Workbook Authoring
lianghsun/open-sheet
Technical reference for writing open-sheet workbooks as React files that export live .xlsx models, built around a rule against hand-written cell addresses.
Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations.
Install Analytics Dashboard
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install charlie947/social-media-skills analytics-dashboard --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/analytics-dashboard .claude/skills/analytics-dashboard && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .claude/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboardType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install charlie947/social-media-skills analytics-dashboard --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/analytics-dashboard .agents/skills/analytics-dashboard && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .agents/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install charlie947/social-media-skills analytics-dashboard --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/analytics-dashboard .cursor/skills/analytics-dashboard && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .cursor/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/charlie947/social-media-skills.git --path skills/analytics-dashboard--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install charlie947/social-media-skills analytics-dashboard --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/analytics-dashboard .gemini/skills/analytics-dashboard && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .gemini/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install charlie947/social-media-skills analytics-dashboardInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/analytics-dashboard .github/skills/analytics-dashboard && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .github/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add charlie947/social-media-skills --skill analytics-dashboard -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install charlie947/social-media-skills analytics-dashboard --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/charlie947/social-media-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/analytics-dashboard .opencode/skills/analytics-dashboard && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "analytics-dashboard" agent skill from https://github.com/charlie947/social-media-skills/tree/main/skills/analytics-dashboard into .opencode/skills/analytics-dashboard/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "analytics-dashboard", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
analytics-dashboard- GitHub stars
- 3.8k
- Token cost
- ~1.8k tokens
- SKILL.md length
- 945 words
- Files
- 1
- Skills in repo
- 15
- Repo updated
- First seen
- Licence
- MIT
At a glance
Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations.
- Works in 5 steps: Get the export file → Parse the data → Build the interactive dashboard → …
- The user says analyse my linkedin
- SKILL.md covers Codex and Claude runtime, CRITICAL: Auto-start on load, Step 1. Get the export file and Step 2. Parse the data, plus 4 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Analytics Dashboard is an agent skill from charlie947/social-media-skills. Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations. Reads every sheet in the export, builds charts for engagement trend, follower growth, post performance scatter, day-of-week heatmap, and audience breakdown. Use this skill whenever the user says "analyse my linkedin", "linkedin analytics", "build my dashboard", "review my performance", or uploads a LinkedIn Analytics export file. Requires the user's…
Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Documents & Office, covering Excel spreadsheets. It works with LinkedIn, Microsoft Excel and React. The licence is MIT.
When your agent uses it
- The user says analyse my linkedin
- Linkedin analytics
- Build my dashboard
- Review my performance
Example prompts
- “analyse my linkedin”
- “linkedin analytics”
- “build my dashboard”
- “/analytics-dashboard”
Workflow steps
5 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 8cefb5b. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Analytics Dashboard loads about 1.8k tokens when it runs. Until then it costs about 143 tokens; SKILL.md has 945 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from charlie947/social-media-skills at commit 8cefb5b, republished under its MIT licence (© charlie947). 945 words, ~1,845 tokens.
Download SKILL.mdSave it as
.claude/skills/analytics-dashboard/SKILL.md (or your agent's skills folder).- name
- analytics-dashboard
- description
- Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations. Reads every sheet in the export, builds charts for engagement trend, follower growth, post performance scatter, day-of-week heatmap, and audience breakdown. Use this skill whenever the user says "analyse my linkedin", "linkedin analytics", "build my dashboard", "review my performance", or uploads a LinkedIn Analytics export file. Requires the user's LinkedIn Analytics export (xlsx) as input.
Analytics Dashboard
Codex and Claude runtime
- Use this skill in Codex or Claude with the tools actually available in the current task.
AskUserQuestionexamples describe the questions, not a required API: use an available question tool within its limits, or ask in chat. Reuse answers and source material already supplied. - Work in the user-selected project. Read its
about-me.md,voice.mdand relevant brand files before personalised work. Confirm the intended author if files conflict or contain starter defaults. Ask for missing facts or runvoice-builder; never inherit the maintainer's identity, accounts or private files. - Resolve bundled
references/relative to this skill folder. For an explicitly requested profile refresh, read and update the canonicalabout-me.md,voice.mdornewsletter-voice.mdin place, preserving unrelated user facts and rules. Consumers must reread those canonical files. Use a new filename only for new deliverables that would collide with unrelated existing files. Installation alone never starts an interview or writes files. Do not write persistent learnings unless requested. - Use supplied evidence first. Verify external claims through available search/source tools when needed. If a source or integration is unavailable, name the missing capability and offer supplied text/export input. Never invent facts, first-person experience, metrics or a successful tool run.
- Connect only services needed for the chosen route through the user's existing account. Never print credentials or overwrite connections. Drafting, saving and reviewing do not authorise publishing, sending messages or changing accounts.
CRITICAL: Auto-start on load
When this skill triggers, go straight to Step 1.
Step 1. Get the export file
Ask:
Upload your LinkedIn Analytics export file (xlsx).
Not sure how to get it? Go to LinkedIn Analytics, set your date range (30, 60, or 90 days works well), and click Export in the top right.
Wait for the file upload.
Step 2. Parse the data
Read every sheet in the file. Confirm author, reporting window, units and actual column names before calculating. The following sheets are examples, not a guaranteed export schema:
- DISCOVERY: overall impressions and reach
- ENGAGEMENT: daily impressions and engagements over time
- TOP POSTS: top 50 posts, ranked by engagements and by impressions (two tables to merge)
- FOLLOWERS: daily new followers plus total count
- DEMOGRAPHICS: job titles, locations, industries, seniority, company size, top companies
Top-post tables are selected samples, not the account’s entire posting history. Keep their denominators separate from account-wide metrics; do not infer best posting times from daily aggregates. Clean any messy headers. Merge the two TOP POSTS tables (by engagements and by impressions) into one unified dataset per post. De-duplicate.
Step 3. Build the interactive dashboard
Use a supported React artifact surface or the selected project’s existing React and Recharts setup. If neither is available, provide the computed analysis and React source with preview pending; do not silently install dependencies or claim an interactive dashboard is running. Preview and exercise chart tooltips/resizing before calling it verified. Dark theme (background #0f1117), accent colours for charts. Use Recharts for all visualisations.
Include these panels in this order:
Headline metrics (top row cards)
- Total impressions
- Total reach
- Total new followers
- Average daily impressions
- Average daily engagements
- Overall engagement rate (sum of engagements / sum of impressions, for the same reporting window). Zero or missing denominators are unavailable, not zero.
- Total posts tracked
Engagement trend (line chart)
- Daily impressions (left y-axis) and engagements (right y-axis) over the full date range
- Highlight the top 3 spike days with markers
Show full SKILL.md (384 more words)Show less
Follower growth (area chart)
- Daily new followers
- 7-day moving average trendline overlaid
- Cumulative follower gain
Post performance scatter
- X axis: impressions. Y axis: engagements
- Colour-code posts into four quadrants:
- Stars: high reach + high engagement
- Viral but shallow: high reach + low engagement
- Niche gold: low reach + high engagement
- Underperformers: low reach + low engagement
- Hoverable dots showing post URL and date
Day-of-week heatmap
- Average impressions and engagements by day of week
- Highlight the strongest days
Audience breakdown (bar charts)
- Job titles
- Industries
- Seniority
- Company size
- Top locations
Formatting rules
- Format numbers:
67Knot67000,1.2Mnot1200000 - Total follower count prominent at the top
- Responsive layout (works on laptop and large display)
- Dark background, high contrast chart colours
Step 4. Written strategic analysis
Below the dashboard, write a concise analysis with these sections:
Performance Summary
- Trajectory: growing, plateauing, or declining (use trendlines)
- Current engagement rate; compare external benchmarks only with a verified dated source and matching metric definition
Top Post Patterns
- Analyse top 10 by impressions and top 10 by engagements
- Patterns: posting day, time of month, content themes
- High impressions + low engagement: what does that signal?
- Low impressions + high engagement: what does that signal?
Audience-Content Fit
- Who the core audience is, based on demographics
- Which content topics and formats would resonate
- Segments to lean into or away from
Growth Velocity
- Average daily follower growth
- 30, 60, 90 day scenarios at current pace, labelled as extrapolations rather than forecasts
- Acceleration or deceleration trends
Day and Timing Strategy
- Best days for impressions
- Best days for engagement
- Optimal posting schedule based on the data
5 Specific Content Recommendations
Each one includes:
- Content angle or topic
- Why the data supports it
- Which audience segment it targets
- Evidence and a testable hypothesis, without guaranteed impact
Step 5. Offer the next move
After the analysis:
Want me to draft one of these 5 recommendations as a full post? Call the post-writer or post-formatter skill with the recommendation number.
Rules
- Use numbers, not adjectives. "Engagement rate is 2.3%" beats "engagement is healthy".
- Keep the analysis direct. No fluff, no filler.
- Never invent metrics not present in the export.
- Flag data quality issues (missing columns, odd date ranges) instead of silently working around them.
- Never use em dashes.
- British English unless voice.md specifies otherwise.
- Recommend running this monthly. Patterns only surface over time.
© charlie947, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in skills/analytics-dashboard of charlie947/social-media-skills.
Open the folder on GitHubat commit 8cefb5b
Compare with similar skills
Analytics Dashboard next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Analytics Dashboard this skillcharlie947/social-media-skills | 3.8k | — | ~1.8k | Automated safety check: Pass | MIT | |
| open-sheet Workbook Authoringlianghsun/open-sheet | 127 | — | ~2.1k | Automated safety check: Pass | MIT | |
| Apply Sheet Viewer Commentslianghsun/open-sheet | 127 | — | ~377 | Automated safety check: Pass | MIT | |
| Open-Sheet Workbook Creatorlianghsun/open-sheet | 127 | — | ~1.4k | Automated safety check: Pass | MIT | |
| MarkitdownImCa0/just-laws | 781 | 14 repos | ~3.2k | Automated safety check: Notes | MIT | |
| Data Table Managern8n-io/n8n | 207k | — | ~2.3k | Automated safety check: Pass | Custom licence |
Similar skills
Apply Sheet Viewer Comments
lianghsun/open-sheet
Finds every @sheet-comment marker left through the open-sheet viewer in a workbook's source, makes the edit each one asks for, and removes the marker.
Open-Sheet Workbook Creator
lianghsun/open-sheet
Walks an agent through building a new spreadsheet workbook in an open-sheet project, from choosing a theme to settling the real numbers and workbook type.
Markitdown
ImCa0/just-laws
Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.
- Official
Data Table Manager
n8n-io/n8n
Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.
Docx4j
plutext/docx4j
A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…
More from charlie947/social-media-skills
All 15 skills in this repoNewsletter Voice
charlie947/social-media-skills
Build newsletter writing instructions inside a Codex or Claude project.
Voice Builder
charlie947/social-media-skills
Build a personalised voice profile inside a Codex or Claude project from a short interview plus 3 to 5 sample pieces of writing.
Content Matrix
charlie947/social-media-skills
Generate 24 to 40 LinkedIn post ideas in a single table by pairing the user's content pillars with 8 proven content formats.
Gemini Carousel
charlie947/social-media-skills
Generate a branded slide-by-slide LinkedIn carousel using Gemini.
Hook Generator
charlie947/social-media-skills
Generate 6 clickbait-style LinkedIn hook variations for any topic.
Niche Research
charlie947/social-media-skills
Surface the 20 most relevant stories in a niche from the last 7 days using available live research tools.
Related
Works with
Categories
Questions about Analytics Dashboard
What does Analytics Dashboard do?
Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations. Analytics Dashboard is an agent skill from charlie947/social-media-skills. Turn a LinkedIn Analytics export into an interactive dark-themed React dashboard plus a written strategic analysis with 5 data-backed content recommendations.
When should I use Analytics Dashboard?
Analytics Dashboard fits situations like: the user says analyse my linkedin; linkedin analytics; build my dashboard; review my performance.
How do I install Analytics Dashboard in Claude Code?
Run `npx skills add charlie947/social-media-skills --skill analytics-dashboard -a claude-code`. Or copy the skill folder (skills/analytics-dashboard in charlie947/social-media-skills) into .claude/skills/analytics-dashboard in your project. Claude Code loads it when a task matches its description.
How do I install Analytics Dashboard in Codex?
Run `npx skills add charlie947/social-media-skills --skill analytics-dashboard -a codex`. Or copy the skill folder (skills/analytics-dashboard in charlie947/social-media-skills) into .agents/skills/analytics-dashboard in your project. Codex loads it when a task matches its description.
Can I use Analytics Dashboard in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add charlie947/social-media-skills --skill analytics-dashboard -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/analytics-dashboard, .gemini/skills/analytics-dashboard, .github/skills/analytics-dashboard and .opencode/skills/analytics-dashboard in your project.
What does Analytics Dashboard need to run?
SKILL.md names no scripts, command-line tools or credentials: Analytics Dashboard is instructions for the agent only.
Does Analytics Dashboard access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Analytics Dashboard safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Analytics Dashboard use?
Analytics Dashboard is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Analytics Dashboard use?
About 1.8k tokens (SKILL.md is roughly 7.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Analytics Dashboard?
Skills that share tags, products or a category with Analytics Dashboard: open-sheet Workbook Authoring (lianghsun/open-sheet, 127 stars), Apply Sheet Viewer Comments (lianghsun/open-sheet, 127 stars), Open-Sheet Workbook Creator (lianghsun/open-sheet, 127 stars) and Markitdown (ImCa0/just-laws, 781 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Analytics Dashboard?
charlie947 (a GitHub user) maintains it in charlie947/social-media-skills, which has 3,844 GitHub stars. The repository holds 15 skills in this directory. The repository was last updated on September 15, 2026.
Source: charlie947/social-media-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.