| 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. Note that auction_id was previously unique to a single bid request, but it is now possible that a single bid request will contain multiple auctions. Refer to request_id for a unique id per bid request. | VARCHAR(255) | |
| bid_time | 6 | Time of bid request sent, YYYY-MM-DD HH:MM:SS in ET timezone | TIMESTAMP | YYYY-MM-DD HH24:MI:SS.MS in ET |
| 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. When no IPv4 address is present, the value is set to '0.0.0.0' | 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(600) | |
| 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 | | 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_long | 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 | |
| account_id | 69 | AIDEM bidder account ID; represents the bidder seat for a particular client | INT4 | |
| auction_adgroup_id | 70 | Combination of auction ID, buzzkey, account ID, campaign ID, and line item ID | VARCHAR(255) | |
| exchange_bid_price_micros_usd | 71 | Bid price in micros sent to the exchange. This includes bid_reduction and vendor_fees. 1 USD = 1,000,000 micros | INT8 | |
| buzz_key | 72 | AIDEM Buzz key, an identifier for client bidder instances | VARCHAR(255) | |
| campaign_id | 73 | ID of the campaign that submitted the bid | INT4 | |
| campaign_revenue_amount_micros | 74 | Campaign revenue in micros. 1 USD = 1,000,000 micros | INT8 | |
| campaign_revenue_type | 75 | 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 | 76 | ID of the creative that was submitted within the bid request | INT4 | |
| customer_id | 77 | Customer AIDEM ID; cookie ID provided for a particular browser by AIDEM | INT4 | |
| deal_id | 78 | Populated with the impression's Deal ID if an impression was sold via a deal. | VARCHAR(255) | |
| line_item_id | 79 | Line Item ID that was responsible for submitting the bid, as listed in AIDEM | INT4 | |
| line_item_revenue_amount_micros | 80 | Amount of revenue booked by line item for winning this impression, in micros. 1 USD = 1,000,000 micros | INT8 | |
| line_item_revenue_type | 81 | Type determines how the revenue was booked by the line item e.g. on a CPM or CPC basis | VARCHAR(255) | |
| bid_price_micros_usd | 82 | Bid price returned by the bidding agent(in USD micros). 1 USD = 1,000,000 micros | INT8 | |
| sent_to_exchange | 83 | Always true. Signifies whether this was the bid internally sent to the exchange | BOOLEAN | |
| total_cpm_vendor_fee_amount_micros | 84 | Internal, tracks total vendor fee per CPM. 1 USD = 1,000,000 micros | INT8 | |
| total_percent_vendor_fee_amount_micros | 85 | Internal, tracks total vendor fee % of win_cost_micros_usd. 1 USD = 1,000,000 micros | INT8 | |
| agent_id | 86 | Pending renaming to agent_id. Holds the agent_id field value of the BidAgentResponse return by the customer's bidding agent. If the line item uses Bid Models, this filed will contain the Bid Model ID. This can be used for debugging. | VARCHAR(255) | |
| agent_params | 87 | 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. If the line item uses Bid Models, this will contain the cache results for the Bid Model lookup. Format => {key}={value},{key}={value}.. | VARCHAR(600) | |
| page_url | 88 | URL of the page responsible for the auction | VARCHAR(255) | |
| exchange_predicted_view_rate | 89 | Predicted Viewability Rate of the impression within the auction, as determined by the exchange-auctioner | NUMERIC(18,6) | |
| available_deal_ids | 90 | Comma-separated list of all the available deal IDs on the associated Bid Request | VARCHAR(255) | |
| battrs | 91 | CSV of Creative attributes that are blocked by the publisher, as declared by the publisher | VARCHAR(255) | |
| exchange_auction_id | 92 | Auction ID generated by the auction host ; different to that of AIDEM | VARCHAR(255) | |
| rewarded | 93 | States whether the placement tag behind the impression is meant for rewarded ads | INT2 | |
| bid_price_micros | 94 | Bid price in native currency returned by the bidding agent(in micros). 1 Unit of LIne Item's Set Currency = 1,000,000 micros | INT8 | |
| bid_price_micros_currency | 95 | Three letter currency code for bid_price_micros field | VARCHAR(10) | |
| bid_price_micros_currency_rate | 96 | Currency exchange rate (in decimal) at the auction time | NUMERIC(18,10) | |
| ua | 97 | User agent header that is passed along by the browser to the auction host when an impression is generated | VARCHAR(255) | |
| advertiser_id | 98 | Advertiser ID for the impression | INT4 | |
| bid_floor_micros | 99 | The floor or lowest allowable clearing price of the auction. 1 USD = 1,000,000 micros | INT8 | |
| bid_floor_currency | 100 | If the bid floor is specified and multiple currencies are supported per bid request, the currency of the bid floor using ISO-4217 codes | VARCHAR(10) | |
| display_manager | 101 | Name of the ad mediation partner, SDK technology, or player responsible for rendering ad (typically video or mobile). Used by some ad servers to customize ad code by partner. | VARCHAR(255) | |
| display_manager_ver | 102 | Version of display_manager | VARCHAR(255) | |
| exchange_device_make | 103 | Device make provided by the exchange, e.g. "Apple" | VARCHAR(255) | |
| exchange_device_model | 104 | Device model provided by the exchange, e.g. "iPhone" | VARCHAR(255) | |
| auction_type | 105 | If 1, first price auction. If 2, second price auction. Additional auction types cna be defined as per the exchange's business rules | INT4 | |
| publisher_id | 106 | Publisher ID on the exchange. Prefixed with the exchange handle for uniqueness | VARCHAR(255) | |
| ads_txt | 107 | Ads.txt status for the request. It is an enum field, and can be one of the following values: UNKNOWN - The request was not augmented by the ads.txt augmentor (should never happen) NO_DOMAIN - The request does not contain a domain, either because it is not a web request (ie it is an app or native request) or it is a web request but does not contain a domain NO_ADS_TXT_FILE - The request's domain does not have an Ads.txt file ADS_TXT_NOT_SCANNED - We have not looked up the Ads.txt file for the request's domain NO_ADVERTISING_ALLOWED - The request's domain does not allow any advertising MISSING_PUB_ID - The request is missing a publisher id so we cannot check its Ads.txt status NOT_AUTH - The request's domain does have an Ads.txt file, but it does not allow advertising from this exchange / publisher ID combination AUTH_RESELLER - The domain's Ads.txt file allows this exchange / publisher ID to resell advertising AUTH_DIRECT - The domain's Ads.txt file allows this exchange / publisher ID to advertise directly | VARCHAR(20) | |
| bid_modifier_id | 108 | ID of the Bid Modifier in Buzz | INT8 | |
| bid_modifier_multipliers_product | 109 | Combined bid modifier multiplier applied to the bid | NUMERIC(18.6) | |
| matched_user_groups | 110 | Matched user IDs for match tables hosted by AIDEM | VARCHAR(255) | |
| ipv6_address | 111 | IPv6 address provided by the exchange during the auction. When no IPv6 address is present, the value is set to '0:0:0:0:0:0:0:0' | VARCHAR(255) | |
| flight_id | 112 | ID of the Line Item Flight in Buzz (if present) | INT4 | |
| user_id_hashed | 113 | GDPR-compliant hashed user_id | VARCHAR(255) | |
| ip_address_hashed | 114 | GDPR-compliant hashed ip | VARCHAR(255) | |
| ipv6_address_hashed | 115 | GDPR-compliant hashed ipv6 | VARCHAR(255) | |
| is_gdpr | 116 | When this field is set to true, AIDEM has determined that this request needs to comply with GDPR | INT2 | |
| gdpr_consent_string | 117 | The raw IAB GDPR consent string as provided in the bid request | VARCHAR(255) | |
| request_id | 118 | Unique ID for every bid request in the system. A joining key for all the events associated with the bid request, like impression, clicks, and activities. Note that it is possible to have multiple auction_ids for a single request_id | VARCHAR(255) | |
| person_linked_ids | 119 | Deprecated; will not be populated. | VARCHAR(600) | |
| household_linked_ids | 120 | Deprecated; will not be populated. | VARCHAR(600) | |
| video_protocols | 121 | Comma-separated list of video protocols that are accepted by the publisher | VARCHAR(255) | |
| banner_top_frame | 122 | Indicates if the banner is in the top frame as opposed to an iframe | INT2 | |
| user_time_of_week | 123 | Time of week in GPS weekly time during which the impression occurred using the user's timezone; internal | INT4 | |
| bid_time_utc | 124 | Time of bid request sent, in UTC timezone | TIMESTAMP | YYYY-MM-DD HH24:MI:SS.MS in UTC |
| test_group_id | 125 | 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 | 126 | Random number between 1-1000 assigned to a user. Used for test group assignment | INT4 | |
| test_plan_id | 127 | ID of the Test Plan associated with the campaign | INT4 | |
| inventory_source_user_id | 128 | Unique consumer ID of the user, as defined by the exchange. | VARCHAR(255) | |
| mccmnc | 129 | Mobile carrier as defined by the concatenated MCC-MNC code. | VARCHAR(255) | |
| us_privacy | 130 | US Privacy String as defined by the IAB CCPA Compliance Framework, and used to define the regulatory context governing the personal data contained within the associated bid request. | VARCHAR(255) | |
| video_placement | 131 | The placement of the video impression (e.g., In-Stream) | VARCHAR(255) | |
| publisher_name | 132 | Publisher Name as specified on the OpenRTB request. | VARCHAR(255) | |
| deal_bid_floors | 133 | Comma-separated list of the bid floors for the available deal IDs | VARCHAR(255) | |
| bid_shade | 134 | The Bid Shade Status of the won impression. Will be one of: NOT_ELIGIBLE - Line Item was ineligible for bid shading BID_SHADED - Line Item had its bid shaded. CONTROL_GROUP - Line Item was eligible for bid shading but was selected for the control group of the algorithm. | VARCHAR(255) | |
| bid_reduction_micros | 135 | Value the bid was shaded by in micros. | INT8 | |
| video_api | 136 | List of supported API frameworks for this impression. | VARCHAR(255) | |
| targeted_segments | 137 | AIDEM segment ID; contains all segments the user qualifies for that were also targeted on the line item that won | VARCHAR(600) | |
| require_native_video | 138 | If the creative for the impression is of type Native, this field will be set to 1 when a video asset is required. The field will be 0 in all other cases. | INT2 | |
| is_gdpr_consented | 139 | Whether the auction is regulated by GDPR AND the customer has been granted consent by the end user. | INT2 | |
| targeted_lat_long_lists | 140 | The names of the lat/long lists specified that were targeted and matched on the given request. | VARCHAR(255) | |
| qag_media_rating | 141 | If defined, contains the QAG Media Rating of the content as defined by OpenRTB spec. | VARCHAR(255) | |
| guaranteed | 142 | Indicates whether a given line item is a guaranteed line item or not. | INT2 | |
| creative_alt_id | 143 | If set, the alternative ID of the creative that won the auction will populate in this column. | VARCHAR(255) | |
| creative_name | 144 | The name of the creative as specified in Buzz. | VARCHAR(255) | |
| lat_long_list_item_ids | 145 | 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 | 146 | 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 | 147 | Blocked advertiser categories using the IAB content categories. | VARCHAR(255) | |
| platform_device_hwv | 148 | Hardware Version of the Device sent via OpenRTB | VARCHAR(255) | |
| platform_device_language | 149 | Browser language using ISO-639-1-alpha-2. Sent via OpenRTB | VARCHAR(255) | |
| platform_device_w | 150 | Physical width of the screen in pixels | INT4 | |
| platform_device_h | 151 | Physical height of the screen in pixels | INT4 | |
| platform_device_ppi | 152 | Screen size as pixels per linear inch. | INT4 | |
| platform_device_pxratio | 153 | The ratio of physical pixels to device independent pixels. | NUMERIC(18,6) | |
| experiment_id_type | 154 | The ID type used for segregation of impressions for AIDEM's experiment feature. | VARCHAR(255) | |
| deal_ats | 155 | If the impression was purchased via a deal, this logs the auction type for all deals on the auction in the same order as the deal_ids column. 1 = First Price, 2 = Second Price, 3 = Fixed Price. Overrides "auction_type" | | |
| account_level_revenue_share_fee_type | 156 | If using the account-level revenue share feature, this column populates whether the fee is expressed as a reduction or fee. | VARCHAR(255) | |
| account_level_revenue_share_percent_micros | 157 | If using the account-level revenue share feature, this column populates the percentage of the rev share for the given impression in micros. | INT8 | |
| tmax | 158 | The required time in milliseconds for the bid to respond to the exchange to be considered in the auction | INT4 | |
| video_skippable | 159 | If the ad is a video ad, this field indicates whether the creative trafficked could have been skippable. | INT2 | |
| is_skadnetwork | 160 | Flags whether the inventory is SKAdNetwork enabled. | INT2 | |
| lmt | 161 | 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 | |
| banner_format | 162 | Comma-separated list of banner formats (wxh) that are accepted by the publisher | VARCHAR(255) | |
| content_id | 163 | ID uniquely identifying the content | VARCHAR(255) | |
| content_episode | 164 | Episode number | VARCHAR(255) | |
| content_title | 165 | Content title | VARCHAR(255) | |
| content_series | 166 | Content series | VARCHAR(255) | |
| content_season | 167 | Content season | VARCHAR(255) | |
| content_genre | 168 | Genre that best describes the content | VARCHAR(255) | |
| content_contentrating | 169 | Content rating (e.g., MPAA) | VARCHAR(255) | |
| content_keywords | 170 | Comma separated list of keywords describing the content | VARCHAR(255) | |
| content_livestream | 171 | 0 = not live, 1 = content is live (e.g., stream, live blog) | INT4 | |
| content_len | 172 | Length of content in seconds; appropriate for video or audio | VARCHAR(255) | |
| content_network_id | 173 | ID of the network the content is on. This may not be a unique identifier across all supply sources | VARCHAR(255) | |
| content_network_name | 174 | Network the content is on (e.g., a TV network like “ABC") | VARCHAR(255) | |
| content_network_domain | 175 | The primary domain of the network (e.g. “abc.com” in the case of the network ABC). | VARCHAR(255) | |
| content_channel_id | 176 | ID of the channel the content is on. This may not be a unique identifier across all supply sources | VARCHAR(255) | |
| content_channel_name | 177 | Channel the content is on (e.g., a local channel like “WABC-TV") | VARCHAR(255) | |
| content_channel_domain | 178 | The primary domain of the channel (e.g. “abc7ny.com” in the case of the local channel WABC-TV) | VARCHAR(255) | |
| content_cat | 179 | Array of IAB content categories that describe the content | VARCHAR(255) | |
