Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Stock and products · Opening soon

Sales by day of week and hour

See sales by weekday and hour from your Square export. Find when sales peak across the week and during the day.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“from the square orders export, total net sales by weekday and hour from created at, drop refunded or voided orders, and show friday 6–7 pm spikes plus saturday/sunday 8 am–12 pm mornings”

The agent read it as

From the Square Payments, total net sales by weekday and hour from created at, drop refunded or voided orders, and show friday 6–7 pm spikes plus saturday/sunday 8 am–12 pm mornings.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Square Payments
    CSV export · 45 rows
  2. Step
    Total sales by weekday and hour
    Step 1
  3. Result
    Weekday Hour Sales
    21 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 21 rows came out.

What you get back

The result of that run, the rows to look at first.

Weekday Hour SalesSample data21 rows
WeekdayHourNet salesPeriod
Sunday10146.70Weekend morning
Sunday11749.95Weekend morning
Saturday11570.15Weekend morning
Sunday12733.00Other hours
Monday9110.70Other hours
Monday10213.50Other hours
Monday19238.65Other hours
Wednesday842.50Other hours
Wednesday1286.20Other hours
Wednesday1797.40Other hours
Wednesday18569.85Other hours
Thursday1292.40Other hours
21 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you show sales by day of week and hour of day?

Upload your Square payments or orders export, then group net sales by the created at date and time. The workflow drops refunded or voided orders, then totals sales by weekday and hour so you can see busy periods.

How it works

How to use the Weekday Hour Sales workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Weekday Hour Sales: questions

Which Square export should you use?
Use a Square payments export or Square orders export that includes the created at field and the order status or refund details.
What happens to rows that do not match?
Rows that are refunded, voided, or missing the needed date or time fields are left out of the totals.
How do you change the rule in words?
Edit the step to group by a different date field, change the time bucket, or include different order statuses in the total.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Find the few products that make most of your sales, what sells together, and the stock that sits too long.

All stock and product templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look