Listing Opportunity Analysis

Enter access PIN to continue

Glossary & FAQ

Opportunity Definition
What is an "Opportunity"?
A product (EAN) that Brack does not currently sell. Specifically, it must meet all three conditions: Exact EAN Listed (Crawling) = NO, Exact EAN Listed (File) = NO, and Variant Listed = NO. If any of these is YES, the product is already considered listed.
What does "Listed" mean?
A product is "Listed" if Brack already sells it — either found on the website via crawling, present in the product feed file, or a variant match was found. Listed products are excluded from opportunities.
What is an EAN?
European Article Number — a 13-digit barcode that uniquely identifies a product. Each row in the dataset represents one unique EAN.
Priority Tiers
What is GOLD tier?
The highest-priority opportunities. These are products that Galaxus sells AND have verified sales data (GfK or Amazon). They represent proven demand from a direct competitor — listing these products is the #1 priority.
What is SILVER tier?
High-priority products that meet one of two conditions: (a) Galaxus sells them (but no verified sales data), OR (b) they have verified sales data AND at least one supplier available. Still strong candidates for listing.
What is BRONZE tier?
Medium-priority products that have some signal but weaker evidence: either sales data without a supplier, or a supplier without sales data. Worth investigating but lower urgency than Gold/Silver.
What is EXPLORE tier?
Products with no market signal — no Galaxus listing, no GfK/Amazon sales, no supplier. These exist in the market but require manual research to evaluate potential.
Scoring System
How is the Opportunity Score calculated?
Each product receives a composite score based on five weighted signals:
Galaxus: +10,000 points if the product is sold by Galaxus (main competitor)
GfK Sales: CH+DE+AT combined sales value, capped at 5,000 points
Amazon Sales: CH+DE+AT combined sales value, capped at 3,000 points
Market Reviews: review count × 2, capped at 500 points
Suppliers: number of suppliers × 200 points
Higher score = stronger listing recommendation.
Market Size & Revenue
What is "Addressable Market (GfK)"?
The total GfK-tracked retail sales value (in CHF) across CH, DE, and AT for all products identified as opportunities. This represents the verified market size that Brack could participate in by listing these products. Current value: ~CHF 2.8B.
What is "Market Signal (Amazon)"?
The total Amazon sales value across CH, DE, and AT for opportunity products. Amazon data serves as a demand proxy — it indicates consumer interest but is not a direct revenue prediction. Think of it as a complementary signal to GfK.
What is the "Galaxus Gap Value"?
The total GfK-tracked market value of products that Galaxus sells but Brack doesn't. This is the most actionable metric — it quantifies the direct competitive disadvantage in CHF.
What does "Gold Tier Revenue" represent?
The combined GfK + Amazon market value of all Gold tier products. This is the highest-confidence revenue opportunity because these products have both competitive evidence (Galaxus) and verified sales.
Are these values direct revenue projections?
No. These are total market sizes, not Brack's expected share. Actual revenue depends on market share capture rate, pricing, and conversion. However, they provide a reliable sizing of the opportunity.
Why are these monthly values?
The sales data represents one month of market activity. Products rotate in and out of active sales each month. The ~68K products with sales today are only a fraction of the 2.9M total opportunities. Next month, different products will appear. This is why continuous catalog management is essential — a one-time listing of today's top sellers misses the dynamic nature of the market.
Data Sources
What is GfK?
GfK (now NIQ) is a market research company that tracks actual point-of-sale retail data across Switzerland (CH), Germany (DE), and Austria (AT). GfK values represent verified retail sales in CHF/EUR.
What is the Amazon data?
Estimated Amazon sales from the German (DE) marketplace only. Used as a demand signal — products with high Amazon DE sales indicate strong consumer interest even if GfK doesn't track the category.
What does "Galaxus" mean in this context?
Galaxus.ch is Switzerland's largest online retailer and Brack's main competitor. If a product is "Listed by Galaxus = YES," it means the competitor already sells it. These products are prioritized because customers may be buying from Galaxus instead of Brack.
What are "Suppliers"?
The number of wholesale suppliers known to carry a product. More suppliers means the product is easier to source and more likely to have competitive wholesale pricing.
What are "Segments"?
Product categories mapped to the Google Product Taxonomy — a standardized classification of 5,000+ product types (e.g., "Electronics > Computers > Laptops"). Segments allow analysis across comparable product groups.
Dashboard Navigation
Who is each tab for?
Overview — CEO / Executive level: market sizing, total opportunity value, high-level KPIs.
Segments, Galaxus Gap, Brands, Categories, Suppliers — Director level: drill into specific dimensions to build a listing strategy.
Top Products — PM level: the top 500 individual products ranked by score.
Explorer (2.9M) — PM level: search, filter, and export across all 2.9 million opportunities (requires the Python server running).
How does the Explorer work?
The Explorer tab connects to a local Python server (brack_server.py) that queries a 1.5GB SQLite database containing all 2.9M opportunities. Run python3 brack_server.py from the same folder, then use the Explorer tab to search, filter, sort, and export to CSV.
Country Data
Why are CH, DE, and AT shown?
CH = Switzerland (Brack's home market), DE = Germany, AT = Austria. GfK data is tracked separately for each country. Amazon data comes from Germany (DE) only. The combined value gives a fuller picture of demand, though CH is typically the primary focus for Brack's listing decisions.
Catalog Strategy
Is listing 68K products enough?
No. The ~68K products with sales this month are a snapshot. The market rotates — different products sell each month as seasons change, trends shift, and new products launch. Managing 2.9M SKUs requires continuous intelligence: automated content creation, supplier integration, competitive monitoring, and dynamic prioritization.
What does "the market rotates" mean?
A product that sold well in January may not appear in February's data, and vice versa. Seasonal items, new launches, and trend shifts mean the active catalog changes every month. A static list quickly becomes outdated.

Executive Overview

— How much money is on the table? Data: December 2024

Revenue Opportunity
Market Distribution (GfK)
Top Segments by GfK Value
Priority Tiers
Monthly Sales by Country

Market Segments

— Google Product Taxonomy Dec 2024

Galaxus Competitive Gap

— Products Galaxus sells that Brack doesn't

Gap Value by Segment (GfK)
Tier Distribution

Top 500 Opportunities

— Ranked by Galaxus + sales + suppliers Dec 2024

#TierEANBrandSegmentCategoryProductGalaxusSupp.🇨🇭🇩🇪🇦🇹 GfK🇨🇭🇩🇪🇦🇹 Amz DEReviewsRatingScore

Brands

— Top 300 Dec 2024

#BrandSegmentTotalOppsListedGalaxusWith Sales🇨🇭🇩🇪🇦🇹 GfK🇨🇭🇩🇪🇦🇹 Amz DEAvg Supp

Categories

— Top 300 Crawlo Dec 2024

#CategorySegmentTotalOppsGalaxusWith Sales🇨🇭🇩🇪🇦🇹 GfK🇨🇭🇩🇪🇦🇹 Amz DE
Top 15

Supplier Strategy

— Suppliers & market value Dec 2024

Opportunities by # Suppliers
Market Value by # Suppliers
Detail

Product Explorer

— Browse all 2.9M opportunities live from the database