How a Square Seller Discovered Hidden Insights Using Transaction Source Analysis

Square Analytics

The Challenge

We recently helped a customer who was struggling with Square source analysis. She ran a thriving boutique coffee shop with three locations across Seattle, and on paper, everything looked great. Revenue was climbing month over month, customer count was up, and her team was hustling. But here's the thing—she had this nagging feeling that she was leaving money on the table.

"I know we're busy," she told me during our first call. "But I don't actually know where all these transactions are coming from. Are people using our app? Are they paying at the counter? Is one location doing better with online orders than the others?"

She'd been running her business on Square for three years, and while she loved the platform, she admitted she'd never really dug into the source data. She was flying blind, making decisions based on gut feeling rather than hard numbers. Sound familiar?

What the Data Revealed

We started by pulling her Square transaction data and running it through our transaction source analysis tool. Within minutes, we had a complete breakdown of every transaction by source, device type, payment method, and location.

The first thing that jumped out was the sheer variety. Her transactions were coming from everywhere: in-person card readers, Square Online, the Square app for delivery, Square Invoices for catering orders, and even some manual entries from her staff. Each source had its own performance profile, and they were wildly different.

Here's what we discovered:

But here's where it got really interesting. When we broke it down by device type, we found that transactions initiated from iPads (her counter registers) had a 23% higher average value than those from iPhones (her mobile checkout devices used for pop-up events and outdoor seating).

The Surprising Insight

I've analyzed hundreds of Square accounts at this point, and I always tell people: the gold is in the details. For this coffee shop owner, the breakthrough came when we started looking at automation opportunities.

She'd been manually checking her Square Dashboard every morning, trying to spot trends and anomalies. It was taking her 30-45 minutes a day, and she still felt like she was missing things. "I don't know what I don't know," she said.

We discovered something that completely changed her approach: her catering orders—those high-value invoice payments—were coming in at completely unpredictable times, often while she was asleep or working the floor. She'd miss follow-up opportunities because she wouldn't see a payment come through until hours later.

Meanwhile, her mobile app orders (with that troublesome 8.2% refund rate) were almost all from a specific type of customer: people ordering ahead during the morning rush and then not picking up their order because the line looked too long when they arrived. She was losing revenue and wasting product, but she didn't have visibility into the pattern because it was buried in aggregate numbers.

The real kicker? Her highest-value customers weren't who she thought they were. She'd been focusing marketing efforts on driving more in-person foot traffic, but the data showed that her online ordering customers and catering clients had dramatically higher lifetime values. They just represented a smaller percentage of total transactions, so they'd been invisible in her decision-making.

Taking Action

Armed with these insights, we helped her set up some automation that transformed how she ran her business. Here's what we implemented:

Automated source monitoring: Instead of manually checking her dashboard, we built alerts that notified her immediately when catering invoice payments came through, when refund rates spiked on any channel, or when online orders exceeded specific thresholds. This freed up her morning routine and ensured she never missed a high-value customer interaction.

Channel-specific strategies: She started treating each transaction source as its own mini-business. For mobile app orders, she added a "running late?" notification system and extended pickup windows during peak hours. Refunds dropped from 8.2% to 2.1% in six weeks.

Device optimization: Knowing that iPad transactions had higher values, she moved more customers to the counter-ordering experience and repositioned her mobile checkout devices specifically for upsells and add-ons rather than primary transactions. Average order value increased by 11%.

Marketing reallocation: She shifted 40% of her marketing budget from foot-traffic campaigns to online ordering promotions and catering outreach. Within two months, her online order volume increased 34% without cannibalizing in-person sales.

The automation piece was crucial. As I've written about in our order value distribution analysis, the businesses that win aren't necessarily those with the most transactions—they're the ones who understand their transaction patterns and can respond in real-time.

Results and Lessons Learned

Three months after implementing these changes, the results were remarkable. Overall revenue was up 18%, but more importantly, profit margins improved by 9 percentage points. She was working smarter, not harder.

But here's what she told me that really stuck: "I always thought I needed more customers. Turns out I needed better insights about the customers I already had."

The lesson I've learned from working with hundreds of Square merchants is this: your transaction sources aren't just accounting categories—they're windows into completely different customer behaviors, preferences, and values. Every source tells a story about how your customers want to interact with your business.

When you analyze by source, you often discover that you're actually running multiple businesses under one roof. And each of those businesses needs its own strategy, its own optimization, and its own attention.

The coffee shop owner now runs source analysis weekly. It's become her strategic compass. She knows exactly which channels are trending up, which ones need attention, and where to invest her limited time and resources. More importantly, she's set up automations that alert her to anomalies before they become problems.

I've seen this pattern repeat itself over and over: merchants who dig into their source data unlock growth they didn't even know was possible. It's not about working harder or opening more locations—it's about understanding where your best customers are coming from and doing more of what already works.

Your Turn

If you're running a business on Square and you've never analyzed your transaction sources, you're almost certainly leaving money on the table. I guarantee you have patterns in your data that would surprise you—opportunities hiding in plain sight.

The good news? You don't need to be a data analyst to uncover them. We built our Square Transaction Source Analysis tool specifically for busy merchants who want insights without the complexity. Connect your Square account, and within minutes you'll see exactly what we saw for the coffee shop: which sources drive revenue, which devices perform best, where your refunds are coming from, and where your biggest opportunities lie.

Want to see how automation can transform your Square analytics? Check out our analytics services or try a live demo to see your own data in action.

Because here's the truth: every transaction tells a story. The question is, are you listening?

Ready to discover what your transaction sources are telling you? Run your own source analysis now →