โ† All skills
Tencent SkillHub ยท Developer Tools

Client Reporting Automation

Automated client reporting for agencies and freelancers using OpenClaw. Pull data from Google Analytics, Google Search Console, social media platforms, and c...

skill openclawclawhub Free
0 Downloads
0 Stars
0 Installs
0 Score
High Signal

Automated client reporting for agencies and freelancers using OpenClaw. Pull data from Google Analytics, Google Search Console, social media platforms, and c...

โฌ‡ 0 downloads โ˜… 0 stars Unverified but indexed

Install for OpenClaw

Quick setup
  1. Download the package from Yavira.
  2. Extract the archive and review SKILL.md first.
  3. Import or place the package into your OpenClaw setup.

Requirements

Target platform
OpenClaw
Install method
Manual import
Extraction
Extract archive
Prerequisites
OpenClaw
Primary doc
SKILL.md

Package facts

Download mode
Yavira redirect
Package format
ZIP package
Source platform
Tencent SkillHub
What's included
SKILL.md, references/ga4-setup.md, references/report-customization.md, scripts/add-client.sh, scripts/dashboard.sh, scripts/deliver-report.sh

Validation

  • Use the Yavira download entry.
  • Review SKILL.md after the package is downloaded.
  • Confirm the extracted package contains the expected setup assets.

Install with your agent

Agent handoff

Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.

  1. Download the package from Yavira.
  2. Extract it into a folder your agent can access.
  3. Paste one of the prompts below and point your agent at the extracted folder.
New install

I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.

Upgrade existing

I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.

Trust & source

Release facts

Source
Tencent SkillHub
Verification
Indexed source record
Version
1.0.0

Documentation

ClawHub primary doc Primary doc: SKILL.md 13 sections Open source page

Client Reporting Automation

Pull metrics from multiple sources, generate branded reports, and auto-deliver to clients. Built for agencies and freelancers who need consistent, professional reporting without manual work.

Dependencies

pip3 install requests jinja2

API Keys (configure in config.json)

Google Analytics 4 โ€” GA4_PROPERTY_ID + service account key Google Search Console โ€” service account key (see seo-audit-suite references) Social platforms โ€” same credentials as social-media-autopilot skill SendGrid โ€” for email delivery (SENDGRID_API_KEY)

Workspace

client-reports/ โ”œโ”€โ”€ config.json # Global settings, API keys โ”œโ”€โ”€ clients/ # Per-client configuration โ”‚ โ””โ”€โ”€ client-name/ โ”‚ โ”œโ”€โ”€ config.json # Client-specific settings (property IDs, branding) โ”‚ โ”œโ”€โ”€ reports/ # Generated reports โ”‚ โ””โ”€โ”€ data/ # Cached metrics data โ”œโ”€โ”€ templates/ # Report templates (Jinja2 HTML) โ””โ”€โ”€ schedules.json # Automated delivery schedule Run scripts/init-workspace.sh to create this structure.

1. Add a Client

scripts/add-client.sh --name "acme-corp" --domain "acme.com" --email "ceo@acme.com" Creates client directory with config template. Edit clients/acme-corp/config.json to add: GA4 property ID Search Console site URL Social media handles Branding (logo URL, brand colors) Report preferences (metrics to include, frequency)

2. Pull Metrics

Fetch fresh data for a client: scripts/pull-metrics.sh --client "acme-corp" # All sources scripts/pull-metrics.sh --client "acme-corp" --source ga4 # Google Analytics only scripts/pull-metrics.sh --client "acme-corp" --source gsc # Search Console only scripts/pull-metrics.sh --client "acme-corp" --source social # Social metrics scripts/pull-metrics.sh --client "acme-corp" --period 30d # Last 30 days Data sources and metrics: Google Analytics 4: Sessions, users, new users, bounce rate Top pages by views Traffic sources breakdown Conversion events Device/browser breakdown Google Search Console: Total clicks, impressions, CTR, avg position Top queries by clicks Top pages by impressions Position changes vs previous period Social Media: Followers/following changes Post engagement (likes, shares, comments) Top performing posts Reach/impressions

3. Generate Reports

scripts/generate-report.sh --client "acme-corp" --type monthly scripts/generate-report.sh --client "acme-corp" --type weekly --format html scripts/generate-report.sh --client "acme-corp" --type custom --metrics "traffic,rankings,social" Report types: weekly โ€” 7-day snapshot with week-over-week changes monthly โ€” 30-day deep dive with month-over-month trends quarterly โ€” 90-day strategic overview custom โ€” pick specific metrics Output formats: Markdown โ€” default, good for Slack/email HTML โ€” branded, professional, email-ready PDF โ€” via HTML-to-PDF conversion (requires wkhtmltopdf or similar)

4. Auto-Deliver Reports

scripts/deliver-report.sh --client "acme-corp" --latest # Send most recent scripts/deliver-report.sh --client "acme-corp" --via email # Email delivery scripts/deliver-report.sh --client "acme-corp" --via slack # Slack webhook

5. Schedule Recurring Reports

Configure in schedules.json: { "schedules": [ { "client": "acme-corp", "type": "weekly", "day": "monday", "time": "09:00", "timezone": "America/Los_Angeles", "deliver_via": "email", "enabled": true }, { "client": "acme-corp", "type": "monthly", "day_of_month": 1, "time": "09:00", "timezone": "America/Los_Angeles", "deliver_via": "email", "enabled": true } ] } Use with OpenClaw cron to automate: check schedules daily, generate and deliver due reports.

6. KPI Dashboard

Quick terminal dashboard for any client: scripts/dashboard.sh --client "acme-corp" Shows current period vs previous: traffic, rankings, social growth, conversions.

Report Template System

Templates use Jinja2 and live in templates/: <!-- templates/monthly.html --> <html> <head><style>/* brand styles */</style></head> <body> <h1>Monthly Report โ€” {{ client.name }}</h1> <p>{{ period.start }} to {{ period.end }}</p> <h2>Traffic Overview</h2> <table> <tr><td>Sessions</td><td>{{ ga4.sessions }}</td><td>{{ ga4.sessions_change }}%</td></tr> <tr><td>Users</td><td>{{ ga4.users }}</td><td>{{ ga4.users_change }}%</td></tr> </table> <h2>Search Performance</h2> <!-- ... --> </body> </html> Customize templates per client by placing overrides in clients/<name>/templates/.

Cron Integration

Daily: Pull fresh metrics for all active clients Weekly: Generate and deliver weekly reports (Monday AM) Monthly: Generate and deliver monthly reports (1st of month) Quarterly: Generate quarterly reviews

References

references/ga4-setup.md โ€” Google Analytics 4 API setup and available metrics references/report-customization.md โ€” How to customize templates and metrics

Category context

Code helpers, APIs, CLIs, browser automation, testing, and developer operations.

Source: Tencent SkillHub

Largest current source with strong distribution and engagement signals.

Package contents

Included in package
3 Docs3 Scripts
  • SKILL.md Primary doc
  • references/ga4-setup.md Docs
  • references/report-customization.md Docs
  • scripts/add-client.sh Scripts
  • scripts/dashboard.sh Scripts
  • scripts/deliver-report.sh Scripts