Cross-Channel Attribution Evaluation

"Website needs 4x ROAS, marketplace only needs 2x." Every D2C founder I meet sets different targets for different channels. They optimize each platform in isolation, cutting "unprofitable" campaigns without understanding the bigger picture. Here's the problem: Your Meta discovery ads aren't just driving website sales. 💥 The Hidden Reality Last quarter, I analyzed a beauty brand spending ₹1.5Cr monthly across channels. Their Facebook campaigns showed 2.8x website ROAS - below their 4x target. The founder wanted to cut budget immediately. But when we dug deeper, we discovered something critical: → 65% of their Amazon brand searches came from users who first saw Meta ads   → Quick commerce sales spiked 40% during Meta campaign periods   → Marketplace revenue dropped 30% whenever they reduced Meta spend  Their "unprofitable" 2.8x campaigns were actually generating 4.2x total business impact The attribution was invisible, but the influence was massive. 😕 Why This Happens Most founders make budget decisions using platform dashboards. But platform data only shows last-click attribution, not cross-channel influence. The reality: - Meta creates awareness - Google captures intent   - Marketplaces convert convenience purchases Cut your discovery budget based on siloed metrics, and watch your "profitable" channels mysteriously underperform next month. ➡️ The Bottom Line Stop measuring channel performance. Start measuring total business impact. The brands that scale fastest understand that discovery channels fuel everything else, even when you can't track it. What "unprofitable" channel have you discovered was actually driving hidden value across your business?

STOP evaluating channels in isolation. This is the biggest mistake I see brands making today - judging each marketing channel by its own metrics without understanding how they interact. That’s why we've developed a Total Business Framework that completely transforms how we measure marketing effectiveness. Here's how it works →  When a customer sees your TikTok ad, searches your brand on Google, clicks a shopping ad, but doesn't purchase... then later clicks an email and buys - who gets credit? In most attribution systems, only the email. But that's not the full story. Our framework tracks how Meta, Google, TikTok, and your organic channels interact throughout the entire customer journey. It de-duplicates conversions and creates a holistic view of your marketing ecosystem by: Setting business-level targets first Instead of starting with "What ROAS do we need on Facebook?" we ask "What total revenue do we need to generate this month?" Then, we work backward to determine each channel's contribution. Measuring cross-channel impact We've observed consistent patterns: when you scale paid social, you typically see corresponding increases in email performance, direct traffic growth, and branded search volume. These aren't coincidences - they're predictable interactions. De-duplicating conversion path Using first and last-touch attribution models creates massive blind spots. Our framework uses multi-touch attribution that weights each touchpoint appropriately based on its position in the funnel. This approach has helped brands understand the true ROI of their marketing investments. Some discover that platforms performing "below target" in isolation are actually driving significant revenue through other channels. Others identify underperforming channels that look good on paper but aren't contributing to overall business growth. The framework helps us set monthly goals for EVERY channel, not just the ones we manage. This ensures the entire business grows synergistically - paid drives awareness, email captures leads, SMS converts sales, and retention strategies maximize LTV. In today's fragmented customer journey, looking at channels in isolation is like trying to understand a movie by watching one scene. You need the complete picture to make smart decisions.

We just published new research on the TikTok Halo Effect and the results are hard to ignore. Most brands still measure TikTok Shop in isolation. Platform-level profitability. Did it 'work' on TikTok or not. That approach is fundamentally broken. We analysed aggregated data across TikTok Shop brands to understand what actually happens after someone discovers a product on TikTok. What we found: • TikTok Shop activity and Amazon sales show a strong correlation of ~0.86–0.87 once customer decision timing is accounted for • Amazon sales consistently rise 2–3 days after TikTok activity increases • On average, every £1 of TikTok Shop GMV is associated with ~£0.50–£0.60 of incremental Amazon revenue • TikTok is acting as a demand creation engine, not a standalone checkout channel In short: People discover on TikTok. They often convert on Amazon. And most attribution models miss this entirely. If you are judging TikTok Shop purely on same-day profitability, you are almost certainly underestimating its true impact. We published the full research here 👇 https://lnkd.in/ezWP3j6y This is exactly why cross-channel measurement matters in discovery-led commerce. Would be curious to hear how others are currently measuring TikTok’s downstream impact.

Reminder: Attribution is tempting and easy to calculate. The numbers look impressive. But noticing a touchpoint does not mean it influenced a consumer. This issue becomes even more problematic when each platform conducts its own attribution, counting only its own or some selected touchpoints to claim credit. However, the biggest problem is actually that there is no true counterfactual. For attribution models, we don't know who would have converted anyway or was influenced by other channels. In case of last-touch or click-based attribution, we don't even know what happened to those who saw ads but did not buy (or click on) our product. A little fun test to illustrate these points - check what your attribution solution would tell you if you ran only blank ads across all channels (still creating viewable impressions). If you just count arbitrary touchpoints, you will always get a positive result - and that's the problem. Attribution models may create an illusion that our ads 'work', when in reality our brand is not growing at all and we are just wasting ad dollars. What we need is insights into incremental conversions, both long and short term. And that's why marketers should embrace a combination of experimentation (geo-experiments and randomised controlled trials=RCT) and Marketing Mix Models (MMM). Image credit (an all time classic): Tom Fishburne https://lnkd.in/ggmEN9gp

Programmatic buyers who recognize the flaws in user-based attribution will appreciate this approach. In platform we measure the impact of each channel/tactic on conversion pixel fires over time, which has proven more effective than user-based attribution in numerous cases. Instead of the traditional user-based attribution method (“I showed this user an ad, I cookie the user, and if within 30 days they fire the pixel, the last ad shown gets credit”), we measure how spend in each channel/tactic impacts pixel fires. Our methodology: “I’m allocating spend to this channel/tactic; over time, we observe its impact on total conversion pixel fires and adjust budgets based on each channel/tactic’s effectiveness in driving those fires.” This enables more accurate measurement of hard-to-track channels in-platform, such as CTV, or environments where user ID is blocked or absent (e.g., iOS). It also eliminates lower-funnel bias and budget waste on organic conversions, a frequent user-based attribution pitfall. Prospecting spend has a longer attribution window but still demonstrates impact. Over-prioritizing retargeting and lower-funnel tactics reduces overall impact by depleting budget from channels/tactics that feed the lower funnel. We can still measure and report user-based attribution to clients. However, we present this impact analysis and allocate budgets based on measured impact.

𝐇𝐨𝐰 𝐈 𝐁𝐮𝐢𝐥𝐭 𝐚 𝐌𝐮𝐥𝐭𝐢-𝐂𝐡𝐚𝐧𝐧𝐞𝐥 𝐀𝐭𝐭𝐫𝐢𝐛𝐮𝐭𝐢𝐨𝐧 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐔𝐬𝐢𝐧𝐠 𝐎𝐧𝐥𝐲 𝐒𝐐𝐋 That’s how I built a Multi-Channel Attribution Dashboard that tracks revenue back to the real drivers, across Google Ads, Facebook Ads, email, and organic traffic — without a single BI tool. Here’s how it happened - The Problem: The client was spending across multiple channels, but GA4’s last-touch model wasn’t giving the full picture. Marketing teams were flying blind, and every channel wanted credit. So, I set out to answer: "Which channels actually drive conversions, and how do they work together?" The Solution: SQL-Only Attribution in BigQuery Using only SQL in BigQuery, I built a dashboard that: ✅ Tracks first-touch, last-touch, and linear attribution ✅ Allocates revenue proportionally to every user journey ✅ Connects ad spend to conversions across sessions and sources ✅ Supports flexible filters by date, campaign, device, and region How I Did It (Simplified) 1. Unified All Touchpoints • Pulled raw GA4 events data, including session_source, user_pseudo_id, and event_name. • Mapped all key user interactions — from ad clicks to checkout completions. 2. Created a Conversion Timeline • Used LAG() and ARRAY_AGG() to reconstruct user journeys. • Tracked each session leading up to a conversion event. 3. Applied Attribution Logic - Wrote modular SQL views for: • First-touch • Last-touch • Linear Each logic had its own SQL CTE, allowing a quick switch for comparison. 4. Joined Spend Data • Brought in Google Ads + Facebook Ads costs from external tables. • Linked spend to sessions via gclid and UTMs. 5. Final Output - A single BigQuery table showing attributed revenue by: • Channel • Campaign • Source/Medium • Attribution model Bonus: I connected it to Looker Studio later for visualization, but the real power? It’s all SQL. Why This Matters • Marketing teams don’t just need numbers; they need trust in their data. • When you eliminate the black-box tools and own your logic in SQL, you unlock freedom and transparency. Curious to see the SQL behind it? Drop a “SQL” in the comments and I’ll share a simplified version. #SQL #BigQuery #Attribution #MarketingAnalytics #DigitalAnalytics #GA4 #DataEngineering #MarketingOps #LookerStudio

Meta, Google, TikTok, and other ad channels are misleading you. Third-party attribution tools like Triple Whale and North Beam aren't better���they’re flawed too. Tracking has always relied on estimated models, not hard numbers. After iOS 14, tracking became harder, leading to a surge in third-party solutions. But these also provide conflicting data, making it tough to find the truth. So, what is the truth? The only reliable way to measure your marketing efforts is through incrementality tests. These tests answer the question, "What if this channel or ad never existed?" By showing ads to one group and withholding from another, you can measure the true impact on revenue and profit. For example, if you're running Facebook ads and selling on Shopify and Amazon, incrementality tests reveal how Facebook ads impact Amazon sales. Without the initial Facebook touchpoint, an Amazon purchase might not have happened, even though traditional attribution wouldn’t show this. This is why ROAS and third-party attribution aren’t accurate. They use models that can be thwarted by privacy settings and cross-channel purchases. By running incrementality tests, you discover the true impact of your marketing efforts. We ran a 14-day Meta holdout test and found that zip codes shown ads generated 50% more Amazon revenue than those not shown ads, despite sending traffic to Shopify. Now is the perfect time to run these tests. Q3 is calm, free from major holidays that skew results. This is your chance to optimize before Q4. If your brand generates seven figures annually, this should be a top priority to grow profits in Q4.

You're giving Google credit for conversions Meta started. Customer sees your Meta ad → searches your brand on Google → buys through Google Shopping. Meta gets nothing. Google gets the conversion. Your reporting says "Google is profitable, Meta isn't." So you shift budget to Google. Performance tanks. Turns out Meta was driving the demand that Google was capturing. The issue: last-click attribution hides Meta's actual impact. Most brands look at platform ROAS and make budget decisions based on incomplete data. Meta is generating awareness and consideration. Google and Klaviyo are closing. But if you only measure last-click, you'll systematically underinvest in Meta and wonder why your top-of-funnel dried up. The tracking fix: Set up custom conversions in Meta for: Google referral traffic (people who clicked a Meta ad, then came back via Google) Klaviyo referral traffic (people who clicked a Meta ad, then converted via email) Branded Google Shopping traffic (people searching your brand after seeing Meta ads) This doesn't change your actual performance. It just shows you what Meta is contributing beyond last-click conversions. But here's the uncomfortable part: If your blended metrics (total spend vs total revenue across all channels) are healthy, attribution modeling doesn't actually matter that much. It's more important for budget allocation between channels than for understanding if your marketing works. Where this really matters: when you're deciding whether to scale Meta spend and you need to prove it's driving demand that other channels are capturing. Without this visibility, you'll cap Meta spend prematurely because the ROAS looks worse than it is. Track it. But don't let attribution modeling become a substitute for testing channel incrementality properly.

I've spent $100M+ on Meta in DTC space And I use 3 attribution models: Ad platforms are notorious for taking credit for view-through conversions they didn't drive. They do it to bait you into spending more. The issue is that your top 1-2% of ads should drive ~50% of your spend and revenue. If you're relying on bad attribution, you won’t be able to find them. This is why 8-9 figure brands (that NEED their tracking to be faultless), use 3 attribution models: 1. Multi-touch attribution (MTA) - for ad and campaign level optimization. This is your Triple Whale or Northbeam. Great for knowing which ads are performing best, which ones to scale, which to cut. Not as good for comparing channel to channel. It also will overcount total revenue, which you need to be careful about. To make sure your account is well optimized, plot CPA vs Spend on a scatter plot. The top ads should be in the low CPA, high spend zone. 2. Post-purchase survey - for channel level allocation. Get a 35%+ response rate, extrapolate to all new customers, and calculate your cost per new customer response per channel. This tells you which channel to push into. Click-based attribution overvalues lower-funnel performance by up to 250%. Post-purchase surveys catch what click attribution misses - top-of-funnel creative can drive 13X more incremental acquisitions than bottom-of-funnel. 3. Marketing Mix Model (MMM) - for validating direction. You can't use this daily, but it confirms your post-purchase survey is sending you the right way. Then you use post-purchase on a daily basis to optimize channel allocation. Some channels drive low-quality customers that look good on ROAS but don't stick around. MMM helps you optimize for 12-month profit as opposed to just immediate return. The other thing to know is that view-through attribution is poor signal. Make sure your attribution is set up for 7 or 14 day click, depending on your purchase funnel. One day view will overcount. Here's what this gives you: When performance drops, you know exactly where to pull budget to create the smallest impact on revenue while keeping the company profitable. When things are going well, you know exactly where to push budget to scale effectively. Bottom line: -> Use MTA for ads and campaigns. -> Use post-purchase surveys for channel allocation. -> Use MMM to validate you're heading the right direction. This is how 8-9 figure brands figure out where every dollar should go.

Stop looking at channels. Start looking at relationships. We ran an experiment this week that broke our entire attribution model. The dashboard flagged one channel red. Underperforming. The playbook said kill it or cut the budget. Instead, (maybe just out of pure curiosity) we asked: What happens to everything else when this channel runs? Some observations: When this channel ran → downstream pipeline velocity jumped 70% When it paused → the whole system decelerated The channel wasn't creating direct conversion, but instead, it was supporting and amplifying the rest of the funnel. Here's what most attribution models miss: → They measure which channel touched the deal → They don't measure how channels influence each other → They optimize parts instead of understanding the system Your marketing isn't independent experiments (at least not anymore). It's an ecosystem. One channel might not convert directly, but it could be the reason three other channels perform better. This is where AI actually matters. But here's the gap: most AI platforms are still running last-touch or rule-based attribution underneath. They're automating old thinking faster. The real transformation is using computational techniques to reveal the hidden architecture of how your marketing actually works. Different channels play different roles: → Some convert directly → Some amplify what's already working → Some sustain momentum when other channels pause → Some create conditions for future conversions You need to see all of it. Causal inference techniques exist. They're not theoretical. They work in production right now on real B2B marketing data. The missing (human element) in a lot of this is imagination. Most teams optimize each channel independently because that's how their tools show them the data. What if your tools showed you the ecosystem instead? Do you optimize individual channels or the relationships between them?