One of the most important considerations in working with an RTB bidder is designing the data pipeline by which auction, bid, and win events are processed and analyzed.
Unlike DSPs, with the Beeswax Bidder-as-a-Service technology you can access the full, unfiltered stream of RTB events, in much the same way you would if you were building a bidder from scratch.
The first consideration for designing your data pipeline is whether you prefer to get the data in batch form, or as a continuous stream. For the very high-volume data, like auction logs, Beeswax only supports batch data. For win logs (impressions) Beeswax supports both methods, and there are pros and cons to each:
Hourly or daily files of data placed in an S3 bucket.
Fairly easy to ingest, fault tolerant
Delay in utilizing data. Also may include many files written per hour.
Use data as fast as you can process it
Higher cost and complexity to support data ingestion
Column definitions, protobuf mapping, field lists and a data dictionary can be found in the is publicly-accessible Google Doc: Beeswax Log File Header Definitions and Proto Mapping.
Beeswax makes multiple types of data available from Stinger as described in the chart below. Based on your use case you may need some, or all of this data. Because some of this data can be quite large, additional fees may apply (contact your Account Manager for more information).
A more comprehensive description of these log types and implementation details can be found in this publicly-accessible Google Doc: Beeswax Log Summary.
Batch Field Manifest
Column Definitions and Protobuf Mapping
The auction request from the exchange, normalized to OpenRTB fields.
The bids returned from the Bidding Agent to the exchange, whether the auction was won or not.
The conversions recorded by Beeswax
The conversions recorded by Beeswax, attributed back to an auction
Loss logs provided by a limited number of exchanges (Google)
The winning auctions (impressions), clicks, and events (video plays, etc)
All 1st party and 3rd party segments available on the auction
When emitting logs in .csv file format, Beeswax escapes certain special characters. While we mostly follow the RFC-4180 standard for CSV files, there are some small deviations from the specification that we do not follow. Most notably, we use \ as the escape character for embedded double quote (in contrast to escaping double quotes with an additional double quote character) and comma characters. Most standard CSV parsers will allow the escape character to be adjustable.
Additionally, Win Logs, Attributed Conversion Logs and Loss Logs always enclose fields in double quotes, while all other log types only enclose fields in double quotes to handle for commas in the value of the field.
Updated about a month ago
|Antenna SQL Access|