How can I distinguish between sourced pipeline and influenced pipeline in my reporting?
Quick Answer: Sourced pipeline is revenue opportunity that your marketing or sales motion originally created, while influenced pipeline is revenue that was shaped by your campaigns at any point in the buyer journey. To distinguish them cleanly, define one primary attribution rule for creation events, then track all qualifying touchpoints separately so you can report both first-touch creation and multi-touch influence without double counting.
Detailed Explanation
The distinction comes down to ownership of the opportunity’s origin versus the degree of marketing impact. Sourced pipeline should only include opportunities whose first recorded qualifying interaction, lead source, or conversion event can be traced to your campaign or acquisition channel, and it should be measured as the revenue amount tied to those newly created opportunities. Influenced pipeline is broader: it includes opportunities where marketing touchpoints occurred before close, even if the deal originated from outbound sales, referrals, or existing accounts. For accurate reporting, you need a clearly documented attribution model, consistent lifecycle stage definitions, and CRM-level tracking of campaign membership, UTM parameters, first/last touch, and opportunity association rules so the same deal is not counted as both fully sourced and fully influenced in the same metric.
Key Technical Drivers
- Define sourced pipeline using a single creation rule: first-touch, first-campaign, or lead-source-based attribution at the moment the opportunity is created in the CRM.
- Define influenced pipeline by counting any opportunity with one or more verified marketing touchpoints before close, then exclude those same dollars from sourced reporting to prevent overlap.
- Instrument your CRM with campaign association, UTM capture, lifecycle stage timestamps, and opportunity-source fields so finance and revenue teams can audit the logic at the deal level.