👥 Customer Groups Report – Segmented Sales Analysis #
1. Navigate to “Customer Groups Report” #
- Log in to your restaurant management system.
- In the sidebar, click Reports.
- Under Reports, select Customer Groups Report.
- The Customer Groups Report page will open showing:
- A “Customer Groups Report” header at the top of the page.
- A ▼ Filters section with filtering options.
- Export buttons for CSV, Excel, Print, Column Visibility, and PDF.
- A data table with two columns:
- Customer Group – Name of the customer segment
- Total Sale – Sales value for that group
- Pagination controls showing entries (e.g., “Showing 0 to 0 of 0 entries”).
2. Understanding Customer Groups Report #
The Customer Groups Report is a powerful customer segmentation tool that helps you analyze sales performance by customer categories:
- Customer Segmentation – Group customers by type, loyalty level, or business category.
- Sales Performance by Segment – Track revenue contribution from each customer group.
- Targeted Marketing – Identify high-value segments for focused marketing efforts.
- Pricing Strategy – Develop group-specific pricing and promotions.
- Service Optimization – Tailor service levels to different customer segments.
- Revenue Analysis – Understand which customer groups drive most revenue.
- Growth Opportunities – Identify underperforming segments with growth potential.
3. Understanding Customer Groups #
Customer groups are predefined segments that categorize your customers:
| Common Group Types | Description | Examples |
|---|---|---|
| Loyalty Tiers | Based on customer loyalty level | VIP, Gold, Silver, Bronze, Regular |
| Business Type | Based on customer business category | Corporate, Retail, Wholesale, Individual |
| Pricing Tiers | Based on pricing agreements | Premium, Standard, Discount, Special Rate |
| Geographic | Based on location or region | Local, Regional, National, International |
| Purchase Frequency | Based on visit frequency | Daily, Weekly, Monthly, Occasional |
| Special Categories | Custom business segments | Staff, Family & Friends, Partners, Walk-in |
4. Configure Customer Groups Report Filters #
- Click the ▼ Filters dropdown to expand filtering options.
- Configure the following filter parameters:
- Customer Group Name – Select specific group:
- Choose “All” to view all customer groups.
- Select specific group to analyze that segment only.
- Useful for focused analysis of particular segments.
- Business Location – Select location scope:
- Choose “All locations” for consolidated view across all branches.
- Select specific location for location-based analysis.
- Compare group performance across different locations.
- Date Range – Set analysis period:
- Format: DD/MM/YYYY – DD/MM/YYYY (e.g., 02/07/2026 – 09/07/2026).
- Select start and end dates for the reporting period.
- Analyze group performance over specific timeframes.
- Customer Group Name – Select specific group:
- Apply filters to generate customized report view.
5. Understanding Report Columns #
The Customer Groups Report displays two key columns:
| Column Name | Description | Purpose |
|---|---|---|
| Customer Group | Name of the customer segment | Identifies the customer category being analyzed |
| Total Sale | Total sales revenue from that group | Quantifies revenue contribution from each segment |
- Sorting Capabilities:
- Click column headers to sort data.
- Sort by Customer Group alphabetically.
- Sort by Total Sale to identify top revenue groups.
- Use sorting to quickly identify patterns.
6. Analyzing Sales by Customer Group #
Use the report to gain insights into customer segment performance:
- Revenue Contribution Analysis:
- Identify which groups generate most revenue.
- Calculate percentage contribution: (Group Sales ÷ Total Sales) × 100.
- Apply 80/20 rule: Often 20% of groups generate 80% of revenue.
- Focus resources on high-value segments.
- Group Performance Ranking:
- Sort by Total Sale to rank groups from highest to lowest.
- Identify top 3-5 performing groups.
- Recognize underperforming groups.
- Set performance benchmarks for each group.
- Comparative Analysis:
- Compare current period with previous periods.
- Identify growing vs. declining segments.
- Track seasonal variations by group.
- Monitor impact of marketing campaigns on specific groups.
7. Date Range Analysis Strategies #
The date range filter enables powerful time-based customer group analysis:
- Short-Term Analysis (Daily/Weekly):
- Track immediate group performance trends.
- Monitor impact of recent promotions on specific groups.
- Identify day-of-week patterns by customer group.
- Respond quickly to changes in group behavior.
- Medium-Term Analysis (Monthly/Quarterly):
- Evaluate group performance over business cycles.
- Assess effectiveness of group-specific marketing campaigns.
- Track loyalty program impact on group sales.
- Plan seasonal strategies for different groups.
- Long-Term Analysis (Yearly):
- Understand annual trends by customer segment.
- Identify shifts in customer base composition.
- Evaluate long-term group growth or decline.
- Make strategic decisions about group focus.
- Comparative Periods:
- Compare same period year-over-year by group.
- Analyze month-over-month changes.
- Identify seasonal patterns specific to groups.
8. Multi-Location Group Analysis #
For restaurant chains, location-based group analysis provides valuable insights:
- All Locations View:
- Select “All locations” for company-wide group performance.
- Identify which groups are important across all branches.
- Develop company-wide strategies for key groups.
- Standardize group offerings and pricing.
- Location-Specific Analysis:
- Select specific location to see location-based group performance.
- Understand local customer demographics and preferences.
- Customize offerings for location-specific groups.
- Optimize marketing for local customer segments.
- Comparative Location Analysis:
- Run report for Location A, then Location B.
- Compare which groups perform better at different locations.
- Identify location-specific opportunities.
- Share successful group strategies across locations.
9. Export and Documentation Options #
The report provides multiple export formats for analysis and sharing:
| Export Option | Button Color | Use Case | Best For |
|---|---|---|---|
| Export to CSV | Purple | Import into spreadsheet applications | Data analysis, calculations, pivot tables |
| Export to Excel | Green | Advanced Excel analysis | Charts, formulas, detailed analysis |
| Blue | Physical copies | Meetings, presentations, filing | |
| Column Visibility | Orange | Customize visible columns | Simplified views, focused analysis |
| Export to PDF | Purple | Shareable format | Reports, documentation, distribution |
10. Strategic Applications of Customer Group Data #
Use customer group insights to drive business strategies:
- Targeted Marketing:
- Develop group-specific marketing campaigns.
- Allocate marketing budget based on group value.
- Create personalized promotions for each segment.
- Use appropriate channels for different groups.
- Pricing Strategy:
- Implement group-specific pricing tiers.
- Offer volume discounts to high-value groups.
- Create loyalty rewards for frequent customer groups.
- Adjust pricing to maximize revenue from each segment.
- Service Optimization:
- Provide premium service to high-value groups.
- Customize service levels based on group expectations.
- Allocate staff resources to important segments.
- Develop group-specific service protocols.
- Product Development:
- Create menu items tailored to group preferences.
- Develop group-specific product bundles.
- Test new offerings with specific segments.
- Customize portion sizes for different groups.
- Loyalty Programs:
- Design tier-based loyalty programs.
- Offer group-specific rewards and benefits.
- Create upgrade paths between groups.
- Incentivize movement to higher-value segments.
11. Identifying Growth Opportunities #
Use the report to uncover opportunities for business growth:
- High-Value Group Expansion:
- Identify top-performing groups.
- Develop strategies to attract more customers to these groups.
- Create referral programs targeting high-value segments.
- Invest in marketing to grow valuable customer groups.
- Underperforming Group Development:
- Identify groups with low sales but high potential.
- Investigate barriers preventing group growth.
- Develop targeted initiatives to boost underperforming segments.
- Test new offerings or promotions with these groups.
- Customer Migration Strategies:
- Encourage customers to move to higher-value groups.
- Create clear upgrade paths and incentives.
- Communicate benefits of premium group membership.
- Track migration rates between groups.
- New Group Creation:
- Identify gaps in current group structure.
- Create new segments to better serve customer needs.
- Test new group concepts with pilot programs.
- Refine group definitions based on performance data.
12. Customer Retention Analysis #
Use group data to improve customer retention:
- Group-Specific Retention Rates:
- Track sales trends by group over time.
- Identify groups with declining sales (potential churn).
- Develop retention strategies for at-risk segments.
- Monitor effectiveness of retention initiatives.
- Loyalty Program Effectiveness:
- Compare sales between loyalty tiers.
- Evaluate if loyalty programs drive increased spending.
- Adjust program benefits based on group performance.
- Identify most effective loyalty incentives by group.
- Win-Back Campaigns:
- Identify groups with declining sales.
- Develop targeted win-back campaigns.
- Offer special incentives to re-engage groups.
- Track success rates of win-back efforts.
13. Best Practices for Customer Groups Analysis #
- Regular Monitoring – Review customer group report monthly to track segment performance.
- Clear Group Definitions – Ensure customer groups are clearly defined and consistently applied.
- Balanced Segmentation – Create meaningful groups that are neither too broad nor too narrow.
- Comparative Analysis – Always compare current period with previous periods to identify trends.
- Action-Oriented – Use insights to develop specific strategies for each group.
- Customer Communication – Inform customers about their group benefits and privileges.
- Staff Training – Train staff to recognize and serve different customer groups appropriately.
- Data Quality – Ensure customers are correctly assigned to appropriate groups.
- Privacy Compliance – Maintain customer data privacy and comply with regulations.
- Feedback Integration – Combine sales data with customer feedback for complete picture.
- Continuous Refinement – Regularly review and refine group definitions and strategies.
- Cross-Functional Collaboration – Share insights with marketing, operations, and management teams.
14. Troubleshooting Common Issues #
| Issue | Possible Cause | Resolution |
|---|---|---|
| No data available in table | No sales in selected period or groups not set up | Verify date range, check customer group configuration |
| Missing customer groups | Groups not created or customers not assigned | Create customer groups, assign customers to groups |
| Unexpected sales values | Customers assigned to wrong groups | Review and correct customer group assignments |
| One group dominates sales | Most customers in default group | Properly segment customers into appropriate groups |
| Export fails | Browser issues or large dataset | Try different browser, reduce date range |
| Inconsistent data across locations | Different group definitions at locations | Standardize customer group definitions company-wide |
| Groups not showing expected results | Recent group changes not reflected | Refresh report, verify customer assignments updated |
| Duplicate group names | Similar groups created at different times | Consolidate duplicate groups, clean up data |
15. Done! 🎉 #
Congratulations! You now have a comprehensive understanding of the Customer Groups Report feature. This powerful segmentation tool enables you to:
- Analyze sales performance by customer segment
- Identify high-value customer groups for focused attention
- Develop targeted marketing strategies for different segments
- Optimize pricing and service levels by customer group
- Track group performance trends over time
- Identify growth opportunities in underperforming segments
- Make data-driven decisions about customer relationship management
Use this report regularly to understand your customer base and maximize revenue from each segment! 👥💰