| name | analytics-update-stats |
| description | Use when user says '/analytics-update-stats', 'update the sheet', 'push stats to sheets', or 'sync analytics to Google Sheets'. Fetches GA4 data and upserts a period section in the Analytics tab of the content tracker spreadsheet.
|
Analytics → Google Sheets Updater
Push GA4 analytics data into the "sprint1-analytics" tab of the content tracker spreadsheet.
Usage
Run from the project root (venv must be set up):
make analytics-sheets [PERIOD=7d]
or directly:
PYTHONPATH=. .venv/bin/python analytics/update_sheets.py --period {period}
Input
Parse the period from the user's message. Default: 7d.
Valid: 1d, 3d, 7d, 14d, 21d, 28d, 30d, 90d, 365d
Weekly tracking cadence
Each period overwrites only its own section — running different periods builds up a
cumulative view of post performance since tracking started:
| Week | Command | GA4 window |
|---|
| Week 1 | make analytics-sheets PERIOD=7d | last 7 days |
| Week 2 | make analytics-sheets PERIOD=14d | last 14 days (includes week 1) |
| Week 3 | make analytics-sheets PERIOD=21d | last 21 days (includes weeks 1–2) |
| Week 4 | make analytics-sheets PERIOD=28d | last 28 days (full month) |
After week 4, reset: run 7d again for the next cycle. Each section stays in the sheet
until overwritten by the same period key, so at any point you can see all periods run
as separate blocks — each one a cumulative window from when you started tracking.
What it does
- Fetches GA4 data for the given period (all posts, filtered)
- Upserts a section in the "Analytics" tab — clears and rewrites only this period's block
- Applies formatting: dark title bar, blue section header, alternating rows, traffic-light
conditional formatting on engagement rate and bounce rate
- Updates the "updated at" summary in row 2
After running
- Confirm success message and print the spreadsheet URL (printed by the CLI from
SHEETS_SPREADSHEET_ID in analytics/config.py)
