Skip to main content

​
Sales Analysis

Learn how to use aidnn to analyze sales data, identify trends, and gain insights into your revenue performance.

​
Common Sales Questions

aidnn can help you answer questions like:
  • What are my total sales for this period?
  • Which products are top performers?
  • How do sales compare to last year?
  • What are the monthly/quarterly trends?
  • Which regions or customers drive the most revenue?
  • Are there seasonal patterns?

​
Example Workflow

​
Step 1: Load Your Sales Data

Upload a file:
“Upload sales_2024.csv”
Or connect to your system:
“Access sales data from my QuickBooks”

​
Step 2: Understand Your Data

Get a summary:
“Show me a summary of the sales data”
Check date range:
“What’s the date range of this data?”
See structure:
“What columns are in this dataset?”

​
Step 3: Calculate Total Sales

Simple total:
“Calculate total revenue”
By time period:
“Calculate total sales by month”
“Show me quarterly revenue totals”
By dimension:
“Calculate total sales by product category”
“Show me revenue by sales region”

​
Step 4: Identify Top Performers

Top products:
“Which 10 products generated the most revenue?”
Top customers:
“Show me my top 20 customers by total sales”
Top regions:
“Rank regions by revenue”
Over time:
“Create a line chart of monthly sales”
“Show me the sales trend for the past 12 months”
Growth rates:
“Calculate month-over-month sales growth”
“What’s the year-over-year growth rate?”

​
Step 6: Compare Periods

Year comparisons:
“Compare 2024 sales to 2023”
“Show me side-by-side revenue for this year and last year by month”
Quarter comparisons:
“Compare Q1 and Q2 revenue”
Before/after:
“Compare sales before and after our price increase in July”

​
Step 7: Segment Analysis

By product:
“Break down sales by product category”
“Show me the percentage of revenue from each product line”
By customer:
“Segment customers by purchase frequency”
“Show me revenue from new vs returning customers”
By geography:
“Create a breakdown of sales by state/region”

​
Real-World Example

​
Scenario: Monthly Sales Review

Business Context: You’re a sales manager preparing for your monthly review meeting. You need to understand last month’s performance and identify areas of concern or opportunity. Your Conversation with aidnn: 1. Load Data
“Upload august_2024_sales.csv”
aidnn confirms: 1,523 transactions loaded 2. Get Overview
“Show me a summary of August sales”
Results: 
August 2024 Sales Summary
- Total Revenue: $248,650
- Total Orders: 1,523
- Average Order Value: $163
- Unique Customers: 892
3. Compare to Previous Month
“Compare these totals to July 2024”
aidnn shows: 
Month-over-Month Comparison
            August      July        Change
Revenue     $248,650    $235,100    +5.8%
Orders      1,523       1,456       +4.6%
AOV         $163        $161        +1.2%
Insight: Revenue growing slightly faster than order count, driven by higher average order value. 4. Identify Best Sellers
“What were the top 5 products in August?”
Results: 
Top Products - August 2024
1. Premium Widget Pro - $45,230 (18% of revenue)
2. Standard Widget - $32,100 (13%)
3. Widget Accessories Kit - $28,450 (11%)
4. Professional Series Widget - $24,120 (10%)
5. Budget Widget - $18,990 (8%)
5. Look for Trends
“Show me daily sales trend for August”
aidnn creates line chart showing:
  • Steady performance most of month
  • Notable spike mid-month (promotion)
  • Weekend dips are normal
6. Investigate Concerns
“Were there any days with unusually low sales?”
aidnn identifies:
  • August 15-16: System outage, $8,000 lost revenue
  • Need to follow up on recovery plan
7. Regional Performance
“Break down revenue by sales region”
Results show:
  • West region up 15% (strong)
  • East region flat (investigate)
  • South region down 8% (concerning)
8. Action Items
“Create a summary of key findings”
aidnn produces: 
August 2024 Key Findings

Positives:
- Overall revenue up 5.8% vs July
- Premium products driving growth
- West region showing strong performance

Concerns:
- System outage cost $8K in mid-month
- East region growth has stalled
- South region declining (down 8%)

Recommended Actions:
- Investigate South region decline
- Review East region strategy
- Follow up on outage prevention
9. Export for Meeting
“Export the monthly comparison and regional breakdown to Excel”
aidnn provides downloadable files for your presentation.

​
Tips for Sales Analysis

​
Be Specific with Time Periods

Good:
  • ✅ “Show me sales for Q4 2023”
  • ✅ “Compare October to September”
  • ✅ “Last 90 days of sales”
Vague:
  • ❌ “Show me recent sales”
  • ❌ “What about last quarter?”

​
Think in Segments

Don’t just look at totals:
  • Product categories
  • Customer segments
  • Geographic regions
  • Sales channels
  • Time periods

​
Look for Patterns

Ask aidnn to identify:
  • Trends (up, down, flat)
  • Seasonality (monthly, quarterly)
  • Anomalies (unusual spikes or dips)
  • Correlations (what moves together)

​
Compare and Contrast

Always provide context:
  • This year vs last year
  • This month vs last month
  • Actual vs target
  • Region A vs Region B

​
Advanced Sales Analysis

​
Customer Lifetime Value

“Calculate lifetime value for each customer”
“Show me CLV by customer acquisition cohort”

​
Sales Forecasting

“Based on the past 12 months, forecast next quarter”
“If this trend continues, what will December sales be?”

​
Product Mix Analysis

“What percentage of sales come from each product category?”
“How has our product mix changed over time?”

​
Sales Rep Performance

“Compare sales by sales representative”
“Who are the top performers this quarter?”

​
Price Analysis

“What’s the relationship between price and quantity sold?”
“Show me how sales changed after our price adjustment”

​
Next Steps

Questions? Check our FAQ or reach us at support@isotopes.ai.