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
code
## 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