How to Connect Marketing Reporting to Sales Outcomes

Why the two reports never meet

In most established organizations, marketing and sales each have a report they trust. Marketing’s comes from GA4 and the ad platforms: sessions, form submissions, cost per lead. Sales has the CRM, or a spreadsheet: calls, proposals, wins. Each report is defensible on its own terms. Put side by side, they do not connect.

So the budget meeting goes the familiar way. Marketing says leads are up. Sales says the leads are poor. Leadership has no way to tell who is right, and decides based on who argues best.

The fix is a chain of data that follows a lead from first click to closed deal, with agreed definitions at each step. None of it is technically exotic. It requires a CRM, a few hidden form fields, some discipline from sales, and a willingness to report less precisely than the software suggests you can.

Agree on lead stages and definitions

Before any data work, marketing and sales sit in the same room and agree on the stages a lead moves through and what qualifies it for each. A workable set for most service businesses:

1. Inquiry. Anyone who submits a form, books a call or phones in. Raw volume.
2. Qualified lead. An inquiry that fits: right type of client, right service, right geography, plausible budget or need. Defined by written criteria, not instinct.
3. Opportunity. A qualified lead where sales has had a real conversation and a proposal, quote or next step exists.
4. Won. A signed deal, booked job or first invoice, with a value.
5. Lost or disqualified, with a reason chosen from a short list (wrong fit, price, timing, went with competitor, no response).

The qualification criteria matter most. If “qualified” means whatever the sales rep feels that day, every downstream number is noise. Write three to five criteria, test them on last quarter’s leads, and revise once. The reasons for loss matter almost as much: “wrong fit” points to targeting, “price” points to positioning or the offer, “no response” may point to how fast the lead was followed up.

These definitions belong in your marketing measurement plan, signed off by both sides.

Capture source data in the CRM

A CRM record without a source is useless for marketing reporting. Most CRMs do record something, but often only “web form” or whatever the rep typed in.

What to capture at the moment of inquiry

• UTM parameters from the visitor’s landing URL: source, medium, campaign, and content if you use it. Store them in hidden form fields, ideally captured on the first visit and carried through, so a visitor who browses five pages before converting still has the original campaign attached.
• Ad click identifiers such as Google’s click ID. These are what allow you to send outcomes back to the ad platform later.
• Landing page and the page the form was on.
• A self-reported source. A simple “How did you hear about us?” field catches word of mouth, podcasts, events and the conversation at the rink that no tracking will ever see.

Many CRMs (HubSpot, Salesforce, Pipedrive and others) have native integrations that do some of this automatically. Check what yours captures before building anything, and test it with a tagged link to make sure the values actually arrive.

Phone and email inquiries

For many Atlantic Canadian businesses, the most serious inquiries still arrive by phone. Call tracking with dynamic numbers can attribute calls to channels; at minimum, ask callers how they found you and record it. Leads that bypass the form are not lost to reporting if the intake process records them consistently.

Report by stage and by source

Once leads carry their source and sales records stage and outcome, the core report is a simple grid: each source or channel down the side, each stage across the top. Inquiries, qualified leads, opportunities, won deals, won value.

This report answers questions the separate reports cannot:

• Which channel produces volume but rarely produces qualified leads?
• Which channel produces few inquiries but a high share of opportunities?
• Where does the funnel leak: at qualification (a targeting problem) or between opportunity and win (a sales or offer problem)?
• What is the cost per qualified lead and per opportunity by paid channel, rather than cost per form fill?

An illustrative example. Say a 40-person accounting firm with three offices sees that LinkedIn ads produce fewer inquiries than Google search, at a higher cost per inquiry. On a marketing report, LinkedIn looks like the weaker channel. On the stage report, LinkedIn inquiries qualify and become opportunities much more often, because they come from the business owners the firm wants. The decision flips. That is the entire value of connecting the reports, and it is why measuring lead quality from paid campaigns matters more than measuring lead volume.

Use a time lag sensibly. If your sales cycle is two months, this month’s inquiries cannot be judged on this month’s wins. Report cohorts: inquiries from a given month, and what they became over the following quarter.

Close the loop with the ad platforms

Once the CRM knows which leads qualified, that information is valuable to the ad platforms too. Google Ads and Meta both accept imported outcomes from your CRM, tied to the original click, so their bidding can learn to find more people who become qualified leads rather than more people who fill in forms.

This requires the click identifiers mentioned above, a regular upload or integration, and respect for the consent the visitor gave. It is one of the most useful forms of server-side tracking, covered in more detail in client-side vs server-side conversion tracking. For B2B organizations with long sales cycles it is often the single change that most improves paid performance, because the platforms stop optimizing toward the cheapest form fill.

Attribution without overclaiming ROI

Here is where good reporting most often goes wrong. Once revenue is in the CRM with a source attached, it is tempting to divide revenue by spend and present a return figure to the board. Resist, or at least caveat it heavily.

• Attribution models are conventions, not facts. First-touch credits whatever brought the person in; last-touch credits whatever they clicked before converting. Both are partly wrong. Data-driven models in ad platforms are better informed but cannot see your offline sales process.
• Tracking is incomplete. Consent choices, blocked scripts, phone calls, referrals and cross-device journeys mean a meaningful share of journeys are invisible or misattributed.
• Some revenue would have happened anyway. Branded search ads, in particular, often capture people who were already coming. Crediting them with the full deal overstates the effect of spend.
• Long cycles and repeat clients complicate everything. A deal that closes after two years of relationship-building was not caused by the ad clicked last week.

What to report instead: marketing-sourced pipeline and revenue by channel, presented as directional evidence, with the attribution method named and the known gaps listed. Compare channels against each other over time using the same method; do not treat any single figure as precise. If a decision would flip based on small differences in attribution, it is not a decision the data can settle. Test it instead: pause or increase a channel in one region or period and watch what happens to qualified leads.

A board will forgive a number with honest caveats. It will not forgive a precise return figure that turns out to have been built on guesswork.

Making it stick

The technology is the easy part. The hard part is sales recording stages and outcomes consistently, every time, including the losses. A few things help:

• Keep the required fields few. Stage, qualification, outcome, loss reason. Nobody fills in fifteen.
• Show sales what they get back: better leads, because marketing can finally see which sources waste their time.
• Review the stage report together, monthly, with marketing and sales in the same meeting.
• Audit a sample of records each quarter for missing sources and stale stages.

The output is one shared view that marketing, sales and leadership all read. That is the core of an executive marketing dashboard, and the reason our analytics and measurement work treats the CRM as part of the measurement system rather than something that belongs to sales alone. For the wider B2B context, our B2B lead generation playbook covers the channels feeding this pipeline.