Ulta Beauty

Royal Oak, MI 48067 · O205e7a24e1f7 · first seen 2026-10-08
3 sourcesoff premise · retail_otherchain: ULTAalcohol: no alcohol retail

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
Ulta Beauty 1 other
the most common name a source states
ulta beauty royal oak doordash
Street
27844 Woodward Ave 1 other
ubereats
27844 Woodward Avenue overture
City
Royal Oak
ubereatsno other value
State
MI
ubereatsno other value
ZIP
48067
ubereatsno other value
Pin
42.49489, -83.16327 map
ubereatsno other value
Phone
2483991081
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa38d2c309fa8; O7d052cc0ecbe

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
doordashulta beauty royal oak
28587994
27844 Woodward Ave, Royal Oak, MI, 4806742.49495, -83.163322026-10-082026-11-06
overtureUlta Beauty
ff1ade49-6f26-4876-b529-d823fa90ba43
27844 Woodward Avenue, Royal Oak, MI, 48067248399108142.49496, -83.163252026-11-062026-11-06
ubereatsUlta Beauty
1LT3m_hCVAS3jzOjVcPs3w
27844 Woodward Ave, Royal Oak, MI, 4806742.49489, -83.163272026-10-112026-11-06

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
doordash ulta beauty royal oakoverture Ulta Beauty1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
doordash ulta beauty royal oakubereats Ulta Beauty1.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
overture Ulta Beautyubereats Ulta Beauty1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00

Attributes

Channel
off_premise · retail_other — ubereats-type
Chain
ULTA — ubereats-parent
Alcohol
no_alcohol_retail — ULTA: licensed at 0 of 556 outlets in licence states
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "retail_other"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
51 within 1 mi · 803 within 3 mi
Off / on premise
13 / 21 within 1 mi · 193 / 439 within 3 mi
Selling alcohol
33 within 1 mi · 423 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (5,018 people per sq mi)
People within 3 mi
141,874 (115,124 adults 21+, 66,946 households) from 46 tract(s), tracts within 3 mi
Income
per capita $58,108 · median household ~$98,571 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 56%
Ethnicity
Hispanic 4% · White 73% · Black 16% · Asian 3%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$50,095,875 a year ($22,509,122 at home, $27,564,984 away) · $118,430 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-06 18:13insertoverture ff1ade49-6f26-4876-b529-d823fa90ba43 ↔ ubereats 1LT3m_hCVAS3jzOjVcPs3wsame address and namemerged11
2026-11-06 18:13insertdoordash 28587994 ↔ overture ff1ade49-6f26-4876-b529-d823fa90ba43same address and namemerged11
2026-10-18 21:02backfilldoordash 28587994 ↔ ubereats 1LT3m_hCVAS3jzOjVcPs3wsame address and namemerged