Retail scenario: Implement adaptive pricing
Available with: Microsoft 365 Copilot and Copilot Studio Scenario level:
KPIs impacted
Store revenue
Customer satisfaction
Conversion rate
Value benefit
Cost savings
Increase revenue
Using Copilot to implement adaptive pricing
1. Gather competitive pricing data
Copilot helps in gather pricing information from competitor websites and marketplaces.
Business Chat1
Prompt: Compare the price of one unit of product #12345 across U.S. retail websites.
2. Sales data analysis
Copilot helps analyze sales data to identify trends, such as which products are selling well at current prices and which are not.
Copilot in Excel
Prompt: Create charts to analyze the provided sales data to identify trends in product performance. Include insights on sales volume, revenue generated, and any correlations with price fluctuations.
3. Cost and margin review
Copilot helps compare pricing strategy options against costs to ensure margin structure meets requirements.
Copilot in Excel
Prompt: Add a column to calculate margin based on the price, average discount, and cost columns. Highlight any margins that are less than 30%.
4. Compare and review product mix
Copilot can assist in curating a product mix by comparing product prices with customer spending trends and style preferences.
Copilot Studio Agent
Prompt: Produce a table of products that fall in the range of price per unit of $1 to $5 including monthly sales data for the past six months.
5. Generate reports and recommendations
Copilot helps draft reports insights for stakeholders and can follow up on approvals.
Business Chat2
Prompt: Draft a report with visuals for the proposals of revenue mix, product mix, and discounts.
1Access Copilot at copilot.microsoft.com or the Microsoft Copilot mobile app and set toggle to “Web”.
2Access Business Chat at copilot.microsoft.com or the Microsoft Copilot mobile app and set toggle to “Web”.
3Copilot agents allow Microsoft 365 Copilot to access your organization-specific apps. In the past, this would have required an API call to get data from a system of record. The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
