How do I audit an e-commerce product feed for completeness and search visibility?
Start by verifying core fields: id, title, description, availability, price, link, image_link, brand, and gtin. Common issues:
- Missing or generic titles — improve by adding brand, model, and key attributes
- Short descriptions — expand to 150–300 words where possible and include top keywords naturally
- Inconsistent availability or price formatting — ensure currency and stock sync
- Low-quality image links — use high-resolution images with proper alt text
Checks & metrics:
- Coverage rate — percent of SKUs with all required fields
- Duplicate SKUs — identify by GTIN or normalized titles
- Image quality score — percentage of SKUs with 800px+ images
- Click-through-rate by attribute — test different title formats
Quick fixes:
- Use templates to auto-generate missing fields (e.g., title templates)
- Replace broken image links and standardize file names
- Flag feed rows with missing GTINs for manual review
Tools: use feed validators from shopping platforms, spreadsheet formulas for quick counts, and automated scripts to detect missing fields.