Connecting marketing data: see which channel brings revenue
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 callHow 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.
| Connection | What travels | How |
|---|---|---|
| Ads, listings, emails → website | Where the visit came from | UTM tags on links; auto-tagging in Google Ads |
| Website form → CRM | Source, click ID, contact details | Hidden form fields, or the CRM's own tracking code |
| Calls and walk-ins → CRM | How they found you | A question at first contact, or a tracking number per source |
| Inside the CRM | Stage and amount | Mark each lead booked, won or lost, with the invoice total |
| Ad accounts → report | Spend | A monthly export, or a free dashboard |
| CRM → ad platforms (optional) | Which leads paid | Uploads 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.
| Tool | Knows | Can't know |
|---|---|---|
| Search Console | Searches, impressions, clicks, average position | Who contacted you |
| Google Analytics (GA4) | Visits, plus forms, calls and bookings by channel | Which lead paid, or how much |
| Google Ads, Meta Ads | Spend, clicks, their own conversion count | Your revenue, unless you send it back |
| CRM or job software | Each lead, its stage, its value | Its 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.
| Number | How to get it |
|---|---|
| Spend per channel | Google Ads, Meta Ads Manager, agency invoices |
| Leads, customers and revenue per source | Your 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.
| Platform | How | Fine print |
|---|---|---|
| Google Ads | Upload booked or paid jobs, matched on click ID or hashed email or phone | See tracking a lead from Google Ads to a booked job |
| Meta, Lead Ads | Conversions API for CRM sends each lead's stage | Meta's fit list: "Generate at least 200 leads per month", upload "at least once per day" |
| Meta, website leads | Conversions API events from your server | Send 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?
- Your forms and calls aren't tracked in Google Analytics yet: GA4 key events for a small business.
- You want Google Ads to bid on paid jobs: tracking a lead from Google Ads to a booked job.
- You want the full monthly report layout: the report to ask for.
- An agency holds your ad accounts: leaving your marketing agency.
- You run a clinic: tracking on a clinic website.
- You'd rather have every lead tracked to revenue for you: Conversion Agent.