A professional automation skill for tracking daily business metrics, calculating growth trends, and maintaining historical KPI records in Markdown.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install xiaozhua-daily-data-tracker
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install xiaozhua-daily-data-tracker using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Daily Data Tracker?
The Daily Data Tracker is a specialized utility designed for developers and analysts who need to maintain rigorous historical records of business performance. By integrating this skill into your Openclaw Skills environment, you can automate the capture of critical metrics such as Billed Revenue, Gross Adds, EOP, and Paid Subscriptions. It acts as a lightweight data warehouse, storing information in a structured format that is easily readable by both humans and automated agents.
This skill eliminates the manual overhead of updating spreadsheets by automatically appending daily captures to a centralized history file. Its primary value lies in its ability to synthesize raw data into actionable insights through automated calculations, ensuring that performance fluctuations are identified immediately rather than discovered days later during manual reviews.
Daily Data Tracker Use Cases
- Automatically logging daily revenue and subscription growth metrics into a persistent history.
- Monitoring product-specific performance across different channels like Word, Excel, and PPT.
- Generating Week-over-Week (WoW) reports to evaluate short-term marketing or product impact.
- Setting up automated alerts for multi-day downward trends in user retention or acquisition.
- Building a local data source for PowerBI or other visualization dashboards using Openclaw Skills.
How Daily Data Tracker Works
- The skill triggers after daily data collection tasks are completed, receiving the latest raw metrics.
- It formats the data into a new row and appends it to the historical table located in memory/powerbi-daily-track.md.
- If benchmark values (captured at specific times like 23:30) are provided, the skill updates the corresponding notes for precision.
- It automatically calculates the Week-over-Week (WoW) percentage by comparing the current day to the record from seven days prior.
- The skill analyzes the last few entries to detect consecutive drops or negative trends over a 2-week period.
- It computes moving averages (7-day and 30-day) to provide a smoothed view of the data trajectory.
Daily Data Tracker Setup
To deploy this skill within your Openclaw Skills workflow, ensure the storage directory exists and the initial tracking file is created:
mkdir -p memory
touch memory/powerbi-daily-track.md
Ensure your data ingestion agent is configured to pass the daily metrics (Revenue, Adds, EOP, etc.) to this skill following the successful completion of your daily scraping or API fetching routines.
Daily Data Tracker Data Schema & Taxonomy
The skill maintains a structured Markdown table within the memory/ directory. The schema follows this format:
| Field | Description |
|---|---|
| Date | The tracking date (YYYY-MM-DD) |
| Billed Revenue | Daily financial intake |
| Gross Adds | New user sign-ups or additions |
| EOP | End of Period total user count |
| Paid Subs | Count of active paid subscriptions |
| Product Totals | Specific counts for PPT, Word, Excel, and Channel |
Trend analysis logic is applied to these columns, where WoW = (Today - Day-7) / Day-7 * 100%.
Daily Data Tracker Advanced Features
- Intelligent WoW calculation with automatic handling of missing data during month-over-month transitions.
- Automated trend alerts that trigger when metrics decline for three consecutive days.
- Support for benchmark value updates to ensure final daily figures are perfectly synchronized.
- Moving average integration for both 7-day and 30-day windows to filter out daily noise.
- Specialized annotations for holidays and weekends to provide context for expected traffic fluctuations.
SKILL.md
Loading
Related Openclaw Skills
Agent Deployment
A professional framework for deploying and managing AI agents on WSL2/Linux environments using Openclaw and GitHub Copilot.
Copywriting Optimization Skill
A sophisticated text refinement tool that adjusts communication style based on roles, scenarios, and audience needs.
Data Completeness Check
A dual-timestamp comparison mechanism to verify if Power BI data has finished backfilling before triggering reports.
Weekly Card Generator
A specialized tool that distills work summaries into elegant, 4:3 minimalist technology-style reporting cards for high-impact communication.
Academic Research
An automated research assistant that retrieves, filters, and synthesizes academic literature into structured reports and presentations.
Storage Engine Selector
A 7-dimensional trade-off analysis tool for selecting the optimal database storage engine architecture based on specific workload patterns.
Featured*
