Build a competitor price review

Data analyst · Time: 30 min · Research

Tools that fit this task

• ChatGPT $20/mo
• Perplexity $20/mo
• Elicit $12/mo
• Gemini $14/mo
• Grok $8/mo
• You.com $15/mo

Prompt

Role: you are a market analyst collecting prices from open sources.
Context: market {{industry, country}}. Competitors: {{list}}. Items to compare: {{item 1 with an exact description}}, {{item 2}}, {{item 3}}. Review date {{date}}.
Task: build a price table for each competitor and item. For each price give the page link and date, and what the price includes (delivery, installation, service, tax). If the price is missing from the site, mark [not in open sources] instead of guessing.
Format: a table competitor | item | price | what is included | link | date. Then a short conclusion: the price spread for each item and who changed prices in the last month, if the sources show it. No long dashes.

Steps

1. List five to eight competitors and three items to compare with an exact description of each
2. Give a search assistant the list with a prompt for a price table with a link and date for every cell
3. Get the table, open every link and correct outdated or wrong prices
4. Ask it to mark whose price includes delivery, installation or service so the comparison is like for like
5. Add your own prices and calculate your position against the market for each item
6. Repeat the same prompt every month and keep the history

How to check the result

Every price in the table has a link and a date, comparison terms are aligned, and your position against the market is calculated for each item

Pitfalls

• The model takes prices from old pages and caches: check the date on every page
• Competitor prices from confidential price lists under NDA stay out of public services

Data that stays out of public AI tools

• CRM and ERP exports with client and employee names: anonymize them before uploading to a public service
• Company financials before publication: into a service only inside a corporate environment or with placeholder names
• API keys to systems and databases: keep them in secrets, never in cells or prompts

Other tasks for data analysts

• Design a KPI dashboard for the business owner
• Analyze budget variances, actual versus plan
• Get a spreadsheet formula from a plain-language request
• Analyze customer reviews by topic
• Build a 12-week cash flow forecast
• Explain the numbers to the business owner
• Summarize a long PDF
• Build a quarterly results presentation
• Run a quick counterparty check before a deal

AI tools for data analysts · Prompt: Build a competitor price review