Master Data
Canonical identity layer for hotels and agents. Used to match future reservation exports against existing affiliation analytics.
Canonical hotels
0
Master list
Canonical agents
0
Master list
Hotel aliases
0
Agent aliases
0
Manual overrides pending
0
0 total
Norm collisions
3
Hotel name normalisation
Gmail/Yahoo agents
74
Public-domain warning
Unmatched hotels
285
Missing hotel_email
74 agents using gmail/yahoo domains
Public-domain emails cannot be uniquely tied to an agency. Confirm canonical mappings before reservation ETL.
285 hotels in raw affiliations but missing from hotels_summary
These hotels have no hotel_email and were excluded from summary aggregation. Add canonical entries to recover them.
3 hotel normalised-name collisions
atlantis hotel · onym currated villas · pilio sea horizon hotel
Ekdromi.gr needs manual override
Resolve before the first reservation ETL run, otherwise reservations will be misattributed.
Generate compact aliases
Auto-generate compact / slug variants for every canonical hotel and agent (e.g. "Boss Boutique Athens" → bossboutiqueathens). Run before re-matching an import to dramatically reduce unresolved matches.
Upload master data files
Canonical hotels (master)
Master list of unique hotels (identity layer).
Canonical agents (master)
Master list of unique travel agents (identity layer).
Hotel alias table
Maps raw hotel name variations to canonical hotels.
Agent alias table
Maps raw agent emails to canonical agents.
Agent manual overrides
Human-curated mappings/overrides for ambiguous agents.
Browse master data
Showing first 50 rows.
Loading…