airbnb host campaign
How does AirBnB increase bookings in N.Y.C. when Covid-19 is ravaging the city’s Travel & Hospitality industry ? They encourage hosts to cater to other remote-working New Yorkers looking to escape to more spacious outer boroughs, by adopt a longer-term rental strategy.
created using:
-
Constructed dataset and conducted more in-depth data queries through use of SQL and PostgreSQL.
-
Automated data cleaning and formatting through use of Javascript and Google Apps Script within Google Sheets.
-
Visualized host popularity and geographic data through use of Tableau.
-
Automated customized outreach via E-mail to the target audience through use of Y.A.M.M. software.
-
Located and downloaded this interesting dataset from Kaggle.
raw data
cleaned data
To identify and target the correct audience, the dataset was formatted to easily filter between qualifying criteria such as borough, average number of reviews, and minimum nights required by the host.
To automate the data cleaning process, YouTube tutorials were used to learn rudimentary Javascript. This knowledge permits me to create data formatting algorithms in Google Apps Script.
Dataset: Kaggle’s New York City Airbnb Open Data
Constructing the database with Postgresql.
querying the database for multiple quality criteria.
To identify
visualizing the most desirable neighborhoods, and highly-rated hosts in n.y.c.’s outer boroughs.
connecting with prospects via y.a.m.m.
The final step of the process is to contact the hosts en masse using Y.A.M.M. (Yet Another Mail Merge)
1) Compose Y.A.M.M. e-mail format.
2) Create Y.A.M.M. Database.
3) Run Y.A.M.M. to disperse E-mails.
1. Create Y.A.M.M. Database.
2. Compose Y.A.M.M. E-mail.
3. Disperse Y.A.M.M. E-mails.