Pavion's real footprint — region hierarchy, operating brands, and the post-acquisition data-grain reality (which offices report actuals vs region-level).
Integrated offices post transactions at office level; recently-acquired ones still record at area/region. The view labels each so actuals are never confused with estimates.
Integrated offices on the common ERP — every transaction booked at office/job grain. Trust as-is.
Integrating offices — some postings still land at area level; AI disaggregates them to office using install base, headcount and job counts.
Recently acquired — recorded only at region/area on legacy systems. The office figure is a modeled estimate until cutover.
1 · Resolve the office. Match legacy IDs, brand names and addresses (RFI San Jose = Office 4021 = Pavion West) into one golden office record — you can't roll up what you can't match.
2 · Tag the grain. Every transaction carries its recording level (office / area / region) and a confidence score, so the view shows actuals vs estimates instead of pretending they're the same.
3 · Disaggregate. For area-level postings, a driver model splits the total to offices by install base, headcount, job counts and payroll — weights learned from integrated offices where both grains exist during cutover.
4 · Reconcile & learn. Allocated office sums must tie back to the area total; anomalies and duplicate customers across brands get flagged. As each office integrates, estimates flip to actuals — coverage is now 87% and rising.
Bubble size = revenue; color = operational health. Hover any office for detail and its operating brand.
Six regions over Pavion's real state footprint.
Brand in parentheses where an acquired entity operates the office.
Bar color = data grain: green actuals · amber allocated · red region-only.
The office-level view — including which acquired offices still report at region level.
| Office | State | Region | Operating brand | Revenue | Office-grain | Recording |
|---|---|---|---|---|---|---|
| Clichy (HQ)HQ | VA | Europe | L'Oréal Groupe (corporate) | $3479.11M | 100% | Actuals |
| Nyack | NY | North America | L'Oréal Paris · 2022 | $2693.5M | 98% | Actuals |
| Woodside | NY | North America | Lancôme · 2021 | $2469.04M | 100% | Actuals |
| San Jose | CA | West | La Roche-Posay · 2023 | $2300.7M | 82% | Allocated |
| Washington | DC | Europe | L'Oréal Groupe | $2244.59M | 98% | Actuals |
| Orlando | FL | Latin America | Star Asset Security / Ion247 · 2023 | $1851.78M | 72% | Allocated |
| Exton (Philadelphia) | PA | North America | Yves Saint Laurent Beauté · 2021 | $1683.44M | 92% | Actuals |
| Atlanta | GA | Latin America | L'Oréal Groupe | $1683.44M | 78% | Allocated |
| Los Angeles | CA | West | L'Oréal Groupe | $1683.44M | 90% | Actuals |
| Boston | MA | North America | L'Oréal Groupe | $1627.32M | 95% | Actuals |
| Hackensack | NJ | North America | L'Oréal Groupe | $1571.21M | 94% | Actuals |
| Denver | CO | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $1458.98M | 92% | Actuals |
| Baltimore | MD | Europe | L'Oréal Groupe | $1346.75M | 96% | Actuals |
| Raleigh | NC | Latin America | L'Oréal Groupe | $1346.75M | 88% | Actuals |
| Dallas | TX | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $1346.75M | 90% | Actuals |
| Mechanicsville | VA | Europe | L'Oréal Groupe | $1234.52M | 97% | Actuals |
| Chicago | IL | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $1234.52M | 72% | Allocated |
| Seattle | WA | West | L'Oréal Groupe | $1066.18M | 90% | Actuals |
| Phoenix | AZ | West | L'Oréal Groupe | $1010.06M | 88% | Actuals |
| Houston | TX | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $1010.06M | 90% | Actuals |
| Norfolk | VA | Europe | L'Oréal Groupe | $953.95M | 95% | Actuals |
| Altamonte Springs | FL | Latin America | L'Oréal Groupe | $897.83M | 90% | Actuals |
| Greer | SC | Latin America | L'Oréal Groupe | $785.61M | 86% | Actuals |
| Portland | OR | West | L'Oréal Groupe | $785.61M | 70% | Allocated |
| Salt Lake City | UT | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $785.61M | 88% | Actuals |
| Nashville | TN | Latin America | L'Oréal Groupe | $729.49M | 74% | Allocated |
| Columbus | OH | South Asia Pacific, Middle East, North Africa | Maybelline New York · 2024 | $729.49M | 80% | Allocated |
| Knightdale | NC | Latin America | L'Oréal Groupe | $673.38M | 88% | Actuals |
| Birmingham | AL | Latin America | ISC (recent acquisition) · 2024 | $617.26M | 45% | Region-only |
| Boise | ID | South Asia Pacific, Middle East, North Africa | L'Oréal Groupe | $505.03M | 50% | Region-only |
| Toronto | CAN | Africa Sub-Saharan | L'Oréal Groupe | $505.03M | 70% | Allocated |
| Tulsa | OK | South Asia Pacific, Middle East, North Africa | Vichy (recent acquisition) · 2024 | $448.92M | 45% | Region-only |
| London | GBR | Africa Sub-Saharan | L'Oréal Groupe | $392.8M | 65% | Allocated |
| Frankfurt | DEU | Africa Sub-Saharan | L'Oréal Groupe | $280.57M | 60% | Allocated |
| Dublin | IRL | Africa Sub-Saharan | L'Oréal Groupe | $224.46M | 48% | Region-only |
| Singapore | SGP | Africa Sub-Saharan | L'Oréal Groupe | $224.46M | 50% | Region-only |
| Tokyo | JPN | Africa Sub-Saharan | L'Oréal Groupe | $168.34M | 45% | Region-only |