Referral reporting breaks when it starts with revenue. Start at the lead stage, carry the referral through stage changes and ownership, and keep pipeline value separate from realized revenue.1 The CRM path for a referred opportunity can differ from the analytics path: analytics can credit a payment processor while the original source disappears.2 A merged report may show the amount collected while hiding where the referral entered, who owns it, and where it stalled.
Set the reporting sequence
Order the report as the opportunity moves. Each view should answer a different question and expose missing fields before they distort the outcome.
| Stage | What you are trying to learn | Example question |
|---|---|---|
| Lead | whether the referral source, owner, stage and initial value are recorded | "Who referred this opportunity, and where did it enter?" |
| Opportunity | whether the opportunity is moving, who owns it and what value is currently open | "What changed since the last review?" |
| Outcome | what happened, what value was realized and whether the referral produced a return | "What happened after the opportunity closed?" |
Build the record
Use fields that remain available as the opportunity moves through the pipeline. If the referral identity is buried in notes or appears only after the deal closes, the report cannot show where the opportunity came from.
Record the referral source, the person or account connected to it, the current stage, the owner, the opportunity value and the outcome. Keep the referral relationship in a field you can filter and roll up. A CRM rollup can sum every deal value where the "Referred By" field names a person and update whenever a referred deal closes.3
Separate pipeline value from realized revenue. Total revenue is the dollar amount generated from purchases using the referral code.4 Put that figure in the outcome view. Open opportunity value belongs in the stage view, where you can inspect it before a purchase occurs.
Use one outcome vocabulary across the report. A closed result should show whether the opportunity became revenue, failed to become revenue, or remains unresolved. When the process allows it, record the reason for an unresolved result so owners can distinguish stalled movement from a lost opportunity.
Review the report
Review the report from intake through outcome, then inspect the owners attached to each stage. Look for breaks in movement while there is still time to act.
In the lead view, find referrals with no source, owner or current stage. In the opportunity view, group records by stage and owner, then compare open value with the next recorded action. In the outcome view, compare the volume entering the pipeline with the value that reached a result.
Keep the denominator fixed when comparing referral conversion with other channels. A published comparison reports referred lead to opportunity conversion at 10.99 percent, compared with 0.90 percent for sales prospecting, 3.82 percent for inbound, 2.98 percent for paid marketing and 0.55 percent for email.5 The comparison only helps when every channel uses the same entry point and outcome definition.
Connect the outcome view to the business result used for growth planning. Outcome metrics can link referral results directly to annual recurring revenue and help predict future growth.6
If one owner has many referred opportunities in one stage, inspect the records before judging the referral source. The source may be producing opportunities that need different follow-up, or the stage may be hiding a data-entry problem. Move to attribution review when the CRM path is complete and the reported source still conflicts with the conversion path.
Audit attribution
Keep operational referral reporting separate from analytics attribution. The CRM should show who referred the opportunity and who owns it. Analytics should test whether the recorded path survives visits, checkout and conversion.
GA4 attributes conversions to third-party domains when it sees them as the last non-direct click before conversion.7 That behavior can give a payment processor credit for a conversion while the marketing source that brought the customer is missing from the result.2 Review these domains whenever referral totals and channel totals disagree.
Referral exclusion sends credit back to the original marketing source, such as Email or PPC, instead of a utility domain.8 Third-party payment processors and password recovery email domains are the most frequent unwanted referral sources.9 Check whether a domain represents a genuine referral before adding it to an exclusion list. Removing a real referral source would change the report you are trying to understand.
GA4 handles a business's own subdomains automatically.10 It allows up to 50 excluded domains per data stream.11 Use those settings to clean conversion reporting, then preserve the CRM referral field as the record for pipeline ownership and stage review.
What not to do
These mistakes make referral performance look cleaner while removing the details needed to manage it.
- Do not wait for closed deals before recording a referral.1
- Do not use total revenue as a substitute for open pipeline value; total revenue describes purchases made with a referral code.4
- Do not let the last non-direct click decide the operational referral source.7
- Do not leave payment processor domains in conversion reports without checking whether they replaced the original source.2
- Do not treat every third-party domain as a genuine referrer; payment processors and password recovery email domains are frequent unwanted sources.9
- Do not manually build exclusions for your own subdomains in GA4, which handles them automatically.10
- Do not exceed 50 excluded domains per data stream.11
Before the next pipeline review, filter the report by stage, owner and referral source, inspect missing values, and trace any conversion credited to a utility domain back to its entry point. Then decide whether the problem is referral capture, opportunity movement or attribution cleanup, and assign the next action from the row itself.