Agent skill

weekly-report

Generate weekly performance reports aggregating metrics across accounts and campaigns, highlighting winners and losers, calculating ROI/ROAS, and providing recommendations. Use for weekly review meetings, client updates, or tracking overall performance trends.

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/weekly-report

SKILL.md

Weekly Report Generator

Create comprehensive weekly performance summaries.

Process

Step 1: Aggregate Metrics

Gather Data From:

  • All active ad accounts
  • All campaigns
  • Tracking platforms
  • Network/offer dashboards

Key Metrics:

  • Total spend
  • Total revenue/conversions
  • CPA/CPL by offer
  • ROAS/ROI overall
  • Click metrics (CTR, CPC)
  • Conversion metrics (CVR)

Step 2: Highlight Winners and Losers

Winners:

  • Top performing campaigns
  • Best creative performers
  • Offers exceeding targets
  • Scaling successes

Losers:

  • Underperforming campaigns
  • Failing creatives
  • Offers below target
  • Budget drains

Step 3: Calculate Overall ROI/ROAS

Formulas:

  • ROI = (Revenue - Spend) / Spend × 100
  • ROAS = Revenue / Spend
  • Profit = Revenue - Spend
  • Margin = Profit / Revenue × 100

Segment By:

  • Offer/vertical
  • Traffic source
  • Account
  • Creative type

Step 4: Identify Trends and Anomalies

Trend Analysis:

  • Week-over-week changes
  • Month-over-month changes
  • Seasonal patterns
  • Platform changes impact

Anomaly Detection:

  • Sudden performance drops
  • Unexpected winners
  • Cost spikes
  • Volume changes

Step 5: Output Executive Summary

## WEEKLY REPORT: [Date Range]

### EXECUTIVE SUMMARY

**Overall Performance:**
- Total Spend: $[X]
- Total Revenue: $[X]
- Profit: $[X]
- ROI: [X]%
- ROAS: [X]x

**Week-over-Week:**
- Spend: [+/-X%]
- Revenue: [+/-X%]
- ROI: [+/-X pts]

**Key Wins:**
- [Win 1]
- [Win 2]

**Key Challenges:**
- [Challenge 1]
- [Challenge 2]

---

### PERFORMANCE BY OFFER

| Offer | Spend | Revenue | Profit | ROI | vs Target | Status |
|-------|-------|---------|--------|-----|-----------|--------|
| [Offer 1] | $X | $X | $X | X% | +/-X% | [G/Y/R] |
| [Offer 2] | $X | $X | $X | X% | +/-X% | [G/Y/R] |
| **TOTAL** | $X | $X | $X | X% | | |

---

### TOP PERFORMERS

**Best Campaigns:**
1. [Campaign] - ROI: X%, Spend: $X
2. [Campaign] - ROI: X%, Spend: $X
3. [Campaign] - ROI: X%, Spend: $X

**Best Creatives:**
1. [Creative] - CPA: $X, Spend: $X
2. [Creative] - CPA: $X, Spend: $X
3. [Creative] - CPA: $X, Spend: $X

**Scaling Successes:**
- [Description of what scaled well]

---

### UNDERPERFORMERS

**Struggling Campaigns:**
1. [Campaign] - Issue: [Problem], Action: [Fix]
2. [Campaign] - Issue: [Problem], Action: [Fix]

**Failed Creatives:**
- [Creative batch] - Why: [Analysis]

**Budget Drains:**
- [Where money was lost and why]

---

### TREND ANALYSIS

**Week-over-Week Comparison:**
| Metric | Last Week | This Week | Change |
|--------|-----------|-----------|--------|
| Spend | $X | $X | +/-X% |
| Revenue | $X | $X | +/-X% |
| CPA | $X | $X | +/-X% |
| CVR | X% | X% | +/-X pts |

**Notable Trends:**
- [Trend 1 with analysis]
- [Trend 2 with analysis]

**Anomalies:**
- [Unusual occurrence and explanation]

---

### ACCOUNT HEALTH

| Account | Status | Spend | Issues |
|---------|--------|-------|--------|
| [Acc 1] | Active | $X | None |
| [Acc 2] | Warning | $X | [Issue] |
| [Acc 3] | Scaling | $X | None |

---

### CREATIVE STATUS

**Production This Week:**
- New creatives launched: [#]
- Variations created: [#]
- Concepts tested: [#]

**Creative Inventory:**
- Active winners: [#]
- In testing: [#]
- In production: [#]

**Fatigue Alerts:**
- [Creatives showing fatigue]

---

### RECOMMENDATIONS

**Immediate Actions (This Week):**
1. [Action] - Priority: High - Owner: [Name]
2. [Action] - Priority: High - Owner: [Name]

**Strategic Initiatives (This Month):**
1. [Initiative] - Expected impact: [Result]
2. [Initiative] - Expected impact: [Result]

**Tests to Run:**
1. [Test hypothesis]
2. [Test hypothesis]

---

### NEXT WEEK GOALS

| Metric | Target | Stretch |
|--------|--------|---------|
| Spend | $X | $X |
| Revenue | $X | $X |
| ROI | X% | X% |

**Focus Areas:**
1. [Priority 1]
2. [Priority 2]
3. [Priority 3]

---

### APPENDIX

**Daily Breakdown:**
[Detailed daily metrics if needed]

**Campaign Details:**
[Expanded campaign-level data]

Reporting Best Practices

Frequency:

  • Daily: Quick CPA/spend check
  • Weekly: Full performance review
  • Monthly: Strategic analysis

Audience Adaptation:

  • Executive: Summary + recommendations
  • Media buyer: Detailed metrics + actions
  • Creative team: What's working/not working

Action Orientation:

  • Every insight should have an action
  • Prioritize recommendations
  • Assign ownership

Source: General affiliate/agency best practices

Didn't find tool you were looking for?

Be as detailed as possible for better results