Product Development
Forecasting Tool

TRADR DSP | Forecasting Tool for More Accurate Media Planning

My Role
Senior Product Manager
Timeline
May-Aug 2022

Background: The Challenge of Media Planning

In advertising, accurate forecasting is critical for effective campaign planning. Advertisers need to estimate how many impressions they can expect, what CPM they should anticipate, how much budget will be required, and how frequently the average user will be exposed to the message. However, forecasting in a dynamic ad marketplace is inherently complex due to fluctuating demand, variable inventory availability, and evolving targeting constraints.

Without reliable forecasting, users often:

  • Overcommit budgets without clear visibility into available inventory.
  • Underestimate costs, leading to missed opportunities or unfulfilled campaign goals.
  • Manually estimate performance, relying on fragmented data sources or guesswork instead of predictive insights.

To solve these challenges, TRADR developed a Forecasting Tool that provides users with data-driven estimates for impressions, CPM, budget ranges, and frequencies based on key campaign parameters.

Solution: A Smarter Forecasting Engine

The Forecasting Tool allows users to input key targeting criteria and receive real-time estimates on available inventory and cost expectations. By leveraging historical data, and using predictive modeling, the tool enables advertisers and traders to make informed decisions before launching a campaign.

Users can forecast:

  1. Estimated Impressions (Range) – Helps gauge available inventory for a given targeting setup.
  2. Estimated CPM (Range) – Provides visibility into expected pricing based on competitive pressures.
  3. Estimated Budget (Range) – Assists in setting realistic spending expectations to achieve campaign goals.
  4. Estimated Frequency (Range) - Predicts how often an ad will be seen by the same user within a campaign timeframe, allowing for better control over ad exposure.

These forecasts are based on multiple user-defined inputs, including:

  • Ad Type: Display, Native, Online Video, CTV.
  • Maximum Average CPM: Defines cost ceiling constraints.
  • Audience Segments: Custom and third-party audience selections.
  • Geos: Targeted locations influencing available impressions.
  • SSPs/Deals: Supply partners and direct deal availability.
  • Inventory Target/Block Lists: Domains, app bundles, URLs, etc.
  • Technology Target/Block Lists: Device types, models, OS, browser restrictions.

The Role

As a Senior Product Manager, I led the strategy, roadmap, and cross-functional coordination to bring this tool from concept to implementation. My focus was on ensuring the tool provided actionable, and user-friendly forecasts while aligning with business objectives.

Key Responsibilities & Planning Strategy

Defining the Problem & Opportunity

To validate the need for a forecasting solution, I worked with advertisers, account managers, and traders to identify common pain points in campaign planning. Through user research, it became clear that manual estimation methods and inconsistent data sources were causing inefficiencies, leading to budget overruns and missed delivery targets. By framing forecasting as a critical decision-making tool, I secured internal alignment and stakeholder buy-in.

Developing the Scope & Success Metrics

I collaborated with engineering and data science teams to define the tool’s functional scope, ensuring it provided forecasting ranges rather than false precision to account for market variability. We also established key success metrics, including:

  • Accuracy of forecasts vs. actual campaign performance.
  • Adoption rate among traders and advertisers.

Cross-Functional Planning & Execution

I worked closely with engineering, UX, and data teams to ensure seamless integration with TRADR’s platform. This involved:

  • Aligning with our data science team on predictive modeling approaches.
  • Defining a user-friendly interface that allowed for quick input modifications.
  • Ensuring that forecast outputs were presented clearly and intuitively for decision-making.

Driving Adoption & Optimization

To ensure adoption, I worked with customer success teams to educate users on how to interpret and apply forecasted insights in their campaign planning workflows. Additionally, I established ongoing tracking of forecast accuracy, allowing us to refine the model based on real-world results.

Next Steps & Future Direction

After the forecasting tool went live, the focus shifted to refinement, optimization, and expanding capabilities to make it even more valuable for users.

  • Improving Forecasting Accuracy
    Continuous model improvements are essential to reduce variance between forecasts and actual campaign performance. This involves refining historical data modeling and improving response to market fluctuations.
  • Incorporating AI-Driven Optimization Recommendations
    Beyond just forecasting, our next step is to introduce proactive recommendations—suggesting budget reallocations or alternative targeting setups to maximize efficiency.
  • Seamless Integration with Campaign Execution
    In the long term, the forecasting tool should be directly embedded into campaign setup workflows, allowing users to apply insights in real time without leaving the workflow.

By iterating based on user feedback, enhancing predictive accuracy, and expanding its capabilities, this forecasting tool will continue to be a core asset for advertisers and traders looking to optimize their programmatic buying strategies.

Key Takeaways & Learnings

Developing a forecasting tool in programmatic advertising comes with unique challenges, but several key lessons emerged from this initiative:

  • Forecasting is inherently probabilistic, not deterministic. Users often expect a single number, but in a dynamic auction environment, ranges provide more realistic expectations. Balancing accuracy with usability, cost management, and development time was a key challenge.
  • Iterative refinement is necessary. Initial forecasts are never perfect, and ongoing validation against actual campaign data is essential to improving accuracy and reliability over time.

Final Thoughts

The Forecasting Tool represents a major step forward in predictive campaign planning, giving advertisers data-driven estimates to guide smarter decisions before launching campaigns. By leading the strategy, execution roadmap, and user adoption efforts, I ensured that this tool delivered tangible value while aligning with TRADR’s broader mission of optimizing programmatic efficiency.

As we continue refining forecast accuracy, transparency, and usability, this tool will remain an essential resource for helping advertisers maximize the impact of their budgets in an unpredictable market.