weekly-performance-digestlisted

# Weekly Performance Digest A skill for producing publication-ready weekly Google Ads performance reports. ## What this skill does Given two weeks of campaign data (this week vs. last week, plus same week last month for MoM context), produces a digest with: 1. Executive summary (3 sentences) 2. Key metrics table with WoW and MoM comparisons 3. Campaign highlights (top 3 + bottom 3) 4. Anomalies and flags 5. Prioritized action items for next week Output is plain-language, non-technical - sendable directly to stakeholders. ## Required inputs 1. **This week's campaign data** (last 7 days) 2. **Last week's data** (the 7 days before that) 3. **Same week last month** (for MoM comparison; optional but recommended) 4. **Known changes context** - any new campaigns, paused ads, budget shifts, creative updates the user made ### Required columns For each period: - Campaign name - Spend, Impressions, Clicks, CTR, CPC - Conversions, CPA, Conv. rate - Conv. value / Revenue (if tracked) - ROAS (if tracked) ## Workflow ### Step 1: Validate data alignment Both periods must have: - Same set of campaigns (or note any added/removed) - Same column structure - Comparable date ranges (7 days each) If a campaign was added or removed between periods, note it explicitly - comparisons across asymmetric periods are misleading. ### Step 2: Compute aggregates and deltas Account-level totals (this week vs. last week): | Metric | Formula | |---|---| | WoW change % | (this - last) / last × 100