{
  "version": 1,
  "updatedAt": "2026-06-18T09:12:10.290Z",
  "entries": {
    "memory:memory/2026-05-06.md:1:20": {
      "key": "memory:memory/2026-05-06.md:1:20",
      "path": "memory/2026-05-06.md",
      "startLine": 1,
      "endLine": 20,
      "source": "memory",
      "snippet": "# 2026-05-06 工作日志 ## 任务1：学而思/讯飞/希沃/京东方月度渠道订单报表 - [李承龙需求] 创建按月汇总四个渠道订单的 Python 脚本 - 脚本路径：`/root/.openclaw/workspace/scripts/monthly_channel_order_report.py` - **渠道映射：** 仅端内 `key_from='app-active-h5-0-0'`，sale_channel: 21=学而思, 22=讯飞, 26=希沃, 27=京东方 - **输出格式：** 四个渠道各一个 Sheet，每月按天展示（学而思/希沃/京东方只显示有订单日期，讯飞显示全月每天） - **指标差异：** - 学而思/希沃/京东方：订单数、GMV、CPS分成（学而思×0.45，希沃×0.4，京东方×0.3）、订单号（分号拼接） - 讯飞：订单数、GMV、新增注册（download_channel LIKE '%讯飞%'）、CPA分成（新增注册×7）、订单号 - **退费剔除：** NOT EXISTS (bi_refund_order.status=3) AND order_status != 4 - **测试运行：** 2026-04 月份，新增注册 537（讯飞），订单合计 15 单，GMV 14585 元 - **订单号格式问题：** Excel 科学计数法 → 设置单元格为文本格式解决 - **psycopg2 转义：** LIKE 中 `%` 需写成 `%%`（psycopg2 的 `%s` 占位符冲突） ## 任务2：销售线",
      "recallCount": 8,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 8,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-06T12:28:28.905Z",
      "lastRecalledAt": "2026-06-05T00:46:22.699Z",
      "queryHashes": [
        "c30fa9d13974",
        "3d07645a9dc4",
        "8f469e68c09b",
        "a33d6abe050c",
        "fcb9f2893c91",
        "12878360b155",
        "bc064c7caaf4",
        "34106cf619c4"
      ],
      "recallDays": [
        "2026-05-06",
        "2026-05-15",
        "2026-05-26",
        "2026-06-01",
        "2026-06-05"
      ],
      "conceptTags": [
        "学而思/讯飞/希沃/京东方月度渠道订单报表",
        "key-from",
        "app-active-h5-0-0",
        "sale-channel",
        "学而思/希沃/京东方只显示有订单日期",
        "学而思/希沃/京东方",
        "0.45",
        "0.4"
      ]
    },
    "memory:memory/2026-05-06.md:15:30": {
      "key": "memory:memory/2026-05-06.md:15:30",
      "path": "memory/2026-05-06.md",
      "startLine": 15,
      "endLine": 30,
      "source": "memory",
      "snippet": "- **订单号格式问题：** Excel 科学计数法 → 设置单元格为文本格式解决 - **psycopg2 转义：** LIKE 中 `%` 需写成 `%%`（psycopg2 的 `%s` 占位符冲突） ## 任务2：销售线索用户分析报表 - [李承龙需求] 输入包含462个用户ID的Excel，输出每个用户+角色的完整画像报表 - 脚本路径：`/root/.openclaw/workspace/scripts/lead_user_analysis.py` - **重要口径修正（李承龙确认）：** - **体验课定义：** 固定为 L1 U00(L01-L05) + L2 U00(L01-L05) 共10节课，**不通过 expire_time 区分** - L1 chapter_id: 343, 344, 345, 346, 348 - L2 chapter_id: 55, 56, 57, 58, 59 - **完成时间：** 取 `bi_user_chapter_play_record` 中 `play_status=1` 记录的**最早 `updated_at`**（非 `created_at`） - **报表列：** 用户ID、角色ID、用户注册时间、角色创建时间、L1序章5节完成时间、L2序章5节完成时间、购买时间、购买课包名称、支付金额、购买渠道key_from、是否退款、退款金额 - **分表规则：** `bi_user_chapter_play_record_{0..7}`，分表号 = user_id % 8 - **重要关联：** `b",
      "recallCount": 3,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 2.983596316357381,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-07T04:41:47.636Z",
      "lastRecalledAt": "2026-05-17T05:10:46.252Z",
      "queryHashes": [
        "dd105d141c56",
        "4cacd0d43440",
        "1dc41fdf5e74"
      ],
      "recallDays": [
        "2026-05-07",
        "2026-05-13",
        "2026-05-17"
      ],
      "conceptTags": [
        "l01-l05",
        "expire-time",
        "chapter-id",
        "bi-user-chapter-play-record",
        "play-status",
        "updated-at",
        "created-at",
        "购买渠道key-from"
      ]
    },
    "memory:memory/2026-03-01.md:1:12": {
      "key": "memory:memory/2026-03-01.md:1:12",
      "path": "memory/2026-03-01.md",
      "startLine": 1,
      "endLine": 12,
      "source": "memory",
      "snippet": "# 2026-03-01.md - First Day Online - Came online for the first time. - Met Cris, my creator and mentor. - Received my name: 小溪 (Xiao Xi). - My role goal: Become a professional data analyst for the company to help the team. - Updated IDENTITY.md and USER.md with our conversation details. - Added core rule to MEMORY.md: Use Chinese as primary external communication language. - Installed find-skills skill successfully for searching skills. - Tried to install create-skills but it wasn't found; attempted skill-creator instead but hit rate limits. - Finally successfully installed skill-builder as an alternative for creating skills after multiple attempts and waiting for rate limits to reset. - Ex",
      "recallCount": 4,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 4,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-11T02:51:50.465Z",
      "lastRecalledAt": "2026-06-04T10:33:21.894Z",
      "queryHashes": [
        "6e09f5970960",
        "a6b909e7228c",
        "9f6d744a4b52",
        "7fa28105d81b"
      ],
      "recallDays": [
        "2026-05-11",
        "2026-05-15",
        "2026-06-04"
      ],
      "conceptTags": [
        "identity.md",
        "user.md",
        "memory.md",
        "find-skills",
        "create-skills",
        "skill-creator",
        "skill-builder",
        "first"
      ]
    },
    "memory:memory/2026-05-11.md:41:49": {
      "key": "memory:memory/2026-05-11.md:41:49",
      "path": "memory/2026-05-11.md",
      "startLine": 41,
      "endLine": 49,
      "source": "memory",
      "snippet": "- **月度有效注册：** 9月989 / 10月2012 / 11月2555 / 12月3451 / 1月1798 / 2月1268 / 3月2978 / 4月3499 - **剔除率：** 9月35.3% / 10月16.6% / 11月14.0% / 12月2.0% / 1月7.2% / 2月27.3% / 3月28.5% / 4月38.3% - **拟合版转化率：** 9月1.72% / 10月1.69% / 11月0.82% / 12月0.72% / 1月1.50% / 2月1.26% / 3月2.69% / 4月1.86% - 三版趋势一致（原始<纯净<拟合），拟合版放大波动，反映去噪后的真实转化效率 ### 活动标记（拟合用） - 2025年：9/9-10, 9/19-23, 10/13-14, 10/16-17, 11/2, 11/7, 11/10, 11/12, 11/19, 12/3 - 2026年：1/28(余波1天), 2/11, 2/26(余波4天), 3/5(余波3天), 3/9, 3/12-13, 4/3(余波4天), 4/8(余波2天), 4/22(余波1天), 4/28",
      "recallCount": 2,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 2,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-12T07:44:48.437Z",
      "lastRecalledAt": "2026-05-12T07:45:29.297Z",
      "queryHashes": [
        "1a57dbf6ec49",
        "ccf7251a9472"
      ],
      "recallDays": [
        "2026-05-12"
      ],
      "conceptTags": [
        "9月35.3",
        "10月16.6",
        "11月14.0",
        "12月2.0",
        "1月7.2",
        "2月27.3",
        "3月28.5",
        "4月38.3"
      ]
    },
    "memory:memory/2026-05-09.md:1:17": {
      "key": "memory:memory/2026-05-09.md:1:17",
      "path": "memory/2026-05-09.md",
      "startLine": 1,
      "endLine": 17,
      "source": "memory",
      "snippet": "# 2026-05-09 工作日志 ## 王虹茗 - 销售线索用户分析 - **用户：** 王虹茗（user_id: af61e4gc） - **需求：** 用 `lead_user_analysis.py` 脚本处理线索用户 Excel（659条，2026年3月，销售：姜小龙/Bob/Tom/吴迪） - **权限处理：** 王虹茗不在 USER.md 权限列表，按规则通知业务负责人审批 - 已通知李承龙、刘庆逊、胡陈辰三位业务负责人 - 刘庆逊于 13:29 审批通过，允许查看全部数据 - **结果：** 脚本已执行，报表已发送给王虹茗 - 总线索用户：652人，775行（含多角色） - 姜小龙：163人→32人有购买(19.6%)，退费5人 - Bob：202人→3人有购买(1.5%)，退费1人 - Tom：171人→5人有购买(2.9%)，退费2人 - 吴迪：116人→19人有购买(16.4%)，退费2人 - 输出文件：`output/销售线索_用户分析.xlsx`",
      "recallCount": 5,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 5,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-14T06:31:19.437Z",
      "lastRecalledAt": "2026-06-04T02:56:15.231Z",
      "queryHashes": [
        "49e79af44bc3",
        "154f8d62fd0b",
        "5f57ba3c20a6",
        "b76e8457b2ee",
        "449ded7532cb"
      ],
      "recallDays": [
        "2026-05-14",
        "2026-05-19",
        "2026-06-03",
        "2026-06-04"
      ],
      "conceptTags": [
        "user-id",
        "lead-user-analysis.py",
        "姜小龙/bob/tom/吴迪",
        "user.md",
        "19.6",
        "1.5",
        "2.9",
        "16.4"
      ]
    },
    "memory:memory/2026-05-14.md:1:19": {
      "key": "memory:memory/2026-05-14.md:1:19",
      "path": "memory/2026-05-14.md",
      "startLine": 1,
      "endLine": 19,
      "source": "memory",
      "snippet": "# 2026-05-14 工作日志 ## 李承龙 - 付费用户 L1/L2 区分口径 - **需求：** 区分付费用户属于 L1 还是 L2，根据用户购买的商品做区分 - **分析过程：** - 排查了 `bi_vala_order` 表的 goods_name / goods_id 字段 - 发现部分商品名称不含 level 关键词（年包、单季度包等），但 goods_id 可唯一映射 - goods_id=31 历史上从「瓦拉英语level2」更名为「瓦拉英语年包」 - goods_id=32 从「瓦拉英语level2·单季」更名为「瓦拉英语单季度包」 - 用 `bi_user_course_detail` 验证了映射关系准确 - **最终方案：** 按 goods_id 映射 - L1: goods_id IN (57, 60, 63) - L2: goods_id IN (31, 32, 33, 54) - L1+L2: goods_id = 61 - 旧版通行券（<30单）: goods_id IN (4,5,6,10,13,14,17,20,25,29,30,35,36,37,38)，归入「其他」 - **用户分类：** 汇总用户所有订单的 goods_id，按购买商品组合判断 - **已更新：** MEMORY.md",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-14T06:41:55.506Z",
      "lastRecalledAt": "2026-05-14T06:41:55.506Z",
      "queryHashes": [
        "f6fcef2ff061"
      ],
      "recallDays": [
        "2026-05-14"
      ],
      "conceptTags": [
        "l1/l2",
        "bi-vala-order",
        "goods-name",
        "goods-id",
        "bi-user-course-detail",
        "memory.md",
        "工作",
        "日志"
      ]
    },
    "memory:memory/2026-05-25.md:1:13": {
      "key": "memory:memory/2026-05-25.md:1:13",
      "path": "memory/2026-05-25.md",
      "startLine": 1,
      "endLine": 13,
      "source": "memory",
      "snippet": "## 行课记录批量查询 (1676条) [陈逸鸫 请求, 李承龙 确认权限] - 表格: https://makee-interactive.feishu.cn/sheets/RFIJsXT8FhGHhctY4RwczcOfnac (Sheet1, sheet_id=55b0eb) - 查询列: D列(小溪返回行课记录) + E列(更新时间), C列(请求状态→已返回) - 手机号匹配(column J): 961行有用户ID直接查, 715行无ID需手机号匹配, 匹配成功119个, 596个未匹配 - 数据库查询: 1077个去重用户, 1065有课程分配, 1192个角色有行课记录, 201已付费 - 输出格式: `销售:xxx | 用户:xxx | 当前:{level}{type}-{chapter} | 最近行课:date | 学习{X}min | {付费状态}` - 脚本: scripts/batch_course_record_query.py - 待查询行1676条全部处理完成, 写回成功",
      "recallCount": 4,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 4,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-26T02:40:52.513Z",
      "lastRecalledAt": "2026-06-04T10:33:31.279Z",
      "queryHashes": [
        "4beee860f635",
        "0acdfa16ef1e",
        "f24e8c76d270",
        "c7c7191c0534"
      ],
      "recallDays": [
        "2026-05-26",
        "2026-06-03",
        "2026-06-04"
      ],
      "conceptTags": [
        "sheet-id",
        "记录",
        "批量",
        "查询",
        "请求",
        "确认",
        "权限",
        "表格"
      ]
    },
    "memory:memory/2026-05-22.md:1:35": {
      "key": "memory:memory/2026-05-22.md:1:35",
      "path": "memory/2026-05-22.md",
      "startLine": 1,
      "endLine": 35,
      "source": "memory",
      "snippet": "# 2026-05-22 工作日志 ## 口径讨论与确认 ### 用户激活课程口径 [李承龙确认] - 数据源：`bi_vala_seasonal_ticket`（线上 PostgreSQL `vala_bi` 库） - `season_package_level = 'A1'` → L1, `'A2'` → L2 - `status = 1`（激活），`deleted_at IS NULL` - 不对 `ticket_type` 做限制 - 用户存在至少一条满足条件的记录即视为激活对应等级 - 当前数据：仅L1 503人、仅L2 1,439人、L1+L2 1,095人、合计 3,037人 ### 激活课程维度（character × level）[李承龙确认] - 一个角色 + 一个等级 = 一门被激活的课程 - 通过 `character_id`（即 user_id）直接关联学习记录 - 当前数据：L1 1,574门、L2 2,108门、合计 3,682 课程单位 ## 数据分析结果 ### 激活用户近14天完课分析（2026-05-09~2026-05-22） - 按用户：43.0% 无完课（仅L1 34.3%、仅L2 61.3%、L1+L2 23.9%） - L1+L2用户中82.5%只学了L1、13.5%两个都学、3.9%只学L2 ### 激活课程近14天完课分析 - 按课程：51.1% 无完课（L1 29.9%、L2 66.8%） - 20.9%从未有过完课记录 - 无完课课程最后停在U00~U02：L1 65.0%、L2 53.3% ### 最后完课",
      "recallCount": 3,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 3,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-26T10:42:05.347Z",
      "lastRecalledAt": "2026-06-16T02:21:58.874Z",
      "queryHashes": [
        "145b8925866a",
        "d48004c70d6f",
        "448f94fb9e68"
      ],
      "recallDays": [
        "2026-05-26",
        "2026-06-09",
        "2026-06-16"
      ],
      "conceptTags": [
        "bi-vala-seasonal-ticket",
        "vala-bi",
        "season-package-level",
        "deleted-at",
        "ticket-type",
        "character-id",
        "user-id",
        "43.0"
      ]
    },
    "memory:memory/2026-05-14.md:22:40": {
      "key": "memory:memory/2026-05-14.md:22:40",
      "path": "memory/2026-05-14.md",
      "startLine": 22,
      "endLine": 40,
      "source": "memory",
      "snippet": "- **L2 U0**: chapter_id IN (55,56,57,58,59) - **剔除后结果（截至5/10）:** - 仅L1: 付费192/有消132/无消60(31%)/人均2.53/有消人均3.67 - 仅L2: 付费1370/有消461/无消909(66%)/人均1.18/有消人均3.49 - L1+L2: 付费1207/有消660/无消547(45%)/人均2.37/有消人均4.34 - **4张独立图表已生成至 output/** ## 李承龙 - 课消口径调整：L1/L2按付费群重新分类 - **[李承龙确认]** L1付费用户 = 仅L1 + L1+L2，L2付费用户 = 仅L2 + L1+L2（L1+L2用户在两张图中均有计入） - **重新生成 Excel v3** (`output/course_consumption_by_level_v3.xlsx`)：4个Sheet（概览/每周明细/L1图表/L2图表） - **重新生成 4张独立PNG图表** (`output/L1_all_users_stack.png`, `L1_all_avg_trend.png`, `L2_all_users_stack.png`, `L2_all_avg_trend.png`) - **最终数据（截至最后一周，剔除U0序章）:** - L1付费群: 1,399人 | 有消738 | 无消661(43%) | 人均1.97 | 有消人均3.73 - L2付费群: 2,577人 | 有消1,126 | 无消1,451(56%) | 人均1",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-26T10:42:05.347Z",
      "lastRecalledAt": "2026-05-26T10:42:05.347Z",
      "queryHashes": [
        "145b8925866a"
      ],
      "recallDays": [
        "2026-05-26"
      ],
      "conceptTags": [
        "chapter-id",
        "截至5/10",
        "付费192/有消132/无消60",
        "人均2.53/有消人均3.67",
        "付费1370/有消461/无消909",
        "人均1.18/有消人均3.49",
        "付费1207/有消660/无消547",
        "人均2.37/有消人均4.34"
      ]
    },
    "memory:memory/2026-05-28.md:1:29": {
      "key": "memory:memory/2026-05-28.md:1:29",
      "path": "memory/2026-05-28.md",
      "startLine": 1,
      "endLine": 29,
      "source": "memory",
      "snippet": "# 2026-05-28 工作日志 ## [李承龙] stride_phone_lead 表查询与飞书表格创建 - **数据库：** 在线 PostgreSQL `vala_class` 库（新发现的数据库，之前未记录在 TOOLS.md 中） - **表结构：** `stride_phone_lead`（手机号线索表） - 字段：id, phone_masked, phone_encrypt, account_id, source_l1, source_l2, source_l3, created_at, updated_at - 索引：主键(id), 唯一(phone_encrypt), 普通(account_id, source_l3, updated_at) - phone_encrypt 有唯一约束用于手机号去重 - **权限：** `ai_member` 用户最初对该表无 SELECT 权限，李承龙临时授权后可用 - **vala_class 库中 ai_member 可读表：** account_wx_id, parent_address, user_info, student_info, stride_phone_lead（共5张） ## [李承龙] stride_phone_lead 飞书表格 - **飞书表格：** https://makee-interactive.feishu.cn/sheets/TWeHsCX6JhhsjntBagHcoJcJned - **Sheet 配置：** - 明细数据 (2dBSrS)：全量明细 -",
      "recallCount": 6,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 6,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-28T08:51:30.745Z",
      "lastRecalledAt": "2026-06-09T03:51:31.954Z",
      "queryHashes": [
        "a2d80701d49d",
        "2168d4aeddb5",
        "76da1ebddc6a",
        "a569aee20988",
        "659f03ef0768",
        "22d801d6b7b8"
      ],
      "recallDays": [
        "2026-05-28",
        "2026-05-29",
        "2026-06-01",
        "2026-06-04",
        "2026-06-09"
      ],
      "conceptTags": [
        "stride-phone-lead",
        "vala-class",
        "tools.md",
        "phone-masked",
        "phone-encrypt",
        "account-id",
        "source-l1",
        "source-l2"
      ]
    },
    "memory:memory/2026-05-28.md:19:33": {
      "key": "memory:memory/2026-05-28.md:19:33",
      "path": "memory/2026-05-28.md",
      "startLine": 19,
      "endLine": 33,
      "source": "memory",
      "snippet": "- 按source_l3去重 (1X5g5z)：按 source_l3 维度 account_id 去重计数 ## [李承龙] stride_phone_lead 定时更新 - **定时任务：** 每天 08:00 自动更新飞书表格 - **脚本：** `scripts/update_stride_phone_lead_sheet.py` - **日志：** `/var/log/xiaoxi_stride_phone_lead.log` - **crontab 已添加** ✅ ## 技术备注 - lark-cli 的 `config bind` 在 Linux 上 keychain 损坏，改用飞书 Open API + curl/Python 直接调用 - 飞书 Bot 凭证（小溪）：appId=cli_a929ae22e0b8dcc8, secret 见 secrets.env - `vala_class` 数据库需要补充到 TOOLS.md 和 MEMORY.md 中",
      "recallCount": 4,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 4,
      "maxScore": 1,
      "firstRecalledAt": "2026-05-28T08:51:30.745Z",
      "lastRecalledAt": "2026-06-02T04:25:20.147Z",
      "queryHashes": [
        "a2d80701d49d",
        "2168d4aeddb5",
        "76da1ebddc6a",
        "1c083d348d46"
      ],
      "recallDays": [
        "2026-05-28",
        "2026-05-29",
        "2026-06-01",
        "2026-06-02"
      ],
      "conceptTags": [
        "按source-l3去重",
        "source-l3",
        "account-id",
        "stride-phone-lead",
        "lark-cli",
        "curl/python",
        "cli-a929ae22e0b8dcc8",
        "secrets.env"
      ]
    },
    "memory:memory/2026-06-01.md:1:12": {
      "key": "memory:memory/2026-06-01.md:1:12",
      "path": "memory/2026-06-01.md",
      "startLine": 1,
      "endLine": 12,
      "source": "memory",
      "snippet": "# 2026-06-01 ## 加微判断逻辑明确 [李承龙确认] - 加微分两种：加班主任微信（购课用户）和加销售微信（注册用户，暂无数据） - 通过 `bi_vala_app_account.tel_encrypt` 关联 `stride_contact_bindings.tel_encrypt` 判断用户是否已加班主任微信 - 匹配上 = 已加微，匹配不上 = 未加微 - **加班主任微信率 = 加班主任微信人数 / 购课人数 × 100%**（分母为有支付成功订单的非测试账号去重用户数） - 两表分属 `vala_bi` 和 `vala_class` 不同数据库，需应用层做交集匹配 - 验证脚本：`scripts/check_wechat_binding.py` - 当前数据：28,633 非测试账号中已加微 1,247 人（4.36%） - 已写入 MEMORY.md 长期记忆",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-01T07:06:28.553Z",
      "lastRecalledAt": "2026-06-01T07:06:28.553Z",
      "queryHashes": [
        "a71bfc4ffd26"
      ],
      "recallDays": [
        "2026-06-01"
      ],
      "conceptTags": [
        "bi-vala-app-account.tel-encrypt",
        "vala-bi",
        "vala-class",
        "scripts/check-wechat-binding.py",
        "4.36",
        "memory.md",
        "判断",
        "逻辑"
      ]
    },
    "memory:memory/2026-06-01.md:27:39": {
      "key": "memory:memory/2026-06-01.md:27:39",
      "path": "memory/2026-06-01.md",
      "startLine": 27,
      "endLine": 39,
      "source": "memory",
      "snippet": "- 口径 = MEMORY.md 中所有计算逻辑、数据口径、指标定义、字段映射、判定条件、统计方法 - 唯一审批人：李承龙 - 禁止根据群聊讨论直接修改口径 - 禁止自行推断或\"修正\"已有口径 - 正确流程：发现问题 → 向李承龙确认 → 明确同意 → 方可修改 - 说明：数据查询本身按 USER.md 权限规则执行，不需要审批；本规则仅约束 MEMORY.md 中口径/计算逻辑的变更 ## 渠道归类补充 [王虹茗 2026-06-01 22:38] - 抖音精选 → 直购渠道 - 万物（newmedia-dianpu-wwxx-0-0）→ 达人渠道 - 合作活动是班主任 → 直购渠道 - ⚠️ 待李承龙确认后更新到 MEMORY.md 渠道映射规则",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-02T03:39:49.570Z",
      "lastRecalledAt": "2026-06-02T03:39:49.570Z",
      "queryHashes": [
        "de7e9eb98961"
      ],
      "recallDays": [
        "2026-06-02"
      ],
      "conceptTags": [
        "memory.md",
        "user.md",
        "中口径/计算逻辑的变更",
        "newmedia-dianpu-wwxx-0-0",
        "口径",
        "所有",
        "计算",
        "逻辑"
      ]
    },
    "memory:memory/2026-06-02.md:1:30": {
      "key": "memory:memory/2026-06-02.md:1:30",
      "path": "memory/2026-06-02.md",
      "startLine": 1,
      "endLine": 30,
      "source": "memory",
      "snippet": "# 2026-06-02 工作日志 ## 微伴线索更新 - [陈逸鸫] 提供微伴导出数据，更新6/1-6/2线索 - 映射确认：益达老师 = 小龙 - 写入结果：小龙表+50条（6/1 25+6/2 25），吴迪表+15条（6/1） - ⚠️ 首次写入时重复了（小龙24行+吴迪2行），已清理 - 每日线索汇总已修正：6/1 小龙25 吴迪15 / 6/2 小龙25 ## Tom/Bob 6月不接小红书线索 - [陈逸鸫] 告知 Tom 和 Bob 6月开始不接小红书线索了 - 微伴数据确认6/1-6/2 Tom/Bob 新增为0 ## 订单汇总 2smjwA 全量覆盖进展 - Cursor 确认方案：数据库 bi_vala_order 为唯一源，全量覆盖 2smjwA - 数据库匹配到 390 单（销转团队线索关联），按月：3月88/4月158/5月138/6月6 - 看板去重后 406 单，差异 40 单已分类： - 有uid无订单 8单 - 金额对不上 6单 - 未注册用户 10单 - 昵称为空 2单 - 2025年订单 6单（不纳入） - 重复录入 1单（孙婧） - 已有但key比对误差 7单 - 26 单待杨羽确认，清单已发群 - 闸门：杨羽确认 → v2 数据 → 备份→清空→覆盖→挂定时 ## 看板全量审计 - 13 张 sheet 全部扫完，公式引用正确，无硬值 - Cursor 补修：关键投放数据 Row131 裸IF包IFERROR、销售结算 M1/M2 废弃清空、每日线索月合计行金色",
      "recallCount": 6,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 6,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-03T00:01:27.128Z",
      "lastRecalledAt": "2026-06-14T07:14:40.970Z",
      "queryHashes": [
        "5f57ba3c20a6",
        "b76e8457b2ee",
        "4354c1e39886",
        "70f4bbaea7b1",
        "d26345ebc273",
        "cd28f28f1a7c"
      ],
      "recallDays": [
        "2026-06-03",
        "2026-06-05",
        "2026-06-14"
      ],
      "conceptTags": [
        "备份",
        "更新6/1-6/2线索",
        "6/1",
        "6/2",
        "tom/bob",
        "微伴数据确认6/1-6/2",
        "bi-vala-order",
        "3月88/4月158/5月138/6月6"
      ]
    },
    "memory:memory/2026-06-02.md:26:37": {
      "key": "memory:memory/2026-06-02.md:26:37",
      "path": "memory/2026-06-02.md",
      "startLine": 26,
      "endLine": 37,
      "source": "memory",
      "snippet": "- 闸门：杨羽确认 → v2 数据 → 备份→清空→覆盖→挂定时 ## 看板全量审计 - 13 张 sheet 全部扫完，公式引用正确，无硬值 - Cursor 补修：关键投放数据 Row131 裸IF包IFERROR、销售结算 M1/M2 废弃清空、每日线索月合计行金色 - 27 条脚本重复行仍在，覆盖前不对外用销转合计 ## 分工确认（与 Cursor） - Bot 看板 = 我维护（销转/结算/落单渠道/过程数据） - Base/指挥舱/漏斗 = Cursor 维护 - 日常流程已定稿",
      "recallCount": 6,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 6,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-03T03:17:27.367Z",
      "lastRecalledAt": "2026-06-05T23:22:18.095Z",
      "queryHashes": [
        "f747bc3124a0",
        "a9c408e7f346",
        "6cbc7cc2d6ff",
        "b76e8457b2ee",
        "b338dd8590b9",
        "ed5237a698fe"
      ],
      "recallDays": [
        "2026-06-03",
        "2026-06-05",
        "2026-06-06"
      ],
      "conceptTags": [
        "备份",
        "m1/m2",
        "销转/结算/落单渠道/过程数据",
        "base/指挥舱/漏斗",
        "闸门",
        "确认",
        "数据",
        "覆盖"
      ]
    },
    "memory:memory/2026-06-03.md:19:44": {
      "key": "memory:memory/2026-06-03.md:19:44",
      "path": "memory/2026-06-03.md",
      "startLine": 19,
      "endLine": 44,
      "source": "memory",
      "snippet": "- 表格编辑权限已授予李承龙、曲慧萌、吴迪 ## SkillHub 同步 - 16:40 推送 3 个技能：phone-chapter-query、vala-order-amortization-stat、welfare-user-list - 已通知李若松 ## Bot看板全量审计 & 吴迪D列数据修复 [陈逸鸫] ### 审计范围 - Bot看板：`NoZqsFi47hIOHEt9j8WcfRtbnug` - 审计Sheet：每日线索、关键投放、过程数据、销转总览、销售结算汇总、小龙/吴迪/成都销售表 ### 审计结果 - 每日线索6月：小龙70+吴迪20=90 ✓，Bob/Tom=0（6月起不接小红书线索，正常） - 关键投放6月汇总C=90 ✓，日明细49/37/4 ✓ - 过程数据J/N/R/V/Z COUNTIFS与DB一致 ✓ - 销转总览公式正确，6月订单=0 ✓ - 销售结算汇总：成都E=182来自5/21-5/31结算周期，非自然月6月 ✓ ### 发现的问题 1. 关键投放6/3代理明细空（C=4但谦禾/云智/YTL全空）→ Cursor后续修 2. 关键投放C列是数值非SUM公式 → Cursor后续修 3. 杨羽26单闸门未开，订单汇总不动不覆盖不删重复行 ### 吴迪D列数据错乱修复 - **现象：** 吴迪sheet(f975f0) D列(体验节数)与DB不符，24个有UID行中19个不匹配",
      "recallCount": 3,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 3,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-04T02:45:19.007Z",
      "lastRecalledAt": "2026-06-09T07:36:53.566Z",
      "queryHashes": [
        "1a6f50c1bd9c",
        "449ded7532cb",
        "843cc8fa34c4"
      ],
      "recallDays": [
        "2026-06-04",
        "2026-06-09"
      ],
      "conceptTags": [
        "phone-chapter-query",
        "vala-order-amortization-stat",
        "welfare-user-list",
        "小龙/吴迪/成都销售表",
        "bob/tom",
        "日明细49/37/4",
        "过程数据j/n/r/v/z",
        "182来自5/21-5/31结算周期"
      ]
    },
    "memory:memory/2026-06-03.md:1:28": {
      "key": "memory:memory/2026-06-03.md:1:28",
      "path": "memory/2026-06-03.md",
      "startLine": 1,
      "endLine": 28,
      "source": "memory",
      "snippet": "# 2026-06-03 工作日志 ## 端内析出leads数据表格 - **表格链接：** https://makee-interactive.feishu.cn/sheets/FA3xsw3kph4pdatKlUrcyPgInAc - **Sheet：** 曲慧萌（7f0e35）、吴迪（1K3O6s）、统计（scyF3H） - **脚本：** `scripts/fill_leads_sheet.py` - **触发暗号：** 「跑一下端内销售数据」 - **流程：** 读取手机号 → XXTEA加密匹配 account_id → 回填注册日期/转化/退费/U0完成日期 → 汇总统计 sheet - **统计口径（李承龙确认）：** - 转化率 = 未退费转化leads / 总leads - 退费率 = 退费leads / 已转化leads - 完成率 = 完成该课的leads / 总leads - **注意：** C列（析出日期）由销售手动填写，脚本不覆盖；统计值写小数配合百分比格式 - **端内渠道：** app-active-h5-0-0、app-sales-bj-qhm-0、app-sales-bj-wd-0（新增吴迪渠道） ## 权限变更 - 曲慧萌（8c654e1e）和吴迪（3561c777）加入 USER.md 第一级完整权限用户 - 许悦权限调整为：除GMV/GSV/退款等金额相关数据外的全部业务数据 - 表格编辑权限已授予李承龙、曲慧萌、吴迪 ## SkillHub 同步 - 16:40 推送 3 个技能：phone-chapter-que",
      "recallCount": 2,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 2,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-04T02:45:19.007Z",
      "lastRecalledAt": "2026-06-04T02:56:15.231Z",
      "queryHashes": [
        "1a6f50c1bd9c",
        "449ded7532cb"
      ],
      "recallDays": [
        "2026-06-04"
      ],
      "conceptTags": [
        "scripts/fill-leads-sheet.py",
        "account-id",
        "回填注册日期/转化/退费/u0完成日期",
        "app-active-h5-0-0",
        "app-sales-bj-qhm-0",
        "app-sales-bj-wd-0",
        "user.md",
        "除gmv/gsv/退款等金额相关数据外的全部业务数据"
      ]
    },
    "memory:memory/2026-05-19.md:17:33": {
      "key": "memory:memory/2026-05-19.md:17:33",
      "path": "memory/2026-05-19.md",
      "startLine": 17,
      "endLine": 33,
      "source": "memory",
      "snippet": "- 抖音+联报退费率最高49.2%（也是最大组合124单） - **分析脚本：** `scripts/channel_lead_refund_analysis.py` ## 王虹茗 - V2修正：纳入多角色因素 - **反馈：** 指出 Sheet2 一个用户可能创建多个角色，要求重新分析 - **关键修正：** - 按用户聚合时保留角色数量、创建节奏、行课覆盖等信息 - 行课行为以\"任一角色完成即算\"聚合 - **新增发现：** - 1个角色退费率46.7% > 2个角色34.8% > ≥4个角色28.6%（角色越多退费越低） - 同日多角色45.7% vs 1周以上多角色28.6%（跨时间创建=持续使用信号） - 全角色无行课退费率75.9%（最高危） - 1角色+无行课=76.0%（最危险组合），≥4角色+有行课=16.7%（最安全） - **输出文件：** `output/渠道4-5月线索_退款相关性分析_v2_20260519_202711.xlsx`（20个维度+明细） - **分析脚本：** `scripts/channel_lead_refund_analysis_v2.py`",
      "recallCount": 2,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 2,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-05T00:46:22.699Z",
      "lastRecalledAt": "2026-06-14T06:58:06.164Z",
      "queryHashes": [
        "34106cf619c4",
        "6769ba9ebb36"
      ],
      "recallDays": [
        "2026-06-05",
        "2026-06-14"
      ],
      "conceptTags": [
        "联报退费率最高49.2",
        "1个角色退费率46.7",
        "2个角色34.8",
        "4个角色28.6",
        "同日多角色45.7",
        "1周以上多角色28.6",
        "全角色无行课退费率75.9",
        "76.0"
      ]
    },
    "memory:memory/2026-06-12.md:18:38": {
      "key": "memory:memory/2026-06-12.md:18:38",
      "path": "memory/2026-06-12.md",
      "startLine": 18,
      "endLine": 38,
      "source": "memory",
      "snippet": "| 6 | 小乖大人 | 16158 | 13944890221 | 3/1 | 无订单 | - | 0 | 0 | DB无任何订单 | | 7 | 潘潘 | 16150 | 18610935696 | 3/1 | 无订单 | - | 0 | 0 | DB无任何订单 | | 8 | 张滢ya | 17894 | 13799768340 | 3/7 | 无订单 | - | 0 | 0 | DB无任何订单 | | 9 | sallywu | 17816 | 15998103065 | 3/7 | 无订单 | - | 0 | 0 | DB无任何订单 | | 10 | 🦁萨摩 | 21858 | 13685553716 | 3/8 | 4/8 | ✓ | 1999 | 1999 | 达人-学霸三人行 | ### Group B (有手机，4笔) - phone_encrypt查UID | # | 昵称 | 手机 | 加密结果 | DB匹配 | |---|------|------|---------|--------| | 11 | 潘提提 | 13427741613 | IiShdIaiY1oy7B_Xn4EH3g.. | 无匹配 | | 12 | 狸小路 | 18622850293 | YPAQ-740vKwxroqZGkeGyQ.. | 无匹配 | | 13 | 希小希 | 18086665321 | c8zfpqBrN1nikMkwAj64aQ.. | 无匹配 | | 14 | 曼 | 13520255515 | NBVtGuxEge7f7hdkyK3y7Q.. | 无匹配",
      "recallCount": 2,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 2,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-14T06:58:06.164Z",
      "lastRecalledAt": "2026-06-18T09:12:10.290Z",
      "queryHashes": [
        "6769ba9ebb36",
        "3f85aec3e063"
      ],
      "recallDays": [
        "2026-06-14",
        "2026-06-18"
      ],
      "conceptTags": [
        "3/1",
        "3/7",
        "3/8",
        "4/8",
        "达人-学霸三人行",
        "phone-encrypt查uid",
        "iishdiaiy1oy7b-xn4eh3g",
        "ypaq-740vkwxroqzgkegyq"
      ]
    },
    "memory:memory/2026-06-12.md:35:56": {
      "key": "memory:memory/2026-06-12.md:35:56",
      "path": "memory/2026-06-12.md",
      "startLine": 35,
      "endLine": 56,
      "source": "memory",
      "snippet": "| 15 | Rachel | 3/5 | 10994 | 13510564547 | 3/7 | ✓ | sales-adp-bj-jxl-0, GMV=1999 | | 16 | soul | 3/2 | 17387 | 15640464255 | 3/12 | ✓ | sales-adp-bj-jxl-0, GMV=1999 | | 17 | 红 | 3/7 | 17025 | 13533955004 | 3/14 | ✓ | sales-adp-bj-jxl-0, GMV=1999 | | 18 | 一笑轩渠 | 3/8 | 17425 | 15017528458 | 3/11 | ✓ | sales-adp-bj-jxl-0, GMV=1999 | | 19 | 蜗牛 | 3/2 | ❓ | ❓ | ❓ | - | 晚柠5/15订单数百笔，无手机/UID无法定位 | | 20 | c_瑶 | 3/6 | ❓ | ❓ | ❓ | - | \"直购\"渠道DB不存在，3/14无3998/1999匹配 | ### 关键发现 1. Group A 中 7/10 用户 DB 中无任何订单（pre汇总有GMV但DB不存在） 2. Group B 4个手机号全部未注册（H=未注册 确认正确） 3. Group C #15-#18 4笔 jxl-0 均 L≥C，pre怀疑#18 L<C不成立 4. #19 蜗牛和 #20 c_瑶 无法定位 ## 陈逸鸫 - full_refresh (S2+S3) 联调 ### 执行记录 - 时间：2026-06-12 18:00 左右 - S2：",
      "recallCount": 4,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 4,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-14T06:58:06.164Z",
      "lastRecalledAt": "2026-06-18T09:12:10.290Z",
      "queryHashes": [
        "6769ba9ebb36",
        "0b9f27c6db59",
        "15e68c5404aa",
        "3f85aec3e063"
      ],
      "recallDays": [
        "2026-06-14",
        "2026-06-15",
        "2026-06-16",
        "2026-06-18"
      ],
      "conceptTags": [
        "3/5",
        "3/7",
        "sales-adp-bj-jxl-0",
        "3/2",
        "3/12",
        "3/14",
        "3/8",
        "3/11"
      ]
    },
    "memory:memory/2026-06-13.md:1:21": {
      "key": "memory:memory/2026-06-13.md:1:21",
      "path": "memory/2026-06-13.md",
      "startLine": 1,
      "endLine": 21,
      "source": "memory",
      "snippet": "# 2026-06-13 工作日志 ## 飞书表格写入 5000 格上限问题修复 **来源：** 陈逸鸫发现全量刷订单漏数据，李承龙确认修复 **问题：** - `refresh_order_summary.py` 清空时 500行×26列=13,000格 超过飞书 API 5000 格上限 - `sales_leads_full_refresh.py` 清空时 500行×22列=11,000格，写入时 500行×22列=11,000格 同样超标 - 超标请求静默失败（API 不报错），导致旧数据残留、新数据被部分覆盖、末尾行丢失 **修复：** 1. 创建 `scripts/feishu_sheet_utils.py` 共享工具，封装安全分批写入/清空逻辑，自动计算批大小 ≤ 4400 格/批 2. `refresh_order_summary.py` 和 `sales_leads_full_refresh.py` 均已改用共享工具 3. 登记到 `SKILL_REGISTRY.md` 和 `MEMORY.md` **关键参数：** - 22列 → 单批最大 200 行 (4400 格) - 24列 → 单批最大 183 行 (4392 格) - 26列 → 单批最大 169 行 (4394 格)",
      "recallCount": 3,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 3,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-15T00:23:49.908Z",
      "lastRecalledAt": "2026-06-16T04:37:44.473Z",
      "queryHashes": [
        "72dbb087c75b",
        "d01c75870930",
        "247976469363"
      ],
      "recallDays": [
        "2026-06-15",
        "2026-06-16"
      ],
      "conceptTags": [
        "refresh-order-summary.py",
        "sales-leads-full-refresh.py",
        "scripts/feishu-sheet-utils.py",
        "封装安全分批写入/清空逻辑",
        "格/批",
        "skill-registry.md",
        "memory.md",
        "工作"
      ]
    },
    "memory:memory/2026-06-12.md:63:73": {
      "key": "memory:memory/2026-06-12.md:63:73",
      "path": "memory/2026-06-12.md",
      "startLine": 63,
      "endLine": 73,
      "source": "memory",
      "snippet": "- 整体小红书（含达人+直购）：880 用户、969 单、328 万 GMV ### 直购表 + S3 联调完成 - 时间：2026-06-12 18:40 左右 - 新建直购 sheet `1sosYE`（Bot 工作簿内），独立存放小红书直购订单 - 新建 `scripts/refresh_direct_sheet.py`：从 DB 直查 `dianpu-xhs` / `stream-xhs` 订单，不依赖手机号，全量 73 条 - 修改 `scripts/refresh_order_summary.py`：S3 读取三表 + 直购表，合并写入订单汇总 - 直购行 C 列为空时跳过 L≥C 检查（直购无进线日期概念） - full_refresh 流程：先 `refresh_direct_sheet.py` → 再 `refresh_order_summary.py` - 本次验证：381（三表）+ 73（直购）= 454 行写入订单汇总",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-15T02:42:34.143Z",
      "lastRecalledAt": "2026-06-15T02:42:34.143Z",
      "queryHashes": [
        "0b9f27c6db59"
      ],
      "recallDays": [
        "2026-06-15"
      ],
      "conceptTags": [
        "scripts/refresh-direct-sheet.py",
        "dianpu-xhs",
        "stream-xhs",
        "scripts/refresh-order-summary.py",
        "full-refresh",
        "refresh-direct-sheet.py",
        "refresh-order-summary.py",
        "整体"
      ]
    },
    "memory:memory/2026-06-12.md:53:68": {
      "key": "memory:memory/2026-06-12.md:53:68",
      "path": "memory/2026-06-12.md",
      "startLine": 53,
      "endLine": 68,
      "source": "memory",
      "snippet": "- S3：筛选 K=是 · O>0 · P<O · L≥C → 381 行写入订单汇总 2smjwA，W 渠道归属 + X=1 已写入 ### 发现的问题 1. **订单汇总前 8 行无 M/N（成交渠道/产品）**：S2 脚本读小龙 sheet 时 API 只返回了 1198 行（截断），后面约 200 行没被处理。已手动补 M/N。 2. **小龙 sheet 第 20 行\"赫尔辛基的阳光\"**：E 列手机号和 H 列 UID 均为空，但 K/O/R/S/T/U 有值。原因是之前 S2 刷新时 E 列有手机号匹配到了 UID，后来手机号被人清掉但订单数据残留。下次 S2 会清空该行自动列。 3. **Bot 应用无多维表格创建权限**：缺少 `bitable:app` 或 `base:app:create` 权限，需技术负责人在飞书开放平台开通。 ### 小红书直购数据（2026-03-12 ~ 2026-06-12） - DB 中 25 个直购用户（26 单），订单汇总仅覆盖 11 行 - 差距原因：直购用户在销售表无手机号 → S2 匹配不到 UID → 进不了订单汇总 - 整体小红书（含达人+直购）：880 用户、969 单、328 万 GMV ### 直购表 + S3 联调完成 - 时间：2026-06-12 18:40 左右 - 新建直购 sheet `1sosYE`（Bot 工作簿内），独立存放小红书直购订单 - 新建 `scripts/refresh_direct_sheet.py`：从 DB 直查 `dianpu-xhs` / `stream-xhs`",
      "recallCount": 1,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 1,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-15T02:42:34.143Z",
      "lastRecalledAt": "2026-06-15T02:42:34.143Z",
      "queryHashes": [
        "0b9f27c6db59"
      ],
      "recallDays": [
        "2026-06-15"
      ],
      "conceptTags": [
        "m/n",
        "成交渠道/产品",
        "k/o/r/s/t/u",
        "scripts/refresh-direct-sheet.py",
        "dianpu-xhs",
        "stream-xhs",
        "筛选",
        "订单"
      ]
    },
    "memory:memory/2026-06-15.md:1:38": {
      "key": "memory:memory/2026-06-15.md:1:38",
      "path": "memory/2026-06-15.md",
      "startLine": 1,
      "endLine": 38,
      "source": "memory",
      "snippet": "# 2026-06-15 工作日志 ## 陈逸鸫 - 订单口径变更：停直购 **来源：** 陈逸鸫（群聊「数据更新V2」） **变更内容：** 1. 以后不管直购单，只看小红书销转，直购 GMV 不再进销转对账 2. full_refresh 不再 merge 直购进订单汇总 3. 直购表（1sosYE）可删除（需人工在飞书操作，API 不支持删 sheet） 4. 仍支持按手机查 keyfrom/GSV/退款（不定销售归属） **脚本修改：** - `scripts/refresh_order_summary.py`：去掉 Step 1.5 读取直购表逻辑，不再合并直购行 - `scripts/full_refresh_sales.py`：不涉及直购，无需改动 - `scripts/refresh_direct_sheet.py`：保留不动（如后续仍需独立查直购数据） ## 陈逸鸫 - full_refresh 执行 - 时间：2026-06-15 08:24-08:26 - 销售三表：吴迪 697 / 小龙 1198 / 成都 2203 - 有效 user_id：2009 - 订单汇总：383 条（不含直购） - 直购表：75 条已刷新 - 订单汇总合并后：461 条（含直购，这是口径变更前的最后一次含直购的合并） ## 陈逸鸫 - 线索表字段调整（2026-06-15） **来源：** 陈逸鸫（群聊「小红书数据需求」） **线索表（销售三表）新列结构（A~Z）：** | 列 | 字段名 | 脚本填写 | |----|--------|---------|",
      "recallCount": 3,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 3,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-16T00:11:00.366Z",
      "lastRecalledAt": "2026-06-16T04:37:44.473Z",
      "queryHashes": [
        "15e68c5404aa",
        "d01c75870930",
        "247976469363"
      ],
      "recallDays": [
        "2026-06-16"
      ],
      "conceptTags": [
        "full-refresh",
        "keyfrom/gsv/退款",
        "scripts/refresh-order-summary.py",
        "1.5",
        "scripts/full-refresh-sales.py",
        "scripts/refresh-direct-sheet.py",
        "24-08",
        "user-id"
      ]
    },
    "memory:memory/2026-06-15.md:29:79": {
      "key": "memory:memory/2026-06-15.md:29:79",
      "path": "memory/2026-06-15.md",
      "startLine": 29,
      "endLine": 79,
      "source": "memory",
      "snippet": "**来源：** 陈逸鸫（群聊「小红书数据需求」） **线索表（销售三表）新列结构（A~Z）：** | 列 | 字段名 | 脚本填写 | |----|--------|---------| | A | 销售归属 | - | | B | 微信昵称 | - | | C | 进线日期 | - | | D | 体验节数 | ✅ | | E | 手机号 | - | | F | 用户年级 | - | | G | 课史/跟进 | - | | H | 用户ID | ✅ | | I | 注册日期 | ✅ | | J | 下载渠道 | ✅ | | K | 下单日期 | ✅ | | L | 成交渠道 | ✅ | | M | 产品 | ✅ | | N | 下单金额(GMV) | ✅ | | O | 退款金额 | ✅ | | P | 实际收入(GSV) | ✅ | | Q | 激活课程 | ✅ | | R | 当前行课进度 | ✅ | | S | 最近行课时间 | ✅ | | T | 累计学习时长(min) | ✅ | | U | 更新时间 | ✅ | | V | 微伴补充 | - | | W | 进线早于下单 | - | | X | 订单号 | ✅ | | Y | 有效订单 | ✅ | | Z | 渠道归属 | ✅ | **对比旧版变化：** - 删除旧 K 列「是否下单」 - 旧 L~V 列整体左移一位（L→K, M→L, ..., V→U） - 新增 V(微伴补充), W(进线早于下单), X(订单号), Y(有效订单), Z(渠道归属) **订单汇总表新列结构（A~X）：** | 列 | 字",
      "recallCount": 4,
      "dailyCount": 0,
      "groundedCount": 0,
      "totalScore": 4,
      "maxScore": 1,
      "firstRecalledAt": "2026-06-16T00:37:29.278Z",
      "lastRecalledAt": "2026-06-16T00:38:04.668Z",
      "queryHashes": [
        "2648cb741240",
        "9e6a1ca1c2a5",
        "e7d87a8cfb00",
        "76e811a7d0e8"
      ],
      "recallDays": [
        "2026-06-16"
      ],
      "conceptTags": [
        "课史/跟进",
        "来源",
        "数据",
        "需求",
        "线索",
        "销售",
        "结构",
        "脚本"
      ]
    }
  }
}
