Maybelline · PIM Alignment Diagnostic
1H26 Master Spec · 951 SKUs ingested · run 19 May 2026 Demo
01 · Master ingest
Your 1H26 MNY master spec ingested and resolved
951 SKUs from
1H26_CPD_Cosmetics_Master_Specs.xlsx processed in 14 seconds. Entity resolution collapsed shade and size variants into product bases. Naming inconsistencies in your own master surfaced before any retailer audit ran.
What we ingested
951
SKUs across 18 product classes
37
Sub-brand groupings
356
Distinct product bases after entity resolution
21
Naming inconsistencies in your master
Top 5 SKU-dense categories
Lipstick
204Foundation
200Mascara
99Concealer
82Eye Shadow
61Your master itself is fragmented
Even before any retailer integration, the same product line is named inconsistently across SKUs in your shipping spec. Three real examples from the file you uploaded:
Fit Me Matte+Pore Foundation — naming variants in your master
Fit Me Matte +Pore Fdn 330 Toffee
Fit Me Matte+Pore Fdn 110Porcelain
Fit Me Matte+Pore Fdn 125Nude Beige
Space-before-plus / missing space / shade name concatenated with shade code — 21 SKUs in this product alone show this pattern.
02 · Cross-retailer comparison
How the same product is described across the LLM's source diet
For each product base, Meridian fetches the live retailer pages, extracts the structured PIM data, and overlays which fields the LLM is actually citing. Below: Fit Me Matte+Pore Foundation (shade 120 Classic Ivory) — the version of this product the LLM is reading from four different sources.
Fit Me Matte+Pore Foundation
SuperStay Matte Ink
Lash Sensational Mascara
Color Sensational Lipstick
Instant Age Rewind
+ 351 more
Your master (canonical)
recommended
Maybelline Fit Me Matte + Poreless Foundation
Shade format
120 Classic Ivory
Coverage
Natural, buildable
Finish
Matte
Skin type
Normal to oily
Key ingredient
Micro-powder pore minimisers
Volume
30 ml / 1.0 fl oz
Amazon
cited 84%
Maybelline New York Fit Me Matte + Poreless Liquid Foundation Makeup, 120 Classic Ivory, 1 Count
Shade format
120 Classic Ivory
Coverage
"Buildable to Medium"
Finish
Natural Matte
Skin type
Combo, oily
Key ingredient
Not surfaced in PDP
Volume
1 fl oz
Sephora
cited 51%
Fit Me Matte + Poreless Foundation by Maybelline
Shade format
120 — Classic Ivory
Coverage
Medium
Finish
Matte / Natural
Skin type
Oily / Combination
Key ingredient
Mineral powder, perlite
Volume
1 fl oz / 30 ml
Ulta
cited 67%
Maybelline Fit Me! Matte+Poreless Foundation
Shade format
Classic Ivory 120
Coverage
Lightweight
Finish
Matte
Skin type
Normal, oily, combo
Key ingredient
Not surfaced
Volume
1 oz
03 · Attribute impact analysis
Which PIM attributes actually govern AI outcomes
Of the 300+ attributes in your PIM schema, 12 explain roughly 80% of cross-retailer LLM citation variance. Each row below shows how often the LLM cites that attribute, how consistent it is across your retailer footprint, and the impact on AI outcomes when it's inconsistent. Start with the high-impact, low-consistency attributes.
Attribute
LLM citation frequency
Cross-retailer consistency
AI outcome impact
Priority
Product name formatCanonical brand + line + product type structure
92%
24%
High
1
Skin type / use caseWho the product is for
88%
31%
High
2
Coverage / finishPerformance descriptor
85%
38%
High
3
Shade name / code formatNumbering and naming conventions
78%
42%
High
4
Key ingredientsWhat's in the product
81%
19%
High
5
Volume / sizeUnit and format declaration
64%
56%
Medium
6
Vegan / cruelty-free claimsEthical-claims block
71%
33%
Medium
7
Application instructionsHow-to-use text
58%
62%
Medium
8
Comparable products & dupesCross-brand positioning and alternatives
52%
47%
Medium
9
Long-wear / claimsDurability and performance claims
49%
78%
Low
10
SPF / sun protectionSPF declaration where relevant
28%
84%
Low
11
Country of originManufacturing origin declaration
14%
91%
Low
12
04 · Remediation output
The deliverable to your PIM team
Per product base, Meridian outputs a canonical master record and the field-level corrections required at each retailer. Format below is JSON-style for clarity; live exports support CSV, JSON, and direct push into Salsify, Akeneo, Stibo, and inRiver. Highlighted lines are the recommended fixes.
Canonical master record
✓ recommended
product_id: "MNY-FITME-MATTEPOR-FDN"
parent_brand: "Maybelline New York"
sub_brand: "Fit Me"
product_line: "Matte + Poreless"
product_type: "Foundation"
canonical_name: "Maybelline Fit Me Matte + Poreless Foundation"
coverage: "Natural, buildable to medium"
finish: "Matte"
skin_type: ["Normal", "Combination", "Oily"]
key_ingredients: ["Micro-powders", "Perlite"]
benefits: ["Pore-minimising", "Natural finish", "Buildable coverage"]
volume_ml: 30
volume_oz: 1.0
shade_format: "{code} {name}"
shade_count: 21
cruelty_free: true
claims: ["Pore-blurring", "16-hour wear"]
Per-retailer corrections required
12 fixes identified
amazon:
product_name: remove "Liquid" + "Makeup, 120 Classic Ivory, 1 Count"
coverage: change "Buildable to Medium" → "Natural, buildable to medium"
skin_type: add "Normal" to current ["Combo", "oily"]
key_ingredients: add field — currently not surfaced
sephora:
product_name: change "by Maybelline" → prefix "Maybelline" instead
shade_format: change "120 — Classic Ivory" → "120 Classic Ivory"
coverage: "Medium" → "Natural, buildable to medium"
finish: "Matte / Natural" → "Matte"
ulta:
product_name: remove "!" — "Fit Me! Matte+Poreless" → "Fit Me Matte + Poreless"
shade_format: "Classic Ivory 120" → "120 Classic Ivory"
coverage: "Lightweight" → "Natural, buildable to medium"
key_ingredients: add field — currently not surfaced
internal_master:
emd_column: standardise to "Fit Me Matte + Poreless Fdn {shade}" (21 SKUs)
05 · Portfolio scale
What this looks like across Maybelline US (and beyond)
The diagnostic surfaces 23 product bases with critical PIM fragmentation (high LLM citation × low cross-retailer consistency), 84 with material gaps, and 249 with minor inconsistencies. Most remediations are field-level and immediately operationalisable by your PIM team.
23
Critical PIM gaps
High citation × low consistency
84
Material gaps
Cross-retailer alignment needed
249
Minor inconsistencies
Field-level corrections
$40M
Est. annual revenue lift (Illustrative)
Recovers $8.6M at-risk + ~10% of $327M opportunity
This diagnostic ran on Maybelline US, 1H26. The same engine processes every brand in your portfolio.
L'Oréal CPD ships ~10 brands across cosmetics, haircare, and skincare. Run quarterly, the diagnostic identifies which PIM attributes are weakest, where the consistency gaps sit per retailer, and what specific corrections will move AI outcomes. The output integrates directly into your existing PIM platform.
Pricing scopes to portfolio breadth, retailer footprint, and refresh cadence. The figures below are illustrative starting points pending scope confirmation.
Brand pilot
Single brand, 3 categories, quarterly cycle. Baseline diagnostic + remediation output for one PIM platform.
Division enterprise
Full division (e.g. CPD), all brands, all categories, quarterly cycle. Full PIM platform integration, dedicated success team.
Group programme
All divisions, all geographies, all retailers. Continuous monitoring, custom integrations, agentic commerce task force support.