The highest-volume channel was not the highest value one.

Google organic looked strongest at first glance. It drove the highest session volume and the highest product-view volume, so by top-line acquisition reporting it appeared to be the clear channel leader.

This case starts from that first impression and tests whether it holds under a stricter definition of performance.

Business problem

The central question is simple: does traffic volume also indicate acquisition quality? A source can lead on reach while performing differently on progression to purchase. To evaluate quality, the analysis must follow behavior through the funnel, not stop at traffic totals.

The analysis uses Google’s GA4 sample ecommerce dataset in BigQuery and is executed in SQL at the session level. Each session is defined by combining ga_session_id with user_pseudo_id, creating a consistent key for tracking within-session movement from product interest toward transaction.

Data and method

The first query defines the funnel stages—view_item, add_to_cart, begin_checkout, and purchase. This is the methodological pivot of the case. It reframes channel evaluation from “who brings the most visits” to “who moves visits through the purchase path.”

With the funnel structure in place, the next layer compares progression across Google organic, direct, referral, and Google CPC. Device category is included as supporting context, but source-level progression remains the main analytical axis.

At this stage, two channel stories can be read in parallel.

The scale story is unchanged: Google organic remains highest in sessions and product views.

The quality story diverges: direct traffic converts more efficiently than organic search despite lower volume. Referral traffic from shop.googlemerchandisestore.com produces the strongest overall view-to-purchase rate in the sample. Google CPC contributes meaningful traffic, but converts less efficiently than direct and referral.

Key findings

• Google organic drove the highest session and product-view volume, making it the largest acquisition source in the funnel.

• Direct traffic converted more efficiently than organic search despite lower volume, pointing to stronger purchase intent.

• Referral traffic from shop.googlemerchandisestore.com produced the strongest overall view-to-purchase rate in the sample.

• Google CPC contributed meaningful traffic but converted less efficiently than direct and referral traffic.

• Device differences added context, but the main performance pattern was driven more by source than by device.
  

Business interpretation

This comparison resolves the core tension. Channel leadership changes when the metric lens changes. Organic leads on top-of-funnel reach; direct and referral lead on progression efficiency toward purchase; CPC adds volume but does not match direct and referral on conversion movement.

Key Outcome

The key interpretation is bounded and evidence-based: in this sample, scale and conversion quality did not move together. The analysis does not claim causal drivers or universal channel rankings; it shows that evaluation changes materially when performance is measured as session-level progression rather than traffic count alone.

Final takeaway: the highest-volume acquisition channel was not the highest-value channel in this sample. Traffic volume captured scale; funnel progression revealed quality.