tier-timezone

name	tier-timezone
description	Add `tier` (T1/T2), `timezone` (NY/BER), and `saocilproof` (region codes) columns to a CSV file. Columns are appended after existing ones — no other data is changed. Use when user says "раздели по тайрам", "присвой таймзоны", "tier и timezone", "размечай CSV", "добавь тайр и тз", "region mapping", "tier-timezone", or asks to classify leads by tier, timezone, and social proof region in a CSV.

Tier & Timezone & Social Proof — CSV Classifier

Adds three columns to a CSV — tier (T1/T2), timezone (NY/BER), and saocilproof (region code) — appended after the existing columns. Nothing else is touched.

Logic (mirrors deep-personalization/csv_to_contacts.py)

Timezone:

• NY — US, Canada, LATAM (Brazil, Mexico, Argentina, Chile, Peru, Ecuador, Uruguay, Colombia, Venezuela, Bolivia, Paraguay)
• BER — everything else

Tier:

• T1 if ALL of:
  • seniority ∈ {FOUNDERS, TECHLEAD}
  • company_size in 5..100 (numeric or parses as such; 1-4, 2-5, 201+, 500+ → T2)
  • country ∈ T1_GEOS (US/UK/AU/CA) OR EU OR (India with size ≥ 10)
• otherwise T2

Social Proof (saocilproof):

• Maps company_name to a region code based on these definitions:
  • UK — Whalar, InfluencerUK, LADbible, Billion Dollar Boy
  • DE — Zalando, Linkster, Intermate, Gocomo
  • FR — Kolsquare, Skeepers, Ykone, Favikon
  • IN — Phyllo, KlugKlug, Qoruz, Tonic Worldwide
  • AU — TRIBEGroup
  • MENA — ArabyAds, Sociata
  • OTHER — Whalar, Kolsquare, Billion Dollar Boy (fallback for universal companies in unknown regions)
• Empty string if company not in any region mapping

Recognized input columns (case-insensitive aliases)

• country: country, Company location, company_location, Country
• seniority: seniority, Seniority (uppercased before matching)
• company_size: company_size, Company size, size, Size
• company_name: company_name, Company name (for social proof mapping)

If tier / timezone / saocilproof already exist in the input header, they are overwritten in place (column order preserved).

Usage

python3 /Users/user/sales_engineer/.claude/skills/tier-timezone/scripts/tier_timezone.py \
  /absolute/path/to/input.csv \
  [-o /absolute/path/to/output.csv]

Default output: <input>-tiered.csv next to the input.

Reporting (after run)

Always report to the user:

• rows in / rows out
• tier counts: T1 / T2
• tz counts: NY / BER
• region counts (if any matches): UK / DE / FR / IN / AU / MENA / OTHER
• output path