Tag: Analytics

  • Revenue Per Available Parking Space, Explained

    Revenue per available space (RevPAS) is a facility’s parking revenue for a stated period divided by its available capacity over that same period. It is analogous to the hotel industry’s revenue per available room. RevPAS normalizes revenue for facility size and helps you investigate changes in pricing and use; it does not by itself prove why revenue changed. It needs revenue records; occupancy counts alone can’t produce it.

    What RevPAS Measures

    A parking space works like a hotel room or an airline seat: if it sits empty during a period, the revenue it could have earned in that period is gone. RevPAS measures how well each space earns, whatever the facility’s size.

    Facility A earns $100,000 a month from 1,000 spaces: $100 per space. Facility B earns $50,000 from 250 spaces: $200 per space. A brings in twice the total revenue, but B earns twice as much from each space. If you’re deciding where to invest in better equipment or where to test a new rate, that difference matters more than the totals.

    Two things must always accompany a RevPAS figure:

    • The period. Per day and per month give very different numbers, and neither is comparable to the other.
    • The capacity over that period. Use spaces that were actually available, not the painted total. If a level closes for half the month, count its spaces for the half when they were open. A single month-end count would misstate the denominator.

    Without both, two RevPAS figures can’t be compared.

    How to Calculate RevPAS

    Before the step-by-step math, here is the whole idea in one picture. RevPAS breaks into two parts: how much of your capacity gets used, and how much each hour of use earns.

    Occupancy rateoccupied space-hours ÷ available space-hours
    ×
    Revenue per occupied space-hourrevenue ÷ occupied space-hours
    =
    RevPAS per space-hourrevenue ÷ available space-hours
    × hours open in the period → RevPAS per day or per month
    Use (occupancy) times yield (revenue per hour of use) gives revenue per available space.

    The basic calculation

    Constant capacity
    RevPAS = Revenue for the period ÷ Available spaces

    Take a 300-space lot open 10 hours a day, every day (300 operating hours in a 30-day month). That schedule matters later: many municipal and commercial garages run 24 hours, so check your own facility’s hours before reusing these numbers. In the month, the lot takes in $45,000 from all sources: hourly parkers, monthly permits, and validations.

    • Monthly RevPAS = $45,000 ÷ 300 = $150 per space per month
    • Daily RevPAS = $150 ÷ 30 = $5.00 per space per day

    That’s all a facility with unchanged capacity and operating hours needs for monthly reporting. When capacity changes, calculate available space-hours instead: sum the spaces open in each hour of the period.

    When capacity changes
    Revenue per available space-hour = Revenue ÷ Available space-hours
    Effective available spaces = Available space-hours ÷ Scheduled open hours
    RevPAS for the period = Revenue ÷ Effective available spaces

    Multiplying revenue per available space-hour by the scheduled open hours gives the same per-space figure as dividing by effective available spaces. For example, if 100 of 300 spaces close for half of a 300-hour month, available space-hours are (300 × 150) + (200 × 150) = 75,000, or 250 effective spaces. Revenue of $45,000 would be $0.60 per available space-hour, or $180 per effective space for the month. Report the closure and denominator alongside the figure.

    Splitting RevPAS into revenue per occupied hour and utilization

    When RevPAS changes, the next question is what moved: use of available capacity, revenue earned per occupied hour, or both. The trick is to measure both in the same unit: the space-hour, meaning one space for one hour. The second component reflects rates, permit mix, discounts, and payment capture together; it is not a pure price measure.

    Return to the constant-capacity example: 300 spaces, open 10 hours a day throughout the month. In general form, the split is:

    The split
    Occupancy rate = Occupied space-hours ÷ Available space-hours
    Revenue per occupied space-hour = Revenue ÷ Occupied space-hours
    RevPAS per space-hour = Occupancy rate × Revenue per occupied space-hour

    Plugging in the numbers:

    1. Available space-hours = spaces × hours open. 300 × 10 hours × 30 days = 90,000.
    2. Occupied space-hours = the total hours cars were parked, from counts or entry and exit records. Say 45,000.
    3. Occupancy rate = occupied ÷ available space-hours = 45,000 ÷ 90,000 = 50%.
    4. Revenue per occupied space-hour = revenue ÷ occupied space-hours = $45,000 ÷ 45,000 = $1.00. This is realized revenue per hour of use, after the effects of permits, discounts, validations, and the rate mix.

    Multiply the two and you get revenue per available space-hour: 50% × $1.00 = $0.50. Multiply by the hours open to get back to the period figures:

    • Per day: $0.50 × 10 hours = $5.00
    • Per month: $0.50 × 300 hours = $150

    These match the basic calculation, which is the check that the split is right. Now a change in RevPAS can be traced: if next month’s RevPAS rises, you can see whether occupancy rose, revenue per occupied hour rose, or both.

    The mistake to avoid

    A tempting shortcut is occupancy × average ticket. It does not account for how long each car stays or how many times each space turns over.

    For a separate example, take a 300-space lot open 10 hours a day, with all revenue coming from parking tickets. It sells 600 tickets at an average of $2.50, earning $1,500 a day. If each car stays an average of 2.5 hours, occupied space-hours are 600 × 2.5 = 1,500 out of 3,000 available space-hours: 50% occupancy. Occupancy × average ticket gives 50% × $2.50 = $1.25, but actual daily RevPAS is $1,500 ÷ 300 = $5.00 per space. The shortcut mixes a proportion of available space-hours (occupancy) with a price per visit (ticket). It leaves out the two parking sessions per available space per day.

    Hotels can use occupancy × average daily rate because a room is usually sold once per night. A parking space can be sold several times a day, which is why the calculation has to go through space-hours.

    What Data You Need

    • For RevPAS itself: revenue by period from every channel (hourly, monthly permits, validations, events), assigned to the right facility and period; plus available spaces and operating hours over that period, including partial closures.
    • For the revenue-and-utilization split: occupied space-hours, from sufficiently frequent counts or from entry and exit records. Sparse snapshots cannot establish total occupied hours.
    • A caveat for ticketless systems: with license plate recognition (LPR) or mobile pay-by-plate, occupancy and payment come from different records, and they can drift apart. If you measure occupied hours from paid sessions, vehicles that park without paying or registering are invisible, so occupancy looks lower and revenue per occupied hour looks higher than it is. If you measure from camera reads, those vehicles are counted but missed or misread plates add noise to dwell times. Either way, the gap between vehicles seen and vehicles paid is the payment-capture issue covered under What Moves RevPAS.

    Occupancy data alone won’t get you there. In my analytics project on Istanbul’s municipal parking network, the city’s feed reports capacity and empty spaces for each facility, which supports occupancy. It has no revenue at all. So the project doesn’t calculate RevPAS or make any revenue claims, even though it would be easy to make up a plausible-looking number. The rule applies to any operator: don’t publish a metric your data can’t support.

    Price vs. Occupancy: The Trade-Off

    One reason to track RevPAS is to see the combined revenue effect when price and use both change. A higher rate can come with lower occupancy, but the response varies by facility and period. RevPAS shows the net revenue per available capacity; compare other conditions before attributing the change to price.

    For this simplified example, assume each occupied space serves one paying car for the full operating day, with no turnover, permits, discounts, or unpaid parking. A 200-space lot charges $8 a day at 95% occupancy: 190 cars generate $1,520 a day, or $7.60 per available space. It raises the rate to $14. If occupancy falls to 70% under the same assumptions, 140 cars generate $1,960 a day, and daily RevPAS becomes $9.80 per space: 29% higher, even with about a quarter fewer cars. With shorter stays or turnover, use the space-hour calculation instead.

    The 70% in that example is an assumption, and that’s the point to take from it. You won’t know how drivers respond until after the change. Some move to a nearby lot, some shift their arrival times, some pay. So:

    • Compare RevPAS for several weeks before and after, against the facility’s own normal range and similar days or seasons. A change inside the range the facility usually varies over the past six to twelve months may be noise.
    • Split the change into utilization and revenue per occupied hour, as above; then investigate what moved each component.
    • If you run nearby facilities, watch whether demand simply moved next door.

    What Moves RevPAS

    • Pricing by time of day. Charging more during the hours a facility runs near capacity and less when it’s quiet. Set those hours from the facility’s own occupancy history rather than a fixed trigger.
    • Event pricing. A flat rate during events, when demand is predictable and high.
    • Reserved spaces. A named reserved space sits empty whenever its holder is away. Moving to unassigned permits lets others use it.
    • Permit mix. How many spaces go to monthly permits and whether permit arrivals overlap with peak transient demand. Any decision to sell more permits than allocated spaces needs its own history and stress test.
    • Payment capture. If 80% of parked vehicles pay and that rises to 95%, revenue from those vehicles rises 18.75% (95 ÷ 80 = 1.1875), assuming the number of parkers and the average payment per paying vehicle stay unchanged. That average depends on rates, length of stay, and discounts; the percentage is not guaranteed if any of those change or drivers leave because enforcement tightened. Measuring the change needs vehicle counts matched to payments.

    A Property-Value Sensitivity Illustration

    For owners, sustained revenue changes may affect net operating income (NOI), which is one input to property valuation. The following calculation shows sensitivity to assumptions; it does not estimate a realizable sale price.

    A 400-space garage raises monthly RevPAS by $25, from $125 to $150. That’s $10,000 a month, or $120,000 a year. Assume 85% of the added revenue reaches NOI after added costs: $102,000. At an assumed 7% capitalization rate, $102,000 ÷ 0.07 is about $1,457,000 of added value.

    That’s arithmetic, not an appraisal or evidence that a buyer would pay $1.457 million more. Actual value depends on the lease or management structure, costs, market, appraisal method, and whether the higher RevPAS is expected to last.

    A Monthly RevPAS Check

    1. Calculate RevPAS for each facility for the month. State the period and the space count.
    2. Compare it with that facility’s last six to twelve months. Judge the change against how much it normally varies.
    3. If it’s off track, split it. Did occupancy move, or revenue per occupied hour?
    4. Assign one action, with an owner and a date.

    How to build a monthly KPI scorecard shows a spreadsheet layout for tracking RevPAS alongside targets and variance.

    Frequently Asked Questions

    What is a good RevPAS?

    There’s no general figure. RevPAS depends on location, facility type, pricing, and demand. Compare each facility with its own history and with your other facilities.

    What’s the difference between RevPAS and average ticket?

    Average ticket is revenue per parking session. RevPAS is revenue per available space. A higher average ticket can come with lower RevPAS if fewer cars park.

    Should RevPAS include monthly permit revenue?

    Yes. Include all parking revenue for the facility. Tracking the hourly and permit shares separately helps explain changes.

    Can I calculate RevPAS from occupancy data?

    No. RevPAS needs revenue. Occupancy data tells you how much of the capacity was used, not what it earned.

  • How to Measure Parking Facility Occupancy

    Parking occupancy is the number of occupied spaces divided by the number of usable spaces at a specific moment, times 100. The formula is the easy part. Before you trust the result, confirm what your capacity and available-space numbers mean, record when each reading was taken, reject invalid records, and collect readings over time. One reading describes one moment; it cannot establish the busiest time of a day or week. Manual counts, gate and payment records, and sensor or feed data can all help if you check their scope and limitations.

    Three Different Numbers People Call “Occupancy”

    When someone says a lot is “at 60%,” they could mean one of three things:

    • Occupancy at a moment: occupied spaces ÷ usable spaces at one time. “At 10:15 Tuesday, 180 of 200 spaces were taken: 90%.”
    • Observed peak occupancy: the highest reading in your sample across a defined period, such as a day or a week. Report the count times and number of readings; sparse sampling can miss the true peak.
    • Average utilization: the share of available space-hours that were used over a period. A 100-space lot open 10 hours has 1,000 space-hours available. If cars occupied 600 of them, utilization is 60%.

    These answer different questions. Utilization tells you how much of your capacity earns its keep over the day. Peak tells you whether you ran out of room.

    Mixing them up is the most common occupancy mistake. A garage reports 45% occupancy to its owner, a 24-hour average. It was effectively full from 11:30 to 1:30 every weekday, turning drivers away. Both statements are true. Only one of them helps anyone decide whether to add permits, change prices, or send overflow elsewhere.

    The Formulas

    Occupancy % = occupied spaces ÷ usable spaces × 100, measured at a stated time.

    Three details decide whether that number is right.

    Use a capacity denominator that matches the spaces being counted. Design capacity is every striped space. Usable capacity excludes spaces closed for repairs or blocked by construction or snow. If you report general-access parking separately, also exclude reserved, accessible, or loading spaces from both the numerator and denominator for that specific pool; do not drop them from a total-facility occupancy figure. A 200-space garage with a closed level of 40 spaces that fills its remaining 160 is 100% full, not 80%. State which capacity you used.

    Deriving “occupied” from “available” works only if both describe the same spaces at the same time. Many systems report empty spaces rather than occupied ones. Occupied = capacity − available is correct only when the capacity and the available count cover the same set of spaces and were recorded at the same moment.

    For gate or entry/exit systems, count the accumulation. Occupancy at a given time = the starting count + entries − exits. If 40 cars are inside at 6:00 AM, 180 enter and 95 leave by 10:00 AM, accumulation is 125 cars inside at 10:00. Divide that by usable capacity to get the occupancy rate. Accumulation drifts over time (more on that below), so it needs a regular reset against a physical count.

    Before You Calculate: Check What Your Data Means

    I’m building an analytics project on Istanbul’s municipal parking network, which publishes a live feed of its facilities with capacity and empty-space counts. Before calculating a single occupancy figure, I audited what the feed actually returns. The arithmetic turned out to be the least of it.

    Here’s a real reading from one snapshot on 2026-08-22. Facility 3068, an enclosed garage listed as open 24 hours, reported a capacity of 1,029 and 589 empty spaces at 02:31 Istanbul time. That’s 1,029 − 589 = 440 occupied, or 42.8%.

    The calculation took one line. The audit found five things that would have made numbers like that wrong without anyone noticing:

    1. Invalid requests return a normal-looking record. Asking for a facility ID that doesn’t exist returns a record with a capacity of 1 and 1 empty space instead of an error. Included in a calculation, it looks like a tiny, empty lot. Lesson: define what a valid record looks like and reject the rest before you calculate.
    2. The facility list has no timestamp. The list doesn’t say when each reading was taken. Lesson: if the source doesn’t timestamp a reading, record the time you retrieved it. A reading you can’t place in time can’t be part of a peak.
    3. A status field has no documentation. The isOpen field is 0 for most facilities, including facility 3068, which lists 24-hour operation. Lesson: don’t guess what an undocumented field means. Leave it out until you can confirm it.
    4. A time field has no timezone. The detail record’s update time doesn’t say which timezone it’s in. Lesson: confirm timezones before comparing readings from different sources.
    5. There’s no history. The feed shows only the current state. Lesson: covered in its own section below.

    Your data will have different quirks, but the questions carry over to any lot, garage, or system:

    • What exactly does “capacity” include? Does it change when spaces close?
    • What does “available” or “empty” mean, and does it cover the same spaces?
    • Where does each reading’s timestamp come from, and in what timezone?
    • What does an invalid, closed, or offline record look like?
    • Does the source keep history, or only the current state?

    The project’s code and evidence are public at github.com/johnserra/istanbul-parking-analytics. These figures come from a single audit snapshot. They aren’t a finding about how full Istanbul’s garages are.

    Istanbul parking data source: Istanbul Metropolitan Municipality (IBB) Open Data Portal, 2026-08-22 audit snapshot. The IBB Open Data License v1.0 requires this attribution: “Contains public sector information licensed under the Attribution 4.0 International (CC BY 4.0).”

    Three Ways to Collect Occupancy Data

    Manual counts

    Someone walks the facility on a schedule and counts occupied spaces. It costs staff time and nothing else, and it’s the most direct measurement there is.

    Choose count times from how the facility is used. An office garage, a retail lot, a hospital, and an event venue peak at different times, and a single universal schedule will miss some of them. Count at the times you expect to be busiest, plus a quiet period for comparison, on the days that matter (weekdays, weekends, or both). Record each count with its date and time on a simple sheet.

    Gate, ticket, and payment records

    If your facility has gates, ticketing, or pay-by-plate, you can reconstruct occupancy from entries and exits, usually in 15- or 30-minute intervals. The data already exists, so this is often the best place to start before buying anything new.

    The catch is drift. Tailgating, unreadable tickets, gate arms left up, and cars that exit without being recorded all push the running count off over time. Reset it against a physical count at a known quiet point on a regular schedule, and compare the two to see how far it drifted.

    Sensors, cameras, and live feeds

    Per-space sensors, entry counters, camera counts, and live data feeds give you frequent readings without anyone walking the lot. They’re worth it when a decision needs real-time information, such as guidance signs showing available spaces or prices that change by time of day.

    Automation doesn’t skip the checks above. A sensor feed has its own capacity definition, its own offline states, and its own timestamps, and all of them need confirming. For planning questions that do not need a live feed, start by testing whether counts and existing records answer the question before paying for hardware.

    One Reading Isn’t a Peak: Build Your Own History

    The Istanbul feed only reports the current state, so my project stores a snapshot each time it reads the feed. Without that, there’s no history. The same is true of most live feeds and many gate-system dashboards: they show you now, and “now” disappears.

    Two rules from the project carry over:

    • Keep the raw readings, not only the calculated percentage. If you later find that a capacity figure was wrong or an invalid record slipped through, you can recalculate.
    • Match the claim to the history you have. My project won’t forecast occupancy or trigger capacity alerts for a facility until it has 26 weeks of readings with at least 90% coverage. That’s a high bar for forecasting. For simple peak reporting, the practical version is to say what the peak is based on: “Peak of 96% at 10:30 on Tuesdays, from 18 weekday readings over three weeks” is an honest statement. “Peaks at 96%” from one busy morning isn’t.

    What Counts as “Full”?

    You may see 85% cited as a parking occupancy target. That number comes from a point-in-time curbside-parking context, not a universal goal for lots or garages. For example, SFMTA’s SFpark policy describes a commonly cited 85% curbside threshold at a single moment while using a 60–80% average occupancy target across a longer period to keep spaces available on each block. Those are different measurements and settings; neither gives your facility its own “full” threshold. Practitioners have also questioned relying on any occupancy target alone: in a May 2026 Parking Today piece, Cole Jaillet argues that occupancy is a snapshot rather than a behavior, and that two blocks at the same percentage can serve very different numbers of vehicles depending on how long each stays.

    For a specific facility, set two thresholds from its own history: a “busy” level where drivers start having trouble finding a space, and a “full” level where the facility is effectively out of room. Look at the readings from times you know were difficult (complaints, turned-away drivers, staff reports) and see where occupancy stood. Then report how long the facility stayed above each threshold, not only whether it crossed.

    A Two-Week Occupancy Audit

    If you’re starting from nothing, this gives you a defensible baseline:

    1. Set usable capacity and write down exactly what you counted and excluded.
    2. Choose count times from the facility’s use pattern. Cover weekdays and weekends if both matter.
    3. Record every count or snapshot with its timestamp in one sheet. Keep the raw numbers.
    4. Reconcile counts with transaction and permit records for the same times. Account for vehicles already present, exits, permits, validations, and unpaid sessions before treating a gap as a counting or payment problem.
    5. Report peak, time near capacity, and how many readings each is based on. End with one follow-up action, an owner, and a date.

    Once occupancy is reliable, it can support revenue analysis when you also have revenue records for the same facility and period. Occupancy data alone cannot show what a space earned. A full lot of monthly permit holders and a lot turning over transient drivers can look identical on an occupancy chart while producing very different revenue, which is why revenue per space needs its own treatment.

    Frequently Asked Questions

    What is the formula for parking occupancy rate?

    Occupied spaces ÷ usable spaces × 100, measured at a stated time. Use the spaces actually available at that moment, not the design total.

    How often should parking occupancy be measured?

    Often enough to sample the periods when your facility is likely busiest. For manual counts, that may mean several readings across the expected peak. Automated intervals should match the decision you need to make and the feed’s actual update frequency. State how many days and readings your observed peak covers.

    Is 100% occupancy good?

    Not usually. A lot at 100% is turning drivers away and has no room for permit holders who arrive late. How far below full a facility should run depends on its layout and its customers.

    Can I measure occupancy without sensors?

    Yes. Manual counts and gate or payment records answer most planning questions. Sensors earn their cost when a decision needs real-time data.

  • The KPIs Every Parking Lot Operator Should Track

    Track six metrics: peak occupancy, hours near capacity, revenue per available space (RevPAS), the split between hourly and monthly revenue, operating cost per space, and payment capture rate. Most KPI lists skip a practical point: each metric needs specific data. Occupancy counts support only the first two. RevPAS and the revenue split need revenue records, cost per space needs expenses by facility, and payment capture needs vehicle counts matched to payments. Start with the metrics your data supports.

    This guide covers what each metric tells you, what data it takes, and how to review them without adding reports nobody reads.

    Why Total Deposits Hide What’s Happening

    Many lots are run from one number: how much was deposited this month. It’s the number that matters most in the end, and on its own it explains almost nothing.

    A deposit total can’t tell you whether revenue rose because rates went up or because more cars parked. It can’t separate hourly parkers from monthly permit holders. And it can’t show the Tuesday mornings when the lot was full, and drivers went somewhere else. An empty space during a busy hour is revenue that can’t be recovered later, and a full lot turning drivers away is revenue you never see at all.

    The fix isn’t a long list of metrics. Keep the scorecard to four to seven numbers, depending on the business, and cut any metric that doesn’t move the needle. For parking, each metric should lead to a decision about staffing, pricing, permit allocation, or enforcement. If nobody would change anything when a number moves, it doesn’t belong. How many KPIs a small business should track makes the general case.

    Start With the Data You Have

    Before choosing metrics, check what your data can support. I learned this building an analytics project on Istanbul’s municipal parking data. The city’s parking API reports capacity and empty spaces for about 250 facilities, which is enough to calculate occupancy. It has no revenue, no payments, and no record of when individual cars arrive or leave. So the project leaves out revenue per space, payment compliance, and how long cars stay. Those metrics could be calculated from other data, but not from that feed, and a number the data can’t support is worse than no number: it looks precise and is wrong.

    The same test applies to any lot. Here’s the scorecard with the data each metric needs:

    MetricHow to calculate itData it needsDecision it drives
    Peak occupancyHighest occupied spaces ÷ usable spaces in a periodTimestamped counts or sensor readingsPermit allocation, whether to add or share space
    Hours near capacityHours at or above your “full” thresholdThe same counts, taken at regular intervalsPricing by time of day, overflow plans
    RevPASRevenue ÷ available spaces, for a stated periodRevenue by period; count of spaces actually usablePricing, allocation, comparing facilities
    Hourly vs. monthly mixShare of revenue (and of peak spaces) from each type of parkerRevenue by channel; permit list; ideally counts by parker typePermit limits, pricing
    Operating cost per spaceOperating expenses ÷ spaces, per periodExpenses recorded by facilityStaffing, automation, contract terms
    Payment capture ratePaid vehicles ÷ parked vehicles in spot checksVehicle counts matched to active payments at the same momentEnforcement, signs, fixing payment problems

    Go down the “data it needs” column and mark each row: have it, could get it, or don’t have it. That gives you your starting scorecard, and a short list of what to start collecting.

    Istanbul parking data source: Istanbul Metropolitan Municipality (IBB) Open Data Portal, 2026-08-22 audit snapshot. The IBB Open Data License v1.0 requires this attribution: “Contains public sector information licensed under the Attribution 4.0 International (CC BY 4.0).”

    Metrics 1 and 2: Peak Occupancy and Hours Near Capacity

    Occupancy is the share of usable spaces that are occupied at a given moment. Averaged over a day, it hides the pressure that matters. A lot averaging 55% can be completely full from 9 to 11 every weekday morning, and those two hours are when drivers get turned away and permit holders complain.

    So report two numbers instead of an average:

    • Peak occupancy: the highest reading in each day or week.
    • Hours near capacity: how many hours the lot stayed at or above your “effectively full” level.

    Peak tells you whether you ran out of room. Hours near capacity tells you how long, which is what pricing and permit decisions depend on. One tight hour on Fridays is a different problem from four tight hours every weekday.

    Getting these right depends on counting properly: using usable capacity rather than the number on the sign, timestamping every reading, and building enough history to describe an observed peak and its sampling limits.

    Metric 3: Revenue per Available Space (RevPAS)

    RevPAS is revenue divided by available spaces for a stated period, such as a day or a month. It does two things occupancy and revenue can’t do alone.

    First, it makes facilities of different sizes comparable. A 40-space lot and a 400-space garage can be judged on the same scale.

    Second, it normalizes revenue across available capacity. A lot raises its hourly rate from $5 to $10, and occupancy during those hours falls from 80% to 30%. Measured per space-hour, which is RevPASH (revenue per available space-hour, or occupancy × rate), revenue falls from $4.00 (0.80 × $5) to $3.00 (0.30 × $10). Total revenue over equal hours and capacity would show the decline too; the normalized measure helps compare different facilities or periods. RevPAS is the same idea over a longer period, such as a day or a month. The before-and-after comparison alone does not prove the rate change caused the decline. Before blaming the price, check for events, weather, and day-of-week patterns in the same hours, and for nearby lots’ occupancy if you can get it.

    RevPAS needs revenue by period and capacity over that same period. If spaces open or close during the period, use available space-hours before converting the result into a per-space figure; a single end-of-month space count would distort the comparison.

    Metric 4: The Mix Between Hourly and Monthly Parkers

    Most lots serve two kinds of customers, and they pay differently.

    • Monthly permit holders bring predictable revenue that arrives on schedule. The trade-off is a lower rate per hour of use, and they hold spaces during the busiest hours.
    • Hourly (transient) parkers usually pay more per hour, but demand swings with weather, events, and the day of the week.

    The mix is a decision, not an accident. Track the share of revenue from each, and, if you can, the share of peak-hour spaces each uses.

    Overselling permits

    Permit holders may not all park at the same time. Some work from home, travel, or leave early. An operator may consider selling more permits than the spaces set aside for them, but that decision needs counts and a plan for days when more holders arrive than expected.

    Set the oversell level from your own counts, not from a ratio you read somewhere. Count how many permit holders are present at the busiest time, over several weeks, and use the highest share you see.

    Here is how it works for a 400-space garage that sets aside 250 spaces for monthly permits:

    • Observed peak: over six weeks of counts, the highest simultaneous presence was 75% of permit holders.
    • Buffer: the operator chooses a 10% space buffer, so modeled peak permit parking stays at or below 225 spaces.
    • Permit cap: 225 ÷ 0.75 = 300 permits, or 120% of the 250 spaces.
    • Left for hourly parkers: the other 150 spaces.

    A future day can exceed the observed rate, so this calculation is a scenario to stress-test against unusual days and contractual obligations, not a guarantee of space.

    Recheck the counts regularly. If more permit holders start coming in every day, the safe number of permits drops.

    Metric 5: Operating Cost per Space

    Add up what it costs to run each facility: labor, payment processing, equipment and software, utilities, insurance, sweeping, snow removal, and repairs. Divide by the number of spaces for the period.

    Cost per space lets you compare facilities and spot drift. If one garage costs noticeably more per space than your others, or more than it did last year, find out why before the next contract renewal. The comparison that matters is against your own history and your own other facilities, since a generic industry ratio won’t reflect your labor market, climate, or contract terms.

    This needs expenses recorded by facility, not lumped together. If your books combine several lots, splitting them is the first job.

    Metric 6: Payment Capture Rate

    Payment capture rate is the share of parked vehicles that have paid or been validated. Unpaid parking is lost revenue, and it hides inside an occupancy count, because an unpaid car and a paid car take up the same space.

    Measure it with spot checks: count the vehicles in the lot, then match them against active payments, permits, and validations at the same moment. Paid ÷ parked is the rate. Repeat at different times and days, since compliance often varies.

    This metric needs matched payment data. Occupancy counts alone can’t show it, which is exactly the kind of metric to leave off until you can support it. There’s no universal target. Set one from your own baseline, and when it drops, check signs, payment machines, and apps before assuming drivers are avoiding payment.

    The spot-check rate measures compliance at that moment. If you also issue notices or invoices to non-payers, track separately what share of them is eventually paid. A lot with a low capture rate and a high recovery rate has a different problem from one that is low on both. Whether and how you can pursue unpaid sessions depends on local law and regulation, so treat recovery as its own measure and don’t fold it into the capture rate. Lots that do not use a modern tech stack have no session records to match, so for them the spot check is the only measure available.

    A Weekly Review in Four Steps

    Once the scorecard is set up, a short weekly review keeps it useful:

    1. Occupancy: peak and hours near capacity by facility. Any lot running full for longer than usual?
    2. RevPAS: compared against each facility’s own trailing baseline. Set how much movement counts as normal based on how much the number has actually varied over the past several months.
    3. Mix and capture: permit share, any oversell pressure, and the latest spot check.
    4. Actions: for each facility that’s off track, one action, one owner, and a date.

    The last step is what turns the review into management. How to build a monthly KPI scorecard shows a spreadsheet layout with targets, variances, and status colors that works for a set of lots as well as for a whole business.

    Parking KPI Checklist

    • I know which of the six metrics my current data supports.
    • I report peak occupancy and hours near capacity, not just averages.
    • I calculate RevPAS using spaces that were actually available.
    • I track revenue from hourly and monthly parkers separately.
    • My permit oversell level comes from my own counts.
    • Expenses are recorded by facility.
    • I run payment spot checks at different times.
    • Each weekly review ends with named actions and dates.

    Frequently Asked Questions

    What is the most important KPI for a parking lot?

    It depends on what you’re deciding. For pricing and comparing facilities, RevPAS, because it combines price and use. For capacity decisions, peak occupancy and hours near capacity.

    What is a good occupancy rate for a parking lot?

    It depends on the facility and on what “full” means for it. Set the threshold from its own layout, operating history, and instances when drivers struggled to find a space.

    How often should parking KPIs be reviewed?

    Weekly for occupancy, mix, and capture, since they change quickly and the fixes are operational. Monthly for RevPAS and cost per space, once revenue and expenses are closed for the month.

    What about turnover?

    If you have entry and exit data, turnover (parking sessions per space per day) shows how intensively spaces are used, and it’s useful for lots that serve short visits. It needs session data that many lots don’t collect, so it’s an optional seventh metric.

  • Data Analytics for Property Management Companies

    Data analytics for a property management company means tracking a handful of operating numbers that can affect net operating income (NOI), rather than reading the monthly accounting package after the fact. Five starting measures are physical occupancy alongside rent collected against potential rent, work-order resolution, days vacant between tenants, rent more than 30 days late, and controllable operating expenses per square foot. Choose the ones that fit your portfolio and data; some inputs may already be in your property management software.

    Accounting Reports Tell You What Happened. Operating Metrics Tell You What's Coming.

    Most property management systems produce a thorough monthly package: rent roll, income statement, general ledger, aged receivables. It's accurate, and it's backward-looking. By the time a slow repair or a rising utility bill shows up on the income statement, the tenant is already frustrated or the money is already spent.

    Operating metrics are the leading indicators behind those accounting results. Repair times, turn times, and late balances move weeks or months before NOI does, which gives you time to act.

    The test for including any metric is simple: does it help the property earn more revenue, run more efficiently, or cost less to operate? If it doesn't, leave it off. Keep the scorecard to four to seven numbers so someone actually acts on each one; how many KPIs a small business should track explains why that range holds.

    1. Physical Occupancy and Rent Collected Against Potential Rent

    Physical occupancy is the share of leasable space that has a tenant in it. For this scorecard, use a cash-collection ratio to show the share of potential rent actually collected. Some property reports call a related measure economic occupancy, but definitions vary, so keep the numerator and denominator visible:

    Cash-collection ratio = rent collected for the period ÷ gross potential rent for the same period × 100

    Here, gross potential rent is what the property would bring in if every leasable space were occupied at the documented market-rent assumption for that space and every tenant paid in full. Document that rent basis and use it consistently; scheduled rent in existing leases, billed rent, concessions, and cash collected are different amounts.

    The two numbers can diverge because of vacancy, free-rent concessions, discounts, and unpaid balances. The gap is not all collectible debt: some of it reflects deliberate lease terms or empty space.

    A building is 95% physically occupied. After two months of free rent on a new lease, one tenant well behind on payments, and a discounted renewal, it collects 84% of gross potential rent. The 11-point gap calls for a breakdown of vacancy, concessions, discounts, and overdue rent. The late balance is the part collections can pursue without changing lease terms.

    2. Work Order Resolution Time

    How quickly a routine repair gets fixed is something every tenant experiences, every month, long before the renewal conversation. Track three numbers:

    • Time to first response: hours from the request to someone acknowledging it or being assigned.
    • Time to complete: days from request to closed work order, for routine requests.
    • Open requests past the property's service target: the backlog that needs someone's attention. Set that target by request type and urgency rather than using one cutoff for every repair.

    Watch the trend rather than the average alone. A property whose completion time creeps up quarter after quarter has a staffing, vendor, or parts problem building, even if no single request looks bad. Slow repairs can also weigh on whether a tenant renews, so watch the renewal rate next to these numbers; it connects service back to NOI.

    3. Days Vacant Between Tenants

    Rent lost while a space sits empty doesn't come back. Measure the total days from move-out to the new tenant's lease start, and split it into three stages:

    1. Move-out inspection and scoping: from the keys being returned to a defined list of work.
    2. Make-ready: repairs, paint, flooring, cleaning.
    3. Leasing: from rent-ready to a signed lease and move-in date.

    The split tells you where time goes. If make-ready is the long stage, the question is vendor scheduling. If spaces sit rent-ready for weeks, it's a leasing or pricing question. A shared board listing every vacant space with its current stage and days in that stage is often enough to show the bottleneck.

    4. Rent More Than 30 Days Late

    A late balance is much easier to collect while it's young. The metric is the over-30-day late rate:

    Over-30-day late rate = rent balances more than 30 days past due ÷ rent billed for the month × 100

    Don't wait for the month-end aging report to find it. Send reminders and talk to tenants before balances become overdue. Use the over-30-day bucket as a review trigger; a balance approaching 60 days calls for a more direct follow-up under the lease and collection process. What counts as a normal level depends on the property type and tenant mix, so compare each property against its own history rather than a generic benchmark.

    5. Controllable Operating Expenses per Square Foot

    Some operating costs, like property taxes and insurance, are set outside day-to-day management. Others, like janitorial, landscaping, repairs, and utilities, are controllable. Track those separately and divide by rentable square feet so you can compare properties of different sizes and each property against its own past months.

    Unexplained changes are the trigger. Water cost per square foot at one building runs 40% above the same month last year with no change in occupancy. That's a reason to walk the building before the next bill: a running toilet, an irrigation zone stuck on, or a meter reading that needs checking. The metric doesn't diagnose the cause. It tells you where to look.

    How to Start Without Buying New Software

    You probably have all five metrics' raw data already.

    1. Export what you have. Rent roll, aged receivables, work order history, and the general ledger by property are standard exports from most property management systems. Put them into one spreadsheet, one tab per export.
    2. Build one screen. Five metrics, one row per property, each with a target, the current value, and a green, yellow, or red status. How to build a monthly KPI scorecard shows the layout.
    3. Review it weekly or monthly with the people who can act. The review is a short conversation about what the numbers mean, who will act on them, and by when. How to get your team to actually use your reports covers running that meeting.

    Stay in the spreadsheet while it gives the team a reliable, timely view. If recurring exports and reconciliation consume more staff time than a reporting tool would save, or multiple systems make errors hard to catch, evaluate an upgrade against those actual costs.

    If your portfolio includes parking, its operating metrics need their own scorecard. The KPIs every parking lot operator should track covers capacity, utilization by hour, revenue per space, and payment capture, which may matter there alongside property-level measures.

  • How to Track Where Customers Came From for Free

    You can learn where customers come from without paying for attribution software. Use four pieces together: tagged campaign links (UTM parameters) on external links you control, and the referrer and channel reports in the analytics tool you already have. Add a “How did you hear about us?” question on your contact form and in your first conversation, and keep one spreadsheet that records each lead’s source next to its eventual value. The tags and reports provide partial evidence about digital visits. The question can reveal word of mouth and context software misses. The spreadsheet connects those clues to sales records.

    That’s the setup I use: tagged links, the referrer reports in my analytics tools, and a “how did you hear” question. Below is how to set each piece up, how to reconcile them when they disagree, and how to turn the results into decisions.

    Why Expensive Attribution Software Rarely Fits a Small Business

    Attribution software tries to credit each sale to every ad, email, and page visit that led to it. It’s built for businesses with large ad budgets and thousands of transactions a month, where small percentage shifts in spend are worth modeling.

    A small business often has too few comparable sales across channels to justify complex attribution modeling, especially when its sales cycle is long. There is no universal customer-count cutoff; the useful sample depends on the decision and how much data each channel produces. Customers may also arrive through channels software can’t see: a recommendation at dinner, a podcast mention, or a forwarded email. Privacy settings, ad blockers, and people switching between phone and laptop break the trail further.

    My view is to stay on free tools for as long as they cover what you need. For customer sources, they can cover the first useful decisions. Paying for a platform before you’ve tried a disciplined free routine may buy a more expensive version of the same blind spots.

    Piece 1: Tag the Campaign Links You Control

    A UTM parameter is a label added to the end of a web address. When someone clicks the link, your analytics tool reads the label and records where the visit came from. Nothing changes for the visitor; they land on the same page.

    A tagged link looks like this:

    https://example.com/services?utm_source=newsletter&utm_medium=email&utm_campaign=2026_10_newsletter

    Three tags are enough:

    TagWhat it recordsExamples
    utm_sourceWho or what sent the visitnewsletter, linkedin, x, chamber_directory
    utm_mediumThe type of channelemail, social, referral, cpc, print
    utm_campaignThe specific effort2026_10_newsletter, fall_workshop

    Google’s free Campaign URL Builder assembles the link for you: paste the page address, fill in the three fields, and copy the result. Most email tools and link shorteners can also add tags automatically.

    Naming rules that keep the data clean

    • Use lowercase everywhere. Analytics tools treat LinkedIn and linkedin as two different sources, and your report splits in half.
    • Pick underscores or hyphens and use the same one everywhere, never spaces. fall-workshop and fall_workshop are reported as different campaigns.
    • Use standard medium names like email, social, cpc, and referral. GA4 uses the medium to sort visits into channels, and a made-up value like newsletter_blast can land in “Unassigned.”
    • Keep a list. One tab in a spreadsheet with every tagged link, the date, and what it was for. When three people create links, the list is what keeps x from becoming twitter and X_posts by spring.
    • Don’t tag links between pages of your own site. Internal UTM tags can distort campaign or source attribution; they are meant for incoming campaigns.

    Where to use them: newsletters, social posts and profile links, directory listings or partner links you manage, email signatures, and ads where manual tags make sense. Tag external campaign links you control; search results, independent editorial links, and links you cannot edit are outside this routine.

    Piece 2: Read the Referrer Reports You Already Have

    Tagged links only cover links you created. Your analytics tool may record a referring website or app for other visits when the referrer is passed and tracking is allowed. Referrer reports are useful, but they do not identify every source.

    • In GA4: Find the Traffic acquisition report (under Reports → Acquisition in the Life cycle collection). Change the dimension to Session source / medium to see individual sources, or Session campaign to see your tagged campaigns. Other report collections can place it elsewhere.
    • In privacy-focused tools like Umami or Plausible: the referrers or sources panel on the main dashboard, with UTM values usually shown alongside.

    Two things to know about referrer data:

    1. “Direct” is partly a catch-all. It includes people who typed your address, but also visits where the tool couldn’t tell the source, such as links in some messaging apps, documents, and email clients. A large “Direct” number means some of your sources are hidden, not that everyone already knew you.
    2. It shows the last step, not the story. Someone who read your article in March, forgot about it, and searched your name in May shows up as organic search or direct. The analytics are correct about the click and silent about why they came back.

    That second gap is why the next piece matters.

    Piece 3: Ask Customers How They Heard About You

    No tracking code sees a conversation over coffee, a recommendation in a group chat, or a podcast mention. The customer knows. Ask them.

    On the contact form

    Add one field: “How did you hear about us?” Make it an open text box, and make it optional so it doesn’t cost you inquiries.

    An optional open-text field can capture more detail than a fixed dropdown. It also takes time to classify consistently, so choose the format that your team will actually review. A long list of vague options (“Social media,” “Search engine,” “Friend”) can hide a useful name or story.

    • A dropdown records “Social media.” Open text records “Saw your post about month-end reports on LinkedIn, then looked you up.”
    • A dropdown records “Referral.” Open text records “My accountant, Priya, said you’d sorted out her client’s reporting.”

    The second version tells you which post worked and which relationship to thank.

    In the first conversation

    Ask again, in person or on the call, even if they filled in the form: “Before we start, who can we thank for sending you our way?” People often give a fuller answer out loud, and phone inquiries never touch the form at all. If whoever answers the phone doesn’t ask, phone leads have no source.

    Piece 4: One Spreadsheet That Ties Sources to Revenue

    Website analytics generally stops before the final sale. Revenue lives in your sales records. The spreadsheet is where the two meet. A shared Google Sheet or Excel file is enough; a CRM you already pay for works too.

    One row per lead, with these columns:

    ColumnWhat goes in it
    DateWhen they first reached out
    LeadName or company
    Recorded sourceWhat the analytics or UTM tag says (e.g., newsletter / email, google / organic, (direct))
    Stated sourceWhat they told you on the form or the call
    Credited sourceYour decision, from a short fixed list (see below)
    StatusOpen, won, or lost
    ValueContract or first-order value, once known

    The recorded source is the column that needs a deliberate setup. Analytics tools show UTM tags in aggregate reports, not next to an individual lead’s name. If your form tool supports hidden fields, it can pass the UTM values from the page address into the notification email or CRM entry, which fills this column automatically. If it doesn’t, leave the column blank and rely on the stated source rather than guessing.

    Keep the credited source list short so the monthly totals mean something. For most service businesses, five categories are enough: website and content, referrals and word of mouth, direct outreach, partners and community, and paid ads.

    When recorded and stated sources disagree

    They often will. Treat the customer’s answer as one clue about why they remembered you and analytics as one clue about the visit path. Neither is a complete causal history.

    • Recorded source: (direct) / (none)
    • Stated source: “Read your article on dashboard mistakes a few weeks ago, then typed your name in.”
    • Credited source: website and content. The article started it; the direct visit was just how they came back.

    When there’s no stated source, use the recorded one as a working classification. When neither exists, mark it “unknown” rather than guessing. Recorded and stated sources are clues, and a customer’s memory can also be incomplete. Your credited-source column is a consistent management judgment, not proof that one channel caused the sale. A growing “unknown” count is a prompt to check whether the question is being asked and recorded.

    If your inquiries arrive by email, phone, and form, you probably already have most of this information scattered across your inbox and invoicing system. The business data you already have covers pulling it together.

    Tracking Offline Sources for Free

    Print, events, signs, and phone calls need a little more setup, but none of it costs money.

    • A memorable redirect. Set up a short address like yourfirm.com/workshop that forwards to a tagged link (?utm_source=fall_workshop&utm_medium=print). Most website platforms can create redirects without a developer. Put the short address on the flyer or slide, and test it first: open it in a private browser window and confirm the tag is still in the address bar after it forwards.
    • QR codes pointing to tagged links. Static QR codes are free to generate. Test the code before printing, and point it at a page on your site so you control where it goes.
    • A standard phone question. Whoever answers asks the same “who can we thank?” question and records the answer in the spreadsheet.

    The Monthly Source Review

    Once a month, filter the spreadsheet to that month’s leads and total them by credited source: how many leads, how many won, and how much revenue.

    Credited sourceLeadsWonRevenue
    Referrals and word of mouth53$13,500
    Website and content72$6,000
    Partners and community21$4,000
    Paid ads40$0
    Unknown20$0
    Total206$23,500

    Before changing a channel, look at how many leads and sales you actually have, how long they take to close, and what that channel costs in money and time. A month may be enough to spot a broken tracking link but too little to judge a long sales cycle. Choose a review window and a time or spending limit in advance; if a source still produces no useful leads over that window, investigate whether to change or pause it.

    Put the headline numbers on your monthly scorecard: leads and won revenue by source. Keep the underlying recorded and stated sources available so you can revisit a classification when new information appears.

    Free Source-Tracking Checklist

    • External campaign links I control carry consistently named, lowercase UTM tags.
    • I keep a list of tagged links and their naming conventions.
    • I check source / medium or referrer reports monthly.
    • My contact form has an optional, open-text “How did you hear about us?” field.
    • Whoever takes calls asks the same question.
    • Every lead goes in one spreadsheet with recorded, stated, and credited sources.
    • Won deals have a value recorded.
    • I review leads and revenue by source monthly and decide quarterly.

    Frequently Asked Questions

    What are UTM parameters?

    Labels added to the end of a link that tell your analytics tool where the click came from. The three that matter are source, medium, and campaign.

    Do UTM tags affect SEO?

    Not when you use them on links you share elsewhere. Don’t use them on links between your own pages.

    What if customers don’t answer the “how did you hear” question?

    Some won’t. Keep it optional, ask again in the first conversation, and fall back on the recorded source. Mark the rest “unknown” and watch whether that count is growing.

    Is a dropdown ever better than open text?

    When you have a large number of inquiries and need clean categories automatically. Even then, add an “Other (please specify)” option. For most small businesses, open text plus your own credited-source column works better.

    When is paid attribution software worth it?

    When you make repeated budget decisions across several channels, have enough conversion data to evaluate the model’s output, and the expected benefit exceeds the software and operating cost. Test whether the tool answers a decision your free routine cannot.

  • Google Analytics 4 Explained for Business Owners

    Google Analytics 4 (GA4) organizes the interactions your tag is configured to collect as events: page views, certain scrolls and clicks, and form submissions when those events are captured. Most of its interface can wait. Start with Traffic acquisition (where visits came from), Pages and screens (what people viewed), and a check that your most valuable actions are recorded as key events. Key events are a setting and metric used across reports, not a separate report.

    Those are the GA4 views and key-event numbers I check on johnserra.com. The rest of this guide explains how GA4 counts things, where to find the reports in a common menu layout, how to test tracking, and what you can safely skip. The examples use a made-up bookkeeping firm, not a real site.

    Why GA4 Feels Confusing

    If you used the older version of Google Analytics (Universal Analytics, whose standard properties stopped processing data on July 1, 2023, with historical access ending in 2024), you may remember reports built around sessions and pageviews. You opened it, and a dashboard told you how many visits you'd had and which pages they saw.

    GA4 counts differently. Every interaction is an event, and each event has a name:

    • page_view when a page loads
    • scroll when 90% of a page becomes visible, if enhanced measurement is enabled
    • click when someone follows a link to another website
    • form_submit for supported form interactions when enhanced measurement catches them; generate_lead is a separate recommended event that you set up

    Google built it this way so websites and mobile apps could be measured in the same system. The cost for a small business is that GA4 is more flexible and less obvious. Reports you'd expect aren't always on the menu, the vocabulary changed, and some of the most visible features are meant for people who analyze data full time.

    The good news is that you need very little of it.

    A Plain-English Translation Table

    What you might call it What GA4 calls it What it means for you
    Visits Sessions A period of activity on your site by one visitor
    Unique visitors Users (or active users) Distinct browsers or devices, not exactly distinct people
    Pageviews Views (the page_view event) A page loaded
    Goals or conversions Key events An action you've marked as valuable, like a form submission
    Where a visit came from Session source / medium, or session default channel group The site, search engine, or campaign that sent the visit
    Bounce rate Engagement rate (bounce rate is its inverse) Share of visits that showed real interest

    Two of these need a closer look.

    Users aren't people. GA4 counts browsers and devices. Someone who visits on a phone at lunch and a laptop that evening can count as two users. Treat user counts as approximate.

    Engagement replaced the old bounce rate. GA4 counts a session as engaged if it lasted longer than 10 seconds, included a key event, or included at least two page views. Engagement rate is the share of sessions that were engaged, and GA4's bounce rate is simply the rest. A visitor who reads one article for three minutes now counts as engaged, which is closer to how you'd judge it yourself.

    Report 1: Traffic Acquisition (Where Did Visitors Come From?)

    Where to find it in the Life cycle collection: Reports → Acquisition → Traffic acquisition. A property using a Business objectives or customized collection may place the same report elsewhere; use the report library or ask an Editor to add it if it is missing.

    This report answers "which sources are sending visitors, and do any of them produce inquiries?" Each row is a channel. The default grouping is called session default channel group, and for a small business the common rows are:

    • Organic Search: unpaid results from Google, Bing, and other search engines
    • Direct: someone typed your address, used a bookmark, or GA4 couldn't tell where they came from
    • Referral: a link on another website
    • Organic Social: unpaid posts on social platforms
    • Paid Search and Email, if you run ads or send newsletters

    The columns that matter are Sessions, Engaged sessions, and Key events.

    The one habit that changes how you read it: sort by key events, not sessions. GA4 sorts by volume by default, so the channel sending the most visitors sits at the top whether or not those visitors ever contact you.

    Last month, Organic Social sent 900 sessions and 2 key events. Referral, mostly from a local business association's member directory, sent 140 sessions and 6 key events. Sorted by sessions, social looks like the winner. Sorted by key events, the directory listing is doing three times the work with a sixth of the traffic.

    "Direct" deserves some skepticism. It includes typed addresses and bookmarks, but also visits GA4 couldn't attribute, such as links in some apps and private messages. If you share campaign links in newsletters or social posts, tag the links you control with UTM parameters so those visits can be identified. A tagged newsletter link looks like https://example.com/services?utm_source=newsletter&utm_medium=email&utm_campaign=october-update. Google's free Campaign URL Builder assembles these for you. Don't add UTM tags to links inside your own site, because that overwrites the original source of the visit.

    Report 2: Pages and Screens (What Did They Look At?)

    Where to find it in the Life cycle collection: Reports → Engagement → Pages and screens. In other report collections, look for Pages and screens by name.

    This report lists every page on your site with its views, users, and average engagement time. It answers "which pages get attention?"

    Read it with two questions:

    1. Are my commercial pages getting seen by the right visitors? A service page can work without ranking near the top by total views. If it gets few views and few inquiries, check whether visitors can reach it from relevant entry pages.
    2. Which pages deserve a closer look? Average engagement time estimates how long the page was in the foreground. Read it alongside the page's purpose and useful actions; low time alone does not show that the headline failed.

    To see which pages people arrive on, rather than every page they view, use the Landing page report (under Reports → Engagement in the Life cycle collection). Its placement may differ in your property. That report can show key events by landing page, so you can investigate which entry pages lead to inquiries.

    Its most-viewed page is an article on year-end payroll deadlines, with 600 views and no key events. Its "Monthly bookkeeping" service page has 90 views and 5 key events. The article may be drawing readers who have no obvious next step. A short line near the end, linking to the service page, is a better use of an hour than writing another article.

    Check 3: Key Events (Did Anyone Contact You?)

    A GA4 setup without useful key events tells you about visits but little about whether visitors took the actions you care about. Key events connect those actions to the acquisition and page reports above.

    What should count as a key event

    For most small businesses:

    • A completed contact form
    • A click on your phone number (tel: link) from a mobile device
    • A booked appointment, if you use a scheduling tool
    • A purchase, if you sell online

    Pick the two or three actions that genuinely lead to revenue. Marking every click as a key event makes the number meaningless.

    How to mark an event as a key event

    1. With Editor access to the property, go to Admin → Data display → Events.
    2. Find the event, such as form_submit or generate_lead.
    3. Mark it as a key event by clicking the star icon next to it.

    This only works for events GA4 is already recording. GA4's enhanced measurement can record some form submissions automatically, but it doesn't catch every form, and phone clicks usually need an extra tag. It can also fire on the wrong thing, such as a search box or newsletter field. Forms embedded from other tools (HubSpot, Typeform, Calendly) or shown in popups often go unrecorded, so they usually need manual event setup.

    If your event isn't in the list, it may simply not have fired yet, so run the test in the next section first. If it still doesn't appear, the setup is incomplete, and whoever built your site or manages your tags needs to add it.

    A common fallback is a "thank you" page after the form. Don't mark page_view itself as a key event, because that would count every page load. Instead, create a new event under Admin → Data display → Events → Create event that fires only when the page location contains your thank-you page's address (for example /thank-you), and mark that new event as the key event.

    Marking a key event only counts from that day forward. It doesn't backfill earlier data, so set it up before you judge results.

    Where to see them

    Once marked, key events appear as a column in Traffic acquisition and the Landing page report, and in the event reports under Reports → Engagement.

    How to Check That Tracking Works in Two Minutes

    Before trusting any of these numbers, confirm GA4 is recording what you think it is:

    1. Open your website in a private or incognito browser window.
    2. In your normal browser, open GA4 and go to Reports → Realtime.
    3. In the private window, submit a test form or tap your phone link on a mobile device.
    4. Watch the Event count by Event name card in Realtime. Realtime typically updates within minutes; allow for a short delay.
    5. Check that the same event shows up as a key event.

    If Realtime is inconclusive, GA4's DebugView (Admin → Data display → DebugView) shows each event as it arrives from a device in debug mode, and Google Tag Manager's preview mode or Tag Assistant can turn that on.

    If nothing appears after several minutes, investigate before concluding that tracking is broken. Confirm you opened the intended property and data stream, check the site's tag and consent state, and see whether an internal-traffic filter hid your test. A phone on mobile data can help test outside an office filter. If the action still does not appear, inspect the event setup.

    Delete or mark your test submission in whatever system receives the form, so it doesn't count as a real inquiry.

    What to Skip

    GA4 has a lot of features that are useful to someone. For most small businesses, these can wait:

    1. Explore. A drag-and-drop workspace for building custom analyses: funnels, paths, free-form tables. It's powerful and meant for analysts. The standard reports answer the owner's questions.
    2. Watching Realtime. It's useful for testing, as above. As a daily habit, watching who's on your site right now is entertaining and rarely changes a decision.
    3. Predictive metrics and audiences. GA4 can predict purchase and churn likelihood, but only when a site has enough purchase and return history to meet Google's minimums, which most small business sites don't.
    4. Monetization reports, unless you sell online. Service businesses don't have the data these reports need.
    5. Demographics and tech details. Browser versions, screen sizes, and age brackets are occasionally useful for a site redesign. They don't belong in a monthly review.

    A Five-Minute Monthly GA4 Check

    Once a month:

    1. Set the date range to last month and turn on comparison with the preceding period.
    2. Open Traffic acquisition and sort by key events. Note total key events and the top three channels by key events.
    3. Open the Landing page report. Check that your main service pages and best articles are still bringing in engaged visits and key events.
    4. Copy the numbers onto your scorecard. My rule is four to seven metrics, depending on the business, and none that don't move the needle. Choose website numbers that support a decision rather than copying every GA4 card.
    5. Close GA4 until next month, unless you're testing a specific change.

    If your scorecard lives in a spreadsheet, how to build a monthly KPI scorecard shows a layout that holds website numbers alongside the rest of the business.

    Do You Need GA4 at All?

    GA4 is free, detailed, and the default choice. It's also complicated, and it sets cookies, which may mean a consent banner depending on where your visitors are. Simpler privacy-focused tools like Umami and Plausible show pages, sources, and events with far less to learn, and I use Umami on a second site. What matters is that whatever tool you use can show three things: where visitors came from, which pages they landed on, and whether they contacted you.

    If you're using GA4 already, start with the two reports and key-event check above. It costs nothing to use the standard product, and staying with a tool that covers your needs is usually the right call for a small business.

    Frequently Asked Questions

    What happened to conversions in GA4?

    Google renamed them key events in 2024. The term "conversions" now refers to key events used in Google Ads. For your own website reporting, key events are what you want.

    Does GA4 still have bounce rate?

    Yes. GA4 defines bounce rate as the share of sessions that weren't engaged, the opposite of engagement rate. You can add it to reports, but engagement rate tells you the same thing.

    Why don't my GA4 numbers match my other tools?

    Different tools count visitors and sessions differently, ad blockers and consent choices hide some visits from GA4, and each tool handles bots its own way. Use each tool's numbers consistently over time rather than trying to make them agree.

    How long does GA4 keep my data?

    Standard reports keep aggregated data. Explorations are limited by a data retention setting (Admin → Data collection and modification → Data retention) that defaults to two months. Change it from 2 months to 14 months, the longest option in a standard property, if you might use Explore later. The setting doesn't affect standard reports.

    Do I need Google Tag Manager?

    Not for the basics. The GA4 tag and enhanced measurement cover page views, scrolls, outbound clicks, and some form submissions. Tag Manager helps when you need events GA4 doesn't collect on its own, such as phone clicks or a form that enhanced measurement misses.

  • Which Website Metrics Matter for a Small Business

    It depends on what the website is for. If it exists to bring in inquiries, track six measures: inquiries, conversion rate by traffic source, the landing pages that lead to inquiries, engaged visits to commercial pages, cost per inquiry, and page speed. If people use your product on the site, swap the inquiry-specific measures for activation, drop-off, and return rates. Pageviews, impressions, and site-wide time on page can leave the monthly review.

    Six isn’t a magic number. My rule for any business scorecard is four to seven metrics, depending on the business, and no vanity metrics: each one has to move the needle. Website analytics is where that rule gets broken most often, because the tools show you everything by default.

    Why Most Default Analytics Reports Don’t Help

    Analytics tools are built to serve every kind of website, from a local accounting firm to a national retailer with a marketing department. So they show everything they can collect: users, sessions, pageviews, events, devices, cities, browsers, screen resolutions. None of it is wrong. Most of it doesn’t help a small business decide anything.

    The useful distinction is between two kinds of numbers:

    • Vanity metrics look good in a report and require no action. Pageviews went up 12%. Great. What do you do differently on Monday?
    • Commercial metrics track inquiries, customers, and the cost of getting them. When one moves, someone has a reason to act.

    The cost of watching the wrong numbers is quiet. A business can spend months redesigning pages to raise time on site while inquiries slide, and nobody notices because the report everyone looks at went up. The test I use on any metric is whether it helps the business make more revenue, run more efficiently, or cut costs. If it does none of those, it comes off the scorecard.

    If you haven’t looked at what your site already records, start there. Contact form submissions, booking confirmations, and phone logs usually exist before anyone opens an analytics tool. The business data you already have covers how to find them.

    What I Track on My Own Two Sites

    I run two sites that do different jobs, and I’ve only just started measuring both. What follows are the metrics I’m setting up, not results.

    johnserra.com is meant to generate inquiries. It uses GA4. I’m tracking two things: the share of visitors who complete a high-intent action (an assessment or the contact form), and where qualified visitors come from, split by referral and search and broken down by page.

    CareerTalkLab is a product. It’s a community whose members learn from and teach each other to advance in data and software careers, and I measure it with Umami. I’m tracking the share of visitors who start a lesson, completion and drop-off by module, and how many new learners come back on Day 7 and Day 30.

    Both sites get one technical metric: how long the slowest page loads and server responses take, measured at the 95th percentile.

    Those are target measures across two sites, not a combined scorecard or a claim that I already have results. The lists differ because the sites do different jobs. An inquiry site succeeds when a stranger reaches out. A product site succeeds when someone starts using it and comes back. Start with what your site is for, then pick four to seven measures for that site; a generic list of “top website KPIs” skips that step.

    The Five Metrics for a Site That Brings in Inquiries

    1. Key Conversion Actions

    A conversion is an action that moves a stranger into your sales pipeline. Count those, not visits. What counts depends on the business:

    • Professional services and consulting: completed contact forms, booked discovery calls, clicks on your email address.
    • Local trades and service businesses: click-to-call taps, quote requests, requests for directions.
    • Online stores and software: purchases, checkout starts, free trial signups.

    In GA4, you mark these actions as key events (Google’s current name for what it used to call conversions). Other tools call them goals or conversions. If you track nothing else on your website, track the total number of these actions each month and compare it with a target.

    2. Conversion Rate by Traffic Source

    Your overall conversion rate blends every source together and hides where buyers come from. Split it by channel:

    • Organic search: people who found you on Google or Bing, often while describing a specific problem.
    • Direct: visits with no identifiable source. This can include typed addresses and bookmarks, but also links from apps or messages that pass no referrer.
    • Referral: visitors from other websites, such as directories, associations, and partners.
    • Social: visitors from platforms like X or LinkedIn. These often bring attention more than inquiries.
    • Paid: ad clicks, if you run ads. These need the tightest tracking because you pay for every visit.

    Then compare. Here is an example with made-up numbers. A source that sends 500 visits at a 4% conversion rate produces 20 inquiries. A source that sends 5,000 visits at 0.1% produces 5. The smaller source is worth four times as much, and it’s the one a traffic report makes look minor.

    Source data from analytics tools is incomplete. Ad blockers, consent choices, and people who switch devices can break the trail. A “How did you hear about us?” field on your contact form fills some gaps, and tagging campaign links you control with UTM parameters helps identify those visits.

    3. Top Converting Landing Pages

    Visitors can arrive through your homepage, a service page, an article, or a guide. Your landing pages are the entry points; find which ones actually lead to inquiries rather than assuming the homepage does all the work.

    Check two things each month:

    • Which pages bring in the visitors who go on to convert?
    • Does each high-traffic page give visitors a clear next step: a form, a phone number, or a link to the relevant service?

    The common problem is a popular article with no conversions. It brings in the right readers and gives them nowhere to go. The fix is usually a clear next step near the top and bottom of the page, or a link to the service it relates to.

    4. Engaged Visits to Commercial Pages

    Raw traffic mixes useful visits with accidental clicks and visits that end quickly. Engagement is a helpful filter, but it cannot tell you by itself whether a visitor was a qualified buyer or even rule out automated traffic.

    GA4 counts a session as engaged if it lasts longer than 10 seconds, includes a key event, or includes two or more page views. Engagement rate is the share of sessions that meet that bar. Privacy-first tools like Umami don’t use the same definition, so there the practical measure is unique visitors to your commercial pages: services, pricing, about, and contact.

    A large traffic spike with almost no engagement is worth investigating. Check its sources and conversions before calling it a marketing win or deciding what caused it.

    5. Cost per Inquiry

    A website costs money and time. Measure what each inquiry costs you:

    Cost per inquiry = (monthly spend on the site and its marketing + hours spent × your hourly rate) ÷ inquiries that month

    Here’s an example with made-up numbers: a firm spends $200 a month on hosting, tools, and a small ad budget, and someone spends 6 hours a month on content at $50 an hour. That’s $500. With 20 inquiries, each costs $25. If the same firm spent $500 and got 2 inquiries, each would cost $250, and that’s a reason to look at whether the time would go further on direct outreach.

    Count inquiries, not every form submission. Spam and job applicants through the contact form will make the site look cheaper than it is.

    If Your Website Is the Product

    For software, online courses, memberships, and tools, an inquiry isn’t usually the goal. Someone using the product is. Keep two measures from the inquiry scorecard—valuable conversion actions and traffic source—then replace the landing-page, engagement, and cost-per-inquiry measures with:

    • Activation rate: the share of new visitors who take the first real product action, such as starting a lesson, creating a project, or running a first report.
    • Drop-off by step: where people stop in a sequence, whether that’s a course module, an onboarding step, or a checkout page.
    • Cohort return rate: of the people who signed up in a given week, the share who come back on Day 7 and Day 30.

    With speed, that is a six-measure product-site starting scorecard. These are the kinds of measures I’m setting up for CareerTalkLab. They answer the question a product site actually has to answer: do people who arrive start using it, and do they keep using it?

    The Metric Every Site Needs: Speed

    A slow page loses visitors before any other metric has a chance to count them. Measure the slow end, not the average. The 95th percentile (P95) is the time within which 95% of page loads finish. An average of 1.5 seconds can hide a meaningful share of visitors waiting six.

    You don’t need paid tools to start. Google’s PageSpeed Insights and the Core Web Vitals report in Search Console are free and show real-user field measurements when a page or site has enough data. Google reports those values at the 75th percentile, not P95, but for most small business sites that is a good enough place to start. If speed turns out to be a real problem, a real-user monitoring tool can report P95 directly.

    The Cut List: Metrics to Stop Reviewing Every Month

    These don’t need to be deleted from your analytics tool. They just don’t belong on the scorecard you review.

    1. Raw pageviews. Refreshes, back-button clicks, and multi-page wandering inflate them. More pageviews don’t mean more business.
    2. Bounce rate, by itself. Under the old Google Analytics definition, a visitor who read a whole page, found your phone number, and called still counted as a bounce. GA4 now defines bounce rate as the share of sessions that weren’t engaged, which is better, but engagement rate and conversions tell you the same thing more directly.
    3. Site-wide average time on site. Tabs left open and one long visit can skew it, and a longer visit isn’t better if the visitor couldn’t find what they needed.
    4. Social impressions. How many people saw a post on another platform says little about whether they visited your site, let alone contacted you.
    5. Keyword rankings in isolation. Ranking first for a phrase nobody searches, or one that attracts people who will never buy, produces nothing. Rankings matter only when they bring engaged visitors to pages that convert.

    A 15-Minute Monthly Website Review

    Once a month, with your scorecard open:

    1. Record conversions for the prior month against your target.
    2. Check conversion rate for your top three traffic sources. Note any that changed sharply.
    3. Find the top converting landing page and the page with the most engaged visits but the fewest conversions.
    4. Check speed on your two or three most important pages.
    5. Write down one action, with a name and a date. “Add a consultation link to the top article, Sam, by the 15th.” “Fix the phone link that doesn’t work on mobile.”

    The last step is the one that makes the review worth doing. A monthly number nobody acts on is just another report. How to get your team to actually use your reports covers how to run that conversation so the action happens.

    If you use GA4, its Traffic acquisition, Landing page, and event reports can help with this review. Check that the actions you count as inquiries are actually recorded.

    Website Metrics Checklist

    • I know what my website is for: inquiries, sales, or product use.
    • I track the actions that matter as conversions or key events.
    • I can see conversion rate by traffic source, not just overall.
    • I know which landing pages bring in converting visitors.
    • I review engaged visits, not raw traffic.
    • I know roughly what each inquiry costs me.
    • If the site is a product, I track activation, drop-off, and return rate.
    • I check page speed at the slow end.
    • My scorecard has four to seven metrics, and I review it monthly.

    Frequently Asked Questions

    How many website metrics should a small business track?

    Four to seven for each site’s scorecard. An inquiry site can start with the five measures above plus speed. A product site can keep conversions and traffic source, replace the inquiry-specific measures with activation, drop-off, and return, and also watch speed. Cut or combine measures when they don’t lead to a decision. How many KPIs should a small business track explains the wider business-scorecard principle.

    Is bounce rate still important?

    Less than it used to be. GA4 redefined it as the opposite of engagement rate, so looking at both is redundant. Engagement rate and conversions tell you more.

    Do I need Google Analytics?

    No. GA4 is free and detailed, but it’s also complicated. Privacy-first tools like Umami or Plausible are simpler and cover page, referral, and event tracking. What matters is that you can see conversions, sources, and landing pages in whatever tool you use.

    How often should I check website analytics?

    Monthly for the scorecard. More often only when you’re testing something specific, such as a new landing page or a campaign, and you know in advance what number you’re waiting to see.

    What’s a good conversion rate for a small business website?

    It depends on the industry, the offer, and where the traffic comes from, so a generic benchmark won’t tell you much. Your own trailing three-month average is the more useful baseline. Improve against that.

    If you want a second pair of eyes on your scorecard, or help deciding what belongs on it, get in touch.

  • How Much Should a Small Business Spend on Data Tools

    Start with the data tools already included in your office software, and spend more only when a specific reporting problem justifies the added cost. If you use Google Workspace, Sheets and the no-cost version of Looker Studio can cover basic reporting without another software subscription. If you use Microsoft 365, Excel and the free Power BI Desktop can cover local analysis; sharing through the Power BI service usually requires licenses. Pay for more when the likely benefit exceeds the full cost of the change: hours of manual data work every month, reports that arrive too late to act on, or people working from conflicting versions of the same file.

    The rest of this article covers what each level of spending buys and how to tell when you’ve outgrown the level you’re on.

    Why Vendors and Small Businesses See This Differently

    Much of the advice about data tools comes from companies that sell them, and it’s written with larger businesses in mind. A typical recommended setup has four parts: a data warehouse to store everything, a pipeline tool to copy data into it automatically, a transformation layer to clean it, and a business intelligence (BI) tool to show it. Each is billed separately, and the setup needs someone who knows how to run it.

    For a company with large data volumes and a data team, that setup may make sense. A 15-person business should first check whether its existing reports have clear owners, consistent definitions, and a decision attached to each number. New software alone will not establish those habits. A business that pays for a sophisticated stack before sorting them out gets the same unclear numbers, faster and at greater cost.

    The software is also only part of the cost. Setting it up, connecting it to your systems, and keeping it running takes someone’s time, whether that’s yours, an employee’s, or a consultant’s. How much a small business dashboard costs covers the build side.

    Level 1: No Added Cost

    My view is that small businesses should stay at this level as long as possible, and that the right tools depend on which office software you already use.

    If you use Google Workspace

    • Google Sheets holds and shapes the data. Pivot tables, QUERY, and IMPORTRANGE can cover many reporting tasks. Google sets a 10 million-cell file limit, though a practical workbook may become slow well before that limit.
    • Looker Studio turns the sheets into dashboards and shares them with a link. It connects directly to Sheets, Google Analytics, and other Google products, and the standard version is free. Looker Studio Pro adds organizational ownership, team workspaces, and support for teams that need those controls.

    If you use Microsoft 365

    • Excel holds the data, and Power Query, built into Excel, cleans and combines exports from different systems and repeats those steps each month with a refresh.
    • Power BI Desktop is free and builds full dashboards on your computer. Sharing them with others online through the Power BI service requires a paid license for the people publishing and viewing, typically Power BI Pro.

    What this level covers

    With either setup, a business can keep a monthly scorecard, combine exports from its accounting, sales, and operations systems, and build useful reports. Sharing options differ: Looker Studio can share online, while Power BI Desktop reports stay local unless the business uses an appropriate Power BI sharing license or capacity. The work may still include exporting data from each system and updating the spreadsheet each month. Track the time and errors in that routine before deciding whether automation would pay for itself.

    Before spending on anything, take stock of what your systems already give you. The business data you already have covers where to look.

    Level 2: Paying for Specific Gaps

    The first paid step isn’t a new platform. It’s paying for the one or two things your free setup can’t do. Three are common.

    Sharing licenses. In the Microsoft setup, publishers and viewers of shared Power BI reports generally need a Pro license: $14 per user per month as of September 2026, paid yearly. Microsoft 365 E5 and Office 365 E5 include Pro. Large Premium or Fabric capacity can allow free viewers, so check your licensing setup before buying separately.

    Automated connectors. Tools like Coupler.io and Supermetrics copy data from your accounting system, CRM, ad accounts, or e-commerce platform into Sheets, Excel, or a BI tool on a schedule, so nobody has to export it by hand. Pricing usually depends on the number of sources, accounts, and how often the data refreshes. Check current plans before comparing.

    Alerts and scheduled delivery. Automatic emails when a number crosses a threshold, or a report sent every Monday morning. Some of this is free with scripts or built-in features; paid tools make it easier to set up and maintain.

    Consider a made-up example. A 12-person firm on Microsoft 365 has five people who need to view shared dashboards. Five Power BI Pro licenses at $14 each come to $70 a month. It adds one connector to pull accounting data automatically, at a hypothetical $60 a month. Total: $130 a month. If it saves six hours of work each month, compare the value of those hours and the cost of setup and upkeep with the $130 fee. If the reports go unread, it’s $1,560 a year for nothing.

    That last point is the real test at this level. A paid tool is worth it when it solves a problem you can name and measure. It’s a waste when it’s bought in the hope that having better software will make people use the numbers.

    Level 3: A Full Data Platform

    At the top end is the setup vendors often lead with: a cloud data warehouse, automated pipelines from every system, a transformation layer, and a BI platform with detailed permissions. Software costs scale with data volume and users, and the larger cost is the person who builds and maintains it.

    It’s justified when:

    • Data volume outgrows spreadsheets. Transaction, sensor, or event data that no longer performs reliably in the current spreadsheet workflow.
    • Access needs to be controlled row by row. Different managers, locations, or clients should see only their own data, and a shared spreadsheet can’t enforce that.
    • Many systems need to be combined continuously. Not once a month, but daily or hourly.
    • Someone is there to run it. A data analyst or engineer on staff, or a committed outside partner. Without that person, the platform decays: pipelines break, definitions drift, and people go back to their own spreadsheets.

    Adopting this level early is expensive twice over: the subscriptions, and the time and attention taken from sales, delivery, and the rest of the business.

    How to Tell Whether a Tool Is Worth It

    Judge tool spending by what it lets you do, not as a percentage of revenue. Three questions work at any level:

    1. What problem does it solve? Name it. "Our month-end report takes three days to assemble" is a problem. "We should be more data-driven" isn’t.
    2. What does the problem cost now? Hours of staff time, late decisions, errors caught too late, customers or cash lost to something nobody noticed.
    3. Will anyone use the result? A tool that produces reports nobody reads costs its full price and saves nothing. Keep reporting focused on four to seven metrics that each lead to a decision, and the tool has a job to do.

    Compare the value of the improvement with the full cost: licenses, setup, maintenance, and staff time. Test a small purchase first when those numbers are uncertain.

    Signs It’s Time to Spend More

    Stay where you are if:

    • Monthly exports and updates are manageable.
    • The people who need reports can get them from shared files or free dashboard links.
    • You haven’t yet used what your office suite includes. Power Query, pivot tables, and Looker Studio go a long way.

    Consider paying for specific tools if:

    • Reports arrive so long after month end that the numbers are too late to act on.
    • Several people edit the same file and overwrite each other’s work, or keep private copies that disagree.
    • The same exports are copied by hand every week, and mistakes creep in.
    • People who need to see reports can’t, because your free setup can’t share them the way you need.

    Consider a full platform if:

    • The data won’t fit in spreadsheets, access needs row-level control, or systems must be combined continuously, and you have someone to run it.

    Keep a record of slow reports, version conflicts, and repeated manual work. Those observations will make the next software decision easier.

    Frequently Asked Questions

    Is Looker Studio really free?

    The standard version is free to build and share reports. Costs can come from paid third-party connectors for non-Google data, or from Looker Studio Pro for organizational and team features.

    Is Power BI free?

    Power BI Desktop, which builds reports on your computer, is free. Publishing and sharing reports online generally requires a paid license for the people involved, such as Power BI Pro.

    Should a small business use Tableau?

    Tableau may be worth comparing when your team already knows it or has requirements your current tools cannot meet. Include its licensing, deployment, and maintenance costs in the comparison.

    What should a small business spend on data tools as a percentage of revenue?

    There isn’t a useful percentage. Spending should follow specific problems, and for many small businesses the right answer for a long time is nothing beyond what they already pay for their office software.

    What’s more important than the tool?

    Clear definitions, an owner for each number, a regular review, and a short list of metrics that lead to decisions. With those in place, a spreadsheet does a lot. Without them, no tool helps much.

  • A Monthly Reporting Pack Template for Small Business

    A monthly reporting pack for a small business fits in five pages: (1) a summary with your core metrics and what’s off track, (2) financial results against budget, (3) operations and team capacity, (4) sales pipeline and customers, and (5) risks and the decisions leadership needs to make. Keep the layout identical every month so the pack takes hours to produce rather than days, and put supporting detail in an appendix.

    Below is a copyable five-page outline, followed by the layout choices and a monthly production routine. Each page has one job. Fill in the placeholders with your own numbers and remove lines your business does not use. For what belongs on each page, in detail, see What to Include in a Monthly Business Report.

    Why Five Pages

    A monthly pack exists to help people decide what to do next. That means reporting what happened briefly, explaining the variances that matter, and giving the most attention to the choices ahead.

    Five pages is enough for that and short enough to be read before the meeting. Long packs get skimmed or skipped, and the page nobody reads is usually the one that mattered. The limit also forces a useful discipline: when something new wants in, something old has to come out.

    The other rule is sameness. The same pages, in the same order, with the same charts in the same places, every month. Readers learn where to look, and the person producing it copies last month’s file instead of starting over.

    Copy This Five-Page Template

    Each page below is shown as a fillable table. Use the same layout in a document or slide deck: start a new page or slide at each page heading, and keep the bracketed prompts until you have real numbers and decisions to replace them. The five pages are the main pack; supporting detail goes in the appendix.

    Prefer a ready-made file? Copy the template as a Google Doc — File > Make a copy, then fill in your own numbers.

    PAGE 1 — SUMMARY AND CORE METRICS

    Reporting month: [month/year]  |  Books closed: [date]  |  Cash at month end: [amount]

    Core metricActualTargetLast monthOn track / Watch / Off track
    [Metric 1]
    [Metric 2]
    [Add only the metrics needed, up to seven]
    Went wellOff track
    [two or three short results][miss, reason, and owner for each item]

    Main decision: [one sentence; see page 5]

    PAGE 2 — FINANCIAL RESULTS

    LineActualBudgetVariance ($)Variance (%)
    Revenue
    Direct costs
    Gross profit ($)
    Operating expenses
    Operating profit
    Gross marginactual [ ]%; budget [ ]%; variance [ ] percentage points
    Cashopening [ ]; in [ ]; out [ ]; closing [ ]
    Receivablestotal [ ]; past due over 60 days [ ]

    Largest variances: [what changed, why, and whether action is needed]

    PAGE 3 — OPERATIONS AND TEAM

    Output this month / last month / target[ ] / [ ] / [ ]
    Backlog this month / last month[ ] / [ ]
    Current bottleneck and response[ ]
    Quality or rework measure[ ]
    Team workload and capacity risk[ ]
    Headcount changes and open roles[ ]

    PAGE 4 — PIPELINE AND CUSTOMERS

    StageOpportunity countValueExpected timing
    Qualified
    Proposal out
    Won this month
    Pipeline for next quarter / revenue target[ ] / [ ]
    Win rate this month / trailing three months[ ] / [ ]
    Customers gained / lost / active, or repeat purchase rate[ ]

    PAGE 5 — RISKS AND DECISIONS

    Quarterly priorityStatusWhat changedOwner
    [Priority]On track / At risk / Delayed
    Risk or blockerImpactOwnerNext check date
    [Risk]
    DecisionContext and company-specific costRecommendationDecision makerDue date
    [Decision]

    Use the same metric definitions and reporting periods each month. Before sending the pack, check that a figure repeated on two pages matches and that every requested decision has a named decision maker and date.

    Page 1: Summary and Core Metrics

    If someone reads only one page, this is it. It should tell them whether the business is on track and what needs their attention.

    Layout, top to bottom:

    • Header line: the month, the date the books closed, cash at month end.
    • Scorecard table: your four to seven core metrics. One row each, with columns for actual, target, last month, and status. My rule is four to seven, depending on the business, with no vanity metrics.
    • Two short lists side by side: “Went well” and “Off track,” two or three bullets each, one line per bullet.
    • One box at the bottom: the most important decision this month, in one sentence, with a pointer to page 5.

    Here’s what that scorecard might look like for a small services firm, with made-up numbers:

    MetricActualTargetLast monthStatus
    Revenue$168,000$180,000$174,000Off track
    Gross margin41%40%39%On track
    Billable utilization72%75%74%Watch
    Receivables over 60 days$9,500Under $10,000$14,000On track
    Qualified pipeline$410,000$450,000$395,000Watch

    Use words, not only colors, for status. Red and green are hard to tell apart for some readers, and printed packs often end up in black and white.

    The sample statuses are illustrative. Set your own watch and off-track thresholds before using the template, and keep their definitions in the appendix.

    If you keep a monthly scorecard in a spreadsheet, this table is a copy of it. How to build a monthly KPI scorecard shows how to set that up so the numbers carry over each month without retyping.

    Page 2: Financial Results Against Budget

    Every financial number sits next to what you expected.

    Layout:

    • Summary income statement, four numeric columns: actual, budget, variance in dollars, variance in percent. Rows: revenue (split by main business line if you have more than one), direct costs, gross profit, operating expenses, operating profit. Show gross margin as a separate percentage and its variance in percentage points.
    • Cash block: starting cash, cash in, cash out, ending cash. If cash is falling, estimate months of cash remaining at the recent average monthly net cash outflow.
    • Receivables line: total owed, and how much is more than 60 days late.
    • Variance notes: two or three bullets, each explaining one of the largest differences from budget in a sentence.

    One chart, at most: revenue by month for the past twelve months against budget. Twelve months shows seasonality, which a single month hides.

    Keep this page to summary lines. The full income statement, balance sheet, and ledger detail go in the appendix, where anyone who wants them can find them.

    Page 3: Operations and Team

    This page shows whether the business can deliver the work it’s selling. It combines two sections that are often split: operations and team capacity. In a small business they’re usually the same question, since the team is the capacity.

    Layout:

    • Output trend: one chart showing your main measure of delivered work (jobs completed, orders shipped, hours billed) over twelve months.
    • Backlog: committed work not yet delivered, with last month’s figure for comparison.
    • Bottleneck: one sentence naming what’s currently limiting delivery, and what’s being done about it.
    • Quality: one or two measures of rework, errors, or complaints.
    • Team: workload (utilization, overtime, or open work per person), people who joined or left, open roles, and any capacity risk worth naming.

    This page varies most between businesses. A manufacturer tracks throughput and scrap; a consultancy tracks utilization and project backlog; a service company tracks jobs per crew and callbacks. Pick the few measures that tell you whether operations can support next quarter’s plan, and keep them the same from month to month.

    Page 4: Pipeline and Customers

    In a business with a longer sales cycle, this month’s revenue often reflects work sold earlier. This page shows what may be coming next, alongside the timing and size of future revenue targets.

    Layout:

    • Pipeline by stage, as a short table or a simple bar chart: inquiries, qualified opportunities, proposals out, won this month. Show counts and values.
    • Pipeline against target: qualified or weighted pipeline value next to next quarter’s revenue target.
    • Win rate: proposals won as a share of proposals decided, this month and over the trailing three months (monthly win rates swing a lot when the numbers are small).
    • Customers: new, lost, and total active; or, for businesses that depend on repeat purchases, the share of customers who bought again.

    Avoid funnel graphics that look impressive but hide the numbers. A four-row table is easier to read and compare month to month.

    Page 5: Risks and Decisions

    The pack ends with what needs to happen next.

    Layout:

    • Priorities status: the three to five things the business committed to this quarter, each marked on track, at risk, or delayed, with a line of explanation for anything not on track.
    • Risks and blockers: a short list, each with a named owner.
    • Decisions table:
    DecisionContext and costRecommendationWho decidesBy when
    Hire a second project managerBacklog grew for three months; the current manager handles 14 projects against the team’s agreed capacity of 10. Cost: [company estimate]/monthApprove; post the role this monthOwnerOct 15

    Put the recommendation in the table. A decision presented without one tends to get deferred.

    This page sets up the meeting. What makes a reporting conversation useful is an action-oriented discussion about what the numbers mean, who will act on them, and by when. Every row here should leave the meeting with a decision or a date for one.

    The Appendix

    Everything that supports the five pages but doesn’t need to be read by everyone:

    • Full financial statements
    • Detailed receivables aging
    • Department or location breakdowns
    • Project or customer lists
    • Definitions of each metric and where its data comes from

    The definitions page is worth writing once. When someone asks why this month’s utilization differs from another report’s, the answer is already there.

    How to Produce It Each Month

    The goal is to produce the pack in a few hours rather than a few days. That comes from setting up once and repeating the same steps.

    Set up once:

    1. Build the five pages as a template, with every table and chart in place.
    2. Write down where each number comes from: which report, which system, which filter.
    3. Link the scorecard and charts to a spreadsheet where possible, so updating the data updates the pages.
    4. Assign an owner for each page’s numbers and notes.

    Each month:

    1. Close: the books close and the source reports are exported.
    2. Update: paste or refresh the data. The scorecard and charts update from it.
    3. Explain: each page owner writes the variance notes for their page. Keep it to a sentence or two per variance.
    4. Review: one person reads the whole pack for consistency, such as matching numbers on pages 1 and 2 and clear decisions on page 5.
    5. Send: distribute it at least a day before the meeting.

    Save each month’s pack as a separate, dated file. The history is useful, and nobody has to wonder whether the numbers they’re looking at have changed since the meeting.

    Slides or a Document?

    Either works. Choose by how the pack is used.

    • Slides (Google Slides, PowerPoint) suit a pack that’s presented in a meeting and read on a screen. Each page becomes one widescreen slide. The constraint is space: if a page doesn’t fit on one slide, it has too much on it.
    • A document (Google Docs, Word, a PDF) suits a pack that’s read in advance, printed, or sent to a lender or investor. It holds variance notes and tables more comfortably.

    Whichever you choose, send it in advance and expect people to have read it. The meeting then spends its time on the off-track items and the decisions rather than on reading. How to get your team to actually use your reports covers the meeting itself, including a short note each owner of an off-track metric brings.

    Monthly Reporting Pack Checklist

    • Five pages, in the same order every month
    • Page 1: header, four to seven metrics with target and status, went well / off track, main decision
    • Page 2: summary income statement against budget, cash, receivables, variance notes
    • Page 3: output, backlog, bottleneck, quality, team
    • Page 4: pipeline by stage, pipeline against target, win rate, customers
    • Page 5: priorities status, risks with owners, decisions table with recommendations
    • Appendix: statements, detail, and metric definitions
    • Sent at least a day before the meeting

    Frequently Asked Questions

    What’s the difference between a reporting pack and a dashboard?

    A dashboard is live and checked whenever someone wants to. A reporting pack is a fixed monthly snapshot with explanations and decisions. Many businesses use both: the dashboard for day-to-day checks, the pack for the monthly review.

    Can a very small business use a shorter version?

    Yes. A business with a handful of people can often fit pages 1 and 5 on one page and pages 2 through 4 on another. Keep the same order and the same sections.

    Should lenders or investors get the same pack?

    Usually a shorter version: pages 1, 2, and 5, with the appendix available on request. Internal operating detail rarely helps them and can raise questions without context.

    How long should the pack take to produce?

    Once the template and data sources are set up, much of the work is updating numbers and writing short notes. The first few months take longer while you settle the definitions.

  • What to Include in a Monthly Business Report

    A monthly business report should cover six things: a summary with your four to seven core metrics, financial results against budget, operations and capacity, sales pipeline and customers, team capacity, and the decisions leadership needs to make. Each number needs a target or a comparison, and each off-track number needs a short explanation. Everything else, including detailed ledgers and metrics nobody acts on, belongs in an appendix or nowhere.

    The checklist below goes section by section. At the end is a cut list: what to take out.

    What a Monthly Report Is For

    A monthly report answers three questions for the people running the business:

    1. Did we hit our targets?
    2. If not, why not?
    3. What do we need to decide or do next?

    Anything that doesn’t help answer one of those three is a candidate for cutting. Length is a design decision, not a sign of thoroughness. A 30-page pack gets skimmed, and the one number that needed attention gets lost among the ones that didn’t.

    The report also isn’t your accounting package. Financial statements tell you what happened. A useful monthly report adds what’s coming: the pipeline, the capacity, and the choices that need to be made while there’s still time to make them.

    1. The Summary and Core Metrics

    The first page should tell the whole story of the month. If someone reads only this page, they should know whether the business is on track and what needs their attention.

    Include:

    • The period and the basics. Which month, when the books closed, and your cash balance at month end.
    • Your core metrics. My rule is four to seven, depending on the business, and no vanity metrics: each one has to move the needle. Show each with its actual value, its target, and a status (on track, watch, or off track). How many KPIs a small business should track covers choosing them.
    • What went well. Two or three results worth knowing about, stated plainly.
    • What’s off track. The metrics that missed, with a one-line reason for each. Be as direct about misses as about wins; a summary that only reports good news stops being trusted.
    • The main decision. The single most important choice leadership faces this month, if there is one.

    If you already keep a monthly scorecard, this page is mostly a copy of it. How to build a monthly KPI scorecard shows how to set one up in a spreadsheet.

    2. Financial Results Against Budget

    A financial number on its own doesn’t tell you much. $180,000 in revenue is good or bad depending on what you expected. Show every financial line next to a target and a comparison.

    Include:

    • Revenue: actual, budget, and the difference, split by your main lines of business if you have more than one.
    • Gross margin: revenue minus the direct cost of delivering it, as dollars and as a percentage. For a service business, direct costs are mostly the labor that does the work.
    • Operating expenses: the overhead, with any line that moved noticeably called out.
    • Operating profit (or net income, if that’s what your books report).
    • Cash: cash in, cash out, and the ending balance. If cash is falling, estimate how many months the current balance would last at the recent average monthly net cash outflow.
    • Receivables: how much customers owe you, and how much of it is late. Revenue that hasn’t been collected isn’t cash yet.

    Add one or two sentences explaining the biggest variance. “Revenue was $12,000 under budget because two projects slipped into next month” is more useful than another table.

    Here’s what that might look like, with made-up numbers:

    LineActualBudgetVariance
    Revenue$168,000$180,000−$12,000 (−6.7%)
    Gross margin41%40%+1 point
    Operating expenses$52,000$50,000+$2,000 (+4.0%)

    Percentages and percentage points are different things. Revenue that falls 6.7% below budget is a percentage; a margin that goes from 40% to 41% has moved one percentage point. Label them so nobody confuses the two.

    3. Operations and Capacity

    Financials show the result. Operating metrics show how well the business is producing it, and they usually move first.

    Include what fits your business:

    • Output: the main measure of work delivered, such as jobs completed, orders shipped, hours billed, or tickets closed.
    • The bottleneck: the one step, team, or resource currently limiting how much you can deliver. Name it. If the answer changed since last month, say so.
    • Backlog: committed work that hasn’t been delivered yet, and whether it’s growing or shrinking.
    • Quality: rework, errors, returns, or complaints. Whatever you track that shows work having to be done twice.

    Keep it to the few measures that tell you whether operations can support the revenue you’re planning. A manufacturer, a consultancy, and a cleaning company will fill this section very differently, and they should.

    4. Sales Pipeline and Customers

    In businesses with longer sales cycles, this month’s revenue often reflects work sold earlier. The pipeline shows what may be coming next; compare it with the timing and size of future revenue targets.

    Include:

    • Qualified opportunities: how many, and their total value. If you estimate the chance of winning each, show the weighted value too.
    • Win rate: of the proposals decided this month, how many you won.
    • Sales cycle: roughly how long it takes from first contact to a signed agreement, if you track it.
    • New and lost customers: how many started and how many left, or, for repeat businesses, the share of customers who bought again.

    A pipeline that looks thin next to next quarter’s revenue target is the kind of early warning a monthly report exists to give.

    5. Team Capacity

    For most small businesses, people are the highest cost and the main limit on growth.

    Include:

    • Workload: whether the team is running at a sustainable level. For a service business, that’s often utilization (billable hours as a share of available hours). For others, it may be overtime, open work per person, or a simple manager’s assessment.
    • Headcount changes: people who joined or left, and open roles.
    • Capacity risks: a key person leaving, a team stretched thin before a busy season, a skill only one person has.

    This section is often left out, and it’s where hiring decisions should start. A team running over capacity for three months is a decision waiting to be made.

    6. Risks, Blockers, and Decisions

    End the report with what needs to happen next. A report that closes on numbers leaves the next step to chance.

    Include:

    • Risks: a large contract up for renewal, a supplier problem, a regulatory change, a customer that accounts for too much revenue.
    • Blockers: anything internal that’s stopping progress, such as a system problem, a missing approval, or two teams waiting on each other.
    • Decisions needed: a short table. Each row is one decision, the options, a recommendation, who decides, and by when.

    When I think about what makes a reporting conversation useful, it’s an action-oriented discussion about what the numbers mean, who will act on them, and by when. This section is where the report sets that conversation up. How to get your team to actually use your reports covers running the meeting, including a short off-track note each metric owner brings.

    What to Leave Out

    A good report is defined as much by what isn’t in it. When deciding whether a metric earns a place, I check whether it helps the business make more revenue, run more efficiently, or cut costs. If the honest answer is no, it goes.

    Take out:

    • Detailed ledgers and trial balances. Your accountant needs them. The leadership team needs the summary. Put them in an appendix if someone asks.
    • Vanity metrics. Social followers, impressions, and website traffic with no link to inquiries. They go up and down without anyone needing to act.
    • Numbers without context. A metric with no target, no prior period, and no trend can’t tell anyone whether to worry.
    • Every metric you can produce. If a number has sat on the report for six months without anyone acting on it, remove it and see whether anyone notices.
    • Unsettled arguments. Work out disagreements about what a number means before the report goes out, not in the margins of it.
    • Long narrative. One or two sentences per variance. If the explanation needs a page, it needs a separate conversation.

    Removing things is harder than adding them, because everything on the report was once someone’s good idea. Review the contents every quarter and cut anything that hasn’t earned its place.

    Monthly Business Report Checklist

    • A one-page summary with four to seven core metrics, each with a target and status
    • Wins and misses, stated plainly
    • Revenue, gross margin, operating expenses, and profit against budget
    • Cash position and receivables
    • A sentence or two on the largest variance
    • Output, bottleneck, backlog, and quality
    • Pipeline, win rate, and customers gained and lost
    • Team workload, headcount changes, and capacity risks
    • Risks, blockers, and a decisions table with owners and dates
    • Nothing without a target or comparison; no vanity metrics

    Frequently Asked Questions

    How long should a monthly business report be?

    Short enough that people read it before the meeting. A five-page starting point is a summary, financials, operations and team capacity together, pipeline and customers, then risks and decisions. Add detail only where the reader needs it to make a decision.

    Who should get the monthly report?

    The people who make decisions from it: owners, partners, and department leads. Lenders and investors often need a shorter version focused on financial results, cash, and risks.

    When should the monthly report go out?

    As soon after month end as the numbers are reliable. The later it arrives, the less time there is to act on it. If closing the books takes weeks, send the operating and pipeline sections early and follow with the financials.

    Should the report include forecasts?

    A short outlook helps: expected revenue for the next month or quarter, based on the pipeline and backlog. Label it as an estimate and compare it with what actually happened the following month.

    What’s the difference between a monthly report and a dashboard?

    A dashboard is something people check whenever they want. A monthly report is a fixed snapshot with explanations, sent at a set time, so decisions are made from the same numbers.