biz-reporterAutomated business intelligence reports pulling data from Google Analytics GA4, Google Search Console, Stripe revenue, social media metrics (Twitter/X, Linke...
Install via ClawdBot CLI:
clawdbot install ariktulcha/biz-reporterBusiness intelligence that writes itself. Pull data from multiple sources, spot trends, and generate beautiful reports ā on demand or on schedule.
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.
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.
gog tool, browser automation, or API callsQuick 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]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]Deep analysis with historical comparisons and strategic recommendations.
Follow the weekly format but expand with:
If the user asks for something specific, build it:
Biz Reporter doesn't just show numbers ā it spots patterns:
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 |
Help users set up recurring reports via cron:
[
{
"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"
}
]On first use:
Reports can be delivered as:
Generated Mar 1, 2026
An online retailer uses the daily KPI snapshot to monitor website traffic, revenue from Stripe, and social media engagement each morning. The AI flags anomalies like a sudden drop in conversion rates, enabling quick adjustments to ad spend or promotions.
A SaaS startup generates weekly marketing reports combining Google Analytics, Google Search Console, and HubSpot data. The report highlights SEO performance, lead generation trends, and MRR changes, with AI insights suggesting focus areas for the next week.
A digital marketing agency creates monthly business reviews for clients by pulling data from multiple sources like social media APIs and Airtable. The report includes year-over-year comparisons, funnel analysis, and strategic recommendations to demonstrate ROI.
A content creator asks natural language queries such as 'how did our launch go' to compare traffic and engagement across platforms after a new product release. The skill combines data from Instagram, Twitter, and Google Analytics into a custom report.
A nonprofit uses the skill to track donations via Stripe and PayPal, alongside website traffic from Google Analytics. Weekly reports show fundraising trends, donor engagement, and social media reach, with alerts for declining donation patterns.
This model relies on recurring revenue from monthly or annual subscriptions. The skill tracks MRR, churn rates, and customer acquisition costs via Stripe and HubSpot, providing insights for retention and growth strategies.
Revenue is generated from one-time product sales. The skill monitors daily sales, conversion rates, and traffic sources, helping optimize marketing spend and inventory based on real-time data trends.
Income comes from project-based fees or retainer contracts. The skill analyzes pipeline value in HubSpot, social media engagement for client campaigns, and website performance to forecast revenue and improve service delivery.
š¬ Integration Tip
Start by connecting one data source like Google Analytics to generate daily snapshots, then gradually add others such as Stripe for revenue tracking to build comprehensive reports.
Marketing Mode combines 23 comprehensive marketing skills covering strategy, psychology, content, SEO, conversion optimization, and paid growth. Use when users need marketing strategy, copywriting, SEO help, conversion optimization, paid advertising, or any marketing tactic.
Access 23 marketing modules offering checklists, frameworks, and ready-to-use deliverables for CRO, SEO, copywriting, analytics, launches, ads, and social me...
SEO specialist agent with site audits, content writing, keyword research, technical fixes, link building, and ranking strategies.
Perform deep SEO competitor analysis, including keyword research, backlink checking, and content strategy mapping. Use when the user wants to analyze a website's competitors or improve their own SEO ranking by studying the competition.
Query Google Search Console for SEO data - search queries, top pages, CTR opportunities, URL inspection, and sitemaps. Use when analyzing search performance,...
Run local SEO autopilot for boll-koll.se or hyresbyte.se and return PR link plus summary.