Ad performance dashboards
Dashboards that showed affiliate managers which affiliates and traffic sources were converting, and which were worth more traffic.
- Company
- Ad Exchange Group
- Role
- Front End Developer → Senior
- When
- 2014–2019
- Stack
- React, PHP
The demos here are recreations with fictional brands and fake data. The original work was done at Ad Exchange Group.
Try it
I built the PHP sales funnels, and the data they sent back fed the dashboards affiliate managers used to answer one question for each affiliate: for the money going in, where were the sales coming from? Pick a date range or traffic source, then open an affiliate to see where people drop off and which sources pay for themselves.
This is a reconstruction from memory with invented affiliates and numbers. It shows the kind of view the team relied on, not the original screens.
Demo controls
Affiliate dashboard · 25 affiliates
- Spend
- $1,069,676
- Revenue
- $1,787,921
- Return on spend
- 67%
- Cost per sale
- $38.27
| Status | |||||
|---|---|---|---|---|---|
| $42,423 | 668 | $22,991 | −46% | Losing money | |
| $42,812 | 811 | $27,712 | −35% | Losing money | |
| $43,665 | 974 | $33,466 | −23% | Losing money | |
| $43,720 | 1,008 | $34,365 | −21% | Losing money | |
| $42,670 | 1,077 | $36,922 | −13% | Losing money | |
| $42,436 | 1,366 | $46,904 | 11% | Thin | |
| $44,029 | 1,128 | $52,018 | 18% | Thin | |
| $42,470 | 1,480 | $50,732 | 19% | Thin | |
| $42,344 | 1,100 | $50,622 | 20% | Thin | |
| $42,503 | 1,493 | $51,388 | 21% | Thin |
The problem
Affiliate managers needed to track each affiliate’s conversions so they could send more traffic to the most profitable sources and fulfill orders. The bottleneck was the data itself: it arrived raw and didn’t give them enough insight to make those decisions.
What I did
I talked with the managers to understand what they needed to know, then worked out how to show it. Quick-glance metrics came first, backed by deeper analytics that showed trends over time and put the numbers each manager cared about front and center.
Result
Managers could spend more of their time finding new affiliates in different verticals, and they could share key insights with the affiliates already in the network.