switching software/crm

Salesforce to HubSpot Migration Checklist for UK Teams

Golden copy backups, sandbox testing, and phased rollouts for Salesforce to HubSpot moves.

Tool Migration Checklist: Salesforce to HubSpot

1. Overview

  • Risk Level: High (due to complex relational data models and custom objects).
  • Estimated Timeline: 8–12 weeks.
  • Recommended Team Size: 5–7 members (Project Lead, CRM Admin, Data Analyst, Sales Ops Lead, IT Security Officer).

2. Phase 1: Pre-Migration Planning (Week 1–3)

Assessment

  • Conduct a comprehensive audit of existing Salesforce custom objects and fields.
  • Identify redundant fields that are no longer utilised by the sales or marketing teams.
  • Document current workflow automation triggers and Apex classes.
  • Define clear objectives for the migration (e.g., improved reporting, better UX).
  • Establish a project governance framework with sign-off authorities.

Data Mapping

  • Create a master data dictionary mapping Salesforce standard and custom objects to HubSpot objects.
  • Normalise data formats (e.g., date formats, currency symbols) to match HubSpot requirements.
  • Define the mapping strategy for multi-select picklists to ensure data integrity.
  • Verify the handling of Salesforce "Record Types" and map them to HubSpot "Lifecycle Stages".
  • Map Salesforce user roles and profiles to HubSpot permission sets.

Golden Copy Backup

  • Perform a full Salesforce Data Export Service (DES) extraction.
  • Store the full export in an encrypted, UK-based AWS S3 bucket.
  • Verify the integrity of the backup by attempting to restore a sample dataset.
  • Maintain a "read-only" instance of the Salesforce production environment for 90 days.
  • Document the file structure of the backup for audit trail purposes.

Integration Audit

  • List all third-party applications currently connected to the Salesforce API.
  • Evaluate whether these integrations have native HubSpot connectors.
  • Document the authentication methods (OAuth, API keys) for all connected services.
  • Review webhooks and ensure they can be re-routed to HubSpot endpoints.
  • Identify any custom middleware (e.g., Zapier, MuleSoft) requiring configuration updates.

3. Phase 2: Migration Execution

Pre-Cutover

  • Cleanse data in Salesforce (e.g., deduplication, formatting phone numbers).
  • Configure HubSpot properties to mirror the validated Salesforce schema.
  • Set up HubSpot user accounts with appropriate access levels based on the finalised permission matrix.
  • Execute a dry-run migration with a subset of data (e.g., 5% of records).
  • Validate the dry-run results against the target KPIs.

Cutover Day

  • Place Salesforce in "Read-Only" mode to prevent new record creation.
  • Initiate the final data export from Salesforce.
  • Import data into HubSpot, prioritising objects in the order of dependencies (Companies, then Contacts, then Deals).
  • Update DNS settings for email sending domains to ensure HubSpot DKIM/SPF compliance.
  • Re-authenticate all third-party integrations with HubSpot API credentials.

Verification

  • Perform a record count reconciliation between Salesforce export files and HubSpot.
  • Spot-check high-value customer accounts for data accuracy and activity history.
  • Verify that all custom workflows and triggers are firing correctly.
  • Confirm that lead routing rules are assigning contacts to the correct owners.
  • Test the integration between HubSpot and existing marketing channels.

4. Phase 3: Post-Migration Optimization

Stabilization

  • Monitor HubSpot system logs for error rates during the first 48 hours.
  • Provide 24/7 support availability for the sales team during the first week.
  • Conduct daily stand-up meetings to address immediate usability concerns.
  • Validate that reporting dashboards display accurate historical data.
  • Ensure all historical activity logs (emails, calls, meetings) are searchable.

Cleanup

  • Archive unused properties that were imported but serve no business purpose.
  • Delete any temporary staging objects used during the import process.
  • Optimise HubSpot list segments based on real-world usage post-migration.
  • Remove obsolete API keys and decommission old middleware endpoints.
  • Finalise the documentation of the new CRM architecture for future onboarding.

Retrospective

  • Evaluate the migration against the original Project Charter and KPIs.
  • Document "lessons learned" for future tool migrations.
  • Survey users regarding the transition experience and identify training gaps.
  • Review the budget versus actual spend to identify cost-saving opportunities.
  • Formalise the "CRM Maintenance Policy" to prevent future data rot.

5. UK GDPR Compliance Checklist

  • Verify that the legal basis for processing (e.g., consent, legitimate interest) is mapped to HubSpot properties.
  • Configure HubSpot’s GDPR settings to enable compliance features (e.g., cookie banners, privacy policy links).
  • Ensure that marketing subscription preferences are correctly migrated to avoid unlawful email communication.
  • Implement data retention policies in HubSpot to automatically purge records beyond the statutory limit.
  • Audit the data processing agreement (DPA) with HubSpot to ensure it meets UK GDPR standards.
  • Conduct a Data Protection Impact Assessment (DPIA) if the CRM contains sensitive special category data.
  • Ensure that the "Right to be Forgotten" workflows are active and testable.
  • Review access logs to ensure that data access is restricted to authorised personnel only.

6. Troubleshooting Common Issues

  • Resolve field mismatch errors by mapping Salesforce text fields to HubSpot single-line text properties.
  • Address "API limit exceeded" errors by staggering the import batches.
  • Fix broken associations by ensuring Record IDs are mapped correctly during the import.
  • Correct timezone discrepancies by normalising data to UTC before the import.
  • Rectify character encoding issues by ensuring all CSV files are saved in UTF-8 format.
  • Manage duplicate records by using HubSpot's "Deduplication by Record ID" feature.

7. Downloadable Resources List

  • Salesforce to HubSpot Data Mapping Template (Excel/CSV).
  • CRM Migration Project Governance Plan (PDF).
  • HubSpot Permission Matrix Template (XLSX).
  • Post-Migration User Training Manual (PDF).
  • UK GDPR Compliance Checklist for CRM (PDF).
  • Data Dictionary Documentation Template (Word).