lesson
25 min

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:

  1. Is it running? Runs this week, and the date of the last run.
  2. Is it helping? Items handled, response time, and misses this week.
  3. 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:

QuestionExample formula idea
Runs this weekCount rows in the run log where the date is in the last 7 days
Last runThe largest date in the run log
Needs a personCount rows where status is Needs review
Response timeAverage 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 done

Reflection

Private. Saved only in this browser. No one else can see it.

Go deeper: MCP Dashboards vs. The Old Way by Dom Davis, Temerarii Media.