Airtable Influencer Database
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.
Blog Post from March 31, 2020
![](https://assets-global.website-files.com/5de460693719a10ef1ede46d/627cb63a323e468303f012c7_CleanShot%202022-05-12%20at%2000.23.51.png)
![](https://assets-global.website-files.com/5de460693719a10ef1ede46d/627b13b02d64480f6c76f848_CleanShot%202022-05-10%20at%2018.38.25.png)
![](https://assets-global.website-files.com/5de460693719a10ef1ede46d/627b13ba1766d057884b9ebd_CleanShot%202022-05-10%20at%2018.38.08.png)
![](https://assets-global.website-files.com/5de460693719a10ef1ede46d/627b140923a3b7cf92788a64_CleanShot%202022-05-10%20at%2018.39.30.png)
![](https://assets-global.website-files.com/5de460693719a10ef1ede46d/627b14164b2b244eeb7c1955_CleanShot%202022-05-10%20at%2018.39.59.png)
![](https://assets-global.website-files.com/5de460683719a12c11ede445/5de460693719a1edbaede45e_Surface%20Pro%20Mockup%20-%20front-min.jpg)
![](https://assets-global.website-files.com/5de460683719a12c11ede445/5de460693719a1923cede460_Surface%20Pro%20Mockup%20-%20Side.jpg)
![](https://assets-global.website-files.com/5de460683719a12c11ede445/5de460693719a147f5ede45d_Surface%20Pro%20Mockup%20-%20Side%20knob-min.jpg)