Social Media Tracker (CSV)¶

Location: /Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv

Purpose: Centralized CSV file for tracking all social media content across platforms. Accessible from any Claude session, easily viewable in Google Sheets, Excel, or any spreadsheet application.

Last Updated: November 5, 2025

Quick Access¶

Opening the CSV¶

# Read from Claude
cd /Users/post/repos/github/nutri-e
cat "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Open in Google Sheets (via Google Drive web interface)
# Navigate to: Google Drive > Nutri-E Marketing > social_media_tracker.csv

# Open in Excel/Numbers (Mac)
open "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Viewing Recent Posts¶

# Show last 10 posts
tail -n 10 "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Search for specific platform
grep "YouTube" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Search for specific content
grep "B12" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

CSV Structure¶

Column Definitions¶

Column	Type	Description	Example
post_id	Integer	Unique identifier for each post	1
platform	Text	Platform name	YouTube, X, TikTok, Instagram
platform_handle	Text	Account handle	@e_codi63034, Nutri-E
platform_status	Text	Account status	Active, Planned, Inactive
content_title	Text	Title/description of content	Vitamin B12 Deficiency: 6 Warning Signs
content_file	Text	File name of the content	symptom-1-fatigue-with-music.mp4
content_path	Text	Path to content file	Google Drive > Nutri-E Marketing > ...
music_track	Text	Background music used	Statement (3:07)
post_url	Text	Direct URL to the post	https://youtube.com/shorts/...
post_text	Text	Caption/description text	Full post text with emojis
published_date	Date (YYYY-MM-DD)	When posted	2025-11-01
post_status	Text	Status of post	published, deleted, scheduled
views	Integer	View count	0
likes	Integer	Like count	0
comments	Integer	Comment count	0
shares	Integer	Share count	0
clicks	Integer	Link click count	0
hashtags	Text (comma-separated)	Hashtags used	VitaminB12,Health,YouTube
external_link	Text	External link in post	https://apps.apple.com/...
notes	Text	Additional notes	Music added via YouTube Studio

Adding New Posts¶

Manually (Google Sheets)¶

Open the CSV file in Google Drive
Right-click → "Open with" → "Google Sheets"
Add new row at the bottom with all column data
File saves automatically in Google Drive

Via Command Line (bash/Claude)¶

# Create new post entry
echo "7,TikTok,@nutrieapp,Active,Vitamin A Symptom 1,symptom-1-night-blindness.mp4,Google Drive > Nutri-E Marketing,Purple Desire,https://tiktok.com/@nutrieapp/video/123,Post text here,2025-11-05,published,0,0,0,0,0,VitaminA,https://nutrieapp.com,First TikTok post" >> "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Via Python Script¶

import csv
from datetime import date

csv_path = "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Get next post_id
with open(csv_path, 'r') as f:
    reader = csv.DictReader(f)
    rows = list(reader)
    next_id = max([int(row['post_id']) for row in rows]) + 1

# Add new post
new_post = {
    'post_id': next_id,
    'platform': 'X',
    'platform_handle': '@e_codi63034',
    'platform_status': 'Active',
    'content_title': 'New Post Title',
    'content_file': 'video.mp4',
    'content_path': 'Google Drive > Nutri-E Marketing',
    'music_track': 'Background Track',
    'post_url': 'https://x.com/...',
    'post_text': 'Post text here',
    'published_date': str(date.today()),
    'post_status': 'published',
    'views': 0,
    'likes': 0,
    'comments': 0,
    'shares': 0,
    'clicks': 0,
    'hashtags': 'Tag1,Tag2',
    'external_link': '',
    'notes': ''
}

with open(csv_path, 'a', newline='') as f:
    writer = csv.DictWriter(f, fieldnames=new_post.keys())
    writer.writerow(new_post)

Updating Engagement Metrics¶

Manually (Google Sheets)¶

Open CSV in Google Sheets
Find the post by post_url or post_id
Update views, likes, comments, shares columns
Changes save automatically

Via Command Line¶

# Update metrics for post_id 1
# This requires reading, modifying, and writing back the entire CSV
# Recommend using Python script or Google Sheets for updates

Common Operations¶

Filter by Platform¶

# Show only YouTube posts
grep "^[0-9]*,YouTube," "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Show only X posts
grep "^[0-9]*,X," "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Find Posts by Date¶

# Posts from November 2025
grep ",2025-11-" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Posts from specific date
grep ",2025-11-01," "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Search by Content¶

# Find all B12 content
grep -i "b12" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Find posts with external links
grep ",https://" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Count Posts by Platform¶

# Count YouTube posts
grep "^[0-9]*,YouTube," "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv" | wc -l

# Count X posts
grep "^[0-9]*,X," "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv" | wc -l

Google Sheets Integration¶

Opening in Google Sheets¶

Go to Google Drive: https://drive.google.com
Navigate to: My Drive > Nutri-E Marketing
Find: social_media_tracker.csv
Right-click → "Open with" → "Google Sheets"

Recommended Google Sheets Formulas¶

Total Posts by Platform¶

=COUNTIF(B:B, "YouTube")
=COUNTIF(B:B, "X")
=COUNTIF(B:B, "TikTok")

Total Views/Likes/Comments¶

=SUM(M:M)  # Total views
=SUM(N:N)  # Total likes
=SUM(O:O)  # Total comments

Average Engagement Rate¶

=(SUM(N:N) + SUM(O:O) + SUM(P:P)) / SUM(M:M) * 100

Posts This Week¶

=COUNTIFS(K:K, ">="&TODAY()-7, K:K, "<="&TODAY())

Conditional Formatting (Google Sheets)¶

Highlight High Engagement: - Format → Conditional formatting - Range: M2:M (views column) - Format cells if: Greater than 1000 - Background: Green

Highlight Posts Without Metrics: - Range: M2:M (views column) - Format cells if: Equal to 0 - Background: Light yellow

Workflow Integration¶

When Publishing New Content¶

Upload to platform (YouTube, X, TikTok)
Get post URL
Add row to CSV:
Open Google Sheets
Add new row with all details
Or use command line to append

When Updating Metrics (Weekly)¶

Check each platform for engagement metrics
Open CSV in Google Sheets
Update views, likes, comments, shares columns
Changes save automatically

When Deleting Posts¶

Find post in CSV by URL
Change post_status from "published" to "deleted"
Add notes explaining why (e.g., "Incorrect link, reposted")

Backup¶

Automatic (Google Drive)¶

CSV file is in Google Drive, automatically synced and backed up
Version history available: File → Version history

Manual Backup¶

# Create local backup
cp "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv" \
   "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker_backup_$(date +%Y%m%d).csv"

Accessing from Claude¶

Claude can read and update the CSV directly:

# Read the entire file
cat "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Add new post
echo "NEW_ROW_DATA" >> "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

# Search for content
grep "search_term" "/Users/post/Library/CloudStorage/GoogleDrive-codiedev42@gmail.com/My Drive/Nutri-E Marketing/social_media_tracker.csv"

Platform Accounts¶

Active Platforms¶

Platform	Handle	Status	Created	Notes
YouTube	Nutri-E	Active	2025-10-31	YouTube Shorts for educational content
X (Twitter)	@e_codi63034	Active	2025-10-25	In Graduated Access period
Snapchat	@nutrieapp	Active	2025-11-01	Display name: Nutri E

Planned Platforms¶

Platform	Notes
TikTok	Cross-post YouTube Shorts
Instagram	Cross-post as Reels

X_POSTING_SCHEDULE.md - X (Twitter) posting schedule
YOUTUBE_POSTING_SCHEDULE.md - YouTube Shorts posting schedule
TIKTOK_CAPTIONS.txt - TikTok captions for Vitamin A series
SOCIAL_MEDIA_STATUS.md - High-level platform status
YOUTUBE_MUSIC_GUIDE.md - Music selection guide
AI_MUSIC_SERVICES.md - AI music generation services

Migration from Database¶

Previous System: SQLite database (social_media.db) New System: CSV file in Google Drive Migrated: November 5, 2025

Why CSV? - ✅ Easy to open in Google Sheets, Excel, Numbers - ✅ Human-readable format - ✅ Simple to edit manually - ✅ Works across all Claude sessions - ✅ Automatic backup via Google Drive - ✅ No database dependencies - ✅ Easy to share and collaborate

Created: November 5, 2025 CSV Version: 1.0

Social Media Tracker (CSV)¶

Quick Access¶

Opening the CSV¶

Viewing Recent Posts¶

CSV Structure¶

Column Definitions¶

Adding New Posts¶

Manually (Google Sheets)¶

Via Command Line (bash/Claude)¶

Via Python Script¶

Updating Engagement Metrics¶

Manually (Google Sheets)¶

Via Command Line¶

Common Operations¶

Filter by Platform¶

Find Posts by Date¶

Search by Content¶

Count Posts by Platform¶

Google Sheets Integration¶

Opening in Google Sheets¶

Recommended Google Sheets Formulas¶

Total Posts by Platform¶

Total Views/Likes/Comments¶

Average Engagement Rate¶

Posts This Week¶

Conditional Formatting (Google Sheets)¶

Workflow Integration¶

When Publishing New Content¶

When Updating Metrics (Weekly)¶

When Deleting Posts¶

Backup¶

Automatic (Google Drive)¶

Manual Backup¶

Accessing from Claude¶

Platform Accounts¶

Active Platforms¶

Planned Platforms¶

Related Documentation¶

Migration from Database¶