| ad_position | 1 | If applicable, ad position on page | VARCHAR(255) | |
| app_bundle | 2 | Application bundle or package name (e.g., com.foo.mygame). This is intended to be a unique ID across multiple exchanges. | VARCHAR(255) | |
| app_id | 3 | Application ID on the exchange. For uniqueness, Uses ad exchange/SSP identifier as prefix e.g. pm/ representing pubmatic | VARCHAR(255) | |
| app_name | 4 | Mobile app name | VARCHAR(255) | |
| auction_id | 5 | Unique ID for every auction in the system. A joining key for all the events associated with the auction, like impression, clicks, and activities. | VARCHAR(255) | |
| bid_time | 6 | Time of bid request sent, YYYY-MM-DD HH:MM:SS in ET timezone | TIMESTAMP | |
| category | 7 | CSV of IAB-defined content categories: http://www.iab.com/guidelines/iab-quality-assurance-guidelines-qag-taxonomy/; determine type of content associated with a particular slice of inventory | VARCHAR(255) | |
| content_coppa_flag | 8 | Children’s Online Privacy Protection Act (COPPA) Flag; inventory with this flag carries several ad quality limitations | BOOLEAN | |
| content_language | 9 | Language in which content associated to the impression is written (as declared by the publisher) | VARCHAR(255) | |
| content_rating | 10 | Content parental rating (as declared by the publisher) | VARCHAR(255) | |
| domain | 11 | Domain name from which a given impression originated | VARCHAR(255) | |
| environment_type | 12 | Environment type (APP or WEB) | VARCHAR(255) | |
| geo_city | 13 | City geo code IP address. MaxMindDB Lookup data | VARCHAR(255) | |
| geo_country | 14 | Country geo name IP address. MaxMindDB Lookup data | VARCHAR(255) | |
| geo_metro | 15 | Metro geo code IP address. MaxMindDB Lookup data | VARCHAR(255) | |
| geo_region | 16 | Geo region name IP address. MaxMindDB Lookup data | VARCHAR(255) | |
| geo_zip | 17 | Zip code IP address. MaxMindDB Lookup data | VARCHAR(255) | |
| inventory_interstitial | 18 | determines if ad tag responsible for the impression accepts interstitial creatives or not; 1 for yes, 0 for no | BOOLEAN | |
| inventory_source | 19 | Inventory source - exchange name | VARCHAR(255) | |
| inventory_source_relationship | 20 | Inventory source relationship | VARCHAR(255) | |
| ip_address | 21 | IP address provided by the exchange during the auction | VARCHAR(255) | |
| ip_range | 22 | IP address provided by the exchange during the auction (same as ip_address) | VARCHAR(255) | |
| placement | 23 | Placement ID/name, as provided by the publisher. Prefixed with exchange handle. | VARCHAR(255) | |
| platform_bandwidth | 24 | Shows whether the browser is using wifi or carrier to establish connection with internet to generate the impression | VARCHAR(255) | |
| platform_browser | 25 | Name of browser used during the auction for the impression at hand | VARCHAR(255) | |
| platform_browser_version | 26 | Version of browser used to during the auction for the impression at hand | VARCHAR(255) | |
| platform_carrier | 27 | If the device is using a mobile carrier to establish internet connection, this field will identify which carrier is used | VARCHAR(255) | |
| platform_device_didmd5 | 28 | Hardware device ID (e.g., IMEI); hashed via MD5 | VARCHAR(255) | |
| platform_device_didsha1 | 29 | Hardware device ID (e.g., IMEI); hashed via SHA1 | VARCHAR(255) | |
| platform_device_dpidmd5 | 30 | Platform device ID (e.g., Android ID); hashed via MD5 | VARCHAR(255) | |
| platform_device_dpidsha1 | 31 | Platform device ID (e.g., Android ID); hashed via SHA1 | VARCHAR(255) | |
| platform_device_idfa | 32 | iOS app ID; "Identifier for Advertisers"; deprecated | VARCHAR(255) | |
| platform_device_ifa | 33 | ID sanctioned for advertiser use in the clear (i.e., not hashed) | VARCHAR(255) | |
| platform_device_make | 34 | Make of the device used to generate the impression | VARCHAR(255) | |
| platform_device_model | 35 | Model of the device used to generate the impression | VARCHAR(255) | |
| platform_device_screen_size | 36 | Screensize of the device used to generate the impression | VARCHAR(255) | |
| platform_device_type | 37 | Type of the device used to generate the impression | VARCHAR(255) | |
| platform_js | 38 | Indicates whether the browser supports JavaScript or not | BOOLEAN | |
| platform_os | 39 | Operating system of the device used to generate the impression | VARCHAR(255) | |
| platform_os_version | 40 | Operating system version of the device used to generate the impression | VARCHAR(255) | |
| segment_id | 41 | AIDEM segment ID | VARCHAR(255) | |
| segment_user_id | 42 | AIDEM segment user ID | INT2 | |
| site_id | 43 | ID of the site that generated the impression, as provided by the publisher. Prefixed with exchange handle for uniqueness. | VARCHAR(255) | |
| site_name | 44 | Name of the site that generated the impression, as provided by the publisher | VARCHAR(255) | |
| time_of_week | 45 | Time of week in GPS weekly time during which the impression occurred; Internal | INT4 | |
| user_id | 46 | Device ID for mobile, cookie for desktop. Will populate with cookie on a desktop OR an iOS/Android ID for mobile | VARCHAR(255) | |
| video_boxing_allowed | 47 | Indicates if letter-boxing of 4:3 content into a 16:9 window is allowed, where 0 = no, 1 = yes | BOOLEAN | |
| video_companion_required | 48 | A banner companion ad is required to accompany the video ad: 0=false, 1=true | BOOLEAN | |
| video_playback_method | 49 | Video playback method, as determined by the publisher. | VARCHAR(255) | |
| video_player_size | 50 | Video player size | VARCHAR(255) | |
| video_start_delay | 51 | Indicates the start delay in seconds for pre-roll, mid-roll, or post-roll ad placements | INT2 | |
| test | 52 | Indicator of test mode in which auctions are not billable, where 0 = live mode, 1 = test mode | BOOLEAN | |
| placement_type | 53 | Placement type, indicates whether the placement is meant for banner, video ads, or both | VARCHAR(255) | |
| geo_lat | 54 | Latitude associated with the impression | VARCHAR(50) | |
| geo_lon | 55 | Longitude associated with the impression | VARCHAR(50) | |
| video_min_Duration | 56 | Minimum duration of the video creative, as allowed by the publisher | INT4 | |
| video_max_duration | 57 | Maximum duration of the video creative, as allowed by the publisher | INT4 | |
| video_player_width | 58 | Width of the video player that is responsible for generating the impression | INT4 | |
| video_player_height | 59 | Height of the video player that is responsible for generating the impression | INT4 | |
| banner_width | 60 | Width of the banner placement tag | INT4 | |
| banner_height | 61 | Height of the banner placement tag | INT4 | |
| banner_width_max | 62 | Maximum width of the banner placement, as allowed by the publisher | INT4 | |
| banner_height_max | 63 | Maximum height of the banner placement, as allowed by the publisher | INT4 | |
| banner_width_min | 64 | Minimum width of the banner placement, as allowed by the publisher | INT4 | |
| banner_height_min | 65 | Minimum height of the banner placement, as allowed by the publisher | INT4 | |
| dnt | 66 | Do Not Track | INT4 | |
| geo_type | 67 | LocationType, how the geographic information was determined | VARCHAR(20) | |
| bid_time_epoch_in_usecs | 68 | bid timestamp(epoch) with microsecond precision. Allows the customer to calculate the bid_time in any timezone instead of relying on bid_time field which is ET timezone | INT8 | |
| page_url | 69 | URL of the page responsible for the auction | VARCHAR(255) | |
| exchange_predicted_view_rate | 70 | Predicted Viewability Rate of the impression within the auction, as determined by the exchange-auctioner | NUMERIC(18,6) | |
| available_deal_ids | 71 | CSV of all available deal IDs that the impression is available via | VARCHAR(255) | |
| battrs | 72 | CSV of Creative attributes that are blocked by the publisher, as declared by the publisher | VARCHAR(255) | |
| exchange_auction_id | 73 | Auction ID generated by the auction host ; different to that of AIDEM | VARCHAR(255) | |
| rewarded | 74 | States whether the placement tag behind the impression is meant for rewarded ads | INT2 | |
| ua | 75 | User agent header that is passed along by the browser to the auction host when an impression is generated | VARCHAR(255) | |
| account_id | 76 | AIDEM bidder account ID; represents the bidder seat for a particular client | INT4 | |
| auction_adgroup_id | 77 | Combination of auction ID, buzzkey, account ID, campaign ID, and line item ID | VARCHAR(255) | |
| bid_price_micros_usd | 78 | Bid price returned by the bidding agent(in USD micros). 1 USD = 1,000,000 micros | INT8 | |
| bid_time | 79 | Time of bid request sent, YYYY-MM-DD HH:MM:SS in ET timezone | TIMESTAMP | YYYY-MM-DD HH24:MI:SS.MS in ET |
| buzz_key | 80 | AIDEM Buzz key, an identifier for client bidder instances | VARCHAR(255) | |
| campaign_id | 81 | ID of the campaign that submitted the bid | INT4 | |
| campaign_revenue_amount_micros | 82 | Campaign revenue in micros. 1 USD = 1,000,000 micros | INT8 | |
| campaign_revenue_type | 83 | Campaign revenue type determines how revenue is booked by the advertiser for a particular campaign; CPM or CPC (cost per click) basis | VARCHAR(255) | |
| creative_id | 84 | ID of the creative that was submitted within the bid request | INT4 | |
| customer_id | 85 | Customer AIDEM ID; cookie ID provided for a particular browser by AIDEM | INT4 | |
| deal_id | 86 | ID of the deal within which the impression is available; Pulsepoint (pp), Mopub (mp), Rubicon (rp); is populated if an impression was sold via a deal | VARCHAR(255) | |
| line_item_id | 87 | Line Item ID that was responsible for submitting the bid, as listed in AIDEM | INT4 | |
| line_item_revenue_amount_micros | 88 | Amount of revenue booked by line item for winning this impression, in micros. 1 USD = 1,000,000 micros | INT8 | |
| line_item_revenue_type | 89 | Type determines how the revenue was booked by the line item e.g. on a CPM or CPC basis | VARCHAR(255) | |
| pre_reduction_bid_price_micros_usd | 90 | Bid price returned by the bidding agent in micros. 1 USD = 1,000,000 micros | INT8 | |
| sent_to_exchange | 91 | Always true. Signifies whether this was the bid internally sent to the exchange | BOOLEAN | |
| total_cpm_vendor_fee_amount_micros | 92 | Internal, tracks total vendor fee per CPM. 1 USD = 1,000,000 micros | INT8 | |
| total_percent_vendor_fee_amount_micros | 93 | Internal, tracks total vendor fee % of win_cost_micros_usd. 1 USD = 1,000,000 micros | INT8 | |
| model_id | 94 | Pending renaming to agent_id. Holds the agent_id field value of the BidAgentResponse return by the customer's bidding agent. This can be used for debugging. | VARCHAR(255) | |
| model_params | 95 | Pending renaming to agent_params. Holds the agent_params field value of the BidAgentResponse return by the customer's bidding agent. This can be used for debugging. Format => {key}={value},{key}={value}.. | VARCHAR(255) | |
| bidding_strategy_id | 96 | ID of the custom bidding strategy in AIDEM | VARCHAR(255) | |
| bidding_strategy_params | 97 | Parameters passed along by the client for the custom bidding strategy in AIDEM | VARCHAR(255) | |
| bid_price_micros | 98 | Bid price in native currency returned by the bidding agent(in micros). 1 USD = 1,000,000 micros | INT8 | |
| bid_price_micros_currency | 99 | Three letter currency code for bid_price_micros field | VARCHAR(10) | |
| bid_price_micros_currency_rate | 100 | Currency exchange rate (in decimal) at the auction time | NUMERIC(18,10) | |
| exchange_feedback_bid_id | 101 | ID of the adcandidate/bid in the bidresponse. It is used to identify the adcandidate making the bid. For GOOGLE_ADX, it is the index of BidResponse_Ad (starting from 0). | VARCHAR(255) | |
| adx_creative_status_code | 102 | The status code for the ad. See creative-status-codes.txt in the technical documentation for a list of IDs. | INT4 | |
| adx_cpm_micros | 103 | The second price cpm in micros of your account currency if your bid won the auction, or the CPM that must be exceeded to win the auction if your bid was outbid. This is only set if your bid participated in the auction. It is not set if the bid was filtered prior to the auction. It is also withheld if the publisher or winning bidder has opted out of price feedback, or if your account has opted out of sharing winning prices with other bidders. | INT8 | |
| user_time_of_week | 104 | Time of week in GPS weekly time during which the impression occurred using the user's timezone; internal | INT4 | |
| minimum_bid_to_win | 105 | Indicates the minimum bid needed to clear floors and outbid all competitors. Only populated for first-price auctions. | INT8 | |
| bid_time_utc | 106 | Time of bid request sent, in UTC timezone | TIMESTAMP | |
| test_group_id | 107 | ID of the Test Group the user fell into within the test plan. Should match the Test Group assigned to the line item | INT4 | |
| experiment_user_index | 108 | Random number between 1-1000 assigned to a user. Used for test group assignment | INT4 | |
| test_plan_id | 109 | ID of the Test Plan associated with the campaign | INT4 | |
| is_gdpr_consented | 110 | Whether the auction is regulated by GDPR AND the customer has been granted consent by the end user. | VARCHAR(255) | |
| targeted_lat_long_lists | 111 | The names of the lat/long lists specified that were targeted and matched on the given request. | INT8 | |
| qaq_media_rating | 112 | If defined, contains the QAG Media Rating of the content as defined by OpenRTB spec. | INT8 | |
| guaranteed | 113 | Indicates whether a given line item is a guaranteed line item or not. | INT2 | |
| creative_alt_id | 114 | If set, the alternative ID of the creative that won the auction will populate in this column. | VARCHAR(255) | |
| creative_name | 115 | The name of the creative as specified in Buzz. | VARCHAR(255) | |
| lat_long_list_item_ids | 116 | Comma-separated list of unique keys describing the matching lat/long list item IDs for this event. Formed as the cocatenation of the List ID and List Item ID. | VARCHAR(255) | |
| lat_long_list_item_names | 117 | Comma-separated list of names (if set) for the the matching lat/long list item IDs for this event. Displayed in the same order as the IDs in the previous column. If no name is set for the matched list item then the field will be set to an empty string for each given list item id. If multiple list items match this field may have multiple commas with no values in it. | VARCHAR(255) | |
| bcat | 118 | Blocked advertiser categories using the IAB content categories. | VARCHAR(255) | |
| platform_device_hwv | 119 | Hardware Version of the Device sent via OpenRTB | VARCHAR(255) | |
| platform_device_language | 120 | Browser language using ISO-639-1-alpha-2. Sent via OpenRTB | VARCHAR(255) | |
| platform_device_w | 121 | Physical width of the screen in pixels | INT4 | |
| platform_device_h | 122 | Physical height of the screen in pixels | INT4 | |
| platform_device_ppi | 123 | Screen size as pixels per linear inch. | INT4 | |
| platform_device_pxratio | 124 | The ratio of physical pixels to device independent pixels. | NUMERIC(18,6) | |
| experiment_id_type | 125 | The ID type used for segregation of impressions for AIDEM's experiment feature. | VARCHAR(255) | |
| tmax | 126 | The required time in milliseconds for the bid to respond to the exchange to be considered in the auction | INT4 | |
| video_skippable | 127 | If the ad is a video ad, this field indicates whether the creative trafficked could have been skippable. | INT2 | |
| advertiser_id | 128 | Advertiser ID | INT8 | |
| lmt | 129 | Limit Ad Tracking (LMT) is a device-level opt-out setting, that allows users to limit the amount of information sent from their device to ad exchanges (including omitting their device ID) | INT2 | |
