hubspot-plg-sync

name	hubspot-plg-sync
description	Run the weekly PLG scoring sync and Slack digest. Pulls PQA/PQL scores from BigQuery, syncs them to HubSpot (companies + contacts), then posts the Monday morning digest to Slack. Use this skill when an Oz cloud agent needs to run the weekly BDR pipeline update.

Weekly PLG HubSpot Sync + Slack Digest

What this does

1. Pulls domain scores and champion contacts from BigQuery
2. Resolves and updates HubSpot companies + contacts with PQA/PQL properties
3. Applies dampening logic (bootstrap promotes immediately on first sync)
4. Excludes Target Account companies from PLG pipeline
5. Associates champion contacts to their companies
6. Legacy Clay enrichment and HubSpot workflow routing are disabled in scoring_sync.py. Dagster now owns Lead creation/update and writes the existing enrichment/routing workflow trigger fields plus Tier 1 Product Qualified Leads sequence intent. Tier 2 is held for now: no Lead creation, no enrichment trigger, and no sequence enrollment.
7. Posts the weekly Slack digest: 📊 This week at a glance (action plays), 🆕 Newly Active Accounts, 📈 Top Movers, 🏆 Tier 1 PQAs, ⚠️ Watch List, 💰 Pipeline Wins.

Enrichment policy

Clay enrichment is expensive, so the Dagster sync restricts it to accounts BDRs will actually work:

• Only enrich Tier 1 Product Qualified contacts for now. Tier 1 contacts receive available_for_enrichment and clay_enrichment_queue plus Product Qualified Leads sequence trigger fields.
• Hold Tier 2 for now. Tier 2 contacts still get PQL property refreshes for reporting, but no Lead is created, no enrichment trigger is written, and no sequence enrollment is requested.
• Never enrich Tier 3. Tier 3 champions still get PQL property refreshes for reporting, but no Lead is created and no outreach trigger fields are written.