YouTube - Show Total Subscribers

The YouTube API does not directly provide the total number of subscribers but instead gives the daily change in subscriber count. However, there is a workaround for this.

To implement the solution, you need to follow a workflow.

Let's say today is October 15, 2024, you will sum the daily subscriber changes from October 1 up to today, and then add the total number of subscribers as of September 30, 2024, which can be found in the YouTube dashboard. This approach combines the historical subscriber count with the recent changes in the number.

The workflow involves these steps:

1. Download data from YouTube.
2. Calculate the summary metrics by removing all dimensions.
3. Add the "Subscribers Net" metric to track daily changes.
4. Create a final metric, "Subscribers Total," by summing the daily changes and adding the constant value from the September 30 subscriber count.

Once this is set up, you can create a dashboard to track the total number of subscribers.