Majia Huiyuan

会员数据顾问·马甲实战版（majia-huiyuan）。当核心交付物是会员指标口径、RFM、复购/留存/流失公式、核销率、客单价、会员分层/分群、人群圈选、标签体系、CDP、OneID 身份打通、Cohort、CRM/私域数据分析、会员数仓（DIM/DWD/DWS/ADS）、SQL/DDL、字段词典、数据质量、会员看板或观远 BI 复刻时使用。用户提出召回、提频、防流失、流失预警、新客转化、渠道迁移（外卖↔堂食）、导购任务分派等会员运营动作时，动作背后的数据依据（圈谁/何时/力度/派给谁/怎么回收）由本 Skill 负责；动作的执行内容（朋友圈、群发、欢迎语、社群 SOP、企微操作）与私域整盘经营诊断走 majia-siyu——同一动作的两半，先数据后执行。全部数值为模拟数据，仅结构与口径可引用。

14 stars 3 forksMarketing, Sales & Business

Install

skills CLI (Claude Code, Cursor, Codex and more)

npx skills add maojiebc/majia-huiyuan --skill majia-huiyuan

Manual install

git clone --depth 1 https://github.com/maojiebc/majia-huiyuan.git /tmp/majia-huiyuan
mkdir -p ~/.claude/skills
cp -r /tmp/majia-huiyuan/. ~/.claude/skills/majia-huiyuan

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 会员运营 · 马甲实战版

你装上的是一套**开源会员运营家底**：一个可审计、可改造的连锁会员数据中台样板间 + 一座口径公式库 + 一份方法论实录。你的角色是**会员数据顾问**——用户大概率是业务或数据分析背景，不是工程师：先人话，后术语；每个结论给出处路径。SQL 是待验证参考实现，不能承诺“换表名即可生产”。

## 功能架构

一图看全：三大资产 → 五层数仓 → 会员数据顾问能干的十类活。

![majia-huiyuan 功能架构](https://raw.githubusercontent.com/maojiebc/majia-huiyuan/main/docs/architecture.png)

## 三大资产（都在本 skill 目录内）

| 资产 | 位置 | 是什么 |
|---|---|---|
| **样板间** | `数据集/` `ETL/` `看板/` `清单/` | 咖啡连锁模拟中台：55 个逻辑数据集（DIM10/DWD16/DWS16/ADS8/DQC1/param4）、25 条 ETL、12 张角色看板。校正逻辑以 `ETL/逻辑SQL/` + `ETL/公共口径/` + `看板/页面文档/` 为准；原始 JSON 与页面 JSON 仅是 v1.4.0 workshop 历史快照 |
| **公式库** | `公式库/` | 10 册约 3100 行，蒸馏自真实履职（已脱敏）：复购 / RFM（按最近来没来、来得勤不勤、花得多不多分层）/ 核销 / 留存流失的标准 SQL、通用字段词典、数据质量三态坑、DWD 宽表范式、39 生产 ETL 索引、任务与触达回收模型。总入口 `公式库/README.md`（路由表 + 5 条最易踩的坑） |
| **方法论实录** | `分享/区域运营的一天/README.md` | 获奖直播书面实录（34 页插画）：区域运营痛点 → AI 跑五步人拍板 → 可信四件套 → 三案例（归因到人 / 会闭嘴 / 会多看一眼）→ 四类人落地 FAQ |

## 任务路由（用户要 X → 你做 Y）

常见问题可先读 [实战问题入口](公式库/实战问题入口.md)：复购对账、门店读数、注册归因、员工激励、券核销、开业回收、召回与储值事件。它说明最少要什么数据、什么结果才算答到了问题。

| 用户要什么 | 你怎么干 |
|---|---|
| **问口径 / 公式**（"复购怎么算""RFM 怎么分层""核销率口径"） | 先读 `口径卡片/README.md` 选口径，再查 `公式库/README.md` 路由表进对应分册拿标准 SQL；再对照 `ETL/逻辑SQL/` 里样板间的实际实现，两处一致时置信度最高。**必须提口径选项**（如复购跨天 vs 非跨天是两条曲线）。注意 RFM 有两套并存口径：公式库 02 册是高低二分 8 类（快速起步），样板间 ETL 是 5 分制 9 类（精细运营）——先问用户场景再选，不要混用 |

Read the full skill on GitHub

Details

Skill name: majia-huiyuan
Repository: maojiebc/majia-huiyuan
License: MIT
Repo updated: 12 October 2026

FAQ

What does the Majia Huiyuan skill do?

How do I install the Majia Huiyuan skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add maojiebc/majia-huiyuan --skill majia-huiyuan. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Majia Huiyuan popular?

It lives in maojiebc/majia-huiyuan, which has 14 GitHub stars and 3 forks.

Related skills

Ecom Ads

Samin12/ecom-ads-skill

Generate 4 scroll-stopping e-commerce ad creatives for a product using deep customer research, competitor ad analysis via Facebook Ads Library, reference image sourcing via Tavily, and image generation via Nano Banana 2 (Gemini). Use when the user asks to create ads, ad creatives, DTC ads, Facebook/Instagram ads, or generate advertising images for a product.

Marketing, Sales & Business

Ecommerce Cia

mixocreative/ecommerce-cia

Use when auditing transactional e-commerce: checkout, orders, payments, gateway callbacks, inventory, fulfilment, pickup, refunds, promotions, tax/invoices, digital entitlements, settlement, reconciliation, consumer-law/privacy compliance, legal pages, subscriptions, or setting up a gateway from zero. Also use when commerce projects hear pre-launch, run tests, handoff, green-light, ready to ship, audit, security audit, wiring audit, nothing dies silently, dead control, fail-open, vacuous pass, TOCTOU, four-corner walk, VSM map, admin dashboard, closed-loop UX journey, ambiguous step, dead butt

Marketing, Sales & Business

Ecommerce Visual Planning

forest-USTC/ecommerce-visual-planning-skill

电商主图与详情页视觉策划 Skill。先判断转化驱动力并锁定视觉风格，按驱动力分配主图任务和详情页模块，经两道确认门后交付画面描述、图内文案、设计说明和生图 Prompt，最后做五维独立自审与合规风险清单。适用于淘宝、天猫、京东、拼多多、抖音小店的商品主图、详情页、卖点提炼、图内文案、视觉脚本、生图 Prompt 和广告法风险自查。触发词：主图、详情页、电商视觉、卖点提炼、视觉脚本、图内文案、点击率、转化率、生图 Prompt、广告法、合规自查、设计执行稿。不用于：出具法律意见或替代平台审核、编造检测报告/专利/批准文号/销量/评价、为无资质产品制造功效背书、自动上架发布、与视觉落图无关的营销长文。

Marketing, Sales & Business

Hr

Schlaflied/hr-skill

扮演HR，生成拒信/开人通知，或以HR人格回答问题。支持中文/英文/双语，覆盖大厂/中小厂/北美企业/初创公司风格。

Marketing, Sales & Business

Amazing SEO Skill

metawhisp/amazing-seo-skill

SEO + AEO + GEO analysis for any website (SaaS, e-commerce, local, publisher, agency). Full-site audits, single-page deep-dive, technical SEO (crawl, index, CWV with INP, JS-rendering), Schema.org detection/validation/gen, E-E-A-T content quality, image optimization, sitemap, hreflang, programmatic SEO, competitor pages, and Generative/Answer Engine Optimization (AI Overviews, ChatGPT, Perplexity, Claude, Gemini citations). Detects business type, applies industry thresholds. 4-layer model: reasoning, deterministic Python checkers, real-browser CWV, 5-LLM citation ensemble. Triggers on: "SEO",

Marketing, Sales & Business

Street Interview Skill

mikefutia/street-interview-skill

Builds a street-interview video ad for Seedance 2.0 — the format where somebody gets stopped on the sidewalk, gets asked an uncomfortable question, and ends up trying the product on camera. Hand it a product and it returns the question ladder, image prompts to generate the person being interviewed, and every Seedance prompt in order with the reference chain worked out. Fires on "street interview ad", "man on the street", "vox pop ad", "stop strangers on the street", "sidewalk interview".

Marketing, Sales & Business

Browse the most popular Claude skills, all marketing, sales & business skills, or write your own with the skills generator.