top of page

Revenue for theSHAFT

Monetization Pathways

> Digital Advertising

Future: off-campus housing listings

Other Stakeholders

> Spectator (Admin)

> Spectator (Revenue, Ad Sales, Marketing)

> Columbia/Barnard University Life

> Landlords and real estate company clients

Costs of Clubs@CU

> DigitalOcean Droplet

> Work Study for qualified staffers

Future: launch advertising costs

About theSHAFT

full launch Spring 2021

How might we demystify and provide reliable information about on- and off-campus housing for thousands of students

the Shaft housing 101.001.png

Demystifying the System

In Spring 2020, Columbia Housing changed its website, selection, and lottery system.

theSHAFT introduced Housing 101 to answer the most pressing student questions.

the Shaft lottery predictor.001.png

Intelligent Calculations

In Spring 2020, Columbia Housing changed its housing lottery system.

Spectator has kept record for years of past lottery data. We built an algorithm for lottery number conversion that 1. translates new numbers to old system equivalents and 2. visually maps onto floorplans the likelihood students will get certain rooms or suites.

the Shaft dorm review.001.png

P2P Recommendations

Columbia Housing charges the same rates for every room, but students know rooms, suites, and buildings are not created equal.

theSHAFT introduced a crowdsourced review page with upvotes and downvotes to provide current and future students with accurate dorm descriptions.

the Shaft Compare.001.png

Side by Side Comparisons

feature in development

---

Columbia Housing profiles every dorm building, but users--especially first year students--struggle to compare their options.

theSHAFT introduced a side-by-side comparisons page where users can easily mix and match dorms and survey differences in their amenities.

revenue
future

Future for theSHAFT

Covid-19

  1. I project that a record number of Columbia and Barnard students will choose to live off-campus

  2. I predict that it will be at least 5 years until the vast majority (95% pre-pandemic) of Columbia and Barnard students choose live on campus for all 4 years of the undergraduate careers

Proposed Iterations

  1. Off-campus listings designed to showcase clients' properties

  2. Housing 101 for first-time renters in New York City

  3. MAYBE: Off-campus listings for graduate students at Columbia's Medical campus

the Shaft off campus.001.png

Project

Credits

Product Team

Cindy, Product Manager

Mirah, Lead Product Designer

Cecilia, Product Manager

---

Sagarika, Product Designer

Philippe, Product Designer

Aaron, Product Designer

Anissa, Product Designer

Trang, Product Designer

April, Product Designer

Engineering Team

Karlo, Head of Engineering

---

McKenna, Engineering Manager

Elaine, Engineering Manager

Caroline, Engineering Manager

Amina, Engineering Manager

---

Spectator Associate Engineers

full launch Spring 2021

Special thanks to Spectrum writers for writing theSHAFT's content.

credits

© 2023 by David Wang

bottom of page