The Challenge:
E-commerce businesses running multiple marketing channels simultaneously face one brutal problem they have no idea which channel is actually doing the work. Direct traffic, Email, Google Ads, Meta Ads, Organic Search, and Referral are all running at the same time, all claiming credit, and all pulling budget. Without a clear attribution model, every marketing decision is essentially a guess. The goal was to build a Tableau dashboard that connected sessions, conversion rates, and revenue across both product categories so the team could finally see the full picture in one place.
- Channel Attribution Chaos: Six marketing channels were running simultaneously across two product categories — Electronics and Fashion — with no unified view of which channel was driving actual revenue vs. just traffic.
- Sessions vs. Revenue Disconnect: High session counts were being celebrated without anyone knowing whether those sessions were converting into money. Volume and value were being confused for the same thing.
- Conversion Rate Volatility: Average conversion rates were fluctuating across channels and categories over time with no visual system to track the trend, spot the dips, or understand what was causing them.
How We Managed It:
- Performance Attribution by Marketing Channel: A fully segmented bar chart broke down revenue by channel across both Electronics and Fashion, instantly revealing:
- Direct and Referral as the strongest revenue-driving channels for Electronics.
- Fashion revenue concentrated heavily in Direct and Email channels.
- Google Ads and Meta Ads showing Electronics dominance, giving the paid team clear data to optimize spend allocation.
- Sessions vs. Revenue Scatter Analysis A bubble chart mapped every channel by session volume against revenue generated, with bubble size encoding average conversion rate. Direct traffic led in both sessions and revenue. Organic Search showed strong session volume with a conversion rate sitting at 6.2 — outperforming paid channels on efficiency. Email delivered the lowest session count but maintained competitive conversion, revealing it as a high-quality, underinvested channel.
- Revenue by Category Electronics and Fashion were split side by side showing Electronics generating significantly higher absolute revenue — pushing close to $1M — while Fashion trailed but maintained consistent contribution. This gave category managers an instant read on portfolio balance and where growth investment should be focused.
- Business Health KPI Tracker A time-series conversion rate tracker running from February through November plotted Electronics and Fashion separately. The chart exposed conversion volatility across both categories, with clear dips and peaks that aligned with seasonal patterns — intelligence that had previously been completely invisible to the marketing team.
The Results:
The Tableau E-commerce Attribution Dashboard gave the marketing and category teams a level of channel clarity they had never had before.
- Full Channel Attribution – Every dollar of revenue traced back to its originating marketing channel across both Electronics and Fashion categories.
- Session Quality Exposed – Organic Search and Email identified as the highest-efficiency channels by conversion rate, completely reframing where budget attention should go.
- Category Revenue Clarity – Electronics confirmed as the dominant revenue category, enabling confident resource allocation decisions across the product portfolio.
- Conversion Trend Visibility – Month-by-month conversion rate tracking across both categories gave the team an early warning system for performance dips before they became revenue problems.
In a Nutshell:
The challenge was six channels, two categories, and zero visibility into what was actually driving revenue. We built a Tableau E-commerce Attribution Dashboard that connected sessions, conversion rates, and revenue across every channel and category into one clean, interactive view. The result was complete attribution clarity — with Organic Search and Email emerging as the highest-efficiency channels and Electronics confirmed as the dominant revenue category, giving the team the data confidence to stop guessing and start growing.
