Free Ecommerce Competitor Analysis Template (2026) — Spreadsheet Included

You can't outmaneuver what you can't see. This template is the same one used by top 1% Amazon sellers to track competitors systematically. It's free. It's comprehensive. And it works.

Why Competitor Analysis Is Critical (And Why Most Sellers Skip It)

Most Amazon sellers focus exclusively on their own metrics: sales, BSR, reviews. They glance at competitors occasionally but never systematically track them.

This is a massive mistake. Here's what you're missing without proper competitor analysis:

• Price wars before they happen — You see a competitor drop price after you've already lost sales
• Stockout opportunities — Competitors run out while you're unaware, missing easy wins
• New entrant threats — New competitors gain traction before you notice
• Market timing mistakes — You run promotions when competitors are out of stock
• Margin erosion — Competitors undercut while you're still at full price

The sellers winning in 2026 treat competitor intelligence as a core business function, not an afterthought. This template makes that systematic and sustainable.

The Template: Complete Breakdown

Our competitor analysis template has 5 core sections. Each serves a specific purpose in your competitive intelligence system.

Section 1: Competitor Profile

This section captures the "who" of your competitive landscape. For each major competitor, document:

• Seller name and ID — Official seller information
• Rating and review count — Current standing
• FBA/FBM status — How they fulfill
• Number of ASINs — Breadth of their catalog
• Est. monthly revenue — Based on BSR and reviews
• Account age — How established are they
• Feedback score — Seller rating on Amazon
• Prime eligibility — Yes/No

Why this matters: Understanding WHO you're competing against helps predict their behavior. A new seller behaves differently than an established giant. A small FBM seller responds differently than a large FBA operation.

Section 2: Product Comparison Matrix

This is where you track specific product-level competition. For each ASIN you sell, create a row that tracks:

• Your ASIN and product name — Baseline
• Your price — Updated weekly
• Your review count — Tracking momentum
• Your rating — Quality signal
• Competitor 1 price/ratings
• Competitor 2 price/ratings
• Competitor 3 price/ratings
• Lowest competitor price
• Buy Box winner — Who holds it
• Notes — Anything notable

Why this matters: This matrix gives you an instant view of your competitive position across your entire catalog. At a glance, you see which products are under pressure and which have breathing room.

Section 3: Pricing Tracking Table

Pricing is the most dynamic competitive factor. This section tracks price movements over time:

• Product identifier — ASIN or SKU
• Date — When price was recorded
• Your price — Your current price
• Competitor price — Each competitor separately
• Buy Box price — Current winning price
• Price change direction — Up/Down/Same
• Price change magnitude — $ amount or %
• Likely cause — Repricing, promotion, stockout, etc.

Why this matters: Price history reveals patterns. You'll notice competitors who always reprice at certain times, or who react to YOUR price changes. This intelligence informs your own pricing strategy.

Section 4: Inventory Monitoring Log

Stockouts are opportunities. This section tracks competitor inventory status:

• Product identifier — ASIN or SKU
• Date checked — Timestamp
• Your inventory level — Units available
• Competitor inventory status — In Stock/Low/Out of Stock
• Days of stock estimated — Based on sales velocity
• Stockout started — When OOS began
• Stockout ended — When they restocked
• Opportunity captured — Yes/No/Partial

Why this matters: When a competitor runs out, their customers are actively looking for alternatives. If you know immediately, you can capture those sales by lowering price slightly or increasing your ad spend.

Section 5: Alert Configuration Worksheet

This section defines your monitoring rules and thresholds:

• Alert trigger type — Price drop, stockout, new review, etc.
• Threshold — What triggers the alert (e.g., 5% price drop)
• Notification method — Email, Slack, SMS
• Response action — What to do when alert fires
• Owner — Who handles this alert
• SLA — How quickly to respond

Why this matters: Without defined alert rules, you either over-monitor (alert fatigue) or under-monitor (missed opportunities). This worksheet ensures you're tracking the right things with appropriate responses.

How to Use Each Section: Step-by-Step Guide

Getting Started (Week 1)

1. List your top 10 competitors — Focus on sellers competing for your Buy Box
2. Fill out Competitor Profiles — One-time data entry
3. Create Product Comparison Matrix rows — One for each ASIN you sell
4. Set up your first pricing checks — Manual at first, automate later
5. Define your first 3 alerts — Start with: price drop >5%, stockout, new competitor

Weekly Maintenance (Week 2+)

1. Update pricing table — Record current prices for all tracked products
2. Check inventory status — Any stockouts since last week?
3. Review alerts that fired — Did you act appropriately?
4. Update competitor profiles — Any changes in ratings, reviews?
5. Document patterns — Any behavioral patterns emerging?

Monthly Analysis

1. Review pricing trends — Who's consistently lowest? Who follows whom?
2. Calculate opportunity capture rate — Did you act on stockout opportunities?
3. Assess alert effectiveness — Any alerts that were noise? Missing critical alerts?
4. Update competitor intelligence — New competitors? Changed strategies?
5. Adjust strategies — Based on insights from the month

Real Example: Analyzing Competitor X in 15 Minutes

Let me walk you through an actual analysis using this template:

Competitor: "HomeGoods Direct" (fictional name)

Category: Kitchen accessories

Step 1: Profile Review (2 minutes)

From our profile data:

• Seller rating: 4.7 (excellent)
• Account age: 3 years
• FBA: Yes, Prime eligible
• Estimated revenue: $80K/month

Insight: Established, professional seller. Not a fly-by-night operation.

Step 2: Product Matrix Scan (5 minutes)

Looking at our overlapping products:

• Product A: They beat us by $2 (we're 8% higher)
• Product B: We beat them by $1 (we're 4% lower)
• Product C: Same price

Insight: They're more aggressive on Product A. We have pricing power on Product B.

Step 3: Pricing History Review (5 minutes)

From our tracking data:

• They reprice every 2-3 hours during business days
• They never go below MAP pricing
• They don't reprice on weekends (prices stay stable)
• They follow our price changes with 4-6 hour delay

Insight: They're rule-based, not real-time. We have speed advantage during price wars.

Step 4: Stockout Log Review (3 minutes)

History shows:

• 3 stockouts in past 6 months
• Average OOS duration: 5 days
• We captured opportunity 2 of 3 times

Insight: They have occasional supply chain issues. We should have automated alerts for their ASINs.

Action Items from 15-Minute Analysis

1. Lower Product A price by $1.50 (reduce their advantage)
2. Add stockout monitoring for their ASINs
3. Don't compete on weekends (no point, they don't reprice)
4. If they drop price on Product B, wait 6 hours before responding

Tools to Automate This Template

Manual tracking works for 10-20 products. Beyond that, you need automation. Here's how to upgrade:

Ecommerce Ops Suite ($29/month)

Our tool automates all 5 sections of this template:

• Profile tracking: Automatic competitor data updates
• Product matrix: Real-time price and rating updates
• Pricing table: Historical price tracking with trends
• Inventory monitoring: Instant stockout alerts
• Alert configuration: Custom rules with automated responses

Spreadsheet-Only Alternative

If you prefer manual tracking, use Google Sheets with these add-ons:

• ImportXML: Pull price data from Amazon (limited)
• AutoTables: Refresh external data periodically
• Email notifications: Set up IFTTT to alert on web changes

Warning: Spreadsheet-only tracking is time-intensive and error-prone. We recommend automation for serious sellers.

The Download: Template Access

Pro Tips for Deeper Analysis

Tip #1: Track Competitor Velocity

Don't just track prices — track how fast they're changing. A competitor who reprices every hour is more dangerous than one who changes weekly. High velocity = high threat.

Tip #2: Map Their Supplier

If you can identify their supplier (reverse image search their product images), you know when they're running low before they do. Suppliers often show stock issues before sellers.

Tip #3: Monitor Their Other Products

A competitor in one category often expands to adjacent categories. Early warning of category expansion lets you prepare.

Tip #4: Track Their Reviews Over Time

Review velocity is a leading indicator. Rapidly increasing reviews = growing threat. Decreasing reviews = opportunity.

Tip #5: Set Competitive Intelligence Cadences

Don't just track when things change. Schedule regular "intelligence gathering sessions" even when nothing changes. Patterns emerge from consistent observation.

Common Mistakes with Competitor Analysis

Mistake #1: Tracking Too Many Competitors

Don't try to track every seller in your category. Focus on the 5-10 who compete for YOUR Buy Box. Depth beats breadth.

Mistake #2: Not Acting on Data

Data without action is trivia. Every insight should generate a response: a price adjustment, an alert rule, a strategic decision. If you're not acting, you're just collecting.

Mistake #3: Ignoring New Entrants

New competitors often grow fastest. Set up alerts for new sellers in your categories. Early warning beats late reaction.

Mistake #4: No Standardized Process

Competitor analysis that happens "when you remember" doesn't work. Set calendar reminders, create standard operating procedures, make it systematic.

Mistake #5: Assuming Stability

Markets change. A competitor who was passive last year might have hired a repricing team. Always verify current behavior, don't assume past patterns hold.

The Math: Why This Pays Off

Let's calculate the ROI of proper competitor analysis:

Scenario: Seller with $40,000/month revenue, 15% Buy Box rate

Without systematic analysis:

• Buy Box rate: 15%
• Monthly sales: $6,000
• Monthly margin (30%): $1,800

With systematic analysis (after 90 days):

• Buy Box rate: 45%
• Monthly sales: $18,000
• Monthly margin (30%): $5,400

Additional monthly margin: $3,600

Cost of template/automation: $0-29/month

ROI: 12,400%

Frequently Asked Questions

How often should I update my competitor analysis?

Minimum: Weekly price updates. Monthly: Full review of all sections. Real-time: Use automated alerts for critical changes (stockouts, major price moves). The key is consistency — better to do weekly updates forever than intense analysis for one month.

How many competitors should I track?

Track your top 5-10 most significant competitors in depth. You can track high-level metrics (price, stock) for 20-30 additional competitors. Beyond that, the marginal value decreases significantly.

Can I automate this entirely?

Yes, with tools like Ecommerce Ops Suite. The template provides the framework and methodology; automation handles the data collection. This frees you to focus on analysis and strategy rather than manual tracking.

What if a competitor has very different pricing strategy?

Document it. Some competitors are always cheap, others are always premium. Some use loss-leaders. Understanding their strategy helps predict their behavior. Your response to a discount-focused competitor differs from your response to a premium competitor.

How do I identify new competitors early?

Use tools that alert on new ASINs in your category. Set Google Alerts for your product names. Monitor new review activity on competing products. New sellers often start with low prices to gain reviews — early detection lets you respond before they establish themselves.

Should I match every competitor price change?

No. Match strategically. Consider: your margins, their significance (market share), duration of your price change, and overall category dynamics. Not every price change deserves a response. Save your moves for moments that matter.