PR

管理画面LTVデータ再集計 #4560

wada opened this at 2026-03-06T18:00:33; closed

Description

opened by wada at 2026-03-06T18:00:33; updated 2026-03-09T15:47:33

概要

管理画面LTVにPU、課金率、ARPPU、ARPU追加用のデータ集計
jrye_cpanel.cpanel_monthly_user_ltvに累計PUカラムを追加
~~現在ヤマダのみ集計~~

ALTER TABLE `cpanel_monthly_user_ltv` 
ADD COLUMN `cumulative_pu` int(11) NOT NULL DEFAULT '0' AFTER `sum_price`;
wada merge at 2026-03-09T15:47:30: 管理画面LTVデータ再集計
wada close at 2026-03-09T15:47:30: Close
wada delete_branch at 2026-03-09T15:47:33: tool_ltv_pu

Commit range

base424211b1b553511fdf16b041353b454662efd6cb
head54377def8363273bd2765bf0c41658a3e5652d06
base branchjolly/jr-web:master
head branchjolly/jr-web:tool_ltv_pu

View commits

Commit details are loaded from Git when a dynamic archive server is running, or can be embedded with --include-commits.
Files changed1 filesView patch
statusfile
addedlib/exec/tool_monthly_user_ltv_pu.php
Patch body is stored as a separate file to keep this page lightweight.