Most small business owners make dozens of decisions every week: what to reorder, which products to promote, when to schedule staff, where to spend marketing dollars. Many of those decisions are based on instinct and experience, which are valuable. But instinct combined with good data leads to better decisions, especially as a business grows beyond what one person can see from the sales floor.
One advantage of running your online store and physical locations on Shopify is that your data lives in one place. You can see how the whole business performs, not just fragments. This article explains which metrics matter, where to find them in Shopify, and how to turn data into action.
Why data matters more as you grow
When you run a single small shop, you can often sense what's selling. As you add locations, staff, channels, and products, that intuition becomes less reliable. Data helps you:
- Spot trends early, such as a product category gaining momentum.
- Identify problems, like a location with declining conversion or rising returns.
- Allocate resources to the channels, products, and locations with the best returns.
- Communicate with your team using shared facts.
- Support financing applications with clear performance history.
With rising costs across Ontario, from wages to rent, data-driven decisions help protect margins.
Shopify's analytics tools
Shopify's analytics have evolved considerably. Depending on your plan, tools include:
- The analytics dashboard: An overview of sales, orders, sessions, conversion rate, and more.
- Reports: Pre-built reports on sales, customers, inventory, marketing, and finance, with the ability to customize and save them.
- Live View: A real-time view of store activity, which is especially useful during big sales events.
- POS reports: Retail-specific reports by location and staff member, with more detail available on POS Pro.
- ShopifyQL and custom exploration: A query-based way to build custom reports on certain plans.
- Sidekick: Shopify's AI assistant can answer questions about your data in plain language, such as "Which products sold best at my Burlington location last month?" and help you carry out tasks based on the answers.
Report availability varies by plan. Check what your plan includes, and consider whether advanced reporting justifies an upgrade.
The metrics that matter
Not every metric deserves attention. Focus on a core set that reflects your business health.
Sales metrics
- Total sales: Revenue after discounts and returns (understand how Shopify calculates gross, net, and total sales).
- Sales by channel: Online store, POS, and other channels.
- Sales by location: Performance of each store.
- Average order value (AOV): Total sales divided by number of orders.
- Units per transaction (UPT): Average number of items per order, a key retail metric for measuring upselling.
Customer metrics
- New versus returning customers: The balance between acquisition and retention.
- Repeat purchase rate: Share of customers who buy more than once.
- Customer lifetime value (CLV): Revenue from a customer over time.
- Customer acquisition cost (CAC): Marketing spend divided by new customers (calculated with data from your ad platforms).
- Cohort retention: How customers acquired in a given period behave over time.
Online store metrics
- Sessions: Visits to your store.
- Conversion rate: Percentage of sessions that result in an order.
- Add-to-cart rate and checkout completion rate: Where customers drop off.
- Traffic sources: Where visitors come from (search, social, email, direct, referrals).
- Top landing pages: Which pages attract visitors.
Retail metrics
- Sales per staff member: Useful for coaching (use carefully and fairly).
- Sales per square foot: Useful for comparing locations and evaluating space (requires your own floor space data).
- Transactions by hour and day: Guides staffing.
- Payment method mix: Debit, credit, cash, and gift cards.
- Returns by location and reason.
Inventory metrics
- Sell-through rate: Units sold divided by units received.
- Inventory turnover: How often inventory sells through in a period.
- Days of inventory on hand: How long current stock will last at the current sales rate.
- Stockouts: Products that sold out and for how long.
- Aging inventory: Products that haven't sold in 60, 90, or 180 days.
Profitability metrics
- Gross margin: Revenue minus cost of goods sold, as a percentage. Requires accurate product costs in Shopify.
- Discount rate: Total discounts as a percentage of gross sales.
- Shipping profitability: Shipping revenue versus shipping costs.
Getting your data right
Analytics are only as good as your data. Common issues:
- Missing product costs: Without cost data, margin reports are meaningless. Add costs to every variant and update them when supplier prices change, which has happened frequently amid recent tariff changes.
- Inconsistent product types and vendors: Standardize these fields so reports group products correctly.
- Anonymous POS sales: Linking sales to customer profiles improves customer analytics.
- Untracked marketing: Use UTM parameters on links in emails, social posts, and ads.
- Test orders: Delete or exclude test orders from reports.
- Duplicate customer profiles: Merge duplicates periodically.
Connecting online and offline
One of the most valuable insights for unified commerce businesses is how channels influence each other. Questions to explore:
- Do customers who shop both online and in store spend more? Compare CLV for single-channel and multi-channel customers.
- Does local pickup lead to additional in-store purchases? Look at customers' same-day POS transactions after pickup.
- Do email campaigns drive store visits? Use in-store discount codes or track POS sales from customers who received a campaign.
- Does opening a store increase online sales nearby? Compare online sales by postal code before and after opening.
These analyses often reveal that online and in-store channels support each other rather than compete.
Turning data into action
Data is only useful if it changes decisions. Here's a practical rhythm.
Daily (5 minutes)
- Check yesterday's sales by channel and location.
- Review any unusual activity (large orders, returns, low stock alerts).
Weekly (30 minutes)
- Compare sales to the same week last year and to your targets.
- Review top and bottom products.
- Check conversion rate and traffic sources.
- Review staffing against transaction patterns.
Monthly (1–2 hours)
- Review margins, discount rates, and shipping profitability.
- Analyze customer metrics: new versus returning, repeat rate.
- Review inventory aging and plan markdowns or promotions.
- Evaluate marketing performance by channel.
- Share key results with your team.
Quarterly (half day)
- Compare performance by location.
- Review cohort retention.
- Reassess your Shopify plan, apps, and costs.
- Update forecasts and budgets.
- Set priorities for the next quarter.
Examples of data-driven decisions
Scheduling staff: A fictional café-and-gift shop in Collingwood reviewed POS transactions by hour and discovered that Saturday mornings were far busier than expected, while weekday late afternoons were quiet. Shifting one staff member's hours improved service without increasing total payroll, which mattered more after the October wage increase.
Rebalancing inventory: A two-location clothing retailer found that a particular jacket style sold out quickly in Kingston but barely moved in Belleville. Transferring stock rather than marking it down preserved margin.
Improving conversion: An online-first home décor brand noticed that mobile visitors from Instagram had a much lower conversion rate than desktop visitors. Investigating revealed a slow-loading product page on mobile due to oversized images. Fixing it improved mobile conversion noticeably.
Refining promotions: A bookstore found that storewide discounts increased sales volume but reduced margin more than expected, while "buy two, get a free tote" promotions increased units per transaction with less margin impact.
Using AI tools responsibly
AI assistants like Sidekick can speed up analysis, answer questions quickly, and suggest actions. To use them well:
- Ask specific questions with clear time periods and filters.
- Verify important numbers against standard reports before making major decisions.
- Treat suggestions as starting points, not final decisions.
- Understand definitions: Make sure you and the tool mean the same thing by "sales" or "customers."
Beyond Shopify: connecting other data
For a complete picture, combine Shopify data with:
- Accounting software (for full profitability, including rent, wages, and overhead)
- Advertising platforms (for acquisition costs)
- Google Business Profile (for local search performance)
- Email platforms (for campaign performance)
- Payroll systems (for labour cost analysis)
Businesses with more complex needs sometimes export data to spreadsheets or business intelligence tools. Shopify's APIs allow developers to build custom dashboards if needed.
Privacy and responsible data use
Collecting and analyzing customer data comes with responsibilities under Canada's privacy law (PIPEDA). Good practices include:
- Collect only the data you need.
- Be transparent in your privacy policy.
- Limit staff access to sensitive information using permissions.
- Secure your accounts with strong passwords and two-factor authentication.
- Respect customer requests about their data.
An analytics checklist
- [ ] Product costs are entered for all variants.
- [ ] Product types and vendors are standardized.
- [ ] Staff link POS sales to customer profiles when appropriate.
- [ ] Marketing links use UTM parameters.
- [ ] I have a defined set of core metrics.
- [ ] I review data daily, weekly, monthly, and quarterly.
- [ ] Key insights are shared with my team.
- [ ] I verify AI-generated insights before acting on major decisions.
- [ ] Staff access to data follows the principle of least privilege.
Key takeaways
- Running online and in-store sales on Shopify gives you a unified view of business performance.
- Focus on a core set of sales, customer, retail, inventory, and profitability metrics.
- Clean data, especially accurate product costs, is essential for meaningful reports.
- Establish a regular review rhythm and connect insights to decisions.
- Use AI tools like Sidekick to speed up analysis, while verifying important results.
Report availability and AI features vary by plan and change over time. Check Shopify's help centre for current capabilities.