Spreadsheet to Calculate Performance Needed for New YPP


Hey Youtubers, I found a thread on reddit with a useful spreadsheet that calculates the performance you need by Feb. 20th to stay within YouTube's new partnership program. Just plug in your stats (watch time and subscribers) and it breaks down your actual performance vs. recommended performance in order to hit 240,000 minutes of watch time and 1,000 subscribers.

Click here to use the spreadsheet and follow the instructions below:

  • Go to File > Make a copy... and save it to your own Google Drive so you can modify it.

  • Remove everything from both columns labelled "Position", as these are my own stats; they only serve as an example and won't suit your channel.

  • Go to your own YouTube channel analytics and start copying your stats from January 18 until the present date. Note that the watchtime minutes should only include your minutes from the last 365 days.

  • Scroll to the bottom and see the graphics for a visual representation of your progress.

  • Update every day until the 20th.
  • Also keep in mind that YouTube's stats can be delayed