Business OS
Finance & AccountingFinancial Reports

Worksheet Market Segmentation Analysis

This template provides a structured framework for conducting a market segmentation analysis, helping businesses identify and understand distinct customer groups to tailor their marketing strategies effectively. Use this worksheet to methodically analyse your target market.

Updated 15d ago
market analysissegmentationmarketing strategycustomer understandingbusiness planningfinancial report

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Worksheet: Market Segmentation Analysis

Date: {{date}}

Prepared by: {{analyst_name}}

Department: {{department}}

Title: Market Segmentation Worksheet

I. Executive Summary

Briefly summarise the key findings of the market segmentation analysis. Include an overview of the identified segments and their significance. This section should be completed after the full analysis is finalised.

Key Segments Identified: {{summary_key_segments}}

Strategic Implications: {{summary_strategic_implications}}

II. Market Definition and Overview

Clearly define the total market being analysed. Provide an overview of the market size, growth trends, and key characteristics.

Total Market Size (Estimated): {{total_market_size}}

Market Growth Rate (Annual): {{market_growth_rate}}%

Key Market Characteristics: {{market_characteristics}}

III. Segmentation Criteria and Variables

Outline the criteria and variables used for segmenting the market. Consider demographic, geographic, psychographic, and behavioural factors.

A. Demographic Segmentation:

- Age Range: {{demographic_age_range}}

- Gender: {{demographic_gender}}

- Income Level: {{demographic_income_level}}

- Education Level: {{demographic_education_level}}

- Occupation: {{demographic_occupation}}

B. Geographic Segmentation:

- Region/Country: {{geographic_region}}

- Urban/Rural: {{geographic_urban_rural}}

- Climate: {{geographic_climate}}

C. Psychographic Segmentation:

- Lifestyle: {{psychographic_lifestyle}}

- Values/Attitudes: {{psychographic_values_attitudes}}

- Interests/Hobbies: {{psychographic_interests}}

D. Behavioural Segmentation:

- Purchase Occasion: {{behavioural_purchase_occasion}}

- Benefits Sought: {{behavioural_benefits_sought}}

- User Status: {{behavioural_user_status}}

- Usage Rate: {{behavioural_usage_rate}}

IV. Identified Market Segments

Based on the chosen criteria, describe each identified market segment in detail. Give each segment a descriptive name.

Segment 1: {{segment_1_name}}

- Description: {{segment_1_description}}

- Key Characteristics: {{segment_1_characteristics}}

- Estimated Size: {{segment_1_size}}

- Potential Value: {{segment_1_potential_value}}

Segment 2: {{segment_2_name}}

- Description: {{segment_2_description}}

- Key Characteristics: {{segment_2_characteristics}}

- Estimated Size: {{segment_2_size}}

- Potential Value: {{segment_2_potential_value}}

(Add more segments as required: {{segment_n_name}}, {{segment_n_description}}, etc.)

V. Segment Attractiveness Analysis

Evaluate the attractiveness of each segment based on factors such as size, growth potential, profitability, accessibility, and competitive intensity.

Segment 1 Attractiveness Score (e.g., on a scale of 1-5): {{segment_1_attractiveness_score}}

- Justification: {{segment_1_attractiveness_justification}}

Segment 2 Attractiveness Score: {{segment_2_attractiveness_score}}

- Justification: {{segment_2_attractiveness_justification}}

(Add more segments as required)

VI. Target Segment Selection

Based on the attractiveness analysis, identify the primary and secondary target segments for the business.

Primary Target Segment(s): {{primary_target_segments}}

Rationale for Primary Target: {{primary_target_rationale}}

Secondary Target Segment(s): {{secondary_target_segments}}

Rationale for Secondary Target: {{secondary_target_rationale}}

VII. Marketing Strategy Implications

Outline how the segmentation analysis will influence marketing strategies, including product development, pricing, promotion, and distribution.

Product/Service Development: {{strategy_product_development}}

Pricing Strategy: {{strategy_pricing}}

Promotional Strategy: {{strategy_promotional}}

Distribution Channels: {{strategy_distribution}}

VIII. Next Steps and Recommendations

Detail the immediate next steps and provide recommendations for further research or action.

Recommended Actions: {{recommended_actions}}

Further Research Required: {{further_research}}

Signature Block

Analyst Name: {{analyst_name}}

Signature: __________________________

Date: {{date}}

Manager/Supervisor Name: {{manager_name}}

Signature: __________________________

Date: {{date}}

Related templates