How to build the 2027 marketing pipeline forecast in HubSpot, with the Salesforce equivalents

A marketing pipeline forecast is a quarter-by-quarter estimate of the qualified opportunities and pipeline value marketing will source, built from planned spend, cost per qualified opportunity, the lag before each channel produces, and deal size. A sales forecast is an estimate of the revenue that open deals will close in a period, built from the deals already in the pipeline and their stage.

Both use the same CRM objects, which is why they get confused. The difference is the question. The marketing forecast asks whether the plan will create enough pipeline, early enough, for the revenue target. The sales forecast asks how much of the pipeline that exists will close this quarter. Jon Miller of Demandbase describes the link between them as reverse waterfall math: the bookings goal divided by the win rate gives the pipeline you need.

HubSpot is one CRM example; the method does not depend on it. These are the features the forecast relies on, as HubSpot’s own knowledge base describes them, with the closest Salesforce building block. Check your own subscription before you plan the build, because several features depend on the tier.

Two details from HubSpot’s documentation matter for forecast quality. If someone edits a deal’s probability by hand, HubSpot stops updating it automatically until the deal closes. And forecast category definitions follow the category’s position in the list, not its label. Decide both rules before the forecast goes to finance.

The plan comes first and lives in a model; the CRM holds the targets and the actuals. Trying to make the CRM produce the plan usually ends with a forecast nobody can explain.

1. Agree what a qualified opportunity is with sales: the deal stage at which marketing gets credit for a created opportunity, and the date property that marks it.
2. Make the source reliable. Keep the Original Traffic Source, and add one custom deal property for pipeline source (marketing, SDR, sales, partner) that RevOps sets by rule, so the forecast does not depend on contact association alone.
3. Pull history: qualified opportunities created per month by pipeline source and by channel for the last four to eight quarters, with the stage conversion and the days from creation to close.
4. Build the plan model: planned spend by channel and quarter, cost per qualified opportunity from that history, the lag before each channel produces, and average deal size. The output is opportunities and pipeline created per quarter.
5. Load the targets. Put quarterly pipeline-created targets into a report target or goal, and, if you use the forecast tool, forecastable revenue goals for the bookings side.
6. Lock the stage probabilities and the forecast category mapping per pipeline, and agree that probabilities are not edited by hand.
7. Build the reports in the next section and review them monthly against the plan, quarterly with finance.

Our marketing budget channel planner builds the plan model by channel, with the lag before each channel produces.

This is a worked example with stated assumptions, not a benchmark or a client result: $2.4M of program spend spread evenly at $600,000 a quarter, a blended cost per qualified opportunity of $5,000, new programs running at 75% of their full rate in Q1 while they ramp, a $50,000 average deal, a 25% win rate and a sales cycle of about two quarters.

Two things stand out. First, only $2.625M of the bookings from 2027 marketing pipeline lands inside 2027 at this cycle length. If the plan needs more marketing-sourced revenue in 2027, it has to come from pipeline created in 2026 and still open on January 1, which belongs on its own line as carry-in. Second, the weighted amount in the CRM will show less than the pipeline created, because early-stage deals carry low probabilities. Report pipeline created against the plan, and weighted pipeline against the bookings forecast; do not mix them on one chart.

Five reports cover the marketing forecast in HubSpot. The same five can be built in Salesforce with opportunity reports and forecasts.

If the plan relies on multi-touch credit, HubSpot’s deal create attribution report is documented for Marketing Hub Enterprise only. Most teams can run the forecast on pipeline source and add attribution later.

• Freeze stage probabilities and forecast category mapping for the year, and review them once at mid-year against actual win rates by stage.
• Stop manual probability edits on deals; HubSpot stops updating a probability automatically once it is edited by hand.
• Require pipeline source on every deal before it reaches the qualified stage, with a rule for partner and SDR deals.
• Report carry-in pipeline from 2026 as its own line, so a weak Q1 for new pipeline is not hidden by old deals closing.
• Re-forecast quarterly with actual cost per qualified opportunity and lag, and move budget with written rules rather than ad hoc.
• Never change the definition of a qualified opportunity mid-year without restating the earlier months.

The rules for moving money once the forecast shows a gap are in our 2027 budget reallocation rulebook.

In Salesforce, each opportunity stage aligns to a forecast category (Pipeline, Best Case, the optional Most Likely, Commit and Closed), and admins can change the mapping and the percent confidence for each category. Forecast types define the object, whether the forecast is revenue or quantity, the date used and the hierarchy. The marketing pipeline forecast uses the same plan model and the same five reports, built on opportunities with lead source or campaign fields. If your company runs Salesforce for sales and HubSpot for marketing, decide which system owns pipeline source before the year starts.

PlanConversion’s HubSpot RevOps work sets up the stages, source properties, reports and forecast so marketing and sales read the same pipeline numbers, and we do the same in Salesforce.

Start with the 2027 B2B marketing planning hub for the full planning sequence, or talk to our team about a pipeline forecast review before the plan goes to finance.