Spaces:
Runtime error
Runtime error
Commit History
-
refactor: align column names with updated Sheets headers
wen Qiu- "流量大类" → "funnel", "广告目标/广告目的" → "优化目标" - p3_config.py: update header-skip logic to recognize new names - Update comments/docstrings across campaign_parser, p3_metrics, p3_analyzer, p3_report, config.yaml Made-with: Cursor8d0d365 -
fix: use independent gspread client in p3_config to avoid HTTPClient.open_by_key error
wen Qiugspread 6.x spreadsheet.client returns HTTPClient not gspread.Client, so open_by_key is not available. Create a standalone gspread client with the same credentials instead. Made-with: Cursorf3833f0 -
feat: add P3 投放分析引擎 (campaign analysis engine)
wen Qiu- Campaign Name 12-field parser with audience classification - Dynamic config loader from Google Sheets (budgets, KPI, benchmarks) - Per-objective metrics engine (Purchase/Lead/ATC/Linkclick/Pageview/PE) - L1-L4 hierarchical aggregation (market → funnel → platform → campaign) - Benchmark annotation (red/yellow/green) driven entirely by Sheets data - Diagnostic rules engine with actionable recommendations - Markdown weekly report formatter - API routes: GET /api/p3/analysis, GET /api/p3/config, POST /api/p3/push - 16 unit tests for campaign name parser - Fix Python 3.9 compatibility (from __future__ import annotations) - Fix percentage parsing bug (0.14% was incorrectly kept as 0.14) Made-with: Cursorebb46dc