Data Analytics report

门店经营数据周报｜2026-07-20—2026-07-26

面向门店运营管理层的完整自然周经营复盘。

经营结论

本周前台实际销售额 1261.7Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 万元，较上周增加 -46.2Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 万元（-3.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch）；98Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 家门店增长、210Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 家下降，下降门店多于增长门店。营业毛利率为 24.0%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch，客单价 17.99Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 元，会员销售占比 19.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch。

当前门店状态快照：新店 7Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 家、成熟门店 287Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 家、暂停营业 15Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 家；配销比仅使用成熟门店计算。

会员销售额 241.3Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 万元（-2.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch），会员订单数 85,121Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 单（-0.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch），会员客单价 28.34Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 元（-2.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch）。新增会员 6,574Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 人（-8.0%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch），会员订单数与会员客单价均下降，共同拖累会员销售。

增量最大的两家门店合计贡献 8.5Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch 万元，但两店上周基数接近零，更像新开店或恢复经营效应，不能直接解释为成熟门店自然增长。

Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

本周销售额（人民币元）

12,617,069.32Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

本周前台实际销售额及其相对上周的变化。

销售周环比 -3.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
本周前台实际销售额及其相对上周的变化。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

营业毛利率

24%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

券售价口径营业毛利率。

券售价口径营业毛利率。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

客单价（人民币元）

17.99Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

前台实际销售额除以订单数。

前台实际销售额除以订单数。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

会员销售占比

19.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

会员销售额占前台实际销售额的比例。

会员销售额占前台实际销售额的比例。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

会员销售额（人民币元）

2,412,546.41Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

会员订单实际销售额及其周环比。

会员销售额周环比 -2.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
会员订单实际销售额及其周环比。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

会员客单价（人民币元）

28.34Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按会员订单数加权计算的券售价口径会员客单价。

会员客单价周环比 -2.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
按会员订单数加权计算的券售价口径会员客单价。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

新增会员数

6,574Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按会员创建时间和来源门店统计的去重新增会员。

新增会员数周环比 -8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
按会员创建时间和来源门店统计的去重新增会员。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

新店数

7Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

当前快照中 branch_extend9 为新开店的去重门店数，排除配送中心和培教店。

当前快照中 branch_extend9 为新开店的去重门店数，排除配送中心和培教店。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

成熟门店数

287Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

当前快照中 branch_extend9 为成熟店的去重门店数，排除配送中心和培教店。

当前快照中 branch_extend9 为成熟店的去重门店数，排除配送中心和培教店。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

暂停营业门店数

15Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

当前快照中 branch_extend9 为暂停营业的去重门店数，排除配送中心和培教店。

当前快照中 branch_extend9 为暂停营业的去重门店数，排除配送中心和培教店。Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

强管部门配销比

100.3%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch

六个强管部门总部净配送金额占标准销售成本的比例。

较上周变化（百分点） +3.3%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch
六个强管部门总部净配送金额占标准销售成本的比例。Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch

按门店计算本周与上周强管部门配销比及总配销比。

总配销比

72.6%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch

全部门总部净配送金额占标准销售成本的比例。

较上周变化（百分点） +2.4%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch
全部门总部净配送金额占标准销售成本的比例。Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch

按门店计算本周与上周强管部门配销比及总配销比。

增长贡献

增长集中在少数高增量门店；其中两家低基数门店应单独核实是否为新开、复业或数据补录。

销售额增量最高的 10 家门店
销售额增量最高的 10 家门店 data
门店名称销售额变化本周销售额上周销售额销售周环比
1992-贵州黔西南兴义永康综合农贸市场店63,639.54人民币元63,639.54人民币元0人民币元—
1588-贵州铜仁德江大龙阡店21,448.53人民币元84,334.43人民币元62,885.9人民币元34.1%
1998-重庆两江新区荷塘路店11,069.05人民币元88,721.47人民币元77,652.42人民币元14.3%
1555-贵州黔东南岺巩龙田镇店9,567.04人民币元67,724.2人民币元58,157.16人民币元16.5%
1936-贵州铜仁塘头镇店8,880.79人民币元84,392.7人民币元75,511.91人民币元11.8%
1652-重庆两江新区宝石路店8,725.25人民币元190,895.36人民币元182,170.11人民币元4.8%
1558-浙江嘉兴海宁盈都新天地店8,561.74人民币元111,482.68人民币元102,920.94人民币元8.3%
1608-贵州遵义绥阳蒲场镇店7,987.6人民币元9,959.3人民币元1,971.7人民币元405.1%
1876-浙江杭州独山工业区店7,220.7人民币元92,502.05人民币元85,281.35人民币元8.5%
1836-贵州贵阳恒大都会店6,817.56人民币元34,281.89人民币元27,464.33人民币元24.8%

下滑风险

优先复盘绝对销售额降幅最大的门店，避免只看百分比而被低销售基数放大。

销售额下降最大的 10 家门店
销售额下降最大的 10 家门店 data
门店名称销售额变化本周销售额上周销售额营业毛利率
1146-贵州遵义职业学院店-35,541.75人民币元19,643.83人民币元55,185.58人民币元20.1%
1986-贵州遵义马蹄镇店-22,428.82人民币元26,605.8人民币元49,034.62人民币元16.4%
1398-浙江杭州头格农贸市场店-21,853.68人民币元98,135.21人民币元119,988.89人民币元32.7%
1040-贵州贵阳望星苑店-21,282.06人民币元43,488.43人民币元64,770.49人民币元22.5%
1577-贵州黔南龙里伯爵钻石广场店-20,427.54人民币元93,085.3人民币元113,512.84人民币元21.6%
1165-贵州贵阳中医药大学店-19,912.46人民币元61,608.46人民币元81,520.92人民币元22.2%
1778-贵州黔南长顺鼓扬镇店-18,924.52人民币元52,393.14人民币元71,317.66人民币元20.6%
1989-贵州贵阳后坝路店-16,905.6人民币元67,780.9人民币元84,686.5人民币元19.6%
1237-贵州黔南独山基长镇店-16,830.43人民币元38,773.29人民币元55,603.72人民币元36%
1525-贵州铜仁印江东馨园店-14,615.39人民币元38,487.84人民币元53,103.23人民币元33.1%

商品销售排行

商品粒度汇总销售额与周报销售额相差 -29.80Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item 元，差异率低于 0.001%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item。排名第 1Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item 的“普通商品 单规格”销售额较高，但成本为零、毛利率为 100%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item，疑似通用码或成本资料缺失，保留真实排行并建议商品/财务团队核查。

Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item

按商品汇总本周实际销售额、数量、毛利和销售门店数并取销售额前10名。

商品销售额排名前 10
商品销售额排名前 10 data
商品名称销售额商品代码销售数量销售毛利率销售门店数
普通商品 单规格617,228.44人民币元110.29K61,094100%142
贵烟(喜)159,882.13人民币元70.06K9,54214.3%146
贵烟(硬高遵)115,463.69人民币元70.06K4,4799.1%159
贵烟(硬黄精品)111,645.92人民币元70.05K7,45122%171
贵烟(萃)90,998.71人民币元70.05K4,58620.1%165
山花纯牛奶250ml【提1*24】73,438.85人民币元113.65K1,1857%148
贵烟(跨越)71,437.67人民币元70.07K2,92717.3%171
万能码171,223.45人民币元113.6K5,958100%9
山花透明纯牛奶180ml 箱55,621.4人民币元100.01K1,4454.5%121
东鹏特饮维生素功能饮料瓶装500ml53,893.04人民币元10.06K12,01923.5%298

商品销售额 TOP10 明细

Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item

按商品汇总本周实际销售额、数量、毛利和销售门店数并取销售额前10名。

商品销售额 TOP10 明细
排名商品代码商品名称规格单位商品部门销售数量销售额销售毛利销售毛利率销售门店数
1Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item110.29KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item普通商品 单规格1箱*28包个自采61,094Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item617,228.44人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item617,228.44人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item100%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item142Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
2Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item70.06KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item贵烟(喜)1条*10包包自采9,542Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item159,882.13人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item22,827.8人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item14.3%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item146Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
3Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item70.06KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item贵烟(硬高遵)1条*10包包自采4,479Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item115,463.69人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item10,452.15人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item9.1%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item159Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
4Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item70.05KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item贵烟(硬黄精品)1条*10包包自采7,451Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item111,645.92人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item24,549.82人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item22%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item171Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
5Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item70.05KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item贵烟(萃)1条*10包包自采4,586Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item90,998.71人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item18,284.83人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item20.1%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item165Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
6Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item113.65KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item山花纯牛奶250ml【提1*24】1提*24瓶提供应商直送1,185Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item73,438.85人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item5,154.12人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item7%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item148Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
7Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item70.07KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item贵烟(跨越)1条*10包包自采2,927Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item71,437.67人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item12,334.15人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item17.3%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item171Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
8Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item113.6KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item万能码1—个自采5,958Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item71,223.45人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item71,223.45人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item100%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item9Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
9Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item100.01KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item山花透明纯牛奶180ml 箱180mL箱供应商直送1,445Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item55,621.4人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item2,492.42人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item4.5%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item121Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item
10Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item10.06KSource: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item东鹏特饮维生素功能饮料瓶装500ml1箱*24瓶瓶酒水12,019Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item53,893.04人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item12,678.8人民币元Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item23.5%Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item298Source: YJC_lemeng 商品销售排行只读查询Tables: dbo.LM_PosOrderSummary, dbo.LM_basic_item

会员经营

会员销售额周环比 -2.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch，会员订单数周环比 -0.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch、会员客单价周环比 -2.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch。会员订单数与会员客单价均下降，共同拖累会员销售。

Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

会员销售额增量最高的 10 家门店
会员销售额增量最高的 10 家门店 data
门店名称会员销售额变化会员销售额会员销售额周环比会员客单价
1992-贵州黔西南兴义永康综合农贸市场店36,214.99人民币元36,214.99人民币元—39.61人民币元
1190-贵州铜仁德江碧桂园店9,559.03人民币元10,361.08人民币元1,191.8%431.71人民币元
1036-贵州贵阳花果园S3区店5,428.21人民币元48,036.54人民币元12.7%29.16人民币元
1506-贵州毕节金帝豪庭店4,450.88人民币元11,611.68人民币元62.2%18.23人民币元
1607-贵州铜仁沿河谯家镇店4,251.44人民币元17,626.38人民币元31.8%47.53人民币元
1321-贵州贵阳中铁逸都店4,167.52人民币元20,055.94人民币元26.2%24.35人民币元
1597-重庆巴南南泉镇虎嘯村店3,885.4人民币元25,502.1人民币元18%33.91人民币元
1056-贵州贵阳开阳兴才路店3,678.36人民币元32,461.18人民币元12.8%29.8人民币元
1836-贵州贵阳恒大都会店3,511.41人民币元14,568.55人民币元31.8%26.76人民币元
1777-贵州毕节威宁祥和佳苑店3,370.74人民币元44,698.26人民币元8.2%27.44人民币元
新增会员数最高的 10 家门店
新增会员数最高的 10 家门店 data
门店名称新增会员数上周新增会员数新增会员数周环比会员销售占比
1992-贵州黔西南兴义永康综合农贸市场店1,0250—56.9%
1998-重庆两江新区荷塘路店352861-59.1%39.4%
1989-贵州贵阳后坝路店344922-62.7%58.7%
1669-贵州铜仁锦江广场店247254-2.8%28.1%
1212-贵州毕节美食街店1851755.7%45.2%
1777-贵州毕节威宁祥和佳苑店170188-9.6%85.2%
1980-贵州贵阳水电九局外区店13511517.4%44.2%
1981-贵州毕节纳雍茶林路店125142-12%41.5%
1028-贵州贵阳天利花园店1098232.9%48%
1139-贵州贵阳甜蜜小镇店1056172.1%43.1%

配销覆盖

仅成熟门店口径下，强管部门配销比为 100.3%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch，较上周 +3.3Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch 个百分点；总配销比为 72.6%Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch，较上周 +2.4Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch 个百分点。配销比上升可能来自补库存、配送前置或总部供货覆盖改善；下降可能来自外采、消化历史库存、配送不足或跨期。

Source: YJC_lemeng 配销比周度只读查询Tables: dbo.LM_PosOrderSummary, dbo.DWD_Outbound_Inc, dbo.LM_basic_item, dbo.LM_basic_branch

按门店计算本周与上周强管部门配销比及总配销比。

强管部门配销比上升最大的 10 家门店
强管部门配销比上升最大的 10 家门店 data
门店名称强管部门配销比变化强管部门配销比上周强管部门配销比总配销比变化
1706-贵州贵阳云关小区店1,132.3%1,770%637.6%964.3%
1783-云南昭通镇雄君悦一品店715.1%715.1%0%343.7%
1205-贵州毕节青场镇店433.6%433.6%0%270.2%
1300-贵州铜仁思南瓮溪镇店408.5%408.4%-0.1%225.4%
1760-贵州毕节对坡镇店353.7%540.5%186.8%191%
1208-贵州毕节杨家湾镇店321.4%321.2%-0.2%301.6%
1773-贵州黔西南晴隆育才路店260.5%260.5%0%136.1%
1580-云南普洱景东阳光别院店258.2%258.2%0%244.5%
1608-贵州遵义绥阳蒲场镇店254.8%254.8%0%250%
1316-贵州铜仁印江中心街店233.1%292.7%59.6%110.2%
强管部门配销比下降最大的 10 家门店
强管部门配销比下降最大的 10 家门店 data
门店名称强管部门配销比变化强管部门配销比上周强管部门配销比总配销比变化
1982-贵州铜仁石阡宴明店-341.8%0%341.8%-217%
1772-贵州毕节纳雍玉龙坝镇店-335.5%0%335.5%-251.8%
1673-云南昭通威信三桃乡店-321.1%0%321.1%-316.4%
1868-贵州铜仁沿河思州花园店-258.5%7.7%266.2%-242.4%
1126-贵州遵义师范学院店-242.3%37%279.3%-167.7%
1292-贵州贵阳息烽开磷城店-233.7%-0.3%233.4%-82%
1337-贵州黔西南兴义河塘郡园店-211.7%0%211.7%-86.5%
1789-贵州铜仁思南宽坪乡店-207.5%65%272.5%-151.4%
1951-云南昭通威信八中店-198.6%0%198.6%-196.1%
1131-贵州贵阳金狮小区店-198.3%-0.6%197.7%-75.2%

本周行动建议

  1. 门店运营： 复核销售下降前 10 家门店的营业天数、缺货、客流与活动变化，先确认数据完整性再归因。
  2. 区域负责人： 单独标记上周销售额接近零的高增长门店，区分新开/复业增量与成熟门店自然增长。
  3. 会员运营： 对会员销售增量前 10 家门店拆分会员订单增长与客单价增长，沉淀可复制动作；对新增会员高但会员销售占比低的门店跟踪首购转化。
  4. 财务/数据： 核对 LM_Daily_PosOrder_Branch 是否已完整抵减退货，并确认配送中心、闭店和测试门店排除规则。
  5. 配送/采购： 对配销比连续下降门店按部门核对总部配送、门店外采与库存消化；对大幅上升门店确认是否为集中补货或跨期配送。

门店明细

用于区域经理逐店筛查销售、毛利率、客单价和会员销售表现。

门店经营明细

Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

门店经营明细
门店本周销售额销售额变化周环比毛利率客单价会员销售占比会员销售额会员销售周环比会员客单价会员客单价周环比新增会员数新增会员周环比强管部门配销比强管配销比变化（百分点）总配销比总配销比变化（百分点）
1652-重庆两江新区宝石路店190,895.36人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+8,725.25人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+4.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch19.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch22.97人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch42.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch81,187.89人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-0.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch28.88人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+3.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch84Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-2.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch————
1139-贵州贵阳甜蜜小镇店149,073.98人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-5,385.96人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch22.05人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch43.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch64,241人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch34.4人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch105Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+72.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch98.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-6.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch70.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-4.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1539-重庆巴南中昂锦锈店114,946.25人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-2,031.99人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch18.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch24.62人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch5.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch6,622.49人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-27.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch41.65人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+8.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch80Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-49.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch————
1558-浙江嘉兴海宁盈都新天地店111,482.68人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+8,561.74人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+8.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch29.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch15.87人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch612.27人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+50.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch14.93人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+24.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch—————
1028-贵州贵阳天利花园店110,058.85人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-6,056.12人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-5.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch19.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20.66人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch48%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch52,770.44人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+5.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch29.91人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch109Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+32.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch78.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-27.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch84.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-19.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1325-贵州贵阳枫丹白鹭店108,910.3人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-4,099.41人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch19%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch16.35人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch24.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch26,357.45人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-10.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch31.86人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-0.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-28.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch96.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch79.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+6.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1896-浙江嘉兴海宁盈都新天地二店102,929.16人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+3,012.04人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch34.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch17.69人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch479.1人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+99.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch31.94人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-20.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch2Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch—————
1039-贵州贵阳党武镇店102,821.46人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-8,483.83人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-7.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch22.42人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch283.94人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-13.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20.28人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-25.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch1Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch—53.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+21.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch39.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+16%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1090-贵州黔南瓮安锦美河畔阳光店101,488.44人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1,199.72人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch18.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch41.32人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch417.99人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+110.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch59.71人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+50.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-100%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch116.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+52.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch53.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+23.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1890-重庆渝中枣子岚垭店100,093.37人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+2,516.84人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+2.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch19.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch15.04人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch5.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch5,704.37人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-16.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch22.02人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-2.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch12Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+9.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch————
1166-贵州贵阳修文珍珠湾星城店100,004.49人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1,624.97人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch19.71人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch18.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch18,722.19人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch34.9人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+8.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch32Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-8.6%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch59%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-38.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch38.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-24%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1398-浙江杭州头格农贸市场店98,135.21人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-21,853.68人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-18.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch32.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch14.76人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch7.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch7,369.03人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-18.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch28.26人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-2.9%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch5Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+25%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch————
1637-重庆渝北伴山名都店97,181.84人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3,293.75人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch15.5%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch16.78人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch323.79人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-44.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch32.38人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+11.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch0Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch—————
1567-贵州毕节金海商业街店96,247.71人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-6,405.69人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-6.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch36.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch25.53人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch7.1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch6,782.3人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+15%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch65.55人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+13.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch20Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+17.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch104.4%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch48.2%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-3.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch
1660-湖南湘西凤凰诚信家苑店93,383.46人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1,619.79人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch-1.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch22.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch23.28人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch66.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch62,260.75人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1.7%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch26.74人民币元Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+1.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch44Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+63%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch140%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+92.3%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch40.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch+27.8%Source: YJC_lemeng 门店经营周报只读查询Tables: dbo.LM_Daily_PosOrder_Branch, dbo.LM_basic_branch

311 results · Showing first 15

口径与限制

  • 采用完整自然周，当前周为 2026-07-20 至 2026-07-26，对比前一自然周。
  • 销售使用 Order_ActualSalesRevenue；毛利使用券售价口径；客单价按订单数重新计算，未汇总日均值。
  • 所有销售额、毛利额和客单价的计量单位均为人民币元（CNY）。
  • 新店数、成熟门店数、暂停营业门店数均为当前快照指标，按 branch_extend9 去重统计门店，排除配送中心和培教店。
  • 配销比仅计算 branch_extend9='成熟店' 且非培教店的门店，分子和分母使用同一成熟门店池。
  • 配销比衡量总部供货覆盖率；六个强管部门使用各自标准毛利率，其他部门统一使用20%标准毛利率反推标准销售成本。
  • 配销比变化按本周减上周计算，单位为百分点；目标区间未确认前，上升/下降不直接等同于好/坏。
  • 当前未获得预算/目标，因此不使用红黄绿达成状态。
  • 退货抵减、线上订单并入口径，以及配送中心/闭店/测试门店排除规则仍需业务确认。

作者：xiechaoyuan@outlook.com

Sources

  1. YJC_lemeng 门店经营周报只读查询Microsoft SQL Server via Metabase · 2026-07-27T11:28:00+08:00

    按门店汇总本周与上周销售、营业毛利、订单、客单价和会员销售指标。

    SQL query
    
DECLARE @current_start date = '2026-07-20';
DECLARE @current_end date = '2026-07-26';
DECLARE @prior_start date = DATEADD(day, -7, @current_start);
DECLARE @prior_end date = DATEADD(day, -7, @current_end);

WITH base AS (
    SELECT
        CAST(f.BizDateFull AS date) AS biz_date,
        f.BranchNum AS branch_num,
        COALESCE(NULLIF(b.branch_name, ''), CONVERT(varchar(32), f.BranchNum)) AS branch_name,
        CAST(ISNULL(f.Order_ActualSalesRevenue, 0) AS decimal(20,4)) AS sales,
        CAST(ISNULL(f.Order_BizsGrossProfit_CouponSellingPrice, 0) AS decimal(20,4)) AS gross_profit,
        CAST(ISNULL(f.Order_OrderCount, 0) AS decimal(20,4)) AS order_count,
        CAST(ISNULL(f.Member_ActualSalesRevenue, 0) AS decimal(20,4)) AS member_sales,
        CAST(ISNULL(f.Member_OrderCount, 0) AS decimal(20,4)) AS member_orders,
        CAST(ISNULL(f.Member_AverageOrderValue_CouponSellingPrice, 0) AS decimal(20,4)) AS member_aov
    FROM dbo.LM_Daily_PosOrder_Branch f
    LEFT JOIN dbo.LM_basic_branch b ON TRY_CONVERT(int, b.branch_num) = f.BranchNum
    WHERE CAST(f.BizDateFull AS date) BETWEEN @prior_start AND @current_end
),
store AS (
    SELECT
        branch_num,
        MAX(branch_name) AS branch_name,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN sales ELSE 0 END) AS sales,
        SUM(CASE WHEN biz_date BETWEEN @prior_start AND @prior_end THEN sales ELSE 0 END) AS prior_sales,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN gross_profit ELSE 0 END) AS gross_profit,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN order_count ELSE 0 END) AS order_count,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN member_sales ELSE 0 END) AS member_sales,
        SUM(CASE WHEN biz_date BETWEEN @prior_start AND @prior_end THEN member_sales ELSE 0 END) AS prior_member_sales,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN member_orders ELSE 0 END) AS member_orders,
        SUM(CASE WHEN biz_date BETWEEN @prior_start AND @prior_end THEN member_orders ELSE 0 END) AS prior_member_orders,
        SUM(CASE WHEN biz_date BETWEEN @current_start AND @current_end THEN member_aov * member_orders ELSE 0 END) AS member_aov_amount,
        SUM(CASE WHEN biz_date BETWEEN @prior_start AND @prior_end THEN member_aov * member_orders ELSE 0 END) AS prior_member_aov_amount
    FROM base
    GROUP BY branch_num
),
new_members AS (
    SELECT
        TRY_CONVERT(int, c.source_store_id) AS branch_num,
        COUNT(DISTINCT CASE
            WHEN c.create_time >= @current_start AND c.create_time < DATEADD(day, 1, @current_end)
            THEN c.customer_id END) AS new_members,
        COUNT(DISTINCT CASE
            WHEN c.create_time >= @prior_start AND c.create_time < DATEADD(day, 1, @prior_end)
            THEN c.customer_id END) AS prior_new_members
    FROM dbo.LM_basic_customer c
    WHERE c.create_time >= @prior_start
      AND c.create_time < DATEADD(day, 1, @current_end)
    GROUP BY TRY_CONVERT(int, c.source_store_id)
)
SELECT
    s.branch_num AS [门店编号],
    s.branch_name AS [门店名称],
    CAST(s.sales AS decimal(18,2)) AS [本周销售额],
    CAST(s.prior_sales AS decimal(18,2)) AS [上周销售额],
    CAST((s.sales-s.prior_sales)/NULLIF(s.prior_sales,0) AS decimal(18,4)) AS [销售周环比],
    CAST(s.gross_profit AS decimal(18,2)) AS [营业毛利],
    CAST(s.gross_profit/NULLIF(s.sales,0) AS decimal(18,4)) AS [营业毛利率],
    CAST(s.order_count AS decimal(18,2)) AS [订单数],
    CAST(s.sales/NULLIF(s.order_count,0) AS decimal(18,2)) AS [客单价],
    CAST(s.member_sales AS decimal(18,2)) AS [会员销售额],
    CAST(s.prior_member_sales AS decimal(18,2)) AS [上周会员销售额],
    CAST((s.member_sales-s.prior_member_sales)/NULLIF(s.prior_member_sales,0) AS decimal(18,4)) AS [会员销售额周环比],
    CAST(s.member_sales/NULLIF(s.sales,0) AS decimal(18,4)) AS [会员销售占比],
    CAST(s.member_orders AS decimal(18,0)) AS [会员订单数],
    CAST(s.prior_member_orders AS decimal(18,0)) AS [上周会员订单数],
    CAST((s.member_orders-s.prior_member_orders)/NULLIF(s.prior_member_orders,0) AS decimal(18,4)) AS [会员订单数周环比],
    CAST(s.member_aov_amount/NULLIF(s.member_orders,0) AS decimal(18,2)) AS [会员客单价],
    CAST(s.prior_member_aov_amount/NULLIF(s.prior_member_orders,0) AS decimal(18,2)) AS [上周会员客单价],
    CAST(
        (s.member_aov_amount/NULLIF(s.member_orders,0) - s.prior_member_aov_amount/NULLIF(s.prior_member_orders,0))
        / NULLIF(s.prior_member_aov_amount/NULLIF(s.prior_member_orders,0),0)
        AS decimal(18,4)
    ) AS [会员客单价周环比],
    CAST(ISNULL(n.new_members,0) AS decimal(18,0)) AS [新增会员数],
    CAST(ISNULL(n.prior_new_members,0) AS decimal(18,0)) AS [上周新增会员数],
    CAST((ISNULL(n.new_members,0)-ISNULL(n.prior_new_members,0))*1.0/NULLIF(n.prior_new_members,0) AS decimal(18,4)) AS [新增会员数周环比]
FROM store s
LEFT JOIN new_members n ON n.branch_num = s.branch_num
WHERE s.sales <> 0 OR s.prior_sales <> 0
ORDER BY s.sales DESC;
  2. YJC_lemeng 配销比周度只读查询Microsoft SQL Server via Metabase · 2026-07-27T11:29:00+08:00

    按门店计算本周与上周强管部门配销比及总配销比。

    SQL query
    
DECLARE @current_start date = '2026-07-20';
DECLARE @current_end date = '2026-07-26';
DECLARE @prior_start date = DATEADD(day, -7, @current_start);
DECLARE @prior_end date = DATEADD(day, -7, @current_end);

WITH periods AS (
    SELECT 0 AS period_id, @current_start AS period_start, @current_end AS period_end
    UNION ALL
    SELECT 1, @prior_start, @prior_end
),
item_dim AS (
    SELECT item_num, MAX(item_department) AS item_department
    FROM dbo.LM_basic_item
    GROUP BY item_num
),
branch_dim AS (
    SELECT branch_num, MAX(branch_name) AS branch_name
    FROM dbo.LM_basic_branch
    WHERE branch_rdc = 'false'
      AND center_branch_num = 99
      AND branch_extend9 = N'成熟店'
      AND ISNULL(branch_extend3, '') <> N'培教店'
    GROUP BY branch_num
),
sales AS (
    SELECT
        p.period_id,
        s.branch_num,
        i.item_department,
        SUM(
            (ISNULL(s.payment_money,0)-ISNULL(s.share_discount_money,0)+ISNULL(s.coupon_sale_share_discount,0))
            * (1 - CASE i.item_department
                WHEN N'散称食品' THEN CAST(0.207 AS decimal(9,4))
                WHEN N'定量食品' THEN CAST(0.187 AS decimal(9,4))
                WHEN N'酒水' THEN CAST(0.192 AS decimal(9,4))
                WHEN N'粮油' THEN CAST(0.160 AS decimal(9,4))
                WHEN N'日化' THEN CAST(0.210 AS decimal(9,4))
                WHEN N'百货' THEN CAST(0.320 AS decimal(9,4))
                ELSE CAST(0.200 AS decimal(9,4))
            END)
        ) AS standard_sales_cost
    FROM periods p
    INNER JOIN dbo.LM_PosOrderSummary s
        ON s.biz_date >= p.period_start AND s.biz_date < DATEADD(day,1,p.period_end)
    INNER JOIN branch_dim b ON s.branch_num = b.branch_num
    INNER JOIN item_dim i ON s.item_num = i.item_num
    GROUP BY p.period_id, s.branch_num, i.item_department
),
delivery AS (
    SELECT
        p.period_id,
        TRY_CONVERT(int,o.BusinessEntity) AS branch_num,
        i.item_department,
        SUM(ISNULL(o.DeliveryAmount,0)) AS delivery_amount
    FROM periods p
    INNER JOIN dbo.DWD_Outbound_Inc o
        ON o.biz_date >= p.period_start AND o.biz_date < DATEADD(day,1,p.period_end)
    INNER JOIN branch_dim b ON TRY_CONVERT(int,o.BusinessEntity)=b.branch_num
    INNER JOIN item_dim i ON o.item_num=i.item_num
    WHERE o.OutboundCategory=N'配送'
      AND o.DC_branch_num=99
    GROUP BY p.period_id, TRY_CONVERT(int,o.BusinessEntity), i.item_department
),
combined AS (
    SELECT
        COALESCE(s.period_id,d.period_id) AS period_id,
        COALESCE(s.branch_num,d.branch_num) AS branch_num,
        COALESCE(s.item_department,d.item_department) AS item_department,
        ISNULL(s.standard_sales_cost,0) AS standard_sales_cost,
        ISNULL(d.delivery_amount,0) AS delivery_amount
    FROM sales s
    FULL OUTER JOIN delivery d
      ON s.period_id=d.period_id
     AND s.branch_num=d.branch_num
     AND ISNULL(s.item_department,N'')=ISNULL(d.item_department,N'')
),
branch_period AS (
    SELECT
        period_id,
        branch_num,
        SUM(CASE WHEN item_department IN (N'散称食品',N'定量食品',N'酒水',N'粮油',N'日化',N'百货') THEN delivery_amount ELSE 0 END) AS strong_delivery,
        SUM(CASE WHEN item_department IN (N'散称食品',N'定量食品',N'酒水',N'粮油',N'日化',N'百货') THEN standard_sales_cost ELSE 0 END) AS strong_cost,
        SUM(delivery_amount) AS total_delivery,
        SUM(standard_sales_cost) AS total_cost
    FROM combined
    GROUP BY period_id, branch_num
)
SELECT
    b.branch_num AS [门店编号],
    MAX(b.branch_name) AS [门店名称],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.strong_delivery END) AS decimal(18,2)) AS [强管部门总部净配送金额],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.strong_cost END) AS decimal(18,2)) AS [强管部门标准销售成本],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.strong_delivery END) AS decimal(18,2)) AS [上周强管部门总部净配送金额],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.strong_cost END) AS decimal(18,2)) AS [上周强管部门标准销售成本],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.strong_delivery/NULLIF(p.strong_cost,0) END) AS decimal(18,4)) AS [强管部门配销比],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.strong_delivery/NULLIF(p.strong_cost,0) END) AS decimal(18,4)) AS [上周强管部门配销比],
    CAST(
        MAX(CASE WHEN p.period_id=0 THEN p.strong_delivery/NULLIF(p.strong_cost,0) END)
        - MAX(CASE WHEN p.period_id=1 THEN p.strong_delivery/NULLIF(p.strong_cost,0) END)
        AS decimal(18,4)
    ) AS [强管部门配销比变化],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.total_delivery END) AS decimal(18,2)) AS [总部净配送金额],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.total_cost END) AS decimal(18,2)) AS [总标准销售成本],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.total_delivery END) AS decimal(18,2)) AS [上周总部净配送金额],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.total_cost END) AS decimal(18,2)) AS [上周总标准销售成本],
    CAST(MAX(CASE WHEN p.period_id=0 THEN p.total_delivery/NULLIF(p.total_cost,0) END) AS decimal(18,4)) AS [总配销比],
    CAST(MAX(CASE WHEN p.period_id=1 THEN p.total_delivery/NULLIF(p.total_cost,0) END) AS decimal(18,4)) AS [上周总配销比],
    CAST(
        MAX(CASE WHEN p.period_id=0 THEN p.total_delivery/NULLIF(p.total_cost,0) END)
        - MAX(CASE WHEN p.period_id=1 THEN p.total_delivery/NULLIF(p.total_cost,0) END)
        AS decimal(18,4)
    ) AS [总配销比变化]
FROM branch_period p
INNER JOIN branch_dim b ON p.branch_num=b.branch_num
GROUP BY b.branch_num
ORDER BY [强管部门配销比变化] DESC;
  3. YJC_lemeng 商品销售排行只读查询Microsoft SQL Server via Metabase · 2026-07-27T12:58:00+08:00

    按商品汇总本周实际销售额、数量、毛利和销售门店数并取销售额前10名。

    SQL query
    
WITH item_dim AS (
    SELECT
        item_num,
        MAX(item_code) AS item_code,
        MAX(item_name) AS item_name,
        MAX(item_spec) AS item_spec,
        MAX(item_unit) AS item_unit,
        MAX(item_department) AS item_department
    FROM dbo.LM_basic_item
    GROUP BY item_num
),
product_sales AS (
    SELECT
        s.item_num,
        SUM(ISNULL(s.amount, 0)) AS sales_qty,
        SUM(
            ISNULL(s.payment_money, 0)
            - ISNULL(s.share_discount_money, 0)
            + ISNULL(s.coupon_sale_share_discount, 0)
        ) AS sales_amount,
        SUM(
            ISNULL(s.payment_money, 0)
            - ISNULL(s.share_discount_money, 0)
            + ISNULL(s.coupon_sale_share_discount, 0)
            - ISNULL(s.cost_total_money, 0)
        ) AS gross_profit,
        COUNT(DISTINCT s.branch_num) AS selling_store_count
    FROM dbo.LM_PosOrderSummary s
    WHERE s.shift_table_bizday >= 20260720
      AND s.shift_table_bizday < 20260727
    GROUP BY s.item_num
),
ranked AS (
    SELECT
        p.*,
        SUM(p.sales_amount) OVER () AS all_product_sales_amount,
        ROW_NUMBER() OVER (ORDER BY p.sales_amount DESC, p.item_num) AS sales_rank
    FROM product_sales p
)
SELECT TOP 10
    r.sales_rank AS [排名],
    r.item_num AS [商品编码],
    COALESCE(NULLIF(i.item_code, ''), CONVERT(varchar(32), r.item_num)) AS [商品代码],
    COALESCE(NULLIF(i.item_name, ''), CONVERT(varchar(32), r.item_num)) AS [商品名称],
    i.item_spec AS [规格],
    i.item_unit AS [单位],
    i.item_department AS [商品部门],
    CAST(r.sales_qty AS decimal(18,3)) AS [销售数量],
    CAST(r.sales_amount AS decimal(18,2)) AS [销售额],
    CAST(r.gross_profit AS decimal(18,2)) AS [销售毛利],
    CAST(r.gross_profit / NULLIF(r.sales_amount, 0) AS decimal(18,4)) AS [销售毛利率],
    r.selling_store_count AS [销售门店数],
    CAST(r.all_product_sales_amount AS decimal(18,2)) AS [全部商品销售额]
FROM ranked r
LEFT JOIN item_dim i ON i.item_num = r.item_num
ORDER BY r.sales_rank;