LarryvsLamps

Head to head

Subscribers over time

Total views over time

Top videos this period

Ranked by views across both channels. Click one to see why it worked.

Every video

Each mark is one upload. Higher is more views; circles are long-form, diamonds are Shorts.

Video Published Format Views Likes Like rate Comments CTR Avg viewed Verdict

Shorts vs long-form

Per channel, videos published in the period.

Packaging vs content

Click-through rate against average percentage viewed, from YouTube Studio exports.

How the numbers update

Views, subscribers, likes, comments

Refreshed automatically every morning at 6:00 New York time by a scheduled job in the GitHub repository. Each run adds one point to the growth lines. Nothing to do.

Click-through rate and retention (YouTube Studio)

These are private to each channel owner, so they come from a YouTube Studio export:

  1. In YouTube Studio: Analytics → Advanced mode → Content tab. Add the columns Impressions, Impressions click-through rate, Average view duration, Average percentage viewed. Date range: Lifetime. Export → CSV.
  2. Unzip the download to find Table data.csv.
  3. Click Upload Studio CSV at the top of this page, pick the channel and the file. The first time it asks for a GitHub token; the dialog explains how to get one. The numbers show on your screen straight away and the shared dashboard rebuilds within a few minutes.
  4. The dashboard rebuilds within a few minutes.

Names, colors, Shorts rule

Edit data/config.json in the repository. Marking a single video as a Short or long-form from its details panel is remembered in this browser only.

Open the repository

Upload a YouTube Studio export

Adds click-through rate and retention for one channel. In YouTube Studio: Analytics → Advanced mode → Content tab, with the columns Impressions, Impressions click-through rate, Average view duration and Average percentage viewed. Date range Lifetime → Export → CSV. Unzip the download to find Table data.csv.

How to get a token (about 2 minutes)
  1. On github.com, click your profile picture → Settings → Developer settings (bottom of the left menu) → Personal access tokens → Fine-grained tokens → Generate new token.
  2. Name: anything. Expiration: pick the longest offered.
  3. Repository access: Only select repositories → choose LarryVsLamps.
  4. Permissions → Repository permissions → Contents → Read and write.
  5. Generate, copy the token, paste it above. It is stored in this browser and never leaves it except to talk to GitHub.

A friend uploading their own channel needs to be added as a collaborator on the repository first (repository Settings → Collaborators), then makes their own token the same way.