How to Track Sales Velocity by Hour or Day in PayHelm

During high-volume sales events like Black Friday, Cyber Monday, or flash sales, understanding your sales velocity—how quickly revenue is coming in—helps you make real-time decisions about inventory, marketing spend, and team resources.

PayHelm makes it easy to monitor sales patterns throughout the day and across multiple days, so you can spot trends, optimize campaigns on the fly, and ensure you're capitalizing on peak selling hours.

This guide will show you how to create reports that track sales velocity with key metrics like Total Sales, Orders, and Average Order Value over time.

---

Why Track Sales Velocity?

Monitoring sales velocity during peak periods helps you:

• Identify Peak Hours – Understand when your customers are most active
• Optimize Ad Spend – Increase budgets during high-converting hours
• Manage Inventory – Anticipate stockouts during surge periods
• Staff Appropriately – Ensure customer service coverage during busy times
• Compare Performance – See how this year's Black Friday compares to last year's
• Spot Problems Early – Notice if sales are slower than expected and react quickly

---

Step 1: Create a Sales Velocity Report

Let's build a report that shows how sales change over time.

How to Create the Report

1. Go to Reports.
Click Reports in the main navigation.

1. Create a New Report.
Click the Create a New Report button.

1. Choose Source Type: Overview.
Select Overview to access comprehensive sales data.

1. Select Report Type: Pivot & Group.
Choose Pivot & Group to organize sales by time periods.

1. Group by Date.
In the Group By section, select Date to track sales over time. You can view sales velocity at different intervals: - Daily – Track total sales per day during multi-day events - Weekly – Compare week-over-week performance - Monthly – Analyze broader trends

1. Add Key Metrics.
In Report Column, select these metrics: - Total Sales – Revenue generated each period - Total Orders – Number of orders placed - Units Sold – Total items sold - New Customers – First-time buyers (helps gauge acquisition velocity)

1. Set Your Date Range.
Use Filters to focus on your event period: - Black Friday weekend (Thu-Sun) - Cyber Monday (single day) - Flash sale hours - Holiday shopping season

1. Run the Report.
Click Run Report to see your sales velocity data.

---

Step 2: Add Custom Columns for Deeper Insights

Create calculated metrics to better understand sales patterns.

Custom Column: Average Order Value (AOV)

Track how much customers spend per order over time.

How to Create:

1. Open Report Configuration at the bottom of your report.
2. Click the Custom Columns tab.
3. Click + Add Column.
4. Name it AOV.
5. Click Edit to open the calculation editor.
6. Leave the Condition field blank (this calculation applies to all rows).
7. In the Calculation field, enter: total_sales / total_orders
8. Click Save.

---

Custom Column: Units Per Order

See how many items customers buy per transaction.

How to Create:

1. In Custom Columns, click + Add Column.
2. Name it Units Per Order.
3. Click Edit to open the calculation editor.
4. Leave the Condition field blank.
5. In the Calculation field, enter: units_sold / total_orders
6. Click Save.

---

Custom Column: New Customer %

Track what percentage of orders come from first-time buyers.

How to Create:

1. In Custom Columns, click + Add Column.
2. Name it New Customer %.
3. Click Edit to open the calculation editor.
4. Leave the Condition field blank.
5. In the Calculation field, enter: (new_customers / total_orders) * 100
6. Click Save.

---

Step 3: Use Filters to Segment Your Data

Filters help you drill down into specific aspects of your sales velocity.

Filter by Sales Channel

Compare performance across different channels:
• Online Store – Your main ecommerce site
• Amazon – Marketplace sales
• Social Commerce – Instagram, Facebook shops
• Retail POS – In-store sales (if applicable)

This shows which channels drive the most velocity during events.

Filter by Campaign or UTM Source

If you're running multiple promotions simultaneously:
• Black Friday Email Campaign
• Paid Search Ads
• Social Media Promotions
• Influencer Partnerships

Track which campaigns generate the fastest sales velocity.

Filter by Product Category

See which product types are selling fastest:
• Electronics
• Apparel
• Home Goods
• Seasonal Items

This helps prioritize inventory and marketing for high-velocity categories.

Filter by Region or Country

For international sellers, track velocity by geography:
• North America
• Europe
• Asia-Pacific

Identify regional differences in shopping behavior and peak times.

---

Step 4: Analyze Sales Patterns

Once your report is running, look for these insights:

Daily Velocity Patterns

Example Black Friday Weekend:

| Date | Total Sales | Orders | AOV | New Customer % | |------------|-------------|--------|--------|----------------| | Thu Nov 28 | $45,000 | 320 | $140.63| 42% | | Fri Nov 29 | $125,000 | 890 | $140.45| 55% | | Sat Nov 30 | $98,000 | 710 | $138.03| 48% | | Sun Dec 1 | $67,000 | 475 | $141.05| 38% |

Insights:
• Friday had the highest velocity (890 orders)
• AOV remained consistent around $140
• New customer acquisition peaked on Friday (55%)
• Saturday maintained strong momentum

Velocity Trends to Watch

Increasing Velocity: Sales and orders trending upward = successful campaign, consider extending or increasing ad spend.

Decreasing Velocity: Sales dropping faster than expected = adjust promotions, send reminder emails, or offer flash bonuses.

Stable AOV: Consistent average order value = healthy mix of products being sold.

Declining AOV: Customers buying cheaper items or fewer products = may need to promote bundles or higher-value items.

---

Step 5: Set Up Scheduled Reports for Real-Time Monitoring

During peak events, you don't want to manually check reports constantly. Schedule automatic updates.

How to Schedule Reports

1. Save Your Report.
Click Save Report and name it (e.g., "Black Friday Daily Velocity").

1. Set Up a Schedule.
Look for the Schedule or Automate option in report settings.

1. Choose Frequency.
Select how often you want updates: - Daily – Receive a summary every morning during your sale period - Weekly – Track week-over-week comparisons - Custom – Set specific dates (e.g., only during Black Friday weekend)

1. Add Recipients.
Enter email addresses for team members who need visibility: - Marketing team - Operations/fulfillment - Executive leadership

1. Activate the Schedule.
Turn on the schedule, and PayHelm will automatically send the report.

This keeps everyone informed without manual work during your busiest days.

---

Advanced Velocity Analysis

Compare Year-Over-Year Performance

Create two reports side by side:
• This Year: Black Friday 2024
• Last Year: Black Friday 2023

Compare metrics:
• Total sales growth %
• Order volume increase
• Changes in AOV
• New customer acquisition rates

Track Multi-Day Event Performance

For events spanning several days (Cyber Week, Holiday Season):

Group by Week or Day and watch:
• Which days drive the most volume
• How velocity changes as the event progresses
• When to send "last chance" messaging

Segment by Customer Type

Create separate reports for:
• New Customers – Track acquisition velocity
• Returning Customers – Monitor retention and repeat purchase rates

This shows whether you're growing your customer base or relying on existing buyers.

Monitor Product-Specific Velocity

Group by Product or Product Category instead of date to see:
• Which items sell out fastest
• What products have the longest sales tail
• When to restock popular items

---

Tips for High-Volume Event Monitoring

Start Tracking Early

Don't wait until Black Friday to set up your reports. Create and test them a week ahead so you:
• Know your baseline velocity
• Spot any data sync issues
• Familiarize yourself with the dashboard

Set Velocity Targets

Based on previous years or projections, define goals:
• "We need $100k in sales on Black Friday"
• "Target: 800 orders per day"
• "Goal: Maintain $125 AOV throughout the weekend"

Check your velocity report against these targets throughout the event.

Monitor Multiple Metrics

Don't focus only on revenue. Watch:
• Order volume – Gauge fulfillment capacity
• AOV – Ensure profitability isn't declining
• New customers – Track long-term growth potential
• Units sold – Anticipate inventory needs

React to Data in Real-Time

If velocity is lower than expected at 2 PM on Black Friday:
• Send a "flash sale extended" email
• Increase ad budgets
• Promote high-margin products more aggressively

If velocity is higher than expected:
• Alert fulfillment team to prepare for volume
• Check inventory levels on fast-selling items
• Consider extending successful campaigns

---

Common Use Cases

Flash Sales

Scenario: 6-hour flash sale on Sunday afternoon.

Setup:
• Create a daily report with hourly granularity (if available)
• Set date filter to Sunday only
• Monitor Total Sales and Orders in real-time

Action: If sales spike in the first 2 hours, extend the sale or increase promotion.

---

Black Friday Through Cyber Monday

Scenario: 5-day event from Thanksgiving through Cyber Monday.

Setup:
• Group by Day
• Compare metrics across all 5 days
• Track cumulative sales total

Action: Identify which day performs best and replicate those tactics next year.

---

Product Launch

Scenario: New product release with anticipated high demand.

Setup:
• Filter by the new product SKU
• Group by Day for the first week
• Track Orders and Units Sold

Action: Ensure sufficient inventory based on day-over-day velocity trends.

---

Troubleshooting

"Sales data is delayed"

• PayHelm syncs with your ecommerce platform every few hours
• For real-time visibility, check your platform's native dashboard
• PayHelm is best for analyzing trends after the fact or daily summaries

"Report shows no data for today"

• Ensure your date filter includes today's date
• Check that your ecommerce platform is connected and syncing
• Verify orders have been placed (check your platform directly)

"AOV calculation shows error"

• This happens when there are zero orders in a time period
• Filter out periods with no sales, or use conditional formulas if available

---

Need More Help?

If you have questions about setting up velocity reports, scheduling automated updates, or analyzing sales patterns, contact our support team. We are here to help you make the most of your high-volume sales events!

Happy selling!