시장 침투를 위한 고급 분석

Develop an advanced query to assess [companyName]'s market penetration in [targetMarket] focusing on [productLine]. Include variables for customer demographics ([customerAgeRange], [customerIncomeSegment]), purchasing behavior ([purchaseFrequency], [averageSpendPerVisit]), and product performance ([productSalesVolume], [productReturnRate]).

Requirements:
1. Construct a multi-dimensional query that combines sales, demographic, and behavioral data.
2. Integrate time series analysis to identify purchasing trends over the last [timePeriod].
3. Apply segmentation analysis to differentiate between customer demographics and behavior.
4. Incorporate a comparison feature to evaluate [productLine] against competitors within [targetMarket].
5. Design a predictive model within the query to forecast future sales trends based on current data.
6. Ensure the query optimizes for execution speed and data retrieval efficiency.
7. Facilitate an option to dynamically update variables ([customerAgeRange], [customerIncomeSegment], etc.) based on user input.
8. Include a comprehensive summary of findings that correlates customer behavior with sales performance.