Quarterly Database Cleanup
Skill AktivRun a comprehensive quarterly CRM audit covering list health, bounce monitoring, data quality, scoring calibration, engagement metrics, and property cleanup. Produces a health report with quarter-over-quarter trend comparison.
Maintain the health and integrity of your HubSpot CRM data by performing a structured quarterly audit, identifying drift and proactively addressing data quality issues.
Funktionen
- Comprehensive quarterly CRM audit
- List health analysis
- Bounce monitoring and reporting
- Data quality assessment
- Scoring calibration review
- Engagement metrics tracking
- Property cleanup recommendations
- Quarter-over-quarter trend comparison report
Anwendungsfälle
- To proactively identify and rectify data drift in a HubSpot CRM at the start of each quarter.
- To monitor key CRM health metrics and ensure data completeness and accuracy over time.
- To generate actionable reports that guide data cleanup and enrichment efforts.
- To maintain sender reputation by monitoring bounce rates and managing unsubscribes.
Nicht-Ziele
- Performing actual data modifications or deletions (this is an audit skill).
- Automating the execution of action items derived from the report (these would be handled by other skills).
- Providing real-time CRM monitoring (it's a scheduled quarterly process).
Workflow
- Gather baseline metrics from the previous quarter's report.
- Execute the audit script to pull current CRM metrics via HubSpot API.
- Compare current metrics to previous quarter's data, flagging significant changes.
- Document specific contacts, lists, or properties needing action.
- Generate a structured health report with a summary and detailed findings.
- Action items from the report are executed separately.
Praktiken
- Data Quality Auditing
- CRM Maintenance
- Reporting
Voraussetzungen
- HubSpot API token in .env
- Python with `hubspot-api-client` installed via `uv`
- Previous quarter's report (optional on first run)
Documentation
- info:Configuration & parameter referencePrerequisites are listed, but the documentation for obtaining and configuring the HubSpot API token could be more detailed, such as specifying required scopes.
Maintenance
- warning:Dependency ManagementThe skill relies on 'hubspot-api-client' and Python, but there's no lockfile or explicit version pinning mentioned for these dependencies, raising concerns about potential instability or vulnerability.
Security
- warning:Secret ManagementThe skill requires a HubSpot API token stored in `.env`, but there is no explicit guidance on how to protect this file or ensure the token is handled securely, making it susceptible to accidental exposure.
Trust
- info:Issues AttentionThere were 0 issues opened and 1 issue closed in the last 90 days. The closure rate is undefined but low activity suggests maintainer engagement is minimal.
Compliance
- info:GDPRThe skill operates on CRM data which may include personal data. While it's an audit and doesn't directly submit data externally, the potential for personal data to be processed by the LLM exists without explicit sanitization steps mentioned for the LLM interaction.
Portability
- warning:Runtime stabilityThe skill requires a specific Python environment with `hubspot-api-client` installed via `uv`, which might not be universally available or easily set up for all users.
- warning:Stack assumptionsThe skill assumes Python 3.10+ with `uv` and the `hubspot-api-client` library are installed, but these are not explicitly declared with minimum versions or installation commands in the SKILL.md, only mentioned as prerequisites.
Install
- warning:Installation instructionThe README mentions installing `hubspot-api-client` via `uv` but doesn't provide the exact command or specify version constraints, and it lacks details on obtaining and configuring the HubSpot API token beyond stating it should be in `.env`.
Execution
- warning:Pinned dependenciesThe skill relies on Python and the `hubspot-api-client` library, but there is no mention of pinned versions or a lockfile, which can lead to runtime instability.
Practical Utility
- warning:Usage examplesWhile the README shows general usage examples for the hubset-admin plugin, there are no specific, ready-to-use invocation examples for the `quarterly-database-cleanup` skill itself within the SKILL.md or README.
- info:Edge casesThe skill mentions the need for the previous quarter's report as optional on the first run, but other potential failure modes like API rate limits or authentication errors are not explicitly detailed with symptoms and recovery steps.
Safety
- info:Halt on unexpected stateThe skill requires a previous report for trend comparison, but the documentation doesn't explicitly state that the workflow will halt if this baseline is missing or malformed, only that it's optional on the first run.
Installation
Zuerst Marketplace hinzufügen
/plugin marketplace add TomGranot/hubspot-admin-skills/plugin install hubspot-admin-skills@hubspot-admin-skillsQualitätspunktzahl
Vertrauenssignale
Ähnliche Erweiterungen
Cleanup Dashboards
100Audit and consolidate HubSpot reporting dashboards. Identifies unused, duplicate, or outdated dashboards. Must be performed manually — no dashboard API is available.
Lifecycle Progression Workflow
100Build workflows to automate contact progression through the sales funnel: Lead to MQL to SQL to Opportunity to Customer. Each transition is triggered by a specific event (score threshold, meeting booked, deal created, deal won).
Reassign Deactivated Owners
99Reassign contacts and companies from deactivated team members to active owners. Fully automated via the HubSpot Owners API and Batch Update API. Includes territory analysis for informed reassignment decisions.
Enrich Contact Industry
99Backfill contact-level industry from associated company records using a HubSpot workflow. Enables industry-based segmentation for targeted campaigns aligned with ICP verticals.
CRM Hygiene
99Audit and improve CRM data quality by identifying missing fields, inconsistent values, duplicate records, and stale data
Weekly Cleanup Routine
98A lightweight 5-minute weekly health check covering bounce monitoring, new contact quality, workflow health, list growth trends, and data quality sampling. Quick early warning system, not a comprehensive audit.