Overview
A Square sales mix report helps you see what actually changed in your store, restaurant, or service business instead of staring at a sales total and guessing. This playbook compares Square revenue, orders, refunds, average order value, and item or category mix across two periods, then turns the movement into a practical report.
It is built for marketers, owners, and operators who need to know whether growth came from more customers, bigger baskets, stronger repeat purchasing, fewer refunds, or a shift in what people bought.
Why you should understand revenue movement
Square gives businesses access to payments, orders, customers, and catalog data, but the useful story is often spread across those views. Square's own documentation describes how orders connect line items, fulfillments, tenders, and returns, which is exactly why a clean sales mix readout can reveal more than a basic revenue snapshot.
The risk is not just missing a bad week. It is misreading a good one. A revenue lift driven by one high-ticket item, a refund drop, or a temporary location spike calls for a different action than broad customer demand.
This playbook gives Juno the structure to compare periods, find meaningful item and category changes, and recommend what to promote, investigate, or fix next.
Step-by-step
- 1Confirm the Square location scope, reporting period, comparison period, and whether the user wants a weekly, monthly, or campaign-specific readout.
- 2Pull together Square sales, orders, refunds, customer counts, and catalog details for the selected windows so the report compares like with like.
- 3Calculate movement in revenue, order volume, average order value, refunds, repeat customer contribution, and location-level performance where available.
- 4Rank items and categories by sales contribution, growth, decline, refund risk, and share of total orders to find the mix changes behind the headline numbers.
- 5Write a concise report that explains the main changes, separates noisy small shifts from material movement, and recommends operator actions.
- 6Update an existing tracker when one exists, or create a reusable table and companion summary for the next reporting cycle.
Frequently asked questions
How often should I run a Square sales mix report?
Weekly works well for active operators who make merchandising or staffing decisions often. Monthly is better for slower-moving strategy, category planning, and owner updates.
What period should I compare against?
Use the most recent complete period against the prior equivalent period by default. For seasonal businesses, a year-over-year comparison may be more useful if the data is available.
Can this report cover multiple locations?
Yes. Juno should include all active Square locations when the user asks for a business-wide readout, then break out location differences only when they are meaningful.
What do I get at the end?
You get a report and table showing the metrics that moved, the items or categories behind the movement, and the recommended next actions.
