30 Questions to Ask Your Shopify Store Data

Most store owners are not missing data. They are missing the right questions to ask it. This is a library of 30 concrete questions, grouped by profit, ads, retention, inventory, and customers, that pull decisions out of your Shopify data instead of surface-level charts.

Each question comes with one line on why it matters, so you know what a good answer would change. Ask them of an AI connected to your store, of an analyst, or of yourself in a spreadsheet. For how to actually connect a store and phrase these as prompts that hold up, see the ChatGPT Shopify guide. For where these fit in the bigger picture, see how D2C brands use AI for analytics.

How to Use This List

Copy the questions that match a decision you are about to make, not all 30 at once. A question is only worth asking if the answer would change something you do this week.

Two rules make every answer better. First, give the tool your business context it cannot infer, like your true margin or what you count as a new customer. Second, ask it to show which fields and rows produced the number, so you can catch a wrong join before you act. With that, here are the questions by area.

Profit Questions

Revenue questions are easy and mostly useless on their own. These push past revenue to what you keep.

1. Which 10 products made the most gross profit last quarter, not the most revenue? Your top sellers by revenue are often not your top earners after cost of goods. See gross margin for the definition.
2. Which products sell well but lose money after ad spend and returns? These are the silent drains. High volume hides a negative contribution margin.
3. What is my true net profit per order, after COGS, shipping, payment fees, and ad spend? The number most stores never compute, and the one that decides if growth is worth it. Work it through with the net profit per order guide.
4. How much revenue came through discount codes, and what was the average margin on those orders? Reveals whether promotions are buying growth or buying orders you would have gotten anyway.
5. Which discount codes produced orders below break-even at my margin? A single over-generous code can quietly run at a loss for months. Check break-even with the margin calculator.
6. What is my blended gross margin this month versus last, and what moved it? A margin drift of a few points across the catalog is easy to miss and expensive to ignore.

Advertising Questions

Platform-reported numbers flatter every channel. These ask your Shopify data to check the ad platforms' homework.

1. What is my blended CAC across Google and Meta, using distinct new Shopify customers, not platform-claimed conversions? Platforms double-count buyers they both touched. See blended CAC.
2. Which channel brings customers who buy again, versus one-and-done buyers? A cheap first order from a channel that never repeats is more expensive than it looks.
3. What is my real ROAS after returns and discounts, not gross revenue ROAS? Returns can turn a winning campaign into a break-even one.
4. Which campaigns drove first-time customers versus repeat buyers I would have kept anyway? Paying to reacquire loyal customers is a common, invisible waste.
5. Does my Shopify new-customer count match what Google and Meta claim they delivered? When platform math exceeds reality, you are over-crediting ads. The revenue mismatch guide covers why.
6. What is my payback window on a new customer at current CAC and margin? Tells you how long your cash is tied up before a new customer is profitable.

Retention Questions

Acquisition gets the attention. Retention math is usually where the real profit hides.

1. What is my repeat purchase rate, and how has it moved over the last six months? A falling repeat rate means you are refilling a leaking bucket. See repeat purchase rate and what a good one looks like.
2. How many days pass between a customer's first and second order, on average? Sets the timing for your win-back and replenishment outreach.
3. What share of this month's revenue came from returning customers versus new ones? A healthy split signals a real base, not just paid growth. See the new versus returning revenue split.
4. Which customers spent a lot historically but have not ordered in 90 days? Your highest-value win-back list, sitting in the data unused.
5. What is the lifetime value of customers acquired through each channel? Some channels bring browsers, some bring buyers. See lifetime value.
6. Which first product a customer buys predicts the highest repeat rate? Points to the products worth pushing as an entry point, not just the ones with the best first-order margin.

Inventory Questions

Cash is stuck in stock. These questions find the stuck cash and the coming stockouts.

1. Which 15 products have the lowest sell-through over the last 60 days? Your slow movers and reorder-risk list. See sell-through rate.
2. Which fast sellers are likely to stock out in the next 30 days at current velocity? A stockout on a winner is lost revenue you never see in a report.
3. How much cash is tied up in products that have not sold a unit in 90 days? Dead stock is a balance-sheet problem hiding as a shelf. Work through clearing it in the dead stock guide.
4. What is my inventory turnover by category, and which category is slowest? Shows where restock discipline is loosest. See inventory turnover.
5. Which products have the highest return rate by units, excluding low-volume noise? A high return rate quietly erases the margin on an otherwise strong product. See return rate.
6. Which variants of a product sell, and which just take up stock? Trimming dead variants frees cash without losing real sales.

Customer Questions

Averages hide your best and worst customers. These questions split the base.

1. Who are the top 20 percent of customers by lifetime spend, and what do they have in common? Your revenue concentration, and the profile to acquire more of. Walk through it in identify your top 20 percent.
2. What is my average order value by customer segment, and where is it rising or falling? A falling AOV in your best segment is an early warning worth catching.
3. Which customers only ever buy on discount? A segment that never pays full price is not the growth you think it is. See discount-dependent customers.
4. Where do my highest-value customers come from, by channel and first product? Tells you what to spend more on to get more of them.
5. What percentage of customers make a third purchase, the real loyalty threshold? The second order can be luck. The third is a habit forming.
6. Which customers are trending toward churn, based on a lengthening gap since last order? Catching a slipping customer before they leave is cheaper than winning them back.

Turn the List Into a Habit

A one-time answer is worth less than a standing one. The questions worth asking every week belong in a report that arrives on its own, not in a spreadsheet you rebuild each Monday.

Group them by cadence. Profit and ad efficiency questions are weekly. Retention and customer questions are monthly, because the numbers move slowly and weekly noise misleads. Inventory sits in between, tied to your reorder cycle. For the exact set of numbers a weekly report should carry, see the AI weekly report spec.

Frequently Asked Questions

What are the most important questions to ask about my Shopify data?

Start with profit and retention, because they are most often missed. The two highest-value questions are usually true net profit per order after all costs, and repeat purchase rate over time. Revenue and traffic are easy to see and rarely the real problem. Profit tells you if growth is worth it, and repeat rate tells you if you are building a base or refilling a leaking bucket.

How do I ask my Shopify data these questions without a data analyst?

Connect your store to an AI assistant that reads live data, then ask in plain English. The barrier used to be the joining and filtering across sources, not the math, and stating the conditions in words removes it. Give the tool your business context it cannot infer, like true margin, and ask it to show which rows produced each number so you can verify the answer before acting on it.

How often should I ask these questions of my store?

Group them by how fast the numbers move. Profit and ad-efficiency questions are worth a weekly look, because a bad discount code or a margin slip costs money fast. Retention and customer questions are better monthly, since weekly swings are mostly noise on small volume. Inventory questions track your reorder cycle. Asking a slow-moving metric too often just adds noise, not insight.

Why do my Shopify numbers not match what Google and Meta report?

Because the ad platforms each claim credit for buyers they merely touched, so their combined conversions exceed your actual new-customer count. Shopify counts a real order once. A platform counts an assisted click as a conversion, and two platforms often count the same buyer. Always base blended CAC and true ROAS on distinct new Shopify customers, not the sum of platform-reported conversions, or you will over-credit your ads.

Can I trust the answers an AI gives to these questions?

For direction yes, for the final number verify it. A model reading your store can rank slow movers or flag money-losing codes well, but it will produce a confident figure even when the data cannot support one, and it can join sources wrong. Ask it to show its fields and rows, and confirm any number you plan to spend or reorder against directly in Shopify before you act.

Conclusion

The gap between stores that grow and stores that stall is rarely the data. It is whether anyone asks it the right questions. Copy the six that map to a decision you face this week, get grounded answers, and act.

For how to connect a store and phrase these as reliable prompts, see the ChatGPT Shopify guide. To make the recurring ones automatic, see the weekly report spec.