Dave Ramsey

Jun 14, 20221 min

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

    320
    0