Home The Sell Sider Unifying Reporting Across All Programmatic Vendors: No Small Task For Publishers

Unifying Reporting Across All Programmatic Vendors: No Small Task For Publishers

SHARE:

madhurasenguptaThe Sell Sider” is a column written by the sell side of the digital media community.

Today’s column is written by Madhura Sengupta, director of ad product technology at Edmunds.com

Programmatic yield management can easily become a nightmare for publishers. We’ve all tested dozens of demand sources, including ad networks and exchanges, such as DoubleClick AdExchange (AdX), AOL and Amazon, as well as different ad placements, units and more.

While every publisher tries to optimize and maximize revenue, this usually includes the laborious process of recording and carefully monitoring tons of data for revenue, impressions, discrepancies and fill rates by device and geography for each demand source. In addition, programmatic buying uses real-time-bidding (RTB) technology, which changes frequently and requires constant monitoring.

Traditionally, this might translate to a human manually logging into various partner portals, normalizing numbers and managing unwieldy Excel spreadsheets with hundreds of tabs. However, more publishers now use data science and development teams to automate and unify this reporting in one centralized location.

But while there are a few third-party vendors that offer reporting consolidation services, they typically haven’t been able to scale simply because each publisher’s reporting needs are so different.

Choosing The Right Metrics

First and foremost, it is important for a dedicated member of a publisher’s ad operations (ad ops) or yield management team to determine which metrics and dimensions they should track. Apart from collecting standard revenue and impression data, there are several to be mindful of.

Discrepancy by demand source: This measures how many impressions are lost when they “hop” between the publisher ad server and demand source. While a “normal” discrepancy rate is anywhere between 1% to 10%, every impression lost in cyberspace means loss of revenue for a publisher. Anything greater than 10% should stir attention, and anything more than 20% is in the red zone.

Performance of demand sources based on rCPM, not eCPM: The “r” in rCPM stands for “real,” meaning the use of impression numbers from the publisher’s ad server to determine performance, instead of from the demand source.

Performance of private marketplace deals (PMPs) within your ad exchanges: Many publishers set up PMP deals directly with advertisers to give them priority over the open exchange. This can be beneficial for both sides, but publishers need to monitor impression and revenue volumes of each deal to ensure that advertisers are spending healthy amounts through this channel. This can be challenging, especially if a publisher uses more than one PMP platform, such as AdX, Rubicon and OpenX.

Subscribe

AdExchanger Daily

Get our editors’ roundup delivered to your inbox every weekday.

Latency and ad load times for header-bidding partners: Which demand sources are consistently “timing out” from the standard 500 milliseconds before which they should be returning bids? While analytics and cookie syncing often allows exchanges to bid higher, users are being subjected to a plethora of measurement pixels that contribute to the slow load times of the page. It is important for publishers to hold their demand sources accountable for any larger-than-expected latency.

Historical bid data from header-bidding partners: With the onset of header bidding, there is a vast amount of data available, including win vs. close bids from each partner and percent of time each ad partner bids. Publishers can use historical bid information to understand the value of their inventory and audience, and price effectively against it.

Performance by ad unit: Certain ad units and sizes may outperform others. Tracking this data can help inform site layout and design, as well as set pricing by unit.

Performance by site section or page type: Certain sections of a publisher site can have vastly different ad performance based on user behavior. In general, when there are more page views per user session, it is important to have more demand sources to fill each impression. For example, photoflippers or slideshows can garner very different ad performance compared to a long-form editorial page.

Performance by geography: Not all countries are created equal. Instead of blending CPMs across geography, it is important to understand and optimize by region.

Extracting The Data

Once the metrics and dimensions that need to be tracked are determined, publisher ad ops teams can work with development teams to automate the extraction of this data from various sources. There should be at least one full-time developer dedicated to this project, with coordination from an ad ops project manager.

The first step to the development effort will be to determine which demand sources have APIs, and which metrics are available to pull via API. Note that APIs are time-consuming to maintain and may not have all the up-to-date functionality that a reporting interface might have. For example, there are many metrics in the AdX Query Tool which are unavailable within the reporting API.

In addition, many demand sources may not have APIs available. In this case, there are a few other options, including pulling from automated daily emailed reports or using a scraping mechanism, such as Selenium, to log into each portal, download the data and feed the information into a data warehouse.

Once the raw data is stored within a data warehouse, publishers can layer on visualization tools, such as Tableau or QlikSense. Others build their own reporting interface with charts and graphs to complement the data tables. Even after the initial development phase is complete, there usually needs to be ongoing development maintenance because demand-source APIs might change, new metrics may be available to report on and publishers are constantly evolving the partners they choose to work with.

While it is undoubtedly a significant effort to unify reporting across all various demand sources, it can be well worth it to gain such insights in a real-time fashion. Instead of using manpower to manually log and track all the data, we can start shifting toward analyzing the insights, setting optimization strategies and, best of all, finding more money under the hood.

Follow Edmunds (@edmunds) and AdExchanger (@adexchanger) on Twitter.

Must Read

LiveRamp Outperforms On Earnings And Lays Out Its Data Network Ambitions

LiveRamp reported an unexpected boost to Q3 revenue, from $160 million last year to $185 million in 2024, during its quarterly call with investors on Wednesday.

Google in the antitrust crosshairs (Law concept. Single line draw design. Full length animation illustration. High quality 4k footage)

Google And The DOJ Recap Their Cases In The Countdown To Closing Arguments

If you’re trying to read more than 1,000 pages of legal documents about the US v. Google ad tech antitrust case on Election Day, you’ve come to the right place.

NYT’s Ad And Subscription Revenue Surge As WaPo Flails

While WaPo recently lost 250,000 subscribers due to concerns over its journalistic independence, NYT added 260,000 subscriptions in Q3 thanks largely to the popularity of its non-news offerings.

Privacy! Commerce! Connected TV! Read all about it. Subscribe to AdExchanger Newsletters
Mark Proulx, global director of media quality & responsibility, Kenvue

How Kenvue Avoided $3 Million In Wasted Media Spend

Stop thinking about brand safety verification as “insurance” – a way to avoid undesirable content – and start thinking about it as an opportunity to build positive brand associations, says Kenvue’s Mark Proulx.

Comic: Lunch Is Searched

Based On Its Q3 Earnings, Maybe AIphabet Should Just Change Its Name To AI-phabet

Google hit some impressive revenue benchmarks in Q3. But investors seemed to only have eyes for AI.

Reddit’s Ads Biz Exploded In Q3, Albeit From A Small Base

Ad revenue grew 56% YOY even without some of Reddit’s shiny new ad products, including generative AI creative tools and in-comment ads, being fully integrated into its platform.