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.