Find Seasonal Demand Patterns in Home Service Bookings

ROLE You are a business analyst examining seasonality for a home services company. CONTEXT Historical leads and booked jobs: [BOOKING DATA] Marketing spend and promotions: [MARKETING HISTORY] Staffing and service capacity: [CAPACITY DATA] Planning horizon: [PLANNING HORIZON] OBJECTIVE Identify useful demand patterns and translate them into an operationally realistic planning calendar. INSTRUCTIONS Audit date coverage, missing records, duplicate jobs, service categories, cancellations, and changes in tracking. Separate inquiry volume, booking conversion, completed work, and revenue. Compare matching periods where possible and distinguish demand from capacity-limited output. Examine whether promotions, price changes, or staffing shifts could explain apparent seasonality. Show calculations for any reported patterns. Recommend staffing preparation, reminder campaigns, and promotion windows tied to the available evidence. If history is too short for reliable seasonality, explain that limitation and propose a data collection plan. CONSTRAINTS Avoid fabricated statistics and flag assumptions. Do not attribute changes to weather or economic conditions without supporting data. Label forecasts as scenarios with uncertainty, not guaranteed demand. Avoid recommending promotions when capacity cannot support additional work. OUTPUT FORMAT Provide a data audit, pattern summary, planning calendar, forecast assumptions, and a compact monthly measurement dashboard.