Search
  • Dave Ramsey

Decent Espresso Machine Youtube Competition by Subscriber/Commenter Analysis



Table column details (see youtube links and detailed explanation below):

  • c_subCount: Total subscribers that the channel has

  • comsubCount: Number of Decent commenters that also subscribe to that channel (of the ~500 we can see)

  • c_views: Number of total views that channel has on all its videos combined

  • c_topicCats: Categories youtube has automatically added to describe each channel.


Emilee Bryant https://www.youtube.com/channel/UCN6R2iBmZ4N30ruHAhG34Kw Kakadu Coffee https://www.youtube.com/channel/UCQgeBSc3Nfy4IU0dtSkRmkw Tim Wendelboe https://www.youtube.com/channel/UCCyw4GaWJHezSUowFJ_uH0A Japanese Knife Imports

https://www.youtube.com/channel/UCpgJbCAVxzDHKaKYeuGYyOA Coffee with April https://www.youtube.com/channel/UCPlsOYZ8ZEam57EUCf3DKjg Home Cafe by Charlie https://www.youtube.com/channel/UCvzv9fsofrazOYNwoARrzag Flair Espresso https://www.youtube.com/channel/UC_t7lJPh4kpIxgdRmTFi1Qg The Coffee Chronicler https://www.youtube.com/channel/UCRX8EMfveYR35Z8PGmlYnpw World Coffee Championships https://www.youtube.com/channel/UCj3EGvvThysiDzBM20BabWw Xris https://www.youtube.com/channel/UCzedlV167cDQGELivcCx_eg Decent Espresso Machines https://www.youtube.com/channel/UCCXojfo44Qhwdg3zmOWIJ7A Coffee Kev https://www.youtube.com/channel/UCJ8SVN2eg7v82-1qr2eNO6A LELIT https://www.youtube.com/channel/UC0Ih6-0BSVnPne9IbpDtIXQ


More Detailed Explanation:


Using the Youtube API I pulled all the Youtube comments from the "Decent Espresso Machines" channel. I then pulled the data showing all the subscriptions for ~500 of those commenters. I then pulled the channel data for the top 2000 of those channels we will call Overlappers. Overlappers are simply the channels that "Decent Espresso Machines" commenters have subscribed to.

With that data, I found the channels with similar view counts(c_views) and subscriber counts(c_subCount).




A Little Extra


Below are the overlappers listed from most overlapping subscriptions to least:



James Hoffmann https://www.youtube.com/channel/UCMb0O2CdPBNi-QqPk5T3gsQ Decent Espresso Machines https://www.youtube.com/channel/UCCXojfo44Qhwdg3zmOWIJ7A Lance Hedrick https://www.youtube.com/channel/UCR2_8uHyWcTSV6iIw6BN4rg The Real Sprometheus https://www.youtube.com/channel/UCiolFxnJSOPMmV1mh9EYyIQ RealChrisBaca https://www.youtube.com/channel/UCvHTmlCbEhgDvC5VdpVAG2A Whole Latte Love https://www.youtube.com/channel/UCJwRmBtnYh_7Xs9oXUrLhZg Seattle Coffee Gear https://www.youtube.com/channel/UC9VhfQi-D-7morDdwjVcJPA Marques Brownlee https://www.youtube.com/channel/UCBJycsmduvYEL83R_U4JriQ Brian Quan https://www.youtube.com/channel/UCwT72F8AWH-nbQYs-1GUBZQ Linus Tech Tips https://www.youtube.com/channel/UCXuqSBlHAE6Xw-yeJA0Tunw European Coffee Trip https://www.youtube.com/channel/UC3KGOt3IfrVxDNtz5o7H-5A Kyle Rowsell https://www.youtube.com/channel/UCRTZoFxKaJuy5ZNVK7iNbUg Scott Rao https://www.youtube.com/channel/UCK4gK5SD-nncb4wtKX647ag Veritasium https://www.youtube.com/channel/UCHnyfMqiRRG1u-2MsSQLbXA Alex https://www.youtube.com/channel/UCPzFLpOblZEaIx2lpym1l1A Joshua Weissman https://www.youtube.com/channel/UChBEbMKI1eCcejTtmI32UEw Babish Culinary Universe https://www.youtube.com/channel/UCJHA_jMfCvEnv-3kRjTCQXw SmarterEveryDay https://www.youtube.com/channel/UC6107grRI4m0o2-emgoDnAA Seven Miles Coffee Roasters https://www.youtube.com/channel/UCZQQDp_XZL1AkZ36ToAU_mw



19 views0 comments

Recent Posts

See All