Products SEO & GEO Agent Paid Ads Agent Website Agent Conversion Agent
How it works Pricing FAQ Blog Book a call

Connecting marketing data: see which channel brings revenue

Updated · 8 min read

Short answer Make your CRM or job list the hub, because it is the only place revenue lives. Label every lead with its source when it arrives (UTM tags, click IDs, a "How did you hear about us?" question), record what the customer paid on the same record, then set each channel's ad spend beside it. Live dashboards are optional.

Want help applying this to your business? Talk it through on a free 30-minute call.

Book a call

How to connect marketing data so revenue shows by channel

Build everything around one record per lead. Your CRM (customer relationship management software), booking or job software, or even a spreadsheet, is the hub: it is the only place that knows who paid and how much. Every other tool hands it a source or reads a result back.

ConnectionWhat travelsHow
Ads, listings, emails → websiteWhere the visit came fromUTM tags on links; auto-tagging in Google Ads
Website form → CRMSource, click ID, contact detailsHidden form fields, or the CRM's own tracking code
Calls and walk-ins → CRMHow they found youA question at first contact, or a tracking number per source
Inside the CRMStage and amountMark each lead booked, won or lost, with the invoice total
Ad accounts → reportSpendA monthly export, or a free dashboard
CRM → ad platforms (optional)Which leads paidUploads to Google Ads and Meta

Which tool knows your revenue?

Only the one that holds your invoices. The others each see one leg of the trip.

ToolKnowsCan't know
Search ConsoleSearches, impressions, clicks, average positionWho contacted you
Google Analytics (GA4)Visits, plus forms, calls and bookings by channelWhich lead paid, or how much
Google Ads, Meta AdsSpend, clicks, their own conversion countYour revenue, unless you send it back
CRM or job softwareEach lead, its stage, its valueIts source, unless you capture it

Search Console's rows hold clicks, impressions, click-through rate and "Average position in search results" (Search Console API documentation): useful for SEO, silent on money. So wire up the lead record first.

Step 1: give every lead a source

A lead without a source can't be credited to any channel. Four ways to label it, most automatic first.

Tag your links. A UTM tag is a label at the end of a link that tells analytics where the visit came from. Add one to every link you control: Meta ads, your Google Business Profile website link, emails, texts, and QR codes on flyers or trucks.

"When you add parameters to a URL, you should always use utm_source, utm_medium, and utm_campaign." (Analytics Help: URL builders)

Keep tags lowercase: Google treats "Meta" and "meta" as different values (same page).

Let Google Ads tag itself. With auto-tagging on, each ad click carries a click ID your form can save. See tracking a lead from Google Ads to a booked job.

Carry the source into the CRM. Add hidden form fields that store the UTM values and click ID, or use a CRM that tracks visits itself. HubSpot does this on all plans:

"Based on actions taken by the contact, HubSpot automatically updates the Original and Latest Traffic Source values." (HubSpot Knowledge Base)

Original is the person's earliest visit, even months before the form; Latest is the most recent.

Ask. Calls, referrals and walk-ins carry no tag. Ask "How did you hear about us?" at first contact and pick the answer from a fixed list in the CRM, or give each source its own tracking phone number.

Step 2: record what each lead paid

When a lead books, mark it booked. When the job is paid, mark it won and enter the invoice amount. Keep lost leads, marked lost: they show which channel brings people who never buy.

For a few dozen leads a month, a spreadsheet works: date, name, source, stage, amount. A CRM saves the typing. Either way, each customer appears once, with one source. Add repeat jobs to the same record, so the channel that found the customer gets credit for later visits too.

Step 3: put spend next to revenue

Once a month, pull spend from each ad account and set it beside your CRM totals.

NumberHow to get it
Spend per channelGoogle Ads, Meta Ads Manager, agency invoices
Leads, customers and revenue per sourceYour CRM
Cost per customer (CAC)Spend ÷ new customers
Return on ad spend (ROAS)Revenue ÷ ad spend

Channels with no ad bill, such as your Business Profile or referrals, still get a row. For the full layout, see the report to ask for.

Don't add up the platforms' own counts. Google Ads records conversions after a click, and "the default window is 30 days" (Google Ads Help: About conversion windows). Meta also offers view windows, crediting ads people saw but never clicked (Meta Marketing API documentation). One customer can count in both. Your CRM gives them one source.

Link Google's free tools. In GA4, under Admin, Product links:

  • Google Ads links let you "see the full customer cycle, from how users interact with your marketing (e.g., clicking ads) to how users finally complete the key events on your site" (Analytics Help). Data arrives "within 48 hours".
  • Search Console links add two reports, search queries and organic landing pages. They are "unpublished by default"; publish them from Library (Analytics Help).

Automate it if you like. Data Studio, Google's free dashboard tool (called Looker Studio until April 2026), connects directly to Google Sheets, Google Ads and Google Analytics (Google Cloud). Export your CRM to a Sheet, and the report updates with it.

Step 4 (optional): tell the ad platforms who paid

Ad platforms aim at whatever you count as a result. Tell them which leads paid, and their bidding chases customers instead of form fills.

PlatformHowFine print
Google AdsUpload booked or paid jobs, matched on click ID or hashed email or phoneSee tracking a lead from Google Ads to a booked job
Meta, Lead AdsConversions API for CRM sends each lead's stageMeta's fit list: "Generate at least 200 leads per month", upload "at least once per day"
Meta, website leadsConversions API events from your serverSend each event within 7 days of when it happened

Meta's CRM option also needs the stage you optimize for to happen "within 28 days after you generate the leads" (Meta for Developers: Conversions API for CRM integration). Contact details go hashed, turned into a one-way code that can be matched but not reversed: Meta's systems "are designed to not accept customer information that is unhashed Contact Information" (Meta for Developers: Customer information parameters).

Under 200 Lead Ads leads a month, skip Meta's CRM option; steps 1 to 3 are the payoff.

Do you need real-time data?

Not to decide where money goes. Revenue lands when jobs are paid, days or weeks after the click, and a few dozen leads a month swing a lot week to week. Check leads weekly and revenue by channel monthly.

Only the upload back to ad platforms runs on a clock. Meta's CRM option asks for uploads "at least once per day", and Meta refuses late events:

"If any event_time in data is greater than 7 days in the past, we return an error for the entire request" (Meta for Developers: Server event parameters)

That is a scheduled job, not a live dashboard.

Is it safe to connect my accounts to a marketing tool?

Yes, if you keep control of access and of customer data.

  • Give access, never your password. Google Ads access levels run from Email-only and Read-only to Standard and Admin, and only Admins can give others access (Google Ads Help: About access levels). A reporting tool needs read-only.
  • Ask vendors that store customer data for their SOC 2 report. It is a CPA's examination of a service provider's controls "Relevant to Security, Availability, Processing Integrity, Confidentiality, or Privacy" (AICPA & CIMA). A report, not a badge: read it and check the period it covers.
  • Remove access when you drop a tool or an agency: see leaving your marketing agency.
  • Get consent where required. For customer data uploads, Google says: "Make sure that you also get consent where required by law or any applicable Google policies governing user consent" (Google Ads Help: About offline conversion imports). In Quebec, a business collecting personal information with technology that can identify, locate or profile someone must first tell them it does, and how to activate those functions (private-sector privacy act, section 8.1). US clinics: see tracking on a clinic website.

Example

Illustrative cases. Numbers are invented for the example.

A plumber on Google Ads and Meta (US dollars)

Monthly spend: $3,000 on Google Ads, $1,000 on Meta. The CRM shows Google Ads with 15 paid jobs worth $9,000, Meta with 3 jobs worth $1,200, and the Business Profile with 10 jobs worth $6,500 at no ad cost. Cost per customer: $200 on Google, $333 on Meta. Return: $3 per $1 on Google, $1.20 on Meta. Meta's dashboard claimed 35 conversions; the CRM logged 30 Meta leads.

A dental office whose software has no source field (Canadian dollars)

The front desk adds "How did you hear about us?" to the new-patient form and types the answer into a custom field. Three months later, 15 of 90 new patients came from Instagram ads that cost C$1,500. They paid C$6,000 in their first visits: C$4 back per C$1.

A renovation firm with slow contracts

It gets 40 Meta Lead Ads leads a month and signs contracts six to eight weeks later, so it misses Meta's 200-lead minimum and 28-day limit. It skips step 4, keeps the CRM report, and judges channels each quarter, since a few large contracts make any one month noisy.

FAQ

Do I need a CRM to see revenue by channel?

No. A spreadsheet with one row per lead (date, source, stage, amount) works. A CRM pays off past a few dozen leads a month.

Can Google Analytics show revenue by channel?

Not for jobs paid offline. GA4 records site actions, such as a form or call tap, not the invoice that follows. See GA4 key events.

Why does my report show "(not set)"?

Usually a link is missing tags. Google says missing UTM parameters "will result in (not set) values being present in reporting" (Analytics Help: URL builders).

First source or last source: which should I use?

First source shows how people found you; last source shows what made them call or write. Keep both if your CRM allows.

Different for you?

Keep learning

NextContribution margin in marketing: calculate profit per campaignHow to work out one campaign's contribution margin: revenue from paid jobs, minus the costs each job adds, minus what the campaign cost. With examples.

Ask us one question

One line is enough. We reply by email.

Sources

  1. Search Console API: Search Analytics query
  2. Analytics Help: URL builders, collect campaign data with custom URLs
  3. HubSpot Knowledge Base: Update and filter contacts using traffic source properties
  4. Google Ads Help: About conversion windows
  5. Meta for Developers: Ad campaign insights (attribution windows)
  6. Analytics Help: Connect Google Ads to Google Analytics
  7. Analytics Help: Connect Search Console to Google Analytics
  8. Google Cloud: Data Studio
  9. Data Studio documentation: Looker Studio is now called Data Studio
  10. Meta for Developers: Conversions API for CRM integration
  11. Meta for Developers: Server event parameters
  12. Meta for Developers: Customer information parameters
  13. Google Ads Help: About access levels in your Google Ads account
  14. AICPA & CIMA: System and Organization Controls (SOC) suite of services
  15. Google Ads Help: About offline conversion imports
  16. LégisQuébec: Act respecting the protection of personal information in the private sector, s. 8.1