Skip to content

Google Sheet Setup Instructions

✅ What's Already Done

  1. Google Sheet Created: Nutri-E YouTube Analytics Tracker
  2. CSV Data File Created: youtube_analytics_data.csv (in this repo)
  3. Baseline Data Collected: Vitamin D has 7 views (42.9% Channel, 42.9% Shorts Feed, 14.3% Search)

📊 How to Import the CSV Data

Method 1: Import CSV (Easiest - 2 minutes)

  1. Open the Google Sheet: https://docs.google.com/spreadsheets/d/1VEtSIszQM_5gUfpqezgYKNJmf37JP0aDLN0S8D0RMpQ/edit

  2. Import the CSV file:

  3. Click File → Import
  4. Click Upload tab
  5. Drag youtube_analytics_data.csv from this repo
  6. Import location: Replace current sheet
  7. Separator type: Comma

  8. Click Import data

  9. Done! The sheet is now populated with:

  10. All 3 optimized videos
  11. Baseline comparison data
  12. Tracking checkpoints (+1h, +24h, +7d)
  13. YouTube URLs for quick access

Method 2: Copy/Paste (Alternative)

  1. Open youtube_analytics_data.csv in a text editor
  2. Select all (Cmd+A), copy (Cmd+C)
  3. Open the Google Sheet
  4. Click cell A1
  5. Paste (Cmd+V)
  6. Done!

📋 Sheet Structure

Columns Explained

Column Purpose Example
A - Date/Time When to check "Nov 1 2025 - +1 hour"
B - Video Name Which video "Vitamin B12 (Optimized)"
C - Views Total views 245
D - Comments Comment count 12
E - Likes Like count 18
F - CTR % Click-through rate 8.5%
G - Avg View % Average view duration 42%
H - Traffic Source Where views came from "Shorts Feed"
I - Notes Observations "Algorithm picked up!"
J - YouTube URL Direct link https://youtube.com/shorts/...

Key Tracking Points

For Each Video: - ✅ Launch (midnight CET) - ✅ +1 hour (First hour is critical!) - ✅ +6 hours (Mid-day check) - ✅ +24 hours (MOST IMPORTANT - Algorithm decision point) - ✅ +48 hours (Algorithm pickup confirmation) - ✅ +7 days (Weekly performance review)

🎯 How to Use the Tracker

Daily Workflow

Nov 1, 10am CET (B12 video +1 hour): 1. Open YouTube Studio: https://studio.youtube.com/video/7t1pDSw-xYY/analytics 2. Note down: Views, Comments, Likes, CTR%, Avg View%, Traffic Source 3. Fill in the "Nov 1 2025 - +1 hour" row in Google Sheet 4. Target: 50+ views = good start

Nov 2, 9am CET (B12 video +24 hours): 1. Check same metrics 2. Fill in "Nov 2 2025 - +24 hours" row 3. Target: 100-500 views = algorithm working 4. Red flag: <50 views = title/thumbnail issue

Or Ask Claude to Check

Just message me: - "Check YouTube analytics" - "How is B12 performing?" - "Update the tracker"

I'll automatically: 1. Navigate to YouTube Studio 2. Read all the metrics 3. Update the Google Sheet 4. Give you analysis and recommendations

🎨 Formatting Recommendations

Make It Pretty (Optional)

  1. Header Row (Row 1):
  2. Bold (Cmd+B)
  3. Background color: Light purple (#E1BEE7)
  4. Text color: Dark purple (#4A148C)

  5. Freeze row: View → Freeze → 1 row

  6. Conditional Formatting (for Views column):

  7. Select column C (Views)
  8. Format → Conditional formatting
  9. Rule 1: If >= 500, background green
  10. Rule 2: If 100-499, background yellow

  11. Rule 3: If < 100, background red

  12. Column Widths:

  13. A: 180px (Date/Time)
  14. B: 200px (Video Name)
  15. C-G: 80px (Metrics)
  16. H: 150px (Traffic Source)
  17. I: 250px (Notes)
  18. J: 250px (YouTube URL)

📈 Quick Reference: Performance Goals

First 24 Hours (New Channel)

  • ✅ 100-500 views = Good
  • ✅ 40%+ avg view duration = Strong
  • ✅ 8%+ CTR = Excellent
  • ✅ 5+ comments = Engaging
  • ✅ 10+ likes = Good signal

Week 1 (Algorithm Pickup)

  • ✅ 500-2,000 views = Algorithm working
  • ✅ "Shorts Feed" top traffic source = Discovery happening
  • ✅ +5-10 subscribers = Audience building

Red Flags 🚩

  • ❌ <50 views in 24h = Title/thumbnail problem
  • ❌ <30% avg view duration = Content not engaging
  • ❌ <5% CTR = Title not compelling
  • ❌ Only "External" traffic after 48h = Algorithm not picking up

🔄 Comparison Analysis

After 7 days (Nov 8), add a new sheet tab called "Before vs After":

Metric Vitamin D (Old) Vitamin B12 (New) Improvement
Total Views (baseline) 7 TBD TBD
CTR % TBD TBD TBD
Avg View % TBD TBD TBD
Comments 0 TBD TBD
Likes 0 TBD TBD

Goal: Prove optimization increased views by 50-100%+

💡 Tips for Best Results

1. Update Immediately

Don't wait - fill in metrics right when you check them. Data gets stale fast!

2. Add Context in Notes

Write down observations: - "First comment came from X/Twitter cross-post" - "Views jumped 2pm-4pm" - "Shorts Feed traffic increased after 24h"

3. Screenshot Key Moments

When you hit milestones (100 views, 500 views), screenshot YouTube Studio and add link to notes.

4. Share the Sheet

Click Share → Add team members → View access They can see progress without editing.

5. Use Mobile App

Download Google Sheets app - update tracker on-the-go when you check analytics.

🤖 Automated Updates (Future)

I can't automatically update the sheet right now, but you can:

  1. Set Reminders on your phone:
  2. Nov 1, 10am: "Ask Claude to check B12 analytics"

  3. Nov 2, 9am: "Ask Claude for 24h B12 performance"

  4. Message Me: "Check YouTube analytics"

  5. I'll navigate to YouTube Studio
  6. Read all metrics
  7. Tell you what to put in the sheet
  8. Analyze performance and suggest actions

Google Sheet

https://docs.google.com/spreadsheets/d/1VEtSIszQM_5gUfpqezgYKNJmf37JP0aDLN0S8D0RMpQ/edit

YouTube Studio - Videos

  • B12 Analytics: https://studio.youtube.com/video/7t1pDSw-xYY/analytics
  • Vitamin E Analytics: https://studio.youtube.com/video/HqqCNV8UvQ0/analytics
  • Vitamin A Analytics: https://studio.youtube.com/video/yiRQkEWXsBQ/analytics
  • B12: https://youtube.com/shorts/7t1pDSw-xYY
  • Vitamin E: https://youtube.com/shorts/HqqCNV8UvQ0
  • Vitamin A: https://youtube.com/shorts/yiRQkEWXsBQ

❓ Common Questions

Q: Why can't Claude auto-update the sheet? A: Google Sheets API requires authentication setup. But I can read YouTube Studio and tell you what to fill in!

Q: Should I track the 6-second symptom videos too? A: Start with the 3 main videos (B12, E, A). Add symptom videos after if you want deeper analysis.

Q: What if a video does poorly? A: Check the troubleshooting section in YOUTUBE_ANALYTICS_TRACKER.md for specific actions to take.

Q: Can I share this sheet publicly? A: Keep it private for now. Share with View access only for team members.

Created: October 31, 2025 Last Updated: October 31, 2025 Sheet URL: https://docs.google.com/spreadsheets/d/1VEtSIszQM_5gUfpqezgYKNJmf37JP0aDLN0S8D0RMpQ/edit