πŸ“Š Marketing Channel Performance & ROI Analysis

Google Analytics Merchandise Store Β· BigQuery Public Dataset Β· Aug 2016 – Aug 2017

Built by Sanduni K. Β· E-Commerce Analytics Portfolio
903,653
Total Sessions
8 channels Β· 12 months
$1.54M
Total Revenue
12,115 transactions
1.34%
Conversion Rate
⚠ Below 2–4% benchmark
Referral
Top Revenue Channel
42.3% of total revenue
Display
Highest RPS Channel
$12.51 per session

Revenue by Channel ($)

Referral generates 42.3% of revenue from just 11.6% of sessions. Social generates 0.3% of revenue from 25% of sessions. This sessions–revenue imbalance is the central finding of the analysis.

Conversion Rate by Channel (2% Benchmark)

Only Referral (5.29%) and Display (2.43%) exceed the 2% industry benchmark. Social (0.06%) and Affiliates (0.05%) drag the site average to 1.34%.

Revenue Per Session β€” Efficiency Ranking ($)

Display generates $12.51 per session β€” 7.3Γ— the site average of $1.70 β€” from fewer than 6,300 sessions. The clearest underleveraged opportunity in the dataset.

Sessions vs Revenue Share Gap (percentage points)

Social: βˆ’24.7pt gap. Referral: +30.7pt gap. A positive gap means a channel earns more than its session share β€” the target state. Any channel with a large negative gap is sending visitors who will never buy.

Full Channel Performance Table

ChannelSessionsSessions %CR% RevenueRevenue %RPSAOVBounce%Gap
Referral104,83811.6%5.29%$651,43042.3%$6.21$117.5225.98%+30.7pts
Direct143,02615.8%1.55%$434,84128.2%$3.04$195.9649.56%+12.4pts
Organic Search381,56142.2%0.94%$326,38121.2%$0.86$91.1448.32%βˆ’21.0pts
Display6,2620.7%2.43%$78,3375.1%$12.51$515.3835.87%+4.4pts
Paid Search25,3262.8%1.89%$43,5592.8%$1.72$90.9438.01%0pts
Social226,11725.0%0.06%$4,9170.3%$0.02$37.5365.24%βˆ’24.7pts
Affiliates16,4031.8%0.05%$5970.04%$0.04$66.3853.05%βˆ’1.76pts

Desktop vs Mobile Conversion Rate by Channel (%)

Referral's mobile penalty: βˆ’96%. Desktop converts at 5.58%; mobile at 0.20%. However, 95% of Referral sessions are already desktop β€” the headline 5.29% CR is genuine. Any new partnership strategy driving mobile-heavy traffic will see dramatically lower performance than the headline average suggests.

Full Device Breakdown

ChannelDeviceSessionsCR%RevenueRPSBounce%Mobile % of Channel
ReferralπŸ–₯ Desktop99,1495.58%$650,517$6.5624.96%4.8% mobile
πŸ“± Mobile5,0320.20%$698$0.1444.00%
DisplayπŸ–₯ Desktop4,5653.11%$77,542$16.9933.36%24.6% mobile
πŸ“± Mobile1,5380.65%$796$0.5241.68%
DirectπŸ–₯ Desktop88,1092.22%$409,271$4.6545.48%34.6% mobile
πŸ“± Mobile49,5370.46%$24,282$0.4956.67%
Paid SearchπŸ–₯ Desktop12,6742.91%$37,030$2.9232.80%41.6% mobile
πŸ“± Mobile10,5460.88%$4,741$0.4542.41%
OrganicπŸ–₯ Desktop245,7641.20%$301,294$1.2347.85%30.8% mobile
πŸ“± Mobile117,6350.44%$19,069$0.1649.61%
SocialπŸ–₯ Desktop199,3050.06%$4,627$0.0265.70%10.2% mobile
πŸ“± Mobile23,0400.02%$176$0.0161.18%
Social fails on every device β€” Desktop: 0.06%, Mobile: 0.02%. Both are functionally zero. This rules out UX friction as the root cause. No mobile optimisation programme will fix a channel that has zero purchase intent on either device.

πŸ”΄ Social Sessions: YouTube vs Everything Else

YouTube = 94% of Social sessions. $314 annual revenue. $0.0015 per session. This is not a Social strategy problem β€” it is a YouTube measurement problem.

Source Efficiency β€” RPS by Top Sources ($)

mail.google.com: $16.01 RPS Β· $333 AOV from just 1,457 sessions. The highest-efficiency source in the dataset β€” massively underutilised.

Source / Medium Performance Detail

Source / MediumSessionsCR%RevenueRPSAOVBounce%Signal
(direct) / (none)371,4672.47%$1,190,175$3.20$129.9341.80%PROTECT
google / organic227,6680.95%$202,496$0.89$93.1448.94%INVESTIGATE
dfa / cpm5,6862.32%$76,928$13.53$582.7936.07%PROTECT
google / cpc13,0781.90%$25,177$1.93$101.5237.01%GROW
mail.google.com / referral1,4574.80%$23,328$16.01$333.2637.54%UNDERUTILISED
dealspotr.com / referral5287.58%$5,691$10.78$142.2751.33%MONITOR
facebook.com / referral2,2961.09%$1,138$0.50$45.5152.09%GROW
l.facebook.com / referral7953.77%$1,044$1.31$34.7963.14%GROW
bing / organic1,5291.37%$988$0.65$47.0341.79%MONITOR
Partners / affiliate16,4030.05%$597$0.04$66.3853.05%CUT
youtube.com / referral212,6020.01%$314$0.0015$28.5565.99%REPOSITION
dfa/cpm (Display) concentration risk: $582.79 AOV and $13.53 RPS from a single programmatic platform. Any platform change removes the entire $76,928 contribution. Identify which campaigns produce the $582 buyer before scaling β€” then test a second platform.

Revenue Concentration: US vs Rest of World

94.3% of revenue comes from the United States. A 10% US revenue decline loses $145,244 β€” more than the entire international portfolio generates.

Conversion Rate by Country (%)

Puerto Rico converts at 1.50% β€” a US territory with US shipping and USD pricing. The UK converts at 0.05%. This proves the UK's barrier is logistics, not brand interest.

Geographic Performance Detail

CountrySessionsCR%RevenueRev %RPSAOVBounce%Opportunity
πŸ‡ΊπŸ‡Έ United States364,7443.14%$1,452,44194.3%$3.98$126.9635.00%BENCHMARK MARKET
πŸ‡¨πŸ‡¦ Canada25,8690.77%$32,8252.1%$1.27$164.9536.84%LOCALISE β†’ +$61K
πŸ‡»πŸ‡ͺ Venezuela2,1327.18%$13,3750.9%$6.27$87.4255.25%INVESTIGATE
πŸ‡―πŸ‡΅ Japan19,7310.09%$6,7290.4%$0.34$373.8357.50%LOCALISE β†’ HIGH AOV
πŸ‡¬πŸ‡§ United Kingdom37,3930.05%$1,6890.1%$0.05$88.9261.11%LOCALISE β†’ +$104K
πŸ‡¦πŸ‡Ί Australia12,6980.10%$1,7450.1%$0.14$134.2555.02%MONITOR
πŸ‡΅πŸ‡· Puerto Rico7321.50%$1,2030.1%$1.64$109.3538.66%US LOGISTICS β†’ CONVERTS
πŸ‡ΉπŸ‡Ό Taiwan12,9960.15%$1,9210.1%$0.15$101.1052.29%MONITOR
πŸ‡²πŸ‡½ Mexico13,2250.15%$1,5930.1%$0.12$79.6461.66%MONITOR
πŸ‡§πŸ‡ͺ Belgium4,4420.11%$9920.1%$0.22$198.4160.31%MONITOR
Japan: $373.83 AOV β€” nearly 3Γ— the US average β€” with 0.09% conversion rate and 57.5% bounce. Visitors arrive and immediately leave. Classic language barrier pattern. A Japanese-language checkout is the single highest-impact localisation investment available.

🟒 PROTECT

Display Β· Referral
CR above 2% AND RPS above site average ($1.70). Scale Display carefully β€” identify the $515 AOV audience first. Grow Referral partnerships actively.

πŸ”΅ GROW

Direct Β· Paid Search
CR approaching benchmark, RPS above average. Direct: invest in loyalty and retention. Paid Search: increase bids, apply negative mobile bid adjustments.

🟑 INVESTIGATE

Organic Search
42% of sessions, 54% CR decline in 12 months. Content strategy reset toward transactional intent = $364K incremental revenue from existing traffic.

πŸ”΄ CUT / OPTIMISE

Social (YouTube) Β· Affiliates
YouTube: reposition as brand awareness, not direct response. Facebook within Social: keep. Affiliates: 9 transactions in 12 months β€” pause immediately.

ROI Scorecard β€” All Channels Ranked

PriorityChannelSessionsCR%RevenueRPSAOVvs Site Avg RPSvs 2% Benchmark
🟒 PROTECTDisplay6,2622.43%$78,337$12.51$515.38+636%+22%
🟒 PROTECTReferral104,8385.29%$651,430$6.21$117.52+265%+165%
πŸ”΅ GROWDirect143,0261.55%$434,841$3.04$195.96+79%βˆ’23%
πŸ”΅ GROWPaid Search25,3261.89%$43,559$1.72$90.94+1%βˆ’6%
🟑 INVESTIGATEOrganic Search381,5610.94%$326,381$0.86$91.14βˆ’49%βˆ’53%
πŸ”΄ CUTSocial226,1170.06%$4,917$0.02$37.53βˆ’99%βˆ’97%
πŸ”΄ CUTAffiliates16,4030.05%$597$0.04$66.38βˆ’98%βˆ’98%

Quantified Revenue Opportunities

$364K
Organic Search CR: 0.94% β†’ 2%
No new traffic needed. Content strategy reset.
$104K
UK localisation: fix shipping + pricing
From 37,393 existing UK sessions annually.
$571K
Site-wide +0.5pt CR improvement
~4,500 additional transactions at $127 AOV.

Budget Reallocation β€” Before vs After

πŸ’° Executive Recommendation

Net principle: Moving budget from Social (YouTube-specific) and Affiliates to Paid Search and Display shifts capital from channels generating $0.02–$0.04 per session to channels generating $1.72–$12.51 per session β€” reducing spend by approximately 20% while improving overall return on investment simultaneously.


The largest single opportunity is Organic Search: 42% of all traffic converting at 0.94% against a 2–4% benchmark. Sessions grew 56% while conversion rate fell 54%. This is an intent-targeting problem, not a traffic volume problem. No amount of additional spend on acquisition will fix a funnel that is leaking 98.7% of visitors.


Limitations: Last-click attribution only β€” Social and Display assisted conversion value is understated. No cost data available β€” RPS is an efficiency proxy, not true ROAS. Referral and Organic have near-zero incremental media cost, which would improve their true ROI ranking further.