Airtable wanted to track the results of the American Song Contest reality TV competition hosted by Snoop Dogg & Kelly Clarkson. For 8 weeks, we pulled social media data & tracked competition progress.
NBC's American Song Contest brought together recording artists from all US States & Territories to compete in an 8-week competition. Airtable's Marketing & PR team was ready to build a case study around what Airtable can do with the right data. I built an Airtable base to pull in, monitor and track social media data for all of the contestants. From here, I programmatically measured contestants' growth across Twitter, Instagram, Youtube and Spotify while also pulling in episode ratings and sentiment via IMDb & Trakt's APIs. To get an apples-to-apples comparison, I built a weighted aggregate score that was used to predict who won the competition.