From Spreadsheets to Strategy, Vol. 2: Turning Patterns Into Action

​Your shop’s numbers tell a story, but the most useful insights often appear when you look beyond the totals.

​In our original From Spreadsheets to Strategy: Using Your Shop Numbers post, we explored the metrics worth tracking and how they can support everyday shop decisions. Now, it’s time to take that information one step further.

A sales report can tell you what sold last month. Looking for patterns can help you understand why it sold, what might happen next, and where to focus your attention.

You don’t need a complicated reporting system or hours of spreadsheet work. A little consistency and a few thoughtful questions can turn the information you already have into a more intentional plan for your shop.

Look for Patterns, Not Just Totals

It’s easy to focus on the biggest numbers. Which collection sold the most? Which month brought in the most sales? Which class filled up first? Those totals are useful, but they don’t always tell the whole story.

Try comparing results over time. Are certain colors or styles consistently popular? Do sales increase when a new collection arrives, then taper off after a few weeks? Do customers tend to purchase more fabric when a coordinating pattern or project sample is on display?

These patterns can help you distinguish a one-time success from a trend worth paying attention to.

For example, a collection might have an impressive first month but slow considerably afterward. Another might sell steadily over several months. Both have value, but they tell different stories about customer interest and how quickly inventory is moving.

Try this: Choose one area of your business to review each month. Compare the current results with the previous month or the same period last year, when possible. Look for recurring trends, unexpected changes, and questions worth investigating.

The goal isn’t to explain every fluctuation. It’s to recognize the patterns that could influence your next decision.

Use Past Performance to Plan Ahead

Once you start recognizing patterns, you can use them to make more informed plans.

Past performance won’t predict the future perfectly, but it can give you a helpful starting point. If certain products consistently sell well during a particular season, you can use that information to plan inventory and displays earlier. If a class topic regularly fills up, you might consider offering it again or exploring a related project.

The same approach can help you identify opportunities before they become urgent. If sales tend to slow during a particular period, you can plan a class, promotional feature, or fresh display to give customers a reason to visit.

For inventory planning, look beyond what sold the most. Consider how quickly it sold, how much stock remains, and whether the same results have occurred with similar collections or products. This helps you make purchasing decisions based on more than one successful week or a promising launch.

Try this: Pick one upcoming month or season and review what happened during a comparable period. Identify one thing to repeat, one thing to adjust, and one opportunity to prepare for earlier.

You’re not trying to recreate the past exactly. You’re using what you’ve learned to make the next plan a little stronger.

Your Monthly Numbers-to-Action Checklist​

Use this quick check-in to turn your shop’s numbers into a plan.

– Compare one key metric with a previous period.
– Identify one pattern, trend, or unexpected change.
– Consider what that pattern might mean for an upcoming decision.
– Choose one action to take, test, or investigate.
– Revisit the results during your next monthly review.

You don’t need to uncover a major breakthrough every month. Consistent, thoughtful adjustments can make a meaningful difference over time.

Your numbers aren’t just a record of what your shop has already done. They can help you recognize opportunities, prepare for what’s ahead, and make decisions with greater confidence.

The next time you open a report, don’t stop at the totals. Look for the story behind them—and decide what you can do with what you learn.