본문으로 건너뛰기
cccskills
무료GitHub에 공개

weekly-crm-report

Cleans a weekly CRM export and produces a regional sales summary. Activates when the user asks to clean a CRM export, deduplicate sales rows, calculate regional totals, or generate a weekly sales report from a CSV.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

실행 점수 미검증

설치 방법 보기

포함된 파일(22)

  • SKILL.md2.4 KB
  • contracts/data_contract_crm_export/.contract_id10 B
  • contracts/data_contract_crm_export/code/contract_health.py386 B
  • discovery.json2.2 KB
  • evals/golden/case-1/expected.json126 B
  • evals/golden/case-1/input.csv62 B
  • evals/golden/case-2/expected.json129 B
  • evals/golden/case-2/input.csv46 B
  • evals/golden/case-3/expected.json106 B
  • evals/golden/case-3/input.csv39 B
  • evals/weekly-crm-report.eval.md1.8 KB
  • README.md1.7 KB
  • scripts/dependency_health.py3.9 KB
  • scripts/evolve.py10.2 KB
  • scripts/review_staleness.py6.2 KB
  • scripts/run_evals.py49.4 KB
  • scripts/run_pipeline.py2.3 KB
  • scripts/schema_drift.py7.3 KB
  • scripts/skill_document.py9.8 KB
  • scripts/staleness_check.py7.5 KB
  • scripts/success_ledger.py16.5 KB
  • VERIFICATION.md845 B

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Weekly CRM Report

Turn a raw weekly CRM export (CSV) into a clean regional sales summary: drop duplicate rows, total revenue per region, and emit a structured JSON summary an agent can narrate or hand to a PDF/dashboard step.

This is a bundled example skill — small but real, and used to demonstrate the creator's validation, pipeline, and eval-rollout machinery end to end.

Activation

Activates on requests like "clean this CRM export", "weekly sales report", "regional totals from this CSV". Do not activate on general spreadsheet or analytics questions that don't involve a CRM export.

Input

A CSV with at least region and amount columns (extra columns are ignored). Duplicate rows (identical across all columns) are removed before totalling.

Run

One command produces the summary:

python3 scripts/run_pipeline.py --input <export.csv> --output summary.json

Output JSON shape:

{
  "rows_in": 120,
  "rows_after_dedup": 118,
  "regions": {"West": 40210.5, "East": 38110.0},
  "grand_total": 78320.5
}

Gotchas

  • rows_after_dedup does not reconcile with grand_total. Rows with a blank or missing region are skipped when totalling but still counted in rows_after_dedup, so a CSV with unassigned rows reports more rows than it actually summed. Do not present the two numbers as if one explains the other — if they must reconcile, filter blank regions before running.
  • An unparseable amount silently becomes 0.0, it does not raise. A column of N/A or — produces a region total of 0.0 that looks like a real zero. Check the input for non-numeric amounts before trusting a suspiciously low total.
  • Dedup compares every column, not just region and amount. Two rows with identical sales data but a differing timestamp or record-ID column are both kept. The "extra columns are ignored" note above applies to totalling, not to dedup.

Anti-goals

  • Not a general BI tool; it totals one numeric column per region.
  • Does not fetch from a live CRM API; it operates on an exported CSV.

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

Create cross-platform agent skills from workflow descriptions. Activates when users ask to create an agent, automate a repetitive workflow, create a custom skill, or need advanced agent creation. Triggers on phrases like create agent for, automate workflow, create skill for, every day I have to, daily I need to, turn process into agent, need to automate, create a cross-platform skill, validate this skill, export this skill, migrate this skill, audit this skill, is this skill safe, vet a skill before installing, what does this skill access. Supports single skills, multi-agent suites, transcript processing, template-based creation, interactive configuration, cross-platform export, spec validation, and security auditing of third-party skills before install.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

FrancyJGLisboa/agent-skills-platform2.4천2026년 9월 16일 업데이트

Create a source-linked briefing for the latest published GitHub release of a public repository. Use for engineering teams tracking a dependency release; do not use it to publish releases or change repositories.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

FrancyJGLisboa/agent-skills-platform2.4천2026년 9월 16일 업데이트

Create a current, source-linked weather briefing for a named city using the Open-Meteo geocoding and forecast APIs. Activate for requests such as "what is the weather in Sao Paulo?", "prepare a current weather briefing for Tokyo", or "get today's live conditions for New York". Do not use for travel booking, weather alerts, historical climatology, or safety-critical decisions.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

FrancyJGLisboa/agent-skills-platform2.4천2026년 9월 16일 업데이트

Summarizes open pull requests into a blockers-first standup digest. Activates when the user asks to summarize open PRs, find blocked pull requests, generate a PR standup, or triage review backlog from a PR export.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

FrancyJGLisboa/agent-skills-platform2.4천2026년 9월 16일 업데이트

Provides comprehensive technical analysis for stocks and ETFs using RSI, MACD, Bollinger Bands, and other indicators. Activates when user requests stock analysis, technical indicators, trading signals, or market data for specific ticker symbols.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

FrancyJGLisboa/agent-skills-platform2.4천2026년 9월 16일 업데이트

FrancyJGLisboa의 스킬 모두 보기

이 스킬의 문제 신고