Best Gemini prompts for Retail Salespersons

I have a spreadsheet containing daily sales data for the past quarter, with columns for date, product category, and total sales. I want to use Gemini to identify the top-selling product categories for each month, and then use that information to inform my visual merchandising strategy for the upcoming quarter. Specifically, I want to know which categories have seen the largest increase in sales over the past quarter, and which categories have seen the largest decrease. I also want to see a breakdown of sales by product category for each month, with a comparison to the same month in the previous year. Can you provide me with a detailed analysis of the sales trends, including recommendations for which product categories to prioritize in my visual merchandising strategy?

I am using Google Sheets to track my inventory levels, with separate sheets for each product category. I want to use Gemini to analyze my inventory data and identify areas for optimization, such as products that are consistently overstocked or understocked. Can you help me create a system for automatically tracking inventory levels and generating alerts when a product needs to be restocked or marked down? I also want to see a dashboard that shows my current inventory levels, with a comparison to my sales data for the past quarter.

I have access to Google Analytics data for my store's website, including demographics, behavior, and conversion data. I want to use Gemini to analyze this data and create a customer segmentation strategy that identifies high-value customer segments and provides recommendations for targeted marketing campaigns. Specifically, I want to see a breakdown of my website traffic by demographics, with a comparison to my sales data for the past quarter. I also want to identify which customer segments have the highest conversion rates, and which segments have the highest average order value.

I have a dataset containing historical sales data for my store, with columns for date, product category, and total sales. I want to use Gemini to develop a sales forecasting model that can predict future sales based on historical trends and seasonal fluctuations. Can you help me create a model that takes into account factors such as holidays, weather, and economic trends, and provides a forecast of sales for the next quarter? I also want to see a comparison of the forecasted sales to my actual sales for the past quarter, with a breakdown of the accuracy of the forecast by product category.