Maksim Golub / Analytics Playbook
Metrics tree ↗

Case 05. Traffic mix

Lithograph: changing yarn proportions changes the cloth

The question

You are a marketing manager and you manage 5 channels (Acquisition, Direct, Paid search, Retargeting and SEO) to bring traffic (sessions) to your e-commerce website.

You noticed that conversion rate (defined as Sales transactions divided by Sessions) dropped to 11% in Q1’23 (top left chart).

You are also given conversion rate of individual channels (bottom left chart) and their contribution in sessions (chart on the right).

What is the most probable cause of this drop?

Input data

0246810121416↑ Conversion, %2022 Q22022 Q32022 Q42023 Q112%12.4%12.6%11%
0246810121416↑ Conversion, %2022 Q22022 Q32022 Q42023 Q112%12.4%12.6%11%
SEOPaid SearchDirectRetargetingAcquisition
024681012141618↑ Conversion, %2022 Q22022 Q32022 Q42023 Q116%14%9.7%8.5%5.2%
SEOPaid SearchDirectRetargetingAcquisition
024681012141618↑ Conversion, %2022 Q22022 Q32022 Q42023 Q116%14%9.7%8.5%5.2%
SEOPaid SearchDirectRetargetingAcquisitionUnresolved split
0102030405060708090100↑ Session share, %2022 Q22022 Q32022 Q42023 Q12022 Q2: SEO 33%2022 Q2: Paid Search 26%2022 Q2: Direct 29%2022 Q2: Unresolved split 12%2022 Q3: SEO 34%2022 Q3: Paid Search 26%2022 Q3: Direct 25%2022 Q3: Unresolved split 15%2022 Q4: SEO 32%2022 Q4: Paid Search 29%2022 Q4: Direct 22%2022 Q4: Unresolved split 17%2023 Q1: SEO 26%2023 Q1: Paid Search 22%2023 Q1: Direct 18%2023 Q1: Acquisition 26%2023 Q1: Retargeting 8%33%26%29%12%34%26%25%15%32%29%22%17%26%22%18%26%8%
SEOPaid SearchDirectRetargetingAcquisitionUnresolved split
0102030405060708090100↑ Session share, %2022 Q22022 Q32022 Q42023 Q12022 Q2: SEO 33%2022 Q2: Paid Search 26%2022 Q2: Direct 29%2022 Q2: Unresolved split 12%2022 Q3: SEO 34%2022 Q3: Paid Search 26%2022 Q3: Direct 25%2022 Q3: Unresolved split 15%2022 Q4: SEO 32%2022 Q4: Paid Search 29%2022 Q4: Direct 22%2022 Q4: Unresolved split 17%2023 Q1: SEO 26%2023 Q1: Paid Search 22%2023 Q1: Direct 18%2023 Q1: Acquisition 26%2023 Q1: Retargeting 8%33%26%29%12%34%26%25%15%32%29%22%17%26%22%18%26%8%
Chart data tables
Visible chart data2022 Q22022 Q32022 Q42023 Q1
SEO: session share33%34%32%26%
Paid Search: session share26%26%29%22%
Direct: session share29%25%22%18%
SEO: sessions3.9M4.0M3.8M3.8M
Paid Search: sessions3.1M3.2M3.4M3.2M
Direct: sessions3.3M3.0M2.6M2.7M
Acquisition: sessionsnot availablenot availablenot available3.9M
Acquisition: session sharenot availablenot availablenot available26%
ChannelConversion rate, 2023 Q1
SEO16.0%
Paid Search14.0%
Direct9.7%
Retargeting8.5%
Acquisition5.2%

How to read the data

The first chart shows the aggregate result. The second shows conversion within each channel. The third shows the weights of the channels in total traffic. A session share and a conversion rate measure different quantities.

How to think it through

  1. Check 2 possible sources of change: conversion within channels and the composition of traffic.
  2. Identify a low-conversion channel and examine the change in its traffic share.
  3. Limit the conclusion to available evidence: the previous Acquisition share cannot exceed Acquisition + Retargeting combined.
Choose an answer
How to solve it
  1. Overall conversion fell from 12.6% to 11%. Individual channel conversion rates did not fall substantially.
  2. Acquisition converts at 5.2%, the lowest rate among the channels. Its share reached 26% in Q1.
  3. In earlier quarters, Acquisition and Retargeting together account for only 12%, 15% and 17%. Acquisition's own traffic share therefore definitely increased.
CR = Σ (traffic share × channel conversion rate)

A larger Acquisition share

Traffic mix changes the total even when individual channel conversion rates stay stable.

Assumptions & further exploration

This explanation is consistent with the charts. An exact channel contribution needs unrounded rates and shares for both periods. A calculation with fixed shares can separate the mix effect from the within-channel effect. Partially reconstructed labels do not support an exact reproduction of the aggregate.

Some labels were reconstructed. Earlier Acquisition and Retargeting shares are only known as a combined segment.