12 Commits
Author SHA1 Message Date
FANGKKandClaude Opus 5 88084ce5ff Add period-over-period trend table at top of report
build_data.py now also computes each buyer's total for the preceding
3-day window under identical rules (exclusions, attribution), exposed as
prev_total plus meta.prev_range. index.html renders it as the first
panel, with green/red deltas and a total row; the panel stays hidden if
no prior period exists.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
2026-09-07 23:42:03 +08:00
FANGKKandClaude Opus 5 fcf9a5c01b Add Geo suffix and Adpingid column to 投手明细
Package now renders as pkg_GEO, where GEO is the region with the highest
total spend for that package. The new Adpingid column shows the
top-spending Adping within that region, so label and id stay consistent.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
2026-08-27 14:39:38 +08:00
FANGKKandClaude Opus 5 06f701699e Show Adpingid counts per buyer in 投手明细
build_data.py now emits active_ids (Adpingids with spend in the window)
and owned_ids (Adpingids assigned to the buyer, exclusions removed).
active_ids sums to the 覆盖 Adpingid 数 card.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
2026-08-27 14:31:45 +08:00
FANGKKandClaude Opus 5 d980690ff2 Add spend labels on bars and $ currency symbols
- 各投手本周期内投放花费: draw value labels at each bar end via a small
  inline Chart.js plugin (no extra CDN dependency); right padding added
  so labels stay inside the panel.
- Prefix all spend figures with $: summary card, both chart axes and
  tooltips, buyer subtotals, and package detail tables.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
2026-08-27 14:23:36 +08:00
fangjie f99e8c004f Update index.html 2026-08-25 18:52:39 +08:00
fangjie 91e51c56ed Update index.html 2026-08-25 18:42:03 +08:00
fangjie 3cccfa361a Revert to data.json approach for stability 2026-08-25 18:23:52 +08:00
fangjie af41220587 Add Excel parsing: read xlsx file and process data dynamically 2026-08-25 18:21:14 +08:00
fangjie 1ff921ca6e Change chart title: Week to 本周期内 2026-08-25 16:12:13 +08:00
fangjie ae6e7cc884 Add data_range to metaLine display 2026-08-25 16:02:33 +08:00
fangjie dc0a676afb style: blue/white theme, black text, PingFang SC font 2026-08-25 11:05:50 +08:00
fangjie 661b3efdd1 add index.html 2026-08-24 18:54:59 +08:00