top of page
Search

How to Analyze Your Microbakery Sales Data, Step by Step | Episode 120

  • Mar 12
  • 7 min read

Updated: 23 hours ago

Listen on Apple Podcasts or watch on YouTube


Most of us run our bakeries on memory. We remember the customers we see every week, the products that sell out fast, and the weeks that felt busy. That memory is selective, and it leaves out most of the picture.


For a long time I believed growth was mostly about visibility. Post more consistently, have a busy market, launch a product people are excited about, and the orders go up. Some of that is true.


Then I exported my sales data and expected the spreadsheet to confirm the story I already believed. What I found instead reshaped how I think about growing this business, and it is the reason I made this whole series.


This is part three, the how. Below is the exact walk-through, step by step, using nothing more complicated than a spreadsheet.


The pattern I did not expect to find

I went in expecting spikes. Big market weekends, a product launch bump, a run of English muffins driving revenue up. I did see some of that.


What I did not expect was how structured my repeat customers were. A typical repeat order was one sandwich loaf, one artisan batard, a breakfast item like scones or English muffins, and every other week something practical like pizza crust or granola. Not a cart full of cookies, and not the exciting products that get talked about on social media. Rhythm.


Then I looked at frequency, and a second pattern showed up. If someone ordered once, they might come back. Twice was encouraging. At order number four, something changed entirely. They stopped behaving like a person exploring a bakery and started behaving like a bread household.


That is the moment bread stops being a treat and becomes part of how a family eats. Growth in my bakery is mostly the work of moving someone from order one to order two to order four.


Step 1: export your sales data

Go into whatever system takes your orders, Square, Hotplate, the Simply Bread app or something else, and download your sales report as a CSV.


Make sure the export includes:

  • Customer name or email address, some way to identify a person

  • Order date

  • Order total

  • Products purchased

Set the date range to the last three to six months. You do not need the entire lifetime of your bakery. That window is long enough to show real patterns without burying you.


Open it in Google Sheets or Excel. I am a Google Sheets girlie, but use whichever one you already know. This step alone puts you ahead of most small business owners, because almost nobody actually does it.


Step 2: count your unique customers

Sort by email address or customer name and figure out how many individual people ordered in that window. Not how many orders. How many humans. If your list is long, a pivot table will do it in about a minute.


Then sort those people into three groups:

  • Customers with one order

  • Customers with two orders

  • Customers with four or more orders

Stop here for a second, because this is the important part. If your bakery is going to be stable, repeat behavior matters far more than one-time curiosity. A lot of bakers feel like they have plenty of customers, then look closely and find that most of them ordered exactly once. That is not bad news. It tells you where the opportunity is.


Step 3: calculate your repeat customer percentage

Take your customers with two or more orders and divide by your total unique customers.


If that percentage is low, your growth problem is retention rather than reach. New people are finding you, and something is stopping them from coming back for a second order. When it climbs over time, customers are building habits around your bread. That is the number I watch most closely of all of them.


Step 4: study the repeat orders

Filter the sheet down to only the customers who ordered at least twice, then group by person so you can see each one's history. Look at what they bought the first time and what they bought the second time, and ask whether certain products show up over and over.


When I did this, the finding got me genuinely excited. Customers who included a staple bread item in their first order, a sandwich loaf or an original sourdough batard, were significantly more likely to place a second order than customers whose first order was a dozen cookies or a box of muffins.


It makes sense once you see it. A plain loaf becomes toast in the morning, sandwiches at lunch, grilled cheese at dinner. It fits into a household routine. Novelty items are delicious and they do not create a routine.


So the first order is not only about the experience. It is about which product introduces someone to your bakery. I want a staple loaf in every new customer's hands by order two at the latest, even if I have to hand it over myself. For ideas on how to do that gracefully, Boost Sales and Delight Customers with These Sourdough Incentives covers a few.


Step 5: look at cart structure

Now look at what repeat buyers bundle together. What combinations keep appearing?


In my data it is consistently a sandwich loaf or an artisan loaf or both, a breakfast item, and an add-on like pizza crust or granola. Those are not elaborate bakery boxes or gifts. That is a weekly food rhythm. Those people are not buying bread at the grocery store anymore.


This changes the question you ask about your menu. Instead of what new product should I introduce, you start asking what products help households build habits, and what items support everyday meals. Habits create retention, and retention is what makes a business stable. How I'm Planning My Weekly Menu in My Sourdough Microbakery in 2026 shows how I build a menu around that idea.


Step 6: compare one-time and repeat customer value

Calculate your average order value twice, once for one-time customers and once for repeat customers.


First orders are sometimes larger, because people are sampling. Cookies and muffins and scones and a loaf, all at once, in a combination they would never buy weekly. Over time, repeat customers generate far more revenue anyway. A customer who spends $40 once is worth $40. A customer who spends $65 every two weeks for six months is worth close to $800.


Once that lands, your priorities move. This is exactly why I am happy to hand a free loaf to a new customer whose cart is nothing but cookies. Ten dollars to try to convert someone with a potential lifetime value of $800 is a marketing cost I will take every time.


Step 7: name your anchor products

Look at which items appear most consistently in repeat orders. Those are your anchor products.


For most microbakeries that list looks something like sandwich bread, a classic sourdough batard or boule, English muffins, bagels, pizza crust, granola. They are the habit formers, and they sustain the business without much fanfare.


Once you know your anchors, a lot of pressure lifts. Keep them consistently available, highlight them in your marketing, and protect them as the products your customers know they can count on.


Your monthly check-in

This is not a one-time exercise. Put it on the calendar once a month, which is often enough, and update five numbers:

  • Total unique customers

  • Repeat customers

  • Repeat customer percentage

  • Customers with four or more orders

  • Average order value

You do not need twenty dashboards. Five meaningful indicators keep you out of the weeds and tell you whether the pulse of the business is steady, climbing or slipping. If you want to see what a real month of this looks like written out, September Microbakery Recap: Behind the Numbers and the Lessons Learned walks through mine.


Four mistakes I have made myself

Looking at only one week. One slow week makes you feel like something is broken and one busy week makes you feel like everything is working. A single week is not a pattern. Zoom out to three to six months for context.


Assuming the loudest product is the most important. Some items photograph beautifully, get talked about constantly and sell out fast. That does not always mean they are stabilizing the business. I could bring in bagels and everyone would love them, and I do not have the bandwidth to keep them around, so they would never be my anchor. It is usually the steady, practical items doing the real work.


Chasing novelty instead of rhythm. Creativity is part of why we fell in love with baking and there is real room for seasonal flavors. If the entire menu changes every week, customers cannot build a habit around you. Bring the novelty and keep the staples reliable.


Expecting the data to hand you an answer. Your spreadsheet will not tell you what to do next. It reveals patterns and helps you ask better questions, and then it is on you to decide what to do about them.


Final thoughts

This probably took you a good while to work through, and I am proud of you for sitting down with it. These are not conversations that come naturally to most of us.


Growth is not mostly about reaching more people. It is about helping the right people build a rhythm with you, until you are part of the week rather than a treat. That is where stability lives, and that is how we build bakeries that support our households and serve our communities without burning us out!


Cheering you on,


Caroline


Keep going

Here is the rest of this series, plus the money episode that pairs with it.


Links to things you might like!


 
 
 

1 Comment

Suzanne Scapelito
Suzanne Scapelito
Jul 13

Hi Caroline! Can i please get a copy of the KIP Dashboard template you have? thanks! Suzanne (TheModernFermentalist@gmail.com)

Like
bottom of page