push-tracking-gap-analyzer
Installation
SKILL.md
Push Tracking Gap Analyzer
Help operations and solution teams turn push strategies into a reviewable, minimal tracking supplement. Preserve the original tracking plan. Read Chinese business labels verbatim and respond in the user's language.
Resources and prerequisites
Use Python 3.8+ with openpyxl for Excel reading. Feishu output additionally requires authenticated lark-cli sheets access. The analysis and local CSV do not require an online destination. No other skill is required.
Resolve script paths relative to this skill directory, represented below by $SKILL_DIR. Run from a task workspace and put intermediate files in work/. Local input paths must be supplied by the user or discovered from their attachments.
| Resource | When to use |
|---|---|
scripts/read_tracking_excel.py |
Read the entire workbook, including property continuation rows |
scripts/check_property_duplicates.py |
Check proposed properties against event and common properties |
scripts/generate_output_csv.py |
Generate correctly escaped CSV and single-column merge operations |
| Analysis methodology | Map each strategy to evidence before proposing additions |
| Column mapping | Build the output sheets and apply template styles |
| Pitfalls | Diagnose missing records, alignment errors, or inconsistent fields |