CRM

CRM

Click to read the full definition in our AI & Automation Glossary.

Field Completeness Baseline Report Template

Your CRM

is either a strategic asset or an expensive contact list. The difference comes down to data completeness.

Most professional services firms run their CRM

at 40-60% field completeness. Partners complain the system "doesn't work." Associates ignore it. Operations teams spend hours manually cleaning records before every board meeting.

This template gives you a quantified snapshot of your current state. Pull it once to establish your baseline. Pull it quarterly to prove ROI on your automation investments.

The template tracks completeness across three record types:

Contact Records (15 fields)

• Basic identifiers: First name, last name, email, phone
• Professional context: Title, department, seniority level
• Engagement data: Lead source, last activity date, owner assignment
• Qualification status: Lead score, lifecycle stage, opt-in status

Company Records (12 fields)

• Firmographics: Industry, employee count, annual revenue
• Relationship data: Account owner, account type, parent company
• Pipeline context: Total contract value, renewal date, health score

Opportunity Records (10 fields)

• Deal mechanics: Amount, close date, stage, probability
• Service details: Practice area, service line, engagement type
• Tracking: Created date, last modified date, next step

Each field gets a binary score: populated or empty. No partial credit. A phone number with just area code counts as empty.

HubSpot Data Pull

Run this in HubSpot's Custom Report Builder or export via API

:

SELECT 
  c.hs_object_id AS contact_id,
  c.firstname,
  c.lastname,
  c.email,
  c.phone,
  c.jobtitle,
  c.hs_lead_status,
  c.lifecyclestage,
  c.hubspotscore,
  c.hs_analytics_source,
  c.notes_last_updated,
  co.hs_object_id AS company_id,
  co.name AS company_name,
  co.industry,
  co.numberofemployees,
  co.annualrevenue,
  co.type AS company_type,
  d.hs_object_id AS deal_id,
  d.dealname,
  d.amount,
  d.closedate,
  d.dealstage,
  d.pipeline,
  d.hs_priority,
  d.hs_next_step
FROM contacts c
LEFT JOIN companies co ON c.associatedcompanyid = co.hs_object_id
LEFT JOIN deals d ON c.hs_object_id = d.hs_deal_associated_contact_id
WHERE c.createdate >= DATEADD(month, -12, GETDATE())
  AND c.hs_object_id IS NOT NULL

Export to CSV. The template's "Data Import" tab expects these exact column headers.

Salesforce Data Pull

Run this in Salesforce Reports or via Workbench SOQL query:

SELECT 
  Contact.Id,
  Contact.FirstName,
  Contact.LastName,
  Contact.Email,
  Contact.Phone,
  Contact.Title,
  Contact.Department,
  Contact.LeadSource,
  Contact.Status,
  Contact.LastActivityDate,
  Contact.OwnerId,
  Account.Id,
  Account.Name,
  Account.Industry,
  Account.NumberOfEmployees,
  Account.AnnualRevenue,
  Account.Type,
  Account.AccountSource,
  Opportunity.Id,
  Opportunity.Name,
  Opportunity.Amount,
  Opportunity.CloseDate,
  Opportunity.StageName,
  Opportunity.Probability,
  Opportunity.Type,
  Opportunity.NextStep
FROM Contact
WHERE Contact.CreatedDate >= LAST_N_MONTHS:12
  AND Contact.IsDeleted = false
ORDER BY Contact.LastModifiedDate DESC

Export as Excel. Paste into the template's "Data Import" tab starting at cell A2.

Step 1: Configure Your Field List

Open the "Field Configuration" tab. You'll see three tables pre-populated with standard fields.

Customize for your firm:

• Remove fields you don't use (e.g., if you don't track lead scores, delete that row)
• Add custom fields critical to your practice (e.g., "Conflict Check Status" or "Engagement Letter Signed")
• Mark fields as "Required" or "Optional" in column C

The template calculates two scores: Required Field Completeness (your primary metric) and Total Field Completeness (includes optional fields).

Step 2: Import Your CRM

CRM

Click to read the full definition in our AI & Automation Glossary.

Data

Paste your HubSpot or Salesforce export into the "Data Import" tab. The template auto-maps columns if you used the queries above.

If you're using a different CRM

:

1. Export contact, company, and opportunity data to CSV
2. Match your column headers to the template's expected format (see row 1 of Data Import tab)
3. Paste data starting at row 2

The template handles up to 50,000 records. For larger datasets, filter your export to active records from the past 12 months.

Step 3: Review the Completeness Dashboard

The "Dashboard" tab auto-calculates four views:

Overall Completeness Score Your firm-wide average across all required fields. This is your headline number.

Target benchmarks:

• Below 60%: Critical. Your CRM

  CRM

  Click to read the full definition in our AI & Automation Glossary.

  is unreliable for decision-making.
• 60-75%: Functional but leaking value. Prioritize automation.
• 75-85%: Good. Focus on high-impact gaps.
• Above 85%: Excellent. Maintain through workflow enforcement.

Completeness by Record Type Separate scores for contacts, companies, and opportunities. Identifies which object needs the most attention.

Completeness by Field Ranked list of your worst-performing fields. Start improvement efforts here.

Completeness by Owner Shows which team members maintain clean data and which need coaching. Use this for accountability, not punishment.

Step 4: Identify Your Top 5 Gaps

The "Priority Gaps" tab auto-generates a ranked list of fields with the lowest completeness and highest business impact.

Business impact is calculated by:

• Field usage in reports (pulled from your CRM

  CRM

  Click to read the full definition in our AI & Automation Glossary.

  's field audit log)
• Field usage in automations (you'll manually mark these in the Field Configuration tab)
• Field requirement in your sales/delivery process (mark as "Critical" in Field Configuration)

Focus on the top 5 gaps. Trying to fix everything at once fails.

Action 1: Make Your Worst Field Mandatory

Pick the single most important field with the lowest completeness. Make it required in your CRM

.

HubSpot: Properties → [Field Name] → Edit → Make required Salesforce: Setup → Object Manager → [Object] → Fields & Relationships → [Field Name] → Edit → Required

Yes, your team will complain. Set a 2-week grace period, then enforce. Completeness for that field will jump 30-40 points within a month.

Action 2: Build a Data Enrichment Workflow

For firmographic fields (industry, revenue, employee count), stop asking humans to fill them in.

Option A: Native enrichment

• HubSpot: Enable Clearbit integration (Settings → Integrations → Clearbit)
• Salesforce: Install Data.com Clean or ZoomInfo integration

Option B: Zapier automation

• Trigger: New company created in CRM

  CRM

  Click to read the full definition in our AI & Automation Glossary.
• Action: Enrich company data via Clearbit API
• Action: Update CRM

  CRM

  Click to read the full definition in our AI & Automation Glossary.

  company record with enriched data

This fixes 15-20 percentage points of company record completeness with zero manual effort.

Action 3: Create a Weekly Cleanup Report

Build a saved view in your CRM

that shows records with missing required fields, assigned to their owner.

HubSpot: Save a filtered contact view: "My Incomplete Records" Salesforce: Create a report: "My Contacts - Missing Required Fields"

Email this report to each team member every Monday morning. Include their personal completeness score. Gamify it if your culture supports competition.

Re-run this baseline report every quarter. The template includes a "Trend Analysis" tab that plots your progress.

Quarter 1 (Baseline): 58% required field completeness Quarter 2 (After mandatory fields): 67% required field completeness Quarter 3 (After enrichment automation): 74% required field completeness Quarter 4 (After cleanup habits): 81% required field completeness

Graph this in your quarterly operations review. Partners respond to trend lines, not lectures about data hygiene.

A law firm client ran this baseline in January 2024. Their score: 52% required field completeness.

They implemented three changes:

1. Made "Matter Type" and "Originating Partner" mandatory on all opportunities
2. Automated industry and revenue enrichment for new companies via Clearbit
3. Sent weekly "incomplete records" emails to associates

By June 2024, their score hit 79%. The CFO could finally trust pipeline reports. Partners stopped asking associates to "pull together a client list" for business development because the CRM

actually had the data.

That's the ROI of a baseline. You can't improve what you don't measure.