Bid Adjustments

This dataset contains bid adjustment data from Prebid, where bids are adjusted due to publisher settings such as floors and currency inputs.

Column	Type	Description
publisher_id	bigint	Unique identifier for the publisher
bidder_code	string	Code identifying the bidder
ad_unit_code	string	Code for the ad unit being targeted
size	string	Dimensions of the ad unit
net_revenue	float	Net revenue from the ad bid
original_currency	string	Currency of the original bid
original_cpm	decimal(10,4)	Original cost per mille (CPM) bid in the original currency
cpm	decimal(10,4)	Adjusted cost per mille (CPM) in the platform’s currency
adjustment_diff	decimal(10,4)	Difference between the original and adjusted CPM
source	string	Source of the bid adjustment
adserver_targeting	jsonb	Targeting parameters passed to the ad server
meta	jsonb	Additional metadata related to the bid adjustment
transaction_id	string	Unique identifier for the transaction
auto_pb	float	Automated price bucket value
custom_pb	float	Custom price bucket value
dense_pb	float	Dense price bucket value
low_pb	float	Low price bucket value
medium_pb	float	Medium price bucket value
high_pb	float	High price bucket value
created_at	datetime(6)	Timestamp when the record was created, cannot be null
updated_at	datetime(6)	Timestamp when the record was last updated, cannot be null
page_id	integer	Unique identifier for the page, cannot be null
floor_data	jsonb	Data related to the minimum bid price
currency	string	Currency used for the adjusted cost for the incoming bids.