Setting Up Firmographic Data in Your CRM: Salesforce, HubSpot, and Marketo

Getting firmographic data integrated into your CRM properly is critical. If you mismap fields or don’t activate them in sales workflows, the data sits unused. This guide shows you the CRM-specific setup process for the three most common platforms.

Our guide to implementing firmographic data successfully covers the full lifecycle. This guide focuses on the technical integration piece: how to get the data into your CRM and make it work.

The Universal Setup Process (All CRMs)

Before platform-specific steps, understand the universal process:

Step 1: Audit Your Current CRM Structure

Before importing new data:

• List all existing account fields (in your CRM)
• Document how they’re currently populated
• Identify which fields are custom vs. standard
• Check for duplicate accounts that need deduplication

Step 2: Map Incoming Data to CRM Fields

Create a mapping document:

Key rule: Each field must map to an existing CRM field. Don’t create new fields just to hold data.

Step 3: Test With Pilot Data

Before full import:

• Import 100–500 records
• Verify field mapping accuracy
• Check for data formatting issues
• Get stakeholder feedback

Step 4: Full Import (Deduplication + Activation)

Once pilot passes:

• Run deduplication against existing accounts
• Merge true duplicates carefully
• Import clean data to CRM
• Activate in sales workflows

Salesforce-Specific Setup

Salesforce has most standard fields built-in, but you’ll likely need to create custom fields for data-specific tracking. Here’s how to set up fields, import data, and activate it in sales workflows.

Salesforce Field Creation

If using standard Salesforce:

• Company Name → Account Name (already exists)
• Employee Count → NumberOfEmployees (standard field)
• Revenue → AnnualRevenue (standard field)
• Industry → Industry (standard field, picklist)
• Create custom fields for: Growth Rate, Data Source, Last Updated

Custom Field Creation:

1. Go to Setup → Object Manager → Account
2. Click Fields & Relationships
3. Create custom fields:
   • Growth_Rate__c (Number, %)
   • Data_Source__c (Text)
   • Last_Data_Update__c (Date)

Salesforce Data Import

Using Data Loader (Recommended):

1. Download your firmographic data as CSV
2. Open Data Loader
3. Create object mapping (Account)
4. Map CSV columns to Salesforce fields
5. Run insert/upsert operation on 100 test records first
6. Verify results
7. Run on full dataset

Using Salesforce Import Wizard:

1. Go to Setup → Data Management → Import
2. Select Account
3. Map fields from your CSV
4. Upsert (match on Account Name) to prevent duplicates
5. Run import

Salesforce Activation

Once data is in Salesforce:

Create Account Views:

• View: “ICP Accounts” (filter by Industry, Revenue, Employees matching your criteria)
• View: “High-Growth Accounts” (filter by Growth Rate >15%)
• View: “Strategic Accounts” (filter by revenue size + growth)

Enable for Reports:

• Create custom report type: “Accounts by Firmographic Attributes”
• Use in dashboards for sales leadership visibility

HubSpot-Specific Setup

HubSpot’s native properties cover most standard firmographic data, but you’ll want to create custom fields for tracking data updates and source. Here’s the setup process for properties, import, and activation.

HubSpot Company Properties

HubSpot has most standard properties already:

• Company Name → Company Name
• Employee Count → Number of Employees
• Revenue → Annual Revenue
• Industry → Industry
• Location → City, State/Region, Country

Create Custom Properties:

1. Go to Settings → Properties
2. Select “Company” object
3. Click “Create Property”
4. Add:
   • Growth Rate (Number, %)
   • Data Source (Single-line text)
   • Last Data Update (Date)

HubSpot Data Import

Using HubSpot Import:

1. Prepare your CSV with columns matching HubSpot property names
2. Go to Contacts → Companies
3. Click “Import companies”
4. Upload CSV
5. Map columns to HubSpot properties
6. Choose deduplication strategy:
   • Match by Company Name
   • Match by Company Domain
7. Run import

Best Practice: HubSpot matches on domain if available. Ensure your data includes company domains for better deduplication.

HubSpot Activation

Once data is in HubSpot:

Create Smart Lists:

• “ICP Companies” (filter by company size, revenue, industry)
• “High-Growth Companies” (filter by growth rate)

Enable for Workflows:

• Create workflow: “Enroll ICP companies in nurture campaign”
• Trigger: Company created + Growth Rate > 20% + Revenue 50M-500M
• Action: Add to ICP nurture list

Activate in Sales Hub:

• Filter account lists by firmographic attributes
• Sales team views enriched company data on account pages

Marketo-Specific Setup

Marketo stores company data at the Lead level (attached to person records), which differs from Salesforce and HubSpot. Here’s how to set up fields, import data, and activate it across campaigns and scoring.

Marketo Account Fields

Marketo stores company data in Lead objects (with company fields):

• Company Name (standard)
• Country (standard)
• Create custom fields:
  • Company Revenue (standard)
  • Number of Employees (standard)
  • Industry (standard)
  • Growth Rate (custom)
  • Data Source (custom)
  • Last Data Update (custom)

Add Custom Fields:

1. Go to Admin → Field Management
2. Click “New Custom Field”
3. Create:
   • Growth Rate (Number, %)
   • Data Source (String)
   • Last Data Update (Date)

Marketo Data Import

Using Marketo Import:

1. Go to Database → Import Lead Data
2. Upload CSV or select from SFDC sync
3. Map CSV columns to Marketo fields
4. Choose matching fields:
   • Match on Email + Company
   • Or match on Company Domain + Title
5. Schedule and run import

Sync from SFDC (Recommended for Salesforce users):

• If your data is in Salesforce first, Marketo syncs automatically
• No need to reimport; data flows through SFDC sync

Marketo Activation

Once data is in Marketo:

Create Smart Lists:

• “ICP Leads” (filter by company revenue, employee count, industry)
• “High-Growth Company Employees” (filter by growth rate)

Enable for Campaigns:

• Create campaign: “ICP Lead Engagement”
• Trigger: Company matches ICP criteria
• Action: Add to ICP nurture stream + alert sales

Enable for Scoring:

• Add points for leads at high-fit companies
• Example: +20 points if company revenue is 100M-500M

Common Integration Mistakes to Avoid

Most CRM integration problems come from rushing the process or skipping validation steps. Understanding these common pitfalls helps you avoid costly data quality issues that take months to fix.

Mistake 1: Not Deduplicating Before Import

Importing 100,000 new records without checking for duplicates creates chaos.

Solution: Always run deduplication first. Merge true duplicates, flag potential matches for review.

Mistake 2: Misaligning Field Mapping

Importing “Revenue” into “Annual Revenue” with different data types (text vs. currency) creates issues.

Solution: Map carefully. Test with 100 records first. Verify field types match.

Mistake 3: Locking Data From Updates

If you import data and then lock it, firmographic data never refreshes.

Solution: Plan for quarterly refreshes. Don’t lock fields that receive updated data.

Mistake 4: Not Activating in Workflows

Data sits in CRM unused if sales team doesn’t know it’s there.

Solution: Create views, smart lists, or workflows that use the data. Train sales team.

Next Steps: From Setup to Ongoing Management

After the CRM setup, the next step is ongoing activation:

• For implementation overview: See full implementation of firmographic data lifecycle
• For data refresh strategy: Review data refresh rates and governance
• For validation: Access testing data quality after import
• For building your ICP: Start with building your ideal customer profile
• For the broader landscape: Review our main firmographic data overview

Final Thoughts: Setup Correctness Determines Success

CRM setup is technical but not difficult. The key is getting the mapping right and testing before full import. Most integration problems come from skipping the pilot phase or not deduplicating properly.