Track It Simply
Build a small tracker that shows your partner, week by week, that the automation is working.
Objective
By the end of this lesson, you can build a one-tab tracker that answers three questions for your partner: is it running, is it helping, and does anything need a person?
Small beats fancy
Big dashboards with many charts often go unread. Your partner needs answers, not graphs. A good tracker answers a question in five seconds.
Start with the three questions:
- Is it running? Runs this week, and the date of the last run.
- Is it helping? Items handled, response time, and misses this week.
- Does anything need a person? Count of items with status Needs review or CHECK.
Build it from your run log
You already have a run log and a status column from Module 5. Your tracker is one more tab that counts them.
In Google Sheets, a few formulas do most of the work:
| Question | Example formula idea |
|---|---|
| Runs this week | Count rows in the run log where the date is in the last 7 days |
| Last run | The largest date in the run log |
| Needs a person | Count rows where status is Needs review |
| Response time | Average of reply time minus received time |
Your coach can help with formulas at The Cook Up. Many people use AI to write a spreadsheet formula. That is a good use. Test the formula on rows you can count by hand.
Make it readable
- Put the three answers at the top in large text.
- Use words, not only color. Write "OK" or "Check" next to each number.
- Add one line at the bottom: "If Last run is more than 2 days ago, see the break plan."
A local example
A Westside nonprofit's tracker has one tab with four numbers: requests this week, average hours to first reply, requests needing review, and last run. The director checks it on Monday mornings in under a minute. When "last run" showed four days ago, she knew to call the volunteer who maintains it before families noticed.
When to go bigger
Some partners grow into needing more, like data from several apps in one view. That is when tools and standards like MCP, which connect AI and dashboards to many apps with one set of access rules, start to matter. Start small. Grow only when the small tracker cannot answer a real question.
My tracker is ready when
0 of 6 doneReflection
Go deeper: MCP Dashboards vs. The Old Way by Dom Davis, Temerarii Media.