AI Blocks › Track your numbers
Get your weekly numbers, a forecast and a dashboard in one run
Describe your weekly numbers. Get a report you can rerun, a forecast and a shareable dashboard.
Build a weekly KPI report with a forecast and dashboard is a free AI workflow for the job "Track your numbers". It guides your AI through several skills in order, passing each step's output to the next.
Free · No account · Made by AI Blocks
What it does
Many people rebuild the same weekly numbers by hand, and each time the definitions shift a little. Last week's "sales" included refunds and this week's does not. A forecast added on top inherits the drift, and a chart pasted into a slide goes stale in a day. The steps fix the numbers first. The report step turns your plain description into metrics with a formula, a grouping, a comparison and a period, builds the workbook, and saves the definition so it reruns the same way. The analysis step then reads the weekly series, splits trend from season, flags spikes and dips, and forecasts with a test on held-back weeks. The dashboard step puts the headline numbers, the trend and the forecast range on one page with filters.
You give it
- A plain description of the report, with the numbers, the groups, the comparison and the period
- A spreadsheet or export with at least two full seasons of weekly history (optional but best)
- How far ahead to forecast
- Known events such as promos or outages, so spikes can be explained (optional)
You get
- A workbook with each metric defined once, plus a saved definition to rerun
- A read on trend, seasons and odd spikes, with a forecast table and ranges
- A test of the forecast on weeks it did not see
- One page with headline cards, trend and forecast charts, and filters
Use it when
- You report the same numbers every Monday and rebuild them each time.
- You want a forecast with a range, not a single guess, for the next quarter.
- Your team keeps asking for a link to "the numbers".
Steps
- Recurring KPI report maker: Describe the report you want in plain words. Get the numbers pulled, a workbook, and a saved report to rerun.
- Trend and forecast analyst: Give it numbers over time. Get trend, seasons and odd spikes found, plus a forecast table and plain insights.
- Dashboard builder: Give it your data and what to track. Get one HTML dashboard with charts, filters and tables you can open and share.
How to use it
- Download the handoff pack. It's a zip with HANDOFF.md and every skill file this workflow uses.
- Give the folder to Claude (in Claude Code, or as files in a Claude Project) and say "Follow HANDOFF.md".
- Describe the report in your own words and attach the data. Answer its one or two questions, like which period each run covers.
- Tell it how far ahead to forecast and which events to know about.
- Open the finished page and check three numbers against your source.