biz-reporter

# Biz Reporter

Business intelligence that writes itself. Pull data from multiple sources, spot trends, and generate beautiful reports — on demand or on schedule.

## Why This Exists

Data & Analytics has only 18 skills out of 3,286 on ClawHub — the most underserved category by far. Yet automated reporting is called "the most universally loved automation" in the OpenClaw community. Every business needs it, nobody has built it properly.

## How It Works

Biz Reporter connects to the user's business tools, pulls key metrics, applies trend analysis, and generates a formatted report. It works with whatever tools the user has — from a solo founder with just Google Analytics to a team with a full data stack.

## Supported Data Sources

### Web Analytics
- **Google Analytics (GA4)**: sessions, users, pageviews, bounce rate, top pages, traffic sources
- **Google Search Console**: impressions, clicks, CTR, average position, top queries
- Access via `gog` tool, browser automation, or API calls

### Revenue & Payments
- **Stripe**: MRR, revenue, new customers, churn, top products
- **PayPal**: transaction summaries
- Access via CLI tools or API calls with stored credentials

### Social Media
- **Twitter/X**: followers, engagement, top posts
- **LinkedIn**: page views, post engagement, follower growth
- **Instagram**: reach, engagement, follower count
- Access via APIs or browser automation

### CRM & Sales
- **HubSpot**: leads, pipeline value, deals closed, contact growth
- **Airtable**: custom database metrics
- Access via API with stored keys

### Custom Sources
- **Any API**: the user can specify custom API endpoints to pull data from
- **CSV files**: if the user dumps data as CSV, parse and include it
- **Spreadsheets**: Google Sheets via API

## Report Types

### Daily KPI Snapshot
Quick pulse check — 2-3 minutes to generate, meant for morning review.

```
📊 Daily KPI Snapshot — [Date]

🌐 Website: [sessions] sessions ([+/-]% vs yesterday)
   Top page: [page] ([views] views)
   
💰 Revenue: $[amount] ([+/-]% vs yesterday)
   New customers: [count]
   
📱 Social: [total engagement] across platforms
   Best post: [platform] — [description] ([engagement])

⚡ Quick take: [One sentence AI analysis of the day]
```

### Weekly Marketing Report
Comprehensive marketing performance overview.

```
📈 Weekly Marketing Report — [Date Range]

EXECUTIVE SUMMARY
[2-3 sentence overview: what went well, what needs attention, key number]

WEBSITE PERFORMANCE
• Sessions: [number] ([%] vs last week)
• Unique visitors: [number]
• Top traffic sources: [source 1] ([%]), [source 2] ([%]), [source 3] ([%])
• Top 5 pages by traffic:
  1. [page] — [views] views
  2. ...
• Bounce rate: [%] ([trend])

SEARCH PERFORMANCE
• Impressions: [number] ([%] change)
• Clicks: [number] ([%] change)
• Average CTR: [%]
• Average position: [number]
• Top gaining queries: [query] (+[positions])
• Top losing queries: [query] (-[positions])

SOCIAL MEDIA
• Total followers: [number] (net +[growth])
• Total engagement: [number]
• Best performing post: [description]
• Platform breakdown:
  - Twitter/X: [followers], [engagement]
  - LinkedIn: [followers], [engagement]

REVENUE (if available)
• Total revenue: $[amount] ([%] vs last week)
• New customers: [count]
• Churn: [count] ([%])
• MRR: $[amount]

TRENDS & INSIGHTS
• [AI-generated insight about notable trends]
• [Comparison to historical averages]
• [Actionable recommendation]

NEXT WEEK FOCUS
• [Suggested action based on data]
```

### Monthly Business Review
Deep analysis with historical comparisons and strategic recommendations.

Follow the weekly format but expand with:
- Month-over-month and year-over-year comparisons
- Cohort analysis for customer retention (if data available)
- Content performance breakdown (which articles drove traffic)
- Funnel analysis: visitors → signups → customers (if trackable)
- Strategic recommendations section with specific actions

### Custom Report
If the user asks for something specific, build it:
- "Show me our top 10 pages by revenue contribution"
- "Compare this month's social engagement to last month"
- "What keywords are we losing rankings for?"

## Trend Detection

Biz Reporter doesn't just show numbers — it spots patterns:

1. **Week-over-week anomalies**: flag metrics that changed more than 20% from the prior week
2. **Declining trends**: if a metric has dropped for 3+ consecutive periods, raise it prominently
3. **Correlation hints**: "Traffic from Twitter spiked 40% — this correlates with your viral post on [date]"
4. **Seasonal patterns**: if historical data shows patterns (e.g., weekend dips), note them instead of alerting
5. **Comparison framing**: always show the comparison baseline so numbers have context

## Natural Language Queries

Users can ask questions about their data conversationally:

| User says | Action |
|-----------|--------|
| "How's our traffic this week?" | Quick web analytics summary with week-over-week comparison |
| "What's our MRR?" | Pull Stripe data, show current MRR with trend |
| "Which blog posts are getting the most traffic?" | Top pages report from GA4 |
| "Are we ranking better or worse this month?" | Search Console comparison |
| "Generate my weekly report" | Full weekly marketing report |
| "How did our launch go?" | Pull metrics for a specific date range around the launch |
| "Show me revenue by month for the last 6 months" | Historical revenue chart description |

## Scheduling Reports

Help users set up recurring reports via cron:

```json
[
  {
    "name": "Daily KPI snapshot",
    "schedule": "0 8 * * 1-5",
    "prompt": "Generate daily KPI snapshot and send to Slack #metrics"
  },
  {
    "name": "Weekly marketing report",
    "schedule": "0 9 * * 1",
    "prompt": "Generate weekly marketing report for last week and send via email"
  },
  {
    "name": "Monthly business review",
    "schedule": "0 10 1 * *",
    "prompt": "Generate monthly business review for last month and post to Notion"
  }
]
```

## Setup & Configuration

On first use:

1. **Discover available tools**: check which data sources the user has access to (GA4, Stripe, etc.)
2. **Authenticate**: help configure API keys or tool access for each source. Store securely in environment variables, never in SKILL.md or memory.
3. **Baseline**: pull initial data to establish benchmarks for future comparisons
4. **Preferences**: ask about reporting frequency, delivery channel, and which metrics matter most
5. **Store config**: save all preferences in workspace memory

## Output Formats

Reports can be delivered as:
- **Chat message**: formatted directly in the conversation or messaging channel
- **Markdown file**: saved to workspace for archival
- **Notion page**: if Notion skill is available
- **Email**: via configured email skill
- **Slack/Discord message**: for team channels

## Edge Cases

- **Partial data**: if some sources are unavailable, generate the report with what's available and note what's missing
- **No historical data**: on first run, can only show current snapshot. Note that comparisons will be available next period.
- **API rate limits**: cache data within a session and batch requests
- **Zero traffic / new site**: don't show depressing "0 visitors" — instead focus on setup progress and first wins
- **Multiple properties**: if user has multiple websites/products, ask which one or generate combined report
- **Currency**: detect user locale and format currency appropriately
- **Privacy**: never include individual user data or PII in reports. Aggregate only.