Running Reports with Zoey AI

Ask Zoey AI about your store's numbers in plain words, then open the report to filter, compare, save and export.

Zoey's Reports are built around Zoey AI. Ask a question about your store's numbers in plain words and get the answer in seconds, then open the report behind it when you need exact figures, filters or an export.

What's New in Reports

  • Zoey AI on every report. Click Ask next to any report, or Ask Zoey AI at the top of any page, to ask about your data in plain language.
  • Find reports by question. Search the Reports page by what you need to know, such as "past due" or "not selling", instead of by report name.
  • Your store at a glance. Sales, orders and money owed for today, this month, quarter or year, compared with the period before.
  • Simpler filters. Every report groups its filters into Date range, Orders, Customers and Display, with date presets like Month to date.
  • Compare and save. Compare any period with the one before or the same period last year, and save the filters you use as a view.

Ask Zoey AI

There are three ways to open Zoey AI:

  • Click Ask next to a report on the Reports page.
  • Click Ask Zoey AI at the top of the page.
  • Press Ctrl+J (Cmd+J on Mac) on any admin page.

The panel opens beside the page you're on, so you can keep working. Zoey AI knows which page you have open, so you can ask about the report in front of you.

What You Can Ask

Zoey AI reads your live store data and answers in plain language. Answers can include tables, links to the records and help articles it used, and suggested follow-up questions.

Ask aboutFor example
Sales"How much did we sell last month, by Customer Group?"
Coupons and promotions"Which coupons drove the most revenue in the last 90 days?"
Accounts and balances"What does Northwind owe, and how late is it?"
Customers"Who are our top 10 customers this quarter?"
Products and stock"What's low on stock?"
How to do something in Zoey"How do I set up a tier price?"

Sales questions can be broken down by customer group, sales rep, payment method, coupon, shipping method or region.

Each report article has an example question for that report. Try it, then change it to fit what you need.

Get Better Answers

  • Name the period. "Last month", "this quarter" or "since January 1" gets a precise answer.
  • Say how to break it down. Add "by customer group", "by sales rep" or "by month".
  • Narrow it with a follow-up. Ask "Now only the Wholesale group" or "Show that by month" without starting over.
  • Click through. Open the records Zoey AI links to and check the details.
📘

Good to know

  • Zoey AI is read-only. It looks up and explains your data but can't create, change or delete anything.
  • It only sees the data you have permission to see. To turn it off for a role, remove Reports > Zoey AI from that role's permissions.
  • Your conversations are kept for 90 days. Click New chat to start over.
  • Each store has a monthly allowance. Zoey AI tells you when it's reached, and it resets the next month.
  • Your question and the data looked up to answer it are processed by Anthropic's Claude.

Zoey AI or the Report?

Use Zoey AI toUse the report to
Get a quick answer in plain wordsGet exact figures to file, reconcile or share
Explore a question and follow upFilter by date, status, sales rep, group or Account
Find out which customers, products or accounts stand outCompare periods side by side
Learn how to do something in ZoeySave a view and export the results

Run a Report

  1. Click Reports.
  2. Type in Find a report, or click a category, then click Open next to the report.
  3. Set the filters and click Show Report.

To go back to the list, click Reports in the breadcrumb at the top of the page. If your store has more than one website, choose one in the All Websites menu in the top right, or leave it on All Websites to include every website.

Filters

Each report shows only the filters that apply to it.

GroupFilterWhat it does
Date rangeDate RangeChoose a preset, such as Month to date or Last quarter, or choose Custom and enter your own dates.
Date rangeFrom / ToThe first and last day of the report. Both are required.
Date rangeShow bySplits the results into one row per Day, Month or Year.
Date rangeMatch Period ToCounts each order by its Order Created Date or its Order Updated Date.
OrdersOrder StatusAny counts orders in every status. Choose statuses to count only those orders.
CustomersFilter by Sales RepCounts only orders for the sales reps you choose.
CustomersFilter by Customer GroupCounts only orders from the customer groups you choose.
CustomersFilter by AccountCounts only orders from the Accounts you choose.
DisplayGroup byBreaks each period down further. None shows one row per period.
DisplayCompare toCompares each period with the Previous period or the Same period last year, and adds "vs previous" columns.
DisplayEmpty RowsYes shows a row for periods with no orders.
DisplayShow Actual ValuesYes adds more columns to the results.

Click Select All under a Customers filter to choose every option. Click the arrow next to Show Report to collapse the filters and give the results more room.

Compare Periods

Above the results, Compare to switches between Previous period, Same period last year and None without opening the filters again.

Save a View

Set the filters you use often, click Save view and name it. Next time, choose it in Saved views to load those filters.

Export the Results

In Results, choose a format such as CSV and click Export. The file downloads to your computer.

🚧

Reports show totals, not records

Reports summarize your store's data. To export the orders, invoices or products themselves, use Exporting Data from the Grids or a Data Mapper.

Incomplete Results

If a report is missing recent orders, click Refresh Statistics on the Reports page. See Refresh Report Statistics.


Did this page help you?