Quarterly Database Cleanup

A structured quarterly audit that catches data drift before it becomes a crisis. Run this at the start of each quarter (or monthly if the database is large or fast-growing).

Prerequisites

• A HubSpot private app access token (HUBSPOT_ACCESS_TOKEN in .env)
• Python 3.10+ with uv
• Previous quarter's report (for trend comparison) — optional on first run

Audit Checklist

1. List Health

• Count total active lists, static lists, and unused lists (zero members)
• Identify lists not referenced by any workflow or email
• Flag duplicate or overlapping lists