Shopify Sidekick can pull a sales summary, an AOV trend, and a best/worst sellers ranking straight from your store’s live data — you just have to ask with the right specificity. It cannot build you a live dashboard or a scheduled report that lands in your inbox on its own. This guide covers what to actually ask for, and where the line sits.
What Sidekick can and can’t do for reporting
Sidekick answers reporting questions by querying your store’s real order and product data (it runs on ShopifyQL under the hood, even though you never see the query). That means:
- It can: summarize revenue, AOV, order counts, and product rankings for any period you specify, compare periods, and flag products with declining sales.
- It can’t: save a report as a live dashboard, refresh automatically, send itself to email/Slack on a schedule, or trigger real-time alerts when a metric crosses a threshold.
Every report below is a fresh conversation with Sidekick, run against current data at the moment you ask. Treat it like a smart analyst you query on demand — not a BI tool running in the background.
Step 1: Get a store performance summary
Start broad before drilling into AOV or product rankings. Ask Sidekick for total sales, AOV, top products and collections, a period-over-period comparison, and which day of the week drives the most orders for [YOUR TIME PERIOD].
This first pass is mostly a sanity check — it tells you if anything looks unusual before you go build a more detailed report on top of it. If total sales looks off vs. what you remember, resolve that before trusting AOV or seller rankings pulled the same way.
Step 2: Pull the AOV trend, not just a single number
A single AOV figure tells you almost nothing on its own — the trend and what’s driving it is where the useful signal lives. Ask for AOV by week or month over [YOUR WINDOW, e.g. last 12 weeks], with:
- % change vs. the prior period and vs. the same period last year
- AOV split by new vs. returning customers
- AOV split by discounted vs. full-price orders
Be explicit about the AOV formula in your prompt — total order revenue divided by number of orders, excluding cancelled and fully refunded orders. Sidekick will follow your definition, but it won’t invent the “correct” one for you, and different definitions produce meaningfully different numbers.
Ask Sidekick to output this as a table (period, order count, revenue, AOV, % change), then call out the single period with the biggest swing and name the likely driver — a discount campaign, a bundle launch, or a high-ticket product spiking.
Step 3: Rank best and worst sellers for the same period
Once you know AOV is moving, find out which products are behind it. Ask Sidekick to rank all products by units and revenue for [YOUR PERIOD], compared to the prior period of equal length, and produce four short lists: top 15 by revenue, bottom 15 by revenue (among products with at least 1 sale in either period), biggest rank gainers, and biggest rank losers.
This is where you catch two things a single AOV number hides: a product quietly declining before it shows up in total revenue, and a low-volume product whose numbers are skewed by one bulk order rather than a real trend. Ask Sidekick to flag anomalies like that explicitly — it can do this reasoning if you ask for it, but won’t volunteer it unprompted.
Step 4: Turn the report into a repeatable prompt
Since Sidekick can’t schedule anything, the practical workaround is a saved prompt template you reuse every week or month. Write your report request once with the period as a placeholder — [LAST 30 DAYS] — save it in a notes app, and swap the date range each time you run it.
If you genuinely need this delivered automatically (Monday morning in Slack, say), you’re outside what Sidekick does. That requires piping the output into an external scheduler like Zapier or Make, or a small script that calls Shopify’s Admin API directly — Sidekick is the ad-hoc query layer, not the delivery mechanism.
Sanity-check the numbers before you act on them
Before making inventory or marketing decisions off a Sidekick report:
- Spot-check total revenue and order count for one period against your Shopify Analytics dashboard.
- Confirm the AOV formula Sidekick used matches what you asked for (re-read its output, not just the table).
- For any “declining” or “anomaly” product flag, click into the actual order list — a shipping delay or a single return can look like a trend in a small sample.
Sidekick is fast at slicing data you already have. It’s not a substitute for knowing your own numbers well enough to catch when something’s off.