# Pipeline by segment for the board: define the CRM fields first

- Page: https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first
- Publisher: Panelhop (https://panelhop.com/)

> **The short answer:** Start with the definitions, not a dashboard. Write each segment as a rule a second person would apply the same way, and store it on the account as a controlled field with an owner. Keep tier and dated facts in fields of their own, copy the segment onto each deal at creation, then report against a baseline quarter.

Published 23 October 2026 · By Saksham Baliyan, Co-founder

## Key numbers

- **76%** of CRM users say less than half of their CRM data is accurate and complete. Source: [Validity, 2025](https://www.prnewswire.com/news-releases/validity-releases-state-of-crm-data-management-in-2025-report-revealing-disconnect-between-data-quality-and-ai-implementation-302499899.html).
- **45%** of sales leaders and sellers have high confidence in their forecast accuracy. Source: [Gartner press release, 2020](https://www.gartner.com/en/newsroom/press-releases/2020-02-12-gartner-says-less-than-50--of-sales-leaders-and-selle).
- **0** of 2 AI answers say what reclassifying an account does to last quarter’s split. Source: [Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#why-does-the-segment-split-take-days-every-quarter).
- **10** closed deals at least before our audit reads a segment’s win rate. Source: [Panelhop, 2026](https://panelhop.com/blog/build-target-account-list-from-operating-evidence#define-fit-as-operating-evidence-then-check-it-at-the-source).

## Why does the segment split take days every quarter?

It takes days because the report needs fields the CRM doesn’t hold, so a person supplies them by hand every quarter. They export the open deals and decide each account’s segment from memory or a quick search. Then they reconcile the result with last quarter’s slide and explain every difference. None of those decisions is saved where the report can read it, so next quarter starts from zero.

The judgement calls are where the split drifts. One is whether a subsidiary counts under its own business or its parent’s. Another is the date from which an account that launched its first product moves segment. Different people answer them differently, and the board sees numbers that move for reasons nobody can name.

Industry codes don’t settle it either. An official code records an establishment’s primary activity, often judged by revenue, shipments or employment. ([Executive Office of the President, Office of Management and Budget, 2022](https://www.census.gov/naics/reference_files_tools/2022_NAICS_Manual.pdf)) Where survey data is missing, it can come from the code a business gave itself on its tax return. ([U.S. Census Bureau](https://www.census.gov/programs-surveys/cbp/technical-documentation/methodology.html)) That works for national statistics; a board’s segments need rules of their own.

Trust in CRM data is low: 76% of CRM users say less than half of their organisation’s CRM data is accurate and complete. ([Validity, 2025](https://www.prnewswire.com/news-releases/validity-releases-state-of-crm-data-management-in-2025-report-revealing-disconnect-between-data-quality-and-ai-implementation-302499899.html)) Only 35% of sales professionals completely trust the accuracy of their organisation’s data. ([Salesforce, 2024](https://www.salesforce.com/news/stories/sales-ai-statistics-2024/)) Among sales leaders and sellers, 45% have high confidence in their forecast accuracy. ([Gartner press release, 2020](https://www.gartner.com/en/newsroom/press-releases/2020-02-12-gartner-says-less-than-50--of-sales-leaders-and-selle))

Today’s AI answers miss the history problem. Google’s AI Overview offers, as its fastest route, bucketing an enriched export in a BI tool and bypassing the CRM for the quarter. ChatGPT lists sound fields but puts them on the account record only. Neither says what reclassifying an account does to last quarter’s split. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#why-does-the-segment-split-take-days-every-quarter))

## Low board confidence in the split is a definitions problem

We think a board that doubts the segment split is usually reacting to definitions that shift between quarters. Neither a better analyst nor a new dashboard fixes that. When the same account lands in different segments depending on who classifies it, the split moves for reasons unrelated to selling. Trust goes with it. That is a property of the system, so we’d look at the definitions before the people.

We’d also wait to automate the rebuild until the rules exist. An enrichment tool or a calculated column applies whatever rule it was given to every account, every quarter. Nobody checks its answers the way an analyst at least tried to. So we’d fix the fields the report reads first, and only those: the segment, its evidence and the copy on each deal. The rest of the CRM can wait, and so can a new platform.

We think a baseline then changes what the board argues about. Without one, any quarter’s movement can be framed as growth or as noise. With one, the discussion is about what changed rather than whose spreadsheet is right.

## Each segment needs a written rule and its own field

Start by writing each segment as a rule a second person would apply the same way, then give it a single home in the CRM. Base the rule on evidence anyone can check at a named source. That usually means what the account sells, how large it is on a measure you can look up and who its customers are. List the look-alikes beside each segment, with the fact that rules each one out.

Settle the edge cases in the rule, once. The account that signs decides the segment, and its parent goes in the hierarchy, which HubSpot and Salesforce both support. ([HubSpot, 2026](https://knowledge.hubspot.com/records/add-a-parent-or-child-company)) ([Salesforce](https://trailhead.salesforce.com/content/learn/modules/accounts_contacts_lightning_experience/understand-account-and-contact-relationships-lightning)) Add 2 values the board didn’t ask for: Other, for verified accounts that fit no segment, and Unknown, for accounts nobody has checked yet. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#copy-the-segment-onto-each-deal-so-past-quarters-hold)) Unknown goes to a research queue with an owner, never into a guessed segment.

Then test the rules before you build anything. Have 2 people classify the same sample, drawn from every segment, without conferring; every disagreement rewrites a rule. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#copy-the-segment-onto-each-deal-so-past-quarters-hold)) Give the definition a single owner and a version number, so every change is a dated decision. ([Panelhop, 2026](https://panelhop.com/blog/build-target-account-list-from-operating-evidence#define-fit-as-operating-evidence-then-check-it-at-the-source))

| Field | Where and what | Owner | What the report does with it |
|---|---|---|---|
| Segment | Account: a single value from the written list, or Other or Unknown | The definition’s owner, usually RevOps | Splits open pipeline |
| Segment evidence | Account: link, date checked and confidence (verified, inferred, unverified) | RevOps; reps can propose | Shows pipeline resting on unverified segments |
| Tier | Account: a single value | Sales leadership | A separate cut by priority |
| Dated facts | Account: each event’s value, date and source | Whoever runs signals | Explains timing, never the split |
| Segment at creation | Deal: copied by a workflow when the deal is created, then read-only | The workflow | Counts pipeline created without restating it |
| Segment change | Account: old and new value, date, reason and rule version | RevOps | Shows pipeline that moved segment |

Keep tier apart from segment. Segment says what the account is; tier says how much effort you give it, and it changes when your strategy does. Fast-moving facts, such as a funding round or a renewal date, go in dated fields with their source. They time the pipeline and never define the split.

Fill the segment before the board reads it. Our audit scores the fill of key fields on records from the last 90 days at 4 out of 5 from 85% and at 5 above 95%. ([Panelhop, 2026](https://panelhop.com/blog/crm-cleanup-before-lead-scoring#how-clean-is-clean-enough-to-switch-scoring-on)) For a board report, we’d want verified segments on more than 95% of open pipeline value. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#copy-the-segment-onto-each-deal-so-past-quarters-hold)) The rest shows as Unknown on the slide.

## Copy the segment onto each deal so past quarters hold

Copy the account’s segment onto every deal when the deal is created, and lock it there. A report that reads the live account field rewrites history whenever an account changes segment. Accounts change for ordinary reasons: an acquisition, a first product launch, a rule you rewrote. If the board report groups deals by the account’s current segment, last quarter’s numbers move the day that happens. The next deck then shows a fall nobody can trace.

The CRM’s own history won’t rebuild old quarters for you. Salesforce’s standard field history tracks up to 20 fields per object and keeps changes for 18–24 months. ([Salesforce](https://developer.salesforce.com/docs/atlas.en-us.field_history_retention.meta/field_history_retention/field_audit_trail.htm)) Even within that window, a standard report groups deals by today’s value. Store these instead:

- **Segment at creation** on each deal, copied by a workflow or flow and read-only after. It counts pipeline created and never restates.
- **A dated snapshot** of open deals at each quarter end, with the segment on that date. It counts open pipeline as the board saw it.
- **A segment change record** on the account, with the old value, new value, date, reason and rule version. It explains every difference between them.

The board slide then gets a line of its own: pipeline that moved segment this quarter, from which segment to which. A single sentence replaces a restated quarter.

## Set the baseline once, then report every quarter against it

Once the fields exist, fill them and rebuild a single quarter as the baseline every later report is measured against. Fill the segment first on accounts with open deals, then on accounts with deals closed in the last 24 months, the window our audit asks for. ([Panelhop, 2026](https://panelhop.com/blog/mes-forecast-pilot-capex-first-site-stages#how-do-you-build-the-baseline-from-your-won-and-lost-deals)) Rebuild the last completed quarter from the fields and set it beside the slide the board saw. Write down every difference, such as a misclassified account or a changed rule. Send that note with the baseline, so the board sees a single restatement, made on purpose.

- **01. Step 1: Write the rules** Each segment as a rule from checkable evidence, with its look-alikes, plus Other and Unknown. Test it with 2 people on a sample. A single owner, version 1. (Week 1)
- **02. Step 2: Build the fields** Segment, evidence, tier and dated facts on the account; segment at creation on the deal; the change record. (Week 2)
- **03. Step 3: Backfill** Accounts with open deals first, then accounts with deals closed in the last 24 months. Unknowns go to a research queue with an owner. (Week 3)
- **04. Step 4: Set the baseline** Rebuild the last completed quarter from the fields, reconcile it once with the board’s slide and send the note. (Week 4)
- **05. Step 5: Report against it** Take the quarter-end snapshot and run the report from the CRM, with what moved and what didn’t. (Each quarter)
- **06. Step 6: Automate** Enrichment proposes segments for new accounts into the research queue and the owner approves them. Then build the dashboard. (After 2 reports)

From then on, each quarter’s report reads the snapshot and the fields, and shows what didn’t move as plainly as what did.

- Open pipeline by segment at quarter end, beside the baseline and last quarter
- Pipeline created, won, lost and slipped, by segment
- Pipeline that moved segment, from which to which
- Open deals with no stage change this quarter, with their value
- Segments with no new pipeline this quarter
- Open pipeline on accounts whose segment is Unknown or unverified
- Win rate by segment only where 10 or more deals have closed

The quiet lines matter as much as the growth. A segment whose pipeline held steady because nothing in it changed stage is a different story from one where new deals replaced the ones it won. Only the stage history shows which. Our audit reads a segment’s win rate only with 10 or more closed deals behind it. ([Panelhop, 2026](https://panelhop.com/blog/build-target-account-list-from-operating-evidence#define-fit-as-operating-evidence-then-check-it-at-the-source)) Below that, list the deals instead of a percentage.

When a rule changes, give it a new version, restate the baseline once and say so on the slide. Automate last: after 2 reports have held, let enrichment propose segments for new accounts into the research queue, where the owner approves them. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#copy-the-segment-onto-each-deal-so-past-quarters-hold))

## How do you split pharma, biotech, medtech and CRO pipeline?

Start with rules on facts that rarely change, and put phase and funding in dated fields of their own. Here is a fictional vendor of clinical trial software, with Illustrative numbers. Its board wants open pipeline split into top pharma, mid-size pharma, biotech, medtech and CROs. Its RevOps lead rebuilds that split by hand in 3 days every quarter. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline))

Its rules, each checkable at a named source:

- **Top pharma:** one of the 20 largest drug companies by revenue in their latest annual reports, on a list RevOps reviews each January ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline))
- **Mid-size pharma:** at least 1 marketed drug and not on that list ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline))
- **Biotech:** develops drugs, with none on the market
- **Medtech:** devices or diagnostics as its main business
- **CRO:** runs trials for sponsors as a service

A device unit of a top pharma company is medtech, with its parent recorded. A biotech with its first approval becomes mid-size pharma on the approval date, with a change record.

The segment rules use none of the 3 fields the RevOps lead found missing. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline)) Tier is a field of its own, set by sales leadership. Phase and funding change during the year, so a split built on them would move between quarters. Phase belongs to each drug programme rather than the company. It comes from ClinicalTrials.gov, where under US rules a covered trial can be registered up to 21 days after its first participant enrols. ([National Institutes of Health](https://www.ecfr.gov/current/title-42/section-11.24)) The field trails the event. By our estimate, a clinical-stage biotech tends to buy trial software 1–6 months after a financing round. ([Panelhop, 2026](https://panelhop.com/industries/pharma/eclinical-platforms)) The round goes in a dated field: it times the deal, and the segment stays biotech.

Backfilling the 160 accounts with open deals at about 4 minutes each takes about 11 hours, once. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline)) In the third quarter, a top pharma company buys a fictional biotech with a €240k open deal. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline)) In the spreadsheet, the deal would jump to top pharma and biotech would show €240k less, unexplained. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline)) With the fields, the second quarter stays as reported. The biotech line reads €2.4M open at the baseline, €900k created, €300k won, €200k lost and €240k moved to top pharma: €2.56M open at quarter end. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline)) Of its 31 open biotech deals, 9 (€800k) didn’t change stage all quarter, and that line goes on the slide too. ([Panelhop, 2026](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline))

## How we do it at Panelhop

A Panel Check (GTM audit · 2–3 weeks) scores your CRM data, segment and tier fields included, and shows how much open pipeline rests on values nobody can verify. You leave with a baseline to report against.

A Leak Fix (we build the fixes) writes the segment rules with your team and builds the fields, the copy onto each deal, the quarter-end snapshot and the change record in your own HubSpot or Salesforce, with every workflow documented in your automation registry. With Panel Ops (we run it monthly), we run the quarterly report against that baseline with you.

## Questions buyers ask about this

### Should the segment live on the account or on the deal?

Both, with different jobs. The account holds the live segment and its evidence; each deal keeps a read-only copy from the day it was created, so pipeline created in a past quarter never moves. Open pipeline at quarter end comes from a dated snapshot.

### Can we build the split in a BI tool instead of the CRM?

Chart it there if you like, but keep the segment itself in the CRM, where reps and routing see it and a single owner maintains it. A calculated column in a BI tool hides the rule from the people who work the accounts, and it still restates history when an account changes segment.

### What if an account fits 2 segments?

Each account holds a single segment, so write the tie-break into the rule: usually the business that signs with you. Record the parent in the hierarchy, and if the board also wants the parent’s view, report it as a second cut.

### What if the next board meeting is in 2 weeks?

Write the rules, classify only the accounts with open deals and show the rest as Unknown on the slide. Add the copy onto each deal and the change record before the quarter closes, so the next report is the first that holds.

### Do we need an enrichment tool before we start?

No. Classify the accounts with open deals by hand against the written rules, which is a one-off job. Add enrichment once the rules have held for 2 reports, and let it propose values the owner approves.

## Sources

1. [Validity, State of CRM Data Management 2025](https://www.prnewswire.com/news-releases/validity-releases-state-of-crm-data-management-in-2025-report-revealing-disconnect-between-data-quality-and-ai-implementation-302499899.html): Validity, 2025
2. [Salesforce, State of Sales, 6th edition, 2024](https://www.salesforce.com/news/stories/sales-ai-statistics-2024/): Salesforce, 2024
3. [Gartner press release, 12 February 2020](https://www.gartner.com/en/newsroom/press-releases/2020-02-12-gartner-says-less-than-50--of-sales-leaders-and-selle): Gartner press release, 2020
4. [North American Industry Classification System: United States, 2022](https://www.census.gov/naics/reference_files_tools/2022_NAICS_Manual.pdf): Executive Office of the President, Office of Management and Budget, 2022
5. [County Business Patterns Methodology](https://www.census.gov/programs-surveys/cbp/technical-documentation/methodology.html): U.S. Census Bureau
6. [Add a parent or child company to an existing company record](https://knowledge.hubspot.com/records/add-a-parent-or-child-company): HubSpot, 2026
7. [Understand Account and Contact Relationships](https://trailhead.salesforce.com/content/learn/modules/accounts_contacts_lightning_experience/understand-account-and-contact-relationships-lightning): Salesforce
8. [Panel Check framework: checks C1, C2 and Q4](https://panelhop.com/blog/crm-cleanup-before-lead-scoring#how-clean-is-clean-enough-to-switch-scoring-on): Panelhop, 2026
9. [Fit by operating evidence: gates, evidence fields, tiers sized to capacity and the re-tier rule](https://panelhop.com/blog/build-target-account-list-from-operating-evidence#define-fit-as-operating-evidence-then-check-it-at-the-source): Panelhop, 2026
10. [Panel Check data request and forecast-accuracy check D4](https://panelhop.com/blog/mes-forecast-pilot-capex-first-site-stages#how-do-you-build-the-baseline-from-your-won-and-lost-deals): Panelhop, 2026
11. [42 CFR § 11.24, When must clinical trial registration information be submitted?](https://www.ecfr.gov/current/title-42/section-11.24): National Institutes of Health
12. [Selling eClinical platforms to sponsors and CROs](https://panelhop.com/industries/pharma/eclinical-platforms): Panelhop, 2026
13. [Field Audit Trail](https://developer.salesforce.com/docs/atlas.en-us.field_history_retention.meta/field_history_retention/field_audit_trail.htm): Salesforce
14. [Panelhop analysis of 2 AI answers and 2 cited pages on reporting pipeline by segment](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#why-does-the-segment-split-take-days-every-quarter): Panelhop, 2026
15. [Segment fields for a board pipeline report: written rules, owned fields, the copy on each deal, the baseline and the quarterly report](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#copy-the-segment-onto-each-deal-so-past-quarters-hold): Panelhop, 2026
16. [Panelhop worked example of a five-segment board split and a reclassified account](https://panelhop.com/blog/pipeline-by-segment-board-report-crm-fields-first#how-do-you-split-pharma-biotech-medtech-and-cro-pipeline): Panelhop, 2026