John SerraBlog
Personal and technical writing — on data, operations, technology, food, and life.
How to Set Up Automatic Alerts in Google Sheets
Four ways to get Google Sheets to warn you: notification settings, conditional notifications, color rules, and a short Apps Script that emails you once when a number crosses your minimum.
How to Build a Cash Flow Tracker in Google Sheets
Build a 13-week cash flow tracker in Google Sheets: the row layout, the formulas, a minimum-cash warning, and a 15-minute weekly update.
Revenue Per Available Parking Space, Explained
Calculate revenue per available parking space, handle capacity changes, and separate occupancy and realized yield when interpreting a change.
How to Measure Parking Facility Occupancy
Calculate parking occupancy with a defined space count, validate the inputs, and build enough observation history to report measured peaks responsibly.
The KPIs Every Parking Lot Operator Should Track
Six parking KPIs and the data each requires: peak occupancy, hours near capacity, revenue per available space, rate mix, cost per space, and payment capture.
Data Analytics for Property Management Companies
Use five property metrics to spot occupancy, collections, work order, vacancy, and controllable expense issues before deciding what to change.
How to Track Where Customers Came From for Free
Use tagged campaign links, analytics referrers, a “how did you hear” question, and one spreadsheet to make a practical judgment about where leads came from.
Google Analytics 4 Explained for Business Owners
Learn the GA4 reports a small business owner needs: Traffic acquisition and Pages and screens, plus a check that valuable actions are recorded as key events.
Which Website Metrics Matter for a Small Business
Choose four to seven website metrics based on what your site does. Inquiry sites should measure conversions, traffic source, landing pages, engagement, cost per inquiry, and speed. Product sites need activation and retention.
How Much Should a Small Business Spend on Data Tools
Start with the data tools your business already has. Learn when sharing licenses, connectors, or a larger platform justify their full cost.
A Monthly Reporting Pack Template for Small Business
A five-page monthly reporting pack: summary and core metrics, financials against budget, operations and team, pipeline, and decisions. Copy the page outlines and update them each month.
What to Include in a Monthly Business Report
A monthly business report needs six things: core metrics, financials against budget, operations, pipeline, team capacity, and decisions. Here's the checklist, and what to leave out.
How Many Charts Should a Dashboard Have?
There’s no fixed number of charts for a dashboard. Use the one-screen test, give every chart a question, and lay the screen out in three parts: cards, trends, and breakdowns.
Why Your Business Numbers Don’t Match Across Systems
Why your payment processor, bank, and accounting software show different totals, and a monthly reconciliation bridge that shows how the numbers connect.
How to Build a Monthly KPI Scorecard
Build a monthly KPI scorecard in Google Sheets or Excel: a four-layer workbook, formulas for current and year-to-date results, targets from your own history, and a repeatable month-end routine.
How Much Does a Small Business Dashboard Cost?
Why there is no single price for a business dashboard, and what drives it: how clean your data is, how many systems feed it, whether it updates itself, and how many metrics you ask for. Plus what a comparable quote should contain.
KPIs for a Small Professional Services Firm
Five KPIs for a small professional services firm: utilization, realization, project margin, DSO, and pipeline—plus plain formulas and the warning each one gives you.
How to Get Your Team to Actually Use Your Reports
Reports get used when they end in decisions. Use a one-page summary, a short off-track note, a weekly meeting, and an action log that checks whether anything happened.
Why Nobody Looks at Your Dashboard (and How to Fix It)
When a team stops opening the dashboard, the cause is usually trust, relevance, missing actions, friction, or leadership. How to tell which one you have and where to start.
7 Dashboard Mistakes Small Businesses Make
Seven common dashboard mistakes that make small business dashboards hard to use, how to recognize each one, and a quick check for your own.
How to Improve a Business Dashboard You Already Have
Before you rebuild a cluttered dashboard, check whether it can be fixed. Use this three-question check and four-step renovation plan.
How Many KPIs Should a Small Business Track?
Most small businesses should track four to seven KPIs. Here is a three-question test for which metrics earn a place, what to do with the rest, and starting scorecards for services, manufacturing, and restaurants.
The Business Data You Already Have (No New Tools)
Unlock the hidden value in your small business data without buying expensive new software. Learn how to extract and analyze existing records from your accounting, POS, banking, and scheduling tools using just a simple spreadsheet.
What to Expect From a Small Business Analytics Project
What happens after you hire analytics help: scope, data, drafts, timeline, testing, and handoff, plus what you need to do at each stage.
12 Questions to Ask Before Hiring a Data Consultant
Don't hire a data consultant without asking these 12 critical questions. Protect your business by clarifying deliverables, data security, IP ownership, and fixed-price scoping from day one.
The Small Business Data Audit Checklist
A step-by-step checklist to help small businesses map their data sources, test usability, and fix critical errors so their records are decision-ready.
Do You Need a Data Analyst or Better Spreadsheets?
Small businesses experiencing reporting failures should identify the root cause before investing in new software or full-time data analysts. Determining whether issues stem from untrustworthy data, fragile spreadsheet workflows, or a lack of analytical judgment allows companies to target the smallest, most effective solution first.
When Should a Small Business Hire a Data Analyst?
Learn when a small business should hire a data analyst—and when spreadsheet cleanup, freelance help, or fractional support is the better choice.
The Machine is Wrong: Designing AI Feedback Loops for EFL
Why fluent AI corrections can miss a learner’s goal, and how lesson constraints, calibrated evaluation, and reviewed learner feedback can improve EFL tutoring.
The Architect’s Leap: Orchestrating Agency in a Multi-Track World
Agency isn't about working harder — it's about shrinking the distance between intention and execution. How I built an orchestration layer to run two demanding roles and a startup in parallel.
Your AI Tutor is Making You Worse at English
You paste your paragraph, the AI fixes it, you copy the result. The AI practiced writing professional English. You practiced copy-paste. Here's why that's a problem.
Why Generic AI is Failing Professional English Learners
Most professionals think ChatGPT as a tutor is a breakthrough. It is — but it has a hidden flaw. Here's what generic AI gets wrong, and how Errorless Teaching fixes it.
Why Your Best Engineers Can’t Explain Their Own Work
Your lead engineer just shipped something that reduced latency by 40%. In the retro, they said: 'I fixed the queries. It's faster now.' That's not a communication failure — it's an invisibility problem.
What is Errorless Teaching — and Why Does It Work for Adult Professionals?
Most language apps let you fail, then correct you. Errorless Teaching flips the model. Here's the science behind it and why it matters for professionals.
Hello, World
A brief introduction to why I'm starting this blog and what you can expect from it.
Building This Site
The technical decisions behind johnserra.com — Next.js, Tailwind, MDX, and a bento grid layout.