Prompt
How do I build a dashboard that shows both conversions and revenue by channel?
Latest observation
To build a dashboard that shows both conversions and revenue by channel, you need three things:
- Clean source data
- A clear metric definition
- A chart/table layout that compares channels consistently
Here’s a practical approach.
1) Define the metrics
Before building the dashboard, decide exactly what each metric means.
Conversions
Usually:
- Number of completed desired actions
- Examples: purchases, signups, demo requests
Decide whether you want:
- Total conversions
- Unique conversions (one per user/session/order)
- Attributed conversions by channel
Revenue
Usually:
- Total revenue generated
- Could be:
- gross revenue
- net revenue
- refunded-adjusted revenue
Channel
This is the acquisition source, such as:
- Paid Search
- Organic Search
- Direct
- Social
- Referral
- Affiliate
Make sure you have a rule for attribution:
- Last click
- First click
- Multi-touch
- Platform-specific attribution
2) Prepare the data
Your dataset should have at least these fields:
datechannelconversion_idororder_idrevenue- optional:
campaign,source,medium,customer_id
Example structure:
| date | channel | conversion_id | revenue |
|---|---|---|---|
| 2026-01-01 | Paid Search | C001 | 120.00 |
| 2026-01-01 | C002 | 75.00 | |
| 2026-01-01 | Organic Search | C003 | 200.00 |
If one conversion can belong to one channel, you can aggregate directly.
3) Aggregate by channel
You want to summarize:
conversions = count(conversion_id)revenue = sum(revenue)
Example SQL:
SELECT
channel,
COUNT(DISTINCT conversion_id) AS conversions,
SUM(revenue) AS revenue
FROM fact_conversions
GROUP BY channel
ORDER BY revenue DESC;
If you need time-based trends:
SELECT
DATE_TRUNC('day', date) AS day,
channel,
COUNT(DISTINCT conversion_id) AS conversions,
SUM(revenue) AS revenue
FROM fact_conversions
GROUP BY 1, 2
ORDER BY 1, 2;
4) Choose the right visualizations
A good dashboard usually includes:
A. Summary cards
At the top:
- Total conversions
- Total revenue
- Conversion rate
- Revenue per conversion
B. Channel comparison chart
Use a:
- Bar chart for conversions by channel
- Bar chart for revenue by channel
- Or a combo chart if you want both in one view
C. Trend chart
Show conversions and revenue over time:
- Line chart by day/week/month
- Filterable by channel
D. Table
A detailed table for analysis:
- Channel
- Conversions
- Revenue
- Avg revenue per conversion
- Share of total
Example additional metric:
Revenue per conversion = revenue / conversions
5) Use a combo chart carefully
If you want both metrics on the same chart:
- Put channels on the x-axis
- Use bars for conversions
- Use a line for revenue
- Because revenue and conversions may have different scales, use a secondary y-axis
Example:
- Left axis: conversions
- Right axis: revenue
This works well if you want quick comparison, but separate charts are often easier to read.
6) Add filters
Useful dashboard filters:
- Date range
- Channel
- Campaign
- Device
- Geography
- New vs returning users
This lets users drill into performance without cluttering the main view.
7) Make the dashboard decision-friendly
Good questions the dashboard should answer:
- Which channel drives the most conversions?
- Which channel drives the most revenue?
- Are high-conversion channels also high-revenue channels?
- Which channels have the best revenue per conversion?
- How do channels change over time?
A channel with many conversions but low revenue may indicate low-value transactions. A channel with fewer conversions but higher revenue may be more efficient.
8) Example dashboard layout
Top row
- Total Conversions
- Total Revenue
- Revenue per Conversion
- Conversion Rate
Middle row
- Conversions by Channel
- Revenue by Channel
Bottom row
- Conversion and Revenue Trend Over Time
- Channel Performance Table
9) If you’re using a BI tool
In Tableau / Power BI / Looker Studio:
- Connect your data source
- Create measures:
Conversions = COUNTD(conversion_id)Revenue = SUM(revenue)
- Build charts grouped by
channel - Add date filters and slicers
- Format with consistent colors and labels
10) Recommended KPIs to include
- Conversions
- Revenue
- Conversion rate
- Revenue per conversion
- Channel share of conversions
- Channel share of revenue
If you want, I can also give you:
- a SQL query + dashboard mockup,
- a Power BI / Tableau step-by-step build, or
- a Python/Plotly example for building it programmatically.