How Do I Connect Paid Media Costs to CRM Revenue?

How do I connect Google Ads and paid social spend to CRM revenue?

Build one unbroken record from ad click to closed deal. The job is simple in concept: collect campaign evidence at conversion, retain it on the contact and opportunity, then join those records to spend. The hard part is not the dashboard. It is letting the evidence disappear halfway through the funnel.

Start with a source spine: a small set of fields that travels with the lead. For Google Ads, retain the GCLID when available. Google recommends including GCLID values with uploaded conversion events whenever possible because they improve attribution to specific ad clicks. Also retain UTMs, campaign name, source, medium, landing page, conversion date, and a stable CRM contact or lead ID.

1. Tag every destination. Use a consistent UTM convention for paid search and paid social. The phrase to align on internally is: “If we cannot name the campaign consistently, we cannot report it consistently.”
2. Write the values into the CRM at lead creation. Do not rely on a later spreadsheet merge to reconstruct source data. HubSpot distinguishes Original Traffic Source, the first known web source, from Latest Traffic Source, the most recent known web source; both are useful, but they answer different questions.
3. Attach the contact to the commercial record. When sales creates an opportunity, preserve the campaign association and connect it to the deal amount and outcome.
4. Return real business outcomes. Google Ads supports offline conversion imports for sales completed through representatives, phone, or other non-web processes. Its documented flow includes normalizing and hashing user data, creating click conversion records, importing them, and reviewing the result.
5. Join costs to outcomes. Aggregate ad spend by the same date range and campaign key used in CRM reporting. If the keys do not match, fix the naming rule before debating performance.

Google’s enhanced conversions for leads can connect an ad click, a website lead form, CRM-held data, and a later outcome such as a customer. According to Google Ads Help, the process can match hashed first-party lead data, such as an email address, to the campaign that generated the lead. That is the bridge between acquisition cost and revenue, not another top-of-funnel counter.

For paid social, the principle stays the same even when the matching method differs: persist campaign data at capture, associate it with opportunities, and report downstream stages. Treat platform-reported conversions as operational signals. Treat CRM outcomes as the commercial scoreboard.

What is the difference between cost per lead and cost per qualified lead?

Cost per lead measures the price of creating a contact; cost per qualified lead measures the price of creating a contact that your agreed process says is ready to advance. They are not interchangeable. The first tells you whether a form converts. The second tells you whether the money produced a lead worth sales attention.

Use your CRM’s lifecycle definitions rather than a vague label. HubSpot’s lifecycle-stage guidance defines a Lead as a contact or company that converted through a website or other interaction, a Marketing Qualified Lead as qualified by marketing for sales, and a Sales Qualified Lead as qualified by sales as a potential customer. An Opportunity is associated with a deal; a Customer has at least one closed deal.

That sequence gives the metric hierarchy its shape: spend, leads, marketing-qualified leads, sales-qualified leads, opportunities, pipeline, and closed revenue. Report all of them. A channel can produce low-cost leads and still create no opportunities. Calling that channel efficient loads the cognitive cost onto sales, which must sort through contacts that never had a credible path forward.

Use this reporting sentence in reviews: “This campaign produced leads at one cost, qualified leads at another cost, and this amount of pipeline and closed revenue.” It keeps the discussion on business movement. It also prevents a low cost per lead from ending the conversation too early.

This is the same discipline that helps a budget-conscious reader compare an investment decision: cost is only meaningful beside the outcome it can produce. The principle behind How Should I Invest $400,000 Without Taking Too Much Risk? applies here too: judge a number in the context of what it is meant to achieve.

Which CRM fields do I need for marketing revenue attribution?

You need fields for identity, acquisition source, stage movement, opportunity value, and outcome. Keep the model lean. A field that nobody completes or trusts is reporting decoration, not attribution data.

• Identity: contact or lead ID, email where permitted, account or company, and opportunity or deal ID.
• Acquisition: original source, latest source, UTM source, medium, campaign, content, landing page, and click identifier when available.
• Stage movement: current lifecycle stage plus dates entered into qualified-lead and opportunity stages.
• Commercial outcome: opportunity amount, closed status, closed date, and closed revenue.
• Attribution link: campaign membership or a campaign-influence record tied to the opportunity.

For a Salesforce team, Salesforce Customizable Campaign Influence combines sales and marketing data and stores an attribution percentage on influential campaign records. That supports predefined or custom models instead of forcing every opportunity into a single winner.

Run a weekly three-way check. Compare platform conversions, analytics conversions, and CRM-created records for the same campaign and date range. Next, compare CRM leads with qualified leads and opportunities. Finally, inspect a small set of records where the source is blank, unexpected, or duplicated. The goal is not identical totals. The goal is an explainable difference.

HubSpot explicitly notes that ad blockers can block tracking cookies and affect traffic-source properties. Google also advises importing all available offline conversion events, including events that may not have come from Google Ads. Those details explain why a clean reconciliation process beats pretending that one system is perfect.

ANA’s 2025 study of senior U.S. B2B marketing leaders found that only 39% were extremely or very confident in measuring marketing’s impact on financial performance. The same study reported that confident marketers were more likely to have fully or mostly integrated data systems. The lesson is practical: integration is not a reporting luxury. It is the operating requirement for a revenue conversation.

Your next move: open one live paid campaign this week and trace a single lead from click data to CRM record to lifecycle stage to deal outcome. Mark the first field that goes missing. Fix that field before building a prettier dashboard.