analytics

Omnichannel Attribution: First-Click vs Last-Click vs Data-Driven Algorithmic Attribution Models

A mathematical and architectural guide to modern omnichannel attribution. Compare first-click, last-click, Shapley Value, and Markov Chain models. Reconcile bottom-up BigQuery clickstream data with top-down Marketing Mix Modeling.

By Taym Residoglu

Executive Overview: The Collapse of Single-Touch Attribution

Relying on platform-reported attribution or single-touch models is an expensive capital allocation mistake. Following Apple App Tracking Transparency (ATT) and Safari Intelligent Tracking Prevention (ITP), ad dashboards operate as uncalibrated claim engines. Summing reported revenues from Meta, Google, TikTok, and affiliate networks routinely produces 200% to 300% of actual collected bank revenue. True measurement in 2026 requires an integrated tri-factor architecture. This combines bottom-up BigQuery event ingestion, algorithmic multi-touch modeling (Markov Chains and Shapley Values), and top-down Marketing Mix Modeling (MMM).

Modern brands navigate a fragmented measurement landscape. A typical customer journey is no longer linear:

1. A user discovers a skincare brand via an Instagram Reel ad during their morning commute.

2. At lunch, they research customer reviews on a work desktop via organic Google search.

3. Three days later, they click a non-branded Google Shopping ad on an iPad to compare sizes.

4. Two days later, they click a promotional Klaviyo SMS message.

5. That evening, they open an incognito browser tab on a personal laptop. They search the brand name on Google, click a branded search ad, and complete a $140 checkout.

In this five-touch journey across three devices, every channel claims total responsibility:

  • Meta claims a 7-day view-through or 1-day click conversion because the user saw the Reel ad.
  • Google Ads claims a conversion for the non-branded shopping click and another for branded search.
  • Klaviyo records the purchase as 100% flow-attributed revenue.
  • The affiliate network asserts a commission claim if a coupon extension fired at checkout.
  • If executive teams allocate budget based on these isolated in-platform ROAS figures, they enter a destructive loop. They overfund conversion-finishing channels (branded search and retargeting). Meanwhile, they defund top-of-funnel prospecting that drives new demand.

    To understand macro financial metrics for governing growth capital, read our guide on ROAS vs ROI Growth Metrics.

    Mathematical Breakdown of Heuristic Attribution Models

    Heuristic models apply static rules to distribute revenue credit across touchpoints. While simple to explain, every heuristic model carries structural biases that distort marketing capital allocation.

    1. First-Click (First-Touch) Attribution

    First-Click attribution assigns 100% of conversion credit to the initial recorded touchpoint:

  • Intended Purpose: Identifies channels that introduce completely new prospects into the marketing funnel.
  • Structural Distortion: Over-credits top-of-funnel visual media (Meta video, TikTok ads, and display banners). It completely ignores mid-funnel education and bottom-of-funnel conversion closing.
  • Capital Allocation Consequence: Marketing teams over-invest in high-volume, low-intent traffic. Conversion rates crater because mid-funnel nurture workflows receive inadequate budget.
  • 2. Last-Click (Last-Touch / Non-Direct Last-Click) Attribution

    Last-Click attribution assigns 100% of conversion credit to the final non-direct interaction before purchase:

  • Intended Purpose: Identifies the immediate conversion trigger that persuaded the prospect to buy.
  • Structural Distortion: Heavily biases budget toward branded Google Search, coupon code aggregators, and aggressive retargeting.
  • Capital Allocation Consequence: The brand pays high bids to capture customers who had already decided to purchase. Teams curtail prospecting spend because cold campaigns show low last-click ROAS. Within 3 to 6 months, top-of-funnel discovery collapses, drying up organic and branded search volume.
  • 3. Linear Attribution

    Linear attribution divides economic credit equally across all recorded touchpoints:

  • Intended Purpose: Democratizes credit across every touchpoint, acknowledging that complex purchase cycles require multiple contacts.
  • Structural Distortion: Assumes every interaction carries identical economic importance. A passive display ad impression is treated the same as a 20-minute product configuration session.
  • Capital Allocation Consequence: Low-quality, high-frequency channels (such as programmatic display networks) appear artificially efficient simply by inserting impressions into user paths.
  • 4. Time-Decay Attribution

    Time-Decay attribution weights touchpoints according to temporal proximity to the conversion event. The decay rate follows an exponential half-life parameter $\lambda$ (typically 7 days):

    Where $t_{\text{conversion}} - t_i$ represents the days elapsed between touchpoint $i$ and the transaction.

  • Intended Purpose: Balances credit across journeys while recognizing that interactions occurring minutes before purchase hold higher conversion momentum.
  • Structural Distortion: Heavily discounts top-of-funnel interactions for considered purchases with longer sales cycles (such as luxury furniture or enterprise software).
  • 5. Position-Based (U-Shaped and W-Shaped) Attribution

    Position-based models assign fixed percentages to strategic milestones:

  • U-Shaped: Assigns 40% credit to the first touchpoint, 40% to the lead conversion touchpoint, and splits 20% evenly across intermediate touches:
  • W-Shaped: Adds a third anchor (opportunity creation) at 30%, allocating 30% first touch, 30% lead creation, 30% opportunity creation, and 10% across remaining steps.
  • Structural Distortion: Imposes arbitrary assumptions on customer journeys. Discovery and closing rarely equal exactly 40% across every price point and vertical.
  • Algorithmic Attribution: Shapley Value and Markov Chain Modeling

    Algorithmic attribution removes static human heuristics. Instead of assuming touchpoint weights, algorithmic models evaluate thousands of customer paths. They compute channel contribution based on empirical probability changes.

    1. Shapley Value Attribution (Cooperative Game Theory)

    Formulated by Lloyd Shapley in 1951, the Shapley Value solves a classic game theory challenge: In a cooperative coalition producing a joint payout, how should gains be divided based on marginal contribution?

    In marketing attribution:

  • The players are marketing channels: $N = \{\text{Meta}, \text{Google Non-Brand}, \text{Email}, \text{Brand Search}\}$.
  • A coalition $S \subseteq N$ is any specific channel combination in a customer journey.
  • The characteristic function $v(S)$ represents conversion rate or revenue generated by coalition $S$.
  • The Shapley Value $\phi_i(v)$ allocated to channel $i$ is calculated across all subsets excluding $i$:

    Where:

  • $|S|$ is the channel count in coalition $S$.
  • $|N|$ is the total number of channels evaluated.
  • $v(S \cup {i}) - v(S)$ is the marginal conversion gain achieved when adding channel $i$ to coalition $S$.
  • The combinatorial factor $\frac{|S|!(|N| - |S| - 1)!}{|N|!}$ represents the sequence probability under random ordering.
  • #### Practical Example:

    Suppose a dataset evaluates two channels: Meta Ads ($M$) and Email ($E$):

  • Conversion rate of users who saw neither: $v(\emptyset) = 0.01$ (1%)
  • Conversion rate of users exposed only to Meta: $v(\{M\}) = 0.03$ (3%)
  • Conversion rate of users exposed only to Email: $v(\{E\}) = 0.04$ (4%)
  • Conversion rate of users exposed to both Meta and Email: $v(\{M, E\}) = 0.08$ (8%)
  • Marginal contribution of Meta:

  • When joining the empty set: $v(\{M\}) - v(\emptyset) = 0.03 - 0.01 = 0.02$
  • When joining Email: $v(\{M, E\}) - v(\{E\}) = 0.08 - 0.04 = 0.04$
  • Weighting each sequence equally (50% probability):
  • Marginal contribution of Email:

  • When joining the empty set: $v(\{E\}) - v(\emptyset) = 0.04 - 0.01 = 0.03$
  • When joining Meta: $v(\{M, E\}) - v(\{M\}) = 0.08 - 0.03 = 0.05$
  • Weighting each sequence equally (50% probability):
  • The Shapley Value mathematically proves the synergy between Meta and Email, distributing credit based on marginal lift.

    2. Markov Chain Attribution Modeling

    Markov Chain attribution models customer browsing paths as a directed stochastic process. The system transitions through finite states:

    The transition probability $P_{ij}$ from state $i$ to state $j$ is calculated empirically from observed user event logs:

    Where $N_{ij}$ is the total number of transitions observed from channel $i$ directly to channel $j$.

    #### The Removal Effect Principle

    To determine the true economic value of channel $i$, the algorithm simulates removing channel $i$ from the transition matrix. When channel $i$ is removed, paths relying on channel $i$ divert to the terminal $\text{Null}$ state.

    The overall conversion probability of the intact network is $P(\text{Conversion})$. The conversion probability with channel $i$ removed is $P(\text{Conversion} \mid \text{Channel } i \text{ Removed})$.

    The Removal Effect ($RE_i$) is:

    Channel attribution normalizes each channel's Removal Effect against the sum of all Removal Effects:

    Channels that act as essential conduits show high removal effects. Low-value intermediary channels that add friction show low removal effects, even if they appear in many user paths.

    Quantitative Empirical Attribution Model Comparison

    The benchmark table below compares all seven major attribution models across mathematical foundations, biases, and risks:

    For deeper perspective on allocating capital between Google Ads and Meta, read our guide on Meta Ads vs Google Ads: Capital Allocation.

    Unified Data Warehousing Architecture in Google BigQuery

    To calculate algorithmic attribution without vendor lock-in, enterprise brands build an owned data pipeline in Google BigQuery managed via dbt (data build tool).

    Production BigQuery SQL: Building Stitched Multi-Touch Paths

    The following SQL query extracts raw GA4 events, sessionizes touchpoints, and maps them to converted orders within a 30-day window:

    This clean path representation serves as the input for Python Markov Chain and Shapley Value routines in Google Cloud Run.

    Triangulating Truth: Blending Top-Down MMM with Bottom-Up Clickstream

    Even advanced bottom-up clickstream attribution has blind spots:

    1. Ad Blocker Bias: Over 30% of desktop users run script blockers that prevent tracking tags from firing.

    2. Untracked Offline Channels: Clickstream cannot record TV ads, podcast sponsorships, direct mail catalogs, or retail wholesale orders.

    3. Correlation vs Causation: A customer ready to convert may click a branded search ad simply because it occupied the top link on Google. Clickstream attributes 100% of revenue to Google Ads, confusing correlation with incremental lift.

    Enterprise teams resolve this with Attribution Triangulation: reconciling econometric MMM, algorithmic MTA, and incrementality tests.

    1. Top-Down Marketing Mix Modeling (Robyn and LightweightMMM)

    Marketing Mix Modeling (MMM) uses multivariate time-series regression to measure macro marketing impact on total sales:

    Where:

  • $Y_t$ is total revenue in week $t$.
  • $f(\text{Spend}_{m, t})$ applies transformations for Adstock Decay (carryover awareness) and Diminishing Marginal Returns (Hill saturation functions).
  • $X_{c, t}$ controls for exogenous variables: inflation indices, seasonality, holidays, and competitor pricing.
  • $\epsilon_t$ represents unobserved error.
  • Open-source frameworks like Meta Robyn and Google Meridian use Bayesian inference to calculate macro coefficients without user cookies.

    2. Incrementality Testing as the Calibration Ground Truth

    To calibrate MMM and MTA models against real performance, brands run controlled incrementality tests:

  • Geo-Split Holdout Testing: Select 20 matched metropolitan areas (DMAs) with similar baseline revenue. In 10 treatment DMAs, increase Meta spend by 50%. In 10 control DMAs, keep Meta spend flat.
  • Measure total company revenue variance across both groups over six weeks.
  • The resulting incrementality coefficient reveals whether ad spend created incremental sales or merely intercepted existing demand.
  • Feed this empirical lift coefficient into the Bayesian priors of both the BigQuery attribution model and the Robyn MMM model.
  • Check out the case studies: Beroea Home Case Study and Clinicana Case Study.

    Capital Allocation Decision-Making with Attribution Confidence Intervals

    Chasing a single fixed performance number is a costly mistake (such as claiming Meta ROAS is exactly 3.42x). Every model produces an estimate with variance and tracking latency.

    Experienced revenue architects manage marketing capital using Attribution Confidence Intervals and Marginal ROAS (mROAS) curves.

    From Blended ROAS to Marginal ROAS

    Blended ROAS reflects historical average performance. Marginal ROAS (mROAS) reveals what the next $1,000 of ad spend will return:

    Because ad channels face diminishing marginal returns, a channel with a 3.5x average ROAS may show an incremental mROAS of only 0.8x on its final $10,000 spent. Spending those extra dollars destroys net profit.

    The Capital Allocation Decision Matrix

    Enterprise teams should govern spend with three core rules:

    1. Scale Capital Where mROAS > Breakeven Marginal Return: Increase channel budget only while the incremental gross margin generated by the next dollar exceeds capital and fulfillment costs.

    2. Evaluate Performance via Media Efficiency Ratio (MER): Maintain executive focus on total enterprise profitability:

    3. Incorporate Model Variance Bounds:

  • Meta Ads: Expected mROAS = 2.4x (90% Confidence Interval: 1.9x to 2.9x).
  • Google Non-Brand: Expected mROAS = 1.8x (90% Confidence Interval: 1.4x to 2.2x).
  • If the lower bound of a confidence interval falls below breakeven, pause scaling and shift budget into channels where the entire distribution remains profitable.
  • Step-by-Step Attribution Modernization Roadmap

    Transitioning from naive last-click reporting to an enterprise attribution engine requires a 90-day execution plan:

    Phase 1: Tracking Hardening & Data Infrastructure (Days 1 - 30)

  • Audit website tracking tags and configure server-side tracking via Meta Conversions API (CAPI), Google Enhanced Conversions, and TikTok Events API.
  • Set up automated daily exports of raw Google Analytics 4 events into Google BigQuery.
  • Build automated ELT pipelines (via Fivetran or Airbyte) connecting Shopify, Google Ads, Meta Marketing API, and Klaviyo into BigQuery.
  • Phase 2: Staging Models & Algorithmic Attribution (Days 31 - 60)

  • Deploy dbt models to clean, deduplicate, and sessionize clickstream events into standardized customer paths.
  • Implement an identity resolution mart that deterministically stitches cross-device touchpoints using hashed customer identifiers.
  • Build automated dbt procedures to compute First-Click, Last-Click, Time-Decay, and Markov Chain Removal Effects side-by-side.
  • Phase 3: Econometric Triangulation & Incrementality Testing (Days 61 - 90)

  • Launch open-source Marketing Mix Modeling (Meta Robyn or Google Meridian) to compute macro coefficients and adstock curves.
  • Execute a 4-week matched-market geo-holdout test to measure true incrementality across primary paid channels.
  • Calibrate BigQuery MTA models and Robyn MMM models using empirical lift factors from holdout tests.
  • Update executive dashboards to display Media Efficiency Ratio, POAS (Profit on Ad Spend), and attribution confidence bounds.
  • For guidance on designing executive reporting suites, explore our blueprint on Ecommerce Marketing Dashboard Architecture: Executive KPIs.

    If your brand needs help resolving conflicting ad platform metrics and optimizing capital allocation, schedule an architectural review through our AD1AD Growth Systems Diagnostic.

    Frequently Asked Questions

    Why does the sum of conversions in ad platform dashboards exceed actual store sales?

    Ad platform conversions exceed store sales because ad networks measure performance in isolated silos. Meta, Google Ads, TikTok, and affiliate networks each claim conversions occurring within their attribution windows (typically 7-day click or 1-day view). When a customer touches multiple channels before a single purchase, every channel claims 100% of that order. In multi-channel setups, platform-reported revenue often reaches 200% to 300% of actual bank deposits.

    What is the primary operational flaw of relying on Last-Click attribution?

    Last-Click attribution over-credits channels at the end of the customer journey while ignoring top-of-funnel discovery. Channels like Google Branded Search, retargeting, and coupon sites look artificially profitable because they capture buyers who already intended to convert. Allocating capital purely on Last-Click metrics leads teams to cut prospecting spend. Within 3 to 6 months, top-of-funnel discovery collapses, reducing overall business revenue.

    How does Markov Chain attribution evaluate the value of an intermediary channel?

    Markov Chain attribution evaluates channels using the Removal Effect principle. It models customer interactions as a directed transition graph from start nodes to conversion or exit states. The algorithm then simulates conversion probability when a specific channel is completely removed. If removing a channel causes many customer journeys to drop off, that channel receives a high Removal Effect score and high attributed revenue. If removing a channel has little effect on conversions, its attribution weighting decreases.

    When should an enterprise brand use Marketing Mix Modeling instead of clickstream Multi-Touch Attribution?

    Brands should use Marketing Mix Modeling when deploying significant capital into channels untracked by cookies. These channels include TV, podcast sponsorships, influencer marketing, billboards, and wholesale retail (such as Amazon, Target, or Sephora). MMM also bypasses browser tracking limits (Safari ITP and Apple iOS ATT) by using macro time-series regression. Leading brands use MMM for quarterly macro budget allocation, while using clickstream attribution for weekly tactical campaign and creative optimization.