You know the meeting. Comp planning, a stack ranking on the screen, and someone says the rep near the top is coasting on the book they were handed when the last rep left. Someone else says that rep has grown it. Both sound sure.

Neither can prove it from the CRM, because the CRM gives each rep one number and that number doesn’t record where the revenue came from.

The argument runs on memory, and memory favors whoever talks last.

How do you tell if a rep is growing their territory or just maintaining it?

Split each closed and open deal by type (new logo, expansion of an existing customer, renewal) and compare each rep’s mix instead of their total. Growth shows up as new logos won and expansion in accounts the rep opened. Maintenance shows up as renewals and repeat orders from accounts the rep was handed. One field and one report make the split visible, and neither needs new software.

The total isn’t wrong. It answers a different question: how much revenue closed with this rep’s name on it. That’s the number that pays commission, so it gets the attention. It says nothing about whether the territory is bigger than it was when the rep got it.

In account-heavy businesses like distribution and wholesale, where customers reorder, the gap gets wide. Repeat business from existing customers can carry a rep’s number for a long time without a single new logo in it.

The one field that makes the split possible

The split starts with a single-select deal field with three values (new logo, expansion, renewal), required when the deal is created, with written definitions the whole team can read. HubSpot ships a default Deal type property you can extend. In Pipedrive, a single option custom field does the job. Agree the definitions before anyone builds anything, because the field is only as useful as the agreement behind it.

In HubSpot, the default options for Deal type are New Business and Existing Business, and HubSpot says you can edit or add deal types in your deal property settings (HubSpot, HubSpot’s default deal properties, updated September 29, 2026). The two defaults put expansion and renewal together under Existing Business, and separating those two is the point of the exercise. Add the third option.

In Pipedrive, a single option custom field is a list of predefined options where only one can be selected, with a maximum of 1,000 options per field (Pipedrive, What types of custom fields are there?, updated September 3, 2026). You need three.

Write the definitions down where the team can find them:

  • New logo: the first closed-won deal with that company.
  • Expansion: new revenue from a company that is already a customer, such as more products, more locations or more users.
  • Renewal: the customer buying again what they already buy, such as a contract renewal or a standing reorder.

The hard calls are the edges: a customer that lapsed and came back, a new division of a company you already sell to. Decide those once and write them down, or reps end up deciding them deal by deal, usually in their own favor.

How do you make reps fill it in?

Require the field on the deal create form, and have any integration or automation that creates deals set the value itself. Pipedrive says its required fields won’t stop deals from progressing when fields are updated via import, bulk editing, API, automations or third-party integrations, and HubSpot describes its create-panel setting in terms of manual creation. Then pull the deals with no type once a month and work the list.

In HubSpot, you choose which fields appear when users manually create deals, and making properties required there takes a Starter, Professional or Enterprise subscription (HubSpot, Set up fields seen when manually creating records, updated September 9, 2026). The page is about the manual create panel. It doesn’t say the requirement reaches deals created by imports, integrations or workflows, so test those paths in your portal before you rely on it.

Pipedrive is more explicit. Its required fields feature lets you make data fields mandatory, it’s available on Professional and higher plans according to Pipedrive’s Required fields article, and Pipedrive says it “won’t stop deals from progressing if the fields are updated via import ... bulk-editing, API, automations, or third-party integrations” (Pipedrive, Required fields, updated September 3, 2026).

That’s how the field ends up blank on deals no rep ever saw a prompt for. If your deals arrive from a web form, an e-commerce platform or a quoting tool, the system that creates the deal is the one that has to set its type.

For the blanks that slip through, keep a saved list of deals where the type is empty, grouped by owner, and review it monthly. The owner column tells you whose habit to work on.

Keep the required list short while you’re at it. Each required field competes with the others for a rep’s patience, and CRM field bloat is how a quick field turns into a form reps rush through.

Who opened the account? Separating inherited from earned

Deal type tells you what kind of revenue a deal is. Account history tells you whose it is. Use the company’s first deal date and its owner history to mark which accounts a rep opened and which were reassigned to them, so expansion in an inherited account doesn’t count as territory growth. Skip this step and a rep who inherits a fast-growing customer reads as a hunter.

HubSpot sets several company properties automatically from deals: First deal created date, the date the first deal was created for a contact at the company; Recent deal close date, the date of the last associated deal closed as won; and Total revenue, the total value of deals closed with the company (HubSpot, HubSpot’s default company properties, updated August 7, 2026).

Property history fills in the rest. For each property on a record, HubSpot shows the historical values, the date and time of each change and the source of the change (HubSpot, View a record’s property history, updated October 16, 2026). Open the company owner property and compare it with the first deal date. If the current rep owned the company when its first deal was created, they opened it. If ownership moved to them later, they inherited it.

Growth shows up as new logos and expansion in accounts the rep opened.

Earned baseRenewals on accounts they opened.Territory growthNew logos and their expansion.UpkeepRenewals on handed accounts.Not territory growthExpansion on a handed account.OpenedInheritedAccountRenewalDeal typeNew or expansion
EarnedbaseRenewals onaccounts theyopened.TerritorygrowthNew logos andtheirexpansion.UpkeepRenewals onhandedaccounts.NotterritorygrowthExpansion on ahandedaccount.OpenedInheritedAccountRenewalDeal typeNew or expansion

Illustrative framework · no data

Growth shows up as new logos and expansion in accounts the rep opened.
QuadrantTitleLine
Opened Account, Renewal Deal typeEarned baseRenewals on accounts they opened.
Opened Account, New or expansion Deal typeTerritory growthNew logos and their expansion.
Inherited Account, Renewal Deal typeUpkeepRenewals on handed accounts.
Inherited Account, New or expansion Deal typeNot territory growthExpansion on a handed account.

One caution: First deal created date is when a deal was created, not won. A company with an old lost deal will show that date, so check the deal list before you make the call.

Pipedrive keeps the same kind of history on the organization. Every Pipedrive item carries an owner field (Pipedrive, Import fields, updated October 19, 2026), and the Changelog tab under History in an organization’s detail view shows all changes made to it since its creation, sorted by date and time, including updates to any default or custom field (Pipedrive, Detail view, updated September 3, 2026). Open the organization’s changelog to see past owner changes. The log starts when the organization was created in Pipedrive, so for an account imported from an older system, it can’t tell you who opened it before then.

Record the answer on the company or organization with a simple opened-by field, so the report can use it instead of someone rereading history each quarter. The history lives on each record, not in a report column. In other CRMs, look for the same two things: the date of the account’s first deal and a record of owner changes. Where that record doesn’t reach back far enough, as with imported accounts, start recording the opening rep on the account now and the history builds from today.

The report: three views, side by side

For each rep, over the same period, show closed-won value by deal type, open pipeline by deal type and win rate by deal type. A rep whose number is mostly renewals from accounts they inherited is maintaining the territory. A rep with new logos and expansion in accounts they opened is growing it. Read the three views together, so one strong quarter of renewals can’t pass for growth.

HubSpot. The custom report builder, available on Sales Hub or Marketing Hub Professional or Enterprise, can analyze multiple data sources across HubSpot (HubSpot, Create reports with the custom report builder, updated October 23, 2026). Build from deals, with deal owner on one axis and deal type as the breakdown, and bring in companies so the opened-by field can separate inherited accounts from opened ones. Make three versions: closed-won amount, open deal amount, and won against lost. If your HubSpot reports already disagree with each other, sort that out first, because HubSpot reports that don’t match will make this one look wrong too.

Pipedrive. The win/loss (deal conversion) report compares deals won against deals lost and by default shows one column per deal owner. Its “view by” options include single option custom fields, so you can view it by deal type, though Pipedrive says only Premium and higher plans can use deal custom fields for filtering and building reports in the visual builder (Pipedrive, Insights reports: deal conversion, updated September 3, 2026). Pipedrive also recommends filtering by won and lost status so the report shows the win/loss rate as expected. Build the closed-won value and open pipeline views by owner and deal type on the same plan.

Any other CRM, Salesforce included. The same field and the same three views work in any CRM with a single-select deal field and a report you can group by owner.

HubSpotPipedriveAny CRM (Salesforce and others)
The fieldDefault Deal type (New Business, Existing Business). Edit or add options to get three.Single option custom field, up to 1,000 options.A single-select deal field with the three values.
Making it requiredRequired on the manual create panel (Starter, Professional or Enterprise). The page describes manual creation.Required fields (Professional and higher, per Pipedrive’s Required fields article). Not enforced on import, bulk edit, API, automations or integrations.Required on create, and set by the system on deals that systems create.
Account historyFirst deal created date (set automatically) plus company owner property history.Owner changes in the organization’s History > Changelog tab, since the organization was created in Pipedrive. An opened-by field makes it reportable.First deal date plus owner changes, or an opened-by field from today.
The reportCustom report builder (Professional or Enterprise): deals by owner and deal type, joined to companies.Win/loss report by owner, viewed by the deal type field. Custom fields in the visual builder need Premium and higher.Closed-won value, open pipeline and win rate, each by owner and deal type.

When the split goes in front of the board, it has to match the CRM to the dollar, or the meeting turns into a debate about whose spreadsheet is right. When board numbers don’t match the CRM covers why that happens.

What should you do with the answer?

Decide what the role is for before you judge the rep. A territory built to farm should be measured on retention and expansion. A hunting role should be measured on new logos. Mixed roles need the split written into the comp plan, or the easier revenue wins by default. The report shows you the mix, and the role decides whether that mix is good.

A rep running a farming territory well, with renewals and steady expansion, is doing the job. A rep in a hunting role whose number is mostly renewals from inherited accounts has a different conversation coming.

Before you decide some reps are coasting, check whether the plan pays them to. If a renewal pays the same as a new logo, the rep who takes the renewal is reading the plan correctly. That’s a plan design problem before it’s a rep problem. If attainment is already uneven across the team, the quota attainment crisis is worth reading alongside this split.

Keep the one total, or add one field this quarter

You can keep ranking reps on one total. It’s simple, it pays commission correctly, and next year’s comp meeting will have the same argument in it. Or you can add one field this quarter, write three definitions, and see the split next quarter. The first report will be thin, because only new deals carry the type. Backfill the open pipeline and recent closed deals if you want a head start.

Start this week: write the three definitions in one sentence each, add the field to the deal record, and make it required on new deals. Then tag last quarter’s closed-won deals so the first split report has a full quarter in it.

The free CRM Diagnostic runs 40+ automated checks across data quality, pipeline hygiene, freshness, reachability and ICP fit, read-only, with a scored report within a few hours. If you’d rather start from that before you build the report, book the free CRM Diagnostic.