Query Builder

Summarize and Analyze any data in your Store

Your store is unique and your needs are different. With Query Builder, you can export data in the form as your wish. Query Builder provides line-level detail and a summary of the data. The summary of the data can be done through the Pivot table in Excel which you can add to the default Excel template.

What can you do with Query Builder:

Sales and Orders queries

• Orders with information of Country, Product Type, Product, UTM source, Referring site, Vendor, Order Source, Gift card, Discount Code for a given date range.

Tax queries

• Based on customer location. Sales tax collected with information of Country, State, County, Product, Tax Rate, Tax refunds.

Customer queries

• First-time customer vs. returning customers, High-value customers. Customer using Discount codes.

Fulfillment queries

• Partial or Full Fulfillment, Pending Fulfillment

Discount queries

• Discount code with information of start date, end date

Product queries

• Product sold by SKU, Units, Dollars, Inventory value, and count. Inventory threshold.