Reporting and Analytics
Jeremy Mckinney
Last Update há 9 meses
1. The Analytics Dashboard
Key Performance Indicators (KPIs)
At the top of the dashboard, you will see "Scorecard" widgets for quick health checks:
• Unpaid Invoices: The total dollar amount currently outstanding (Sent + Overdue).
• Profit: Calculated automatically as Total Revenue minus Total Expenses.
• Active Clients: The number of unique customers served in the last 90 days.
Financial Charts
• Revenue Forecast: The system uses linear regression on your last 6 months of data to project your revenue for the next 3 months. This helps you plan for hiring or marketing pushes before a busy season hits.
Operational Charts
• Top Clients by Revenue: A bar chart ranking your top 10 customers. These are your VIPs who should be prioritized for loyalty rewards.
2. AI-Powered Business Insights
• Churn Risk: "23% of your customer base hasn't booked in 6 months. Launch a re-engagement campaign."
• Cost Reduction: "Fuel expenses are rising faster than revenue. Optimize routes to reduce drive time."
• Maintenance Predictions: It analyzes service history to predict which clients are due for recurring maintenance (e.g., annual HVAC tune-ups) before they even call you.
3. Customer Segmentation
• 🙂 Loyal: Consistent regulars with moderate spend. (Action: Maintain service quality).
• ⚠️ At Risk: High historical spenders who haven't booked recently. (Action: Send a "We Miss You" coupon).
• 🌱 New: First-time customers. (Action: Send a welcome series).
• 💤 Lost: Inactive for 180+ days. (Action: Win-back campaign).
4. Exporting Data (CSV Reports)
Sometimes you need raw data for your accountant or external software. You can export detailed reports from any list view in the system.
Available Exports:
• Invoice Register: Billed amounts, tax collected, and payment status.
• Client Database: Full contact info and lifetime value.
• Expense Report: Categorized list of all business expenses for tax time.
How to Export:
2. Apply any desired filters (e.g., Date Range: "Last Year").
3. Click the "Export CSV" button in the top right corner.
4. The file will download immediately, ready for Excel or QuickBooks Desktop.
5. Marketing Analytics
• Conversion Rate: How many clients booked a job directly from the email link.
• Revenue Recovered: The total dollar value of jobs generated from "Re-engagement" campaigns.
