Discover when your customers shop and discounts perform best.
Why Timing Matters #
Understanding when customers use discounts helps you:
- Schedule flash sales at optimal times
- Staff appropriately for peak hours
- Plan marketing campaigns
- Optimize server resources
Daily Performance Table #
Shows performance broken down by day of the week:
| Day | What You’ll See |
|---|
| Monday | Start of week shopping patterns |
| Tuesday | Mid-week behavior |
| Wednesday | Mid-week peak? |
| Thursday | Pre-weekend preparation |
| Friday | Weekend kickoff |
| Saturday | Weekend shopping |
| Sunday | End of week patterns |
Reading the Daily Table #
| Pattern | Insight |
|---|
| Friday highest orders | Weekend sales work well |
| Monday low efficiency | People browse, less buying |
| Sunday high AOV | Customers have time to shop carefully |
Hourly Performance Table #
Shows performance by 4-hour time slots:
| Time Slot | Typical Activity |
|---|
| 00:00-03:59 | Late night / insomnia shopping |
| 04:00-07:59 | Early morning |
| 08:00-11:59 | Morning work hours |
| 12:00-15:59 | Lunch break shopping |
| 16:00-19:59 | After work peak |
| 20:00-23:59 | Evening relaxation |
Reading the Hourly Table #
| Pattern | Insight |
|---|
| 16:00-19:59 peak | After-work shoppers |
| 12:00-15:59 high | Lunch break buyers |
| 00:00-03:59 surprising activity | Night owl audience |
Columns in Both Tables #
| Column | Meaning |
|---|
| Orders | Number of discounted orders |
| Revenue | Total sales |
| Discount | Total discounts given |
| Efficiency | Revenue per discount |
| Discount % | Discount as % of revenue |
| Avg. Order | Average order value |
Sorting Options #
Both tables support sorting:
| Sort By | Find |
|---|
| Orders | Busiest times |
| Revenue | Highest earning times |
| Efficiency | Best performing times |
| Avg. Order | When big spenders shop |
Business Decisions #
Flash Sale Timing #
| Your Data Shows | Schedule Flash Sales |
|---|
| Peak at 16:00-19:59 | Start sales at 16:00 |
| Thursday highest | Run Thursday sales |
| Weekend low | Avoid weekend-only offers |
Campaign Scheduling #
| Pattern | Action |
|---|
| High orders, low efficiency on Monday | Reduce Monday discounts |
| High efficiency on Friday evenings | Focus campaigns there |
| Sunday has highest AOV | Premium campaigns on Sunday |
Resource Planning #
| Your Peak | Plan For |
|---|
| Lunch hours | Server capacity at noon |
| Evenings | Customer support after 6pm |
| Weekends | Stock inventory |
Combining Insights #
Example Analysis #
| Day | Best Time Slot | Strategy |
|---|
| Friday | 16:00-19:59 | Main promotion window |
| Saturday | 12:00-15:59 | Secondary push |
| Monday | Skip | Low efficiency, avoid |
Tips #
- Check seasonally — Summer vs winter patterns differ
- Consider holidays — Check dates around holidays
- Test and adjust — Move flash sales based on data
- Match campaigns — Different products, different timing
- Use drill-down — Analyze timing for specific campaigns
Quick Reference #
Best Practices #
| Goal | Look At |
|---|
| Maximize orders | Highest order count times |
| Maximize profit | Highest efficiency times |
| Reach new customers | Times with high unique customers |
| Increase cart size | Times with highest AOV |
