The question
Which ingredients are in the skincare people buy, how common is each one, and what do the products that contain it cost? Brand teams ask this to position a launch. Ingredient suppliers ask it to size demand. Analysts and journalists ask it to check whether a trend is real.
Marketing copy cannot answer it. A product described as “with niacinamide” may or may not list it, and many products contain an active without advertising it. The answer is in the ingredient list itself.
The data that answers it
The Sephora US Product Catalogue holds one row per product with its brand, category path, prices and rating, and a linked details table with the complete ingredients text for each product. Joining the two gives every skincare product with its formulation, price and category.
Worked example: the most common actives
Share of 2,328 skincare products whose ingredient list contains each active.
| Active ingredient | Products | Share | Median price | Average rating |
|---|---|---|---|---|
| Vitamin E | 1,525 | 65.5% | $37 | 4.42 |
| Hyaluronic acid | 1,082 | 46.5% | $38 | 4.42 |
| Squalane | 612 | 26.3% | $38.50 | 4.46 |
| Niacinamide | 593 | 25.5% | $34 | 4.47 |
| Peptides | 541 | 23.2% | $45 | 4.43 |
| Panthenol | 473 | 20.3% | $32 | 4.47 |
| Vitamin C | 409 | 17.6% | $43 | 4.39 |
| Ceramides | 361 | 15.5% | $30 | 4.52 |
| Salicylic acid | 211 | 9.1% | $35 | 4.49 |
| Glycolic acid | 134 | 5.8% | $42 | 4.52 |
Two things stand out. Peptide products carry the highest median price in the table, at $45. Ceramide products are among the cheapest, at $30, and share the highest average rating, 4.52.
Worked example: formulation by category
| Category | Products | Median ingredients per product | Fragrance-free | Hyaluronic acid | Niacinamide | Vitamin C | Retinoids |
|---|---|---|---|---|---|---|---|
| Face serums | 444 | 34 | 77.9% | 56.8% | 34.5% | 24.3% | 11.7% |
| Moisturisers | 593 | 38 | 69.0% | 57.8% | 26.5% | 18.7% | 4.9% |
| Cleansers | 396 | 27 | 72.0% | 32.6% | 16.4% | 10.9% | 2.0% |
| Sunscreen | 182 | 35 | 66.5% | 46.2% | 26.4% | 15.4% | 2.2% |
| Masks | 161 | 35 | 67.1% | 49.7% | 36.6% | 18.6% | 3.7% |
| Eye care | 173 | 41 | 80.9% | 63.6% | 30.6% | 34.1% | 15.0% |
Eye care products have the longest formulas, with a median of 41 ingredients, and the highest share of retinoids. Among sunscreens with a readable list, 39.5% use mineral filters alone, at a median price of $38.
Run it yourself
On the delivered Parquet files, the niacinamide share of skincare is one query:
SELECT count(*) AS skincare_products,
count(*) FILTER (WHERE d.ingredients ILIKE '%niacinamide%') AS with_niacinamide,
round(100.0 * count(*) FILTER (WHERE d.ingredients ILIKE '%niacinamide%') / count(*), 1) AS share_pct
FROM 'products.parquet' p
JOIN 'product_details.parquet' d USING (productId)
WHERE p.categoryPath LIKE 'Skincare%'
AND d.ingredients IS NOT NULL;
Swap the search term to test any ingredient, add brandName to the grouping to compare brands, or join the price history table to see how products with a given active are priced over time.
Going further
- By brand: which brands lead on a given active, and which have none.
- By price tier: whether an ingredient is moving from prestige into mass products.
- With reviews: join the Sephora US Customer Reviews dataset on product to see how products with an ingredient are rated by skin type or concern.
- Over time: daily recording shows when reformulated or new products enter the range.
An ingredient extract can be delivered on its own, with one row per product and ingredient.