WB/Ozon Product Card SEO: Excel Template for Keywords and Tags

Product description

LISTING SEO IN ONE HOUR — WITH A REAL KEYWORD CORE AND AN AUDIT

An Excel template for Wildberries and Ozon: a semantic core with automatic phrase priority, a listing audit (title length, description volume, characteristics), an SEO score of 0-100 and competitor analysis.

EXAMPLE FROM THE SCREENSHOT (real calculation of the workbook):

• The core: 15 phrases with 290 500 impressions a month in total
• The example title: 60 characters at a 60-character limit
• The example's SEO score: 80/100 — status "Good"

WHAT'S INSIDE (one xlsx, no macros):

• The "Keywords" sheet: 15 phrases, frequency, competition, priority
• The priority formula: a balance of reach and competition with adjustable weights
• The "Listing" sheet: an audit of the title, description and characteristics with statuses
• A total SEO score of 0-100 across five criteria
• The "Competitors" sheet: 5 examples with a revenue estimate and a price delta
• A 10-point checklist with automatic readiness in percent
• All formulas are open — easy to add your own phrases and rows

WHO IT'S FOR:

Wildberries and Ozon sellers. Paid analytics services cost from 5000 RUB a month, while here the whole method sits in one workbook you can reuse for any product.

FORMAT: .xlsx, works in Excel and Google Sheets. Instant file delivery after payment.