Programmatic Campaign Management: DSP or Excel? Why You Need Both
A few days ago, a Media Trader told me: “I manage everything directly in the DSP. That's more than enough to track my campaigns and adjust my investments.” Naturally, that started a debate. 😉
Whether you work in DV360, The Trade Desk, Amazon DSP, Adform or Hawk, the interface is essential. But managing your campaign exclusively inside the DSP can make it surprisingly difficult to see the bigger picture. My preferred approach? Use the DSP to execute and a structured Excel scorecard to diagnose.
1. Should you manage programmatic campaigns directly in your DSP?
Of course you should use your DSP. It has two fundamental jobs: (1) campaign setup and optimization, and (2) generating detailed, customizable reports. The first is obvious; the second is often underused.
The trap is relying entirely on the DSP interface for investigation. You might pull a site report today, a device report tomorrow and a supply-path report next week. Each individual view can be useful, but it becomes difficult to reconstruct the full story of what changed, when, and why.
And without a consistent historical file, documenting your optimization decisions becomes another task on your already crowded to-do list.
2. The goldmine is in your DSP's reporting functionality
Most major DSPs let you configure reports with dimensions and metrics that go well beyond the standard dashboard. Those exports are the raw material for an automated or semi-automated campaign scorecard.
Instead of opening a new report every time a question comes up, build a recurring template. The objective is simple: maintain a reliable dataset that lets you inspect campaign performance across the same dimensions, day after day.
(Available dimensions, export formats, refresh schedules and automation options vary by DSP and account permissions.)
3. Which dimensions should you include in the DSP report?
Start with the dimensions that can explain where the budget is being spent and how those impressions perform.
| Dimension | What it helps you investigate |
|---|---|
| Date | Delivery trends, pacing shifts and before/after comparisons |
| Campaign and line item | Which strategies are driving results or consuming budget |
| Media type and creative size | Differences between display, video, native and individual formats |
| SSP and seller | Supply-path concentration and potential inefficiencies |
| Device | Mobile versus desktop performance and delivery mix |
| Site or app | Publisher-level patterns and outliers |
Add the KPIs that match your campaign objective: impressions, spend, CPM, clicks, conversions, viewability, video completion or other available metrics. Keep a consistent definition for each metric (and distinguish measured impressions from all served impressions where relevant).
For an even more granular perspective, read our article on placement-level programmatic optimization.
4. How to build an Excel scorecard with pivot tables
Once you have a reusable DSP reporting template, the workflow becomes surprisingly straightforward:
- Export the same granular report on a regular schedule, ideally with a stable column structure.
- Load the raw extract into Excel as a structured table (or use Power Query to refresh and transform recurring exports).
- Create around ten pivot tables covering pacing, line items, formats, devices, SSPs, sellers, publishers and other useful combinations.
- Apply conditional formatting to highlight underdelivery, unusual CPMs or KPIs that need attention.
- Keep a dated optimization log recording what you changed in the DSP and the reason for the change.
You do not need an elaborate business intelligence platform to start. A well-designed workbook can already provide the overview that is missing from one-off reports.
5. What can an Excel scorecard reveal?
Delivery evolution: Is spend accelerating or slowing? Did performance change after a targeting adjustment? With historical daily data, those questions become much easier to answer.
Bottlenecks: Conditional formatting can make an underperforming line item, expensive seller or poorly completing video format stand out immediately.
Cross-dimensional insights: Perhaps a publisher performs well overall but poorly on a specific device and creative format. A pivot table lets you cross-reference those dimensions in a couple of clicks rather than requesting another report.
This is also why I question the idea that a DSP is always optimizing your campaigns as effectively as it could. Automated bidding is useful, but Media Traders still need the right evidence to challenge its outcomes.
6. A practical daily optimization routine
| Step | Action | Outcome |
|---|---|---|
| 1 | Refresh the saved DSP report and Excel dataset | Up-to-date daily and historical performance |
| 2 | Review pacing and KPI scorecards | Spot problems early |
| 3 | Filter pivot tables by format, site, device or seller | Identify likely sources of inefficiency |
| 4 | Make justified changes in the DSP | Act on the diagnosis |
| 5 | Record the change and review the next reporting period | Build a usable optimization history |
Once the reporting template and workbook are configured, the recurring update can take only a few clicks (provided the export format remains stable and the data refresh is working correctly).
7. What are the limitations of DSP-to-Excel optimization?
A spreadsheet does not automatically make an optimization valid. Check reporting latency, attribution windows, metric definitions and missing or aggregated dimensions before interpreting a result. Small samples can create misleading winners and losers.
Similarly, a color-coded drop in viewability is a signal to investigate, not proof that a placement is worthless. We explored that nuance in why you should not optimize solely on viewability.
Finally, protect the workbook's integrity: avoid mixing incompatible metrics, double-counting overlapping rows or exposing user-level data unnecessarily. For larger or more complex accounts, a database or BI solution may be more appropriate than Excel alone.
8. GreyFox Ads: programmatic expertise for the French Open Web
At GreyFox Ads, we believe a quality Open Web can deliver real efficiency for advertisers — but only when buying decisions are informed by granular evidence.
We help Media Traders outside France activate the French market with local publisher knowledge, supply-quality controls and targeting expertise, packaged into a simple Master Curated Deal. Fewer operational headaches, more time to understand what actually performs.
My conclusion? Don't choose between your DSP and Excel. Use the DSP to buy and optimize; use a scorecard to see the full picture. The best optimizations usually begin with better questions. 🚀
Need a clearer view of your French programmatic campaigns?
GreyFox Ads combines French Open Web expertise with transparent curation and simple DSP activation.
Let's talkExplore the Master Deal