Back to Resources
Data Attribution & ROI 7 min read

How Can I Prove Which Marketing Channel Actually Drove Revenue?

Wali Nori
Wali Nori
12 March 2024

The Attribution Credibility Problem

Every channel claims more credit than it deserves. Google Ads says it drove 45% of conversions. Meta says it drove 38%. Email marketing says 29%. Add it up and you have 112% of your conversions attributed, which is mathematically impossible. This is the double-counting problem that makes channel attribution reports distrust magnets with finance teams. The solution isn't a better attribution model, it's a disciplined data infrastructure that establishes one authoritative system of record for channel performance, fed by clean, consistent tracking data from every source.

Building the UTM Framework: The Non-Negotiable Foundation

Channel attribution starts with consistent UTM parameter usage across every marketing channel. The structure: utm_source (the platform, google, linkedin, meta, newsletter), utm_medium (the format, cpc, organic, email, social), utm_campaign (the campaign name, use consistent naming conventions like YYYY-MM-CampaignName), utm_content (the ad or content variant), utm_term (for search, the keyword). Create a UTM naming convention document that every person managing any channel must follow, inconsistent UTM use (mixing "google" with "Google" with "google_ads") creates fractured data that's impossible to aggregate accurately. Store first-touch and last-touch UTM parameters as dedicated properties in your CRM.

The CRM as Your Attribution Source of Truth

Platform-native attribution (what Google Ads reports, what Meta reports) will always claim more credit than reality because each platform only sees the touchpoints it controls. Your CRM is the only system that can see the full journey from first marketing touch to closed deal. The architecture: store UTM parameters from every form submission and tracked website visit in HubSpot; log all offline touchpoints (calls, meetings, referrals) as HubSpot activities with a channel tag; connect deal closed-won events to the associated contact's channel history; build a Looker Studio report that joins CRM deal data with channel spend data from a central data source. This report, not any platform's self-reported attribution, is your system of record.

Incrementality Testing: The Gold Standard

For channels with high uncertainty (display, social, branded search), the most rigorous attribution method is incrementality testing: turning off a channel for a defined period and measuring the change in conversions that can't be explained by other factors. This is difficult to do at scale but straightforward for individual channels. Run a 4-week holdout test where 20% of your target audience doesn't see your Meta ads, and compare conversion rates between the exposed and holdout groups. The difference in conversion rate represents the true incremental lift of that channel, independent of any model-based attribution.

Communicating Attribution to Finance and Leadership

When presenting channel attribution to finance or leadership, the key is acknowledging model uncertainty while presenting directionally confident conclusions. Use a range rather than a point estimate: "Based on our CRM attribution data, SEO contributed between 28–35% of closed revenue in Q1, while Google Ads contributed 20–28%", acknowledging the measurement uncertainty while still providing actionable insight. Pair this with channel-specific efficiency metrics (Cost Per Acquired Customer by channel) rather than just revenue attribution, as efficiency metrics are more directly actionable for budget allocation decisions. Excel's Looker Studio dashboards include pre-built channel attribution views for all major B2B channels.

Wali Nori
Wali Nori
Founder of Excel Consultancy. Digital marketing and marketing operations specialist with 3 years building automation systems and tracking infrastructure for SMEs across Australia and Europe.
Connect on LinkedIn