Win Logs Schema

HeaderPositionDefinitionsql_datatypeDDL desc
account_id1AIDEM bidder account ID; represents the bidder seat for a particular clientINT4
ad_position2If applicable, ad position on pageVARCHAR(255)
app_bundle3Application bundle or package name (e.g., com.foo.mygame). This is intended to be a unique ID across multiple exchanges.VARCHAR(255)
app_id4Application ID on the exchange. For uniqueness, Uses ad exchange/SSP identifier as prefix e.g. pm/ representing pubmaticVARCHAR(255)
app_name5Application nameVARCHAR(255)
auction_adgroup_id6Internal Unique IDVARCHAR(255)
auction_id7Unique 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.VARCHAR(255)
beeswax_fee_rate_micros8For PERCENT fee-type option, applicable AIDEM fee rate in micros 1 micro = 0.000,0001%INT8
bid_hour9Datestamp during which a particular bid was made, YYYY-MM-DD HH:00:00 in ET timezoneTIMESTAMPYYYY-MM-DD HH24:MI:SS in ET
bid_price_micros_usd10Bid price returned by the bidding agent (in USD micros); $1.00 CPM = 1,000,000 microsINT8
bid_reduction_rate_micros11For BID_REDUCTION(rev-share) fee type option, applicable Bid reduction rate in micros 1 micro = 0.000,0001%INT8
bid_time12Time of bid request sent, YYYY-MM-DD HH:MM:SS in ET timezoneTIMESTAMPYYYY-MM-DD HH24:MI:SS.MS in ET
buzz_key13AIDEM Buzz key, an identifier for client bidder instancesVARCHAR(255)
campaign_id14ID of the campaign that submitted the bidINT4
campaign_revenue_amount_micros15Amount of revenue set in the campaign config for completion of the revenue type condition, in micros. 1 USD = 1,000,000 microsINT8
campaign_revenue_type16Campaign revenue type determines how revenue is booked by the advertiser for a particular campaign; CPM or CPC (cost per click) basisVARCHAR(255)
category17comma separate list 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 inventoryVARCHAR(255)
clearing_price_micros_usd18Auction Clearing price(in micros) returned by exchange. This is the raw media cost. 1 USD = 1,000,000 microsINT8
clicks19Set to 1 if the impression received a clickINT2
content_coppa_flag20Children’s Online Privacy Protection Act (COPPA) Flag; inventory with this flag carries several ad quality limitationsINT4
content_language21Language in which content associated to the impression is written (as declared by the publisher)VARCHAR(255)
content_rating22Content parental rating (as declared by the publisher)VARCHAR(255)
conversions23Number of conversions associated to a particular impressionINT4
conversion_order24Conversion order, constitutes how many orders a particular conversion represents; info provided by the advertiser in AIDEM UI/APINUMERIC(18,6)
conversion_value25Value of a given conversion as ispecified by the advertiser in AIDEM UI/APINUMERIC(18,6)
create_time26Time created; AIDEM internal bookkeeping fieldTIMESTAMPYYYY-MM-DD HH24:MI:SS.US in UTC
creative_id27AIDEM ID for the creative that won an impressionINT4
customer_id28Customer AIDEM IDINT4
deal_id29Populated with the impression's Deal ID if an impression was sold via a deal.VARCHAR(255)
domain30Domain name from which a given impression originatedVARCHAR(255)
environment_type31Environment type (APP or WEB)VARCHAR(255)
exchange_discrepancy_rate_micros32Observed operational spend discrepancy between exchange and AIDEM. 1 micro = 0.000,0001%INT8
geo_city33City geo code IP address. MaxMindDB Lookup dataVARCHAR(255)
geo_country34Country geo name IP address. MaxMindDB Lookup dataVARCHAR(255)
geo_metro35Metro geo code IP address. MaxMindDB Lookup dataVARCHAR(255)
geo_region36Geo region name IP address. MaxMindDB Lookup dataVARCHAR(255)
geo_zip37Zip code IP address. MaxMindDB Lookup dataVARCHAR(255)
has_frequency_cap38Frequency capped at campaign/lineitem levelINT2
inventory_interstitial39determines if ad tag responsible for the impression accepts interstitial creatives or not; 1 for yes, 0 for noINT4
inventory_source40Inventory source - exchange nameVARCHAR(255)
inventory_source_relationship41Inventory source relationship—direct or indirectVARCHAR(255)
ip_address42IP 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_range43IP address provided by the exchange during the auction (same as ip_address)VARCHAR(255)
line_item_id44Line Item ID that was responsible for winning the auction, as listed in AIDEMINT4
line_item_revenue_amount_micros45Amount of revenue set in the line item config for completion of the revenue type condition, in micros. 1 USD = 1,000,000 microsINT8
line_item_revenue_type46Type determines how the revenue was booked by the line item e.g. on a CPM or CPC basisVARCHAR(255)
placement47Placement ID/name, as provided by the publisher. Prefixed with exchange handle.VARCHAR(255)
platform_bandwidth48Shows whether the browser is using wifi or carrier to establish connection with internet to generate the impressionVARCHAR(255)
platform_browser49Name of browser used during the auction for the impression at handVARCHAR(255)
platform_browser_version50Version of browser used to during the auction for the impression at handVARCHAR(255)
platform_carrier51If the device is using a mobile carrier to establish internet connection, this field will identify which carrier is usedVARCHAR(255)
platform_device_didmd552Hardware device ID (e.g., IMEI); hashed via MD5VARCHAR(255)
platform_device_didsha153Hardware device ID (e.g., IMEI); hashed via SHA1VARCHAR(255)
platform_device_dpidmd554Platform device ID (e.g., Android ID); hashed via MD5VARCHAR(255)
platform_device_dpidsha155Platform device ID (e.g., Android ID); hashed via SHA1VARCHAR(255)
platform_device_idfa56iOS app ID; "Identifier for Advertisers"; deprecatedVARCHAR(255)
platform_device_ifa57ID sanctioned for advertiser use in the clear (i.e., not hashed)VARCHAR(255)
platform_device_make58Make of the device used to generate the impressionVARCHAR(255)
platform_device_model59Model of the device used to generate the impressionVARCHAR(255)
platform_device_screen_size60Screensize of the device used to generate the impressionVARCHAR(255)
platform_device_type61Type of the device used to generate the impressionVARCHAR(255)
platform_js62Indicates whether the browser supports JavaScript or notINT4
platform_os63Operating system of the device used to generate the impressionVARCHAR(255)
platform_os_version64Operating system version of the device used to generate the impressionVARCHAR(255)
pre_reduction_bid_price_micros_usd65Bid price returned by the bidding agent in micros. 1 USD = 1,000,000 microsINT8
revenue_amount_micros66Revenue in micros. Takes into account the Revenue Type to calculate actual revenue generated by impression based on whether revenue condition was achieved.This represents the actual revenue generated by an impression. 1 USD = 1,000,000 microsINT8
segment_id67AIDEM segment ID; contains all segments the user qualifies for, comma-delimited, regardless if it is targeted on the line item that wonVARCHAR(600)
segment_user_id68AIDEM segment user IDINT2
site_id69ID of the site that generated the impression, as provided by the publisherVARCHAR(255)
site_name70Name of the site that generated the impression, as provided by the publisherVARCHAR(255)
time_of_week71Time of week in GPS weekly time during which the impression occurred; internalINT4
user_id72Device ID for mobile, cookie for desktop. Will populate with cookie on a desktop OR an iOS/Android ID for mobileVARCHAR(255)
video_boxing_allowed73Indicates if letter-boxing of 4:3 content into a 16:9 window is allowed, where 0 = no, 1 = yesINT2
video_companion_required74A banner companion ad is required to accompany the video ad: 0=false, 1=trueINT4
video_completes75Number of videos watched through completion; Set to 1 if video watched through completionINT2
video_midpoints76Number of videos watched through video midpoint; Set to 1 if video watched through video midpointINT2
video_playback_method77Video playback method, as determined by the publisher.VARCHAR(255)
video_player_size78Video player sizeVARCHAR(255)
video_plays79Number of video plays; Set to 1 if video playsINT2
video_q1s80Number of videos watched the first quarter; Set to 1 if video watched through the first quarterINT2
video_q3s81Number of videos watched through the third quarter; Set to 1 if video watched through the third quarterINT2
video_skips82Number of video skips; Set to 1 if video is skippedINT2
video_start_delay83Indicates the start delay in seconds for pre-roll, mid-roll, or post-roll ad placementsINT2
win_cost_micros_usd84Total win_cost including media cost, beeswax fees, exchange-specific disprecancy adjustment, vendor fees 1 USD = 1,000,000 microsINT8
advertiser_id85Advertiser ID for the impressionINT8
vendor_fee_micros_usd86Vendor fee in micros, USD 1 USD = 1,000,000 microsINT8
test87Indicator of test mode in which auctions are not billable, where 0 = live mode, 1 = test modeBOOLEAN
placement_type88Placement type, indicates whether the placement is meant for banner, video ads, or bothVARCHAR(255)
geo_lat89Latitude associated with the impressionVARCHAR(50)
geo_lon90Longitude associated with the impressionVARCHAR(50)
total_cpm_vendor_fee_amount_micros91Internal, tracks total vendor fee per CPM. 1 USD = 1,000,000 microsINT8
total_percent_vendor_fee_amount_micros92Internal, tracks total vendor fee percentage of win_cost_micros_usd. 1 USD = 1,000,000 microsINT8
bid_time_epoch_in_usecs93bid 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 timezoneINT8
model_id94Holds 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)
model_params95Holds the agent_params field value of the BidAgentResponse return by the customer's bidding agent. If the line item uses Bid Models, this will contain the cache results for the Bid Model lookup. This can be used for debugging. Format => {key}={value},{key}={value}..VARCHAR(600)
data_center96AIDEM's data center responsible for processing the bid request/response in questionVARCHAR(50)
billing_version97InternalVARCHAR(50)
in_view98Determines if the impression is viewable or notINT2
is_measurable99Determines if the impression is measurable for viewability or notINT2
in_view_time_millis100States how much time the impression was in view, measured in milisecondsINT8
bidding_strategy_id101ID of the custom bidding strategy in AIDEMVARCHAR(255)
bidding_strategy_params102Parameters passed along by the client for the custom bidding strategy in AIDEMVARCHAR(255)
exchange_predicted_view_rate103Estimated viewability rate, provided by the auction hostNUMERIC(18,6)
rx_timestamp104Impression Event received time in ET timezoneTIMESTAMPYYYY-MM-DD HH24:MI:SS.MS in ET
battrs105Creative attributes that are blocked by the publisher, as declared by the publisherVARCHAR(255)
exchange_auction_id106Auction ID generated by the auction host ; different to that of AIDEMVARCHAR(255)
rewarded107States whether the placement tag behind the impression is meant for rewarded adsINT2
currency_rate108Currency exchange rate (in decimal) at the auction timeNUMERIC(18,10)
currency_code109Three letter currency codes setup in buzzVARCHAR(10)
clearing_price_micros110Auction Clearing price(in micros) returned by exchange. This is the raw media cost 1 Unit of Line Item's set Currency = 1,000,000 microsINT8
win_cost_micros111Total win_cost including media cost, beeswax fees, exchange-specific disprecancy adjustment, vendor fees 1 Unit of Line Item's set Currency = 1,000,000 microsINT8
bid_price_micros112Bid price in native currency returned by the bidding agent(in micros). 1 Unit of Line Item's set Currency = 1,000,000 microsINT8
vendor_fee_micros113Vendor fee in micros. 1 Unit of Vendor Fee's set Currency = 1,000,000 microsINT8
viewability_vendor_name114Vendor used for providing viewability metricsVARCHAR(10)
conversion_update_time115Formerly used internallyTIMESTAMP
companion_clicks116Set to 1 if the video's companion banner received a clickINT2
companion_views117Set to 1 if the video's companion banner served an impressionINT2
banner_width118Width of the impression in pixelsINT4
banner_height119Height of the impression in pixelsINT4
bid_floor_micros120The floor or lowest allowable clearing price of the auction. 1 USD = 1,000,000 microsINT8
bid_floor_currency121If the bid floor is specified and multiple currencies are supported per bid request, the currency of the bid floor using ISO-4217 codesVARCHAR(10)
display_manager122Name 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_ver123Version of display_managerVARCHAR(255)
exchange_device_make124Device make provided by the exchange, e.g. "Apple"VARCHAR(255)
exchange_device_model125Device model provided by the exchange, e.g. "iPhone"VARCHAR(255)
line_item_alt_id126Alternative ID in Buzz of the Line ItemVARCHAR(255)
page_url127URL of the page responsible for the auctionVARCHAR(255)
auction_type128If 1, first price auction. If 2, second price auction. Additional auction types can be defined as per the exchange's business rulesINT4
publisher_id129Publisher ID on the exchange. Prefixed with the exchange handle for uniquenessVARCHAR(255)
ads_txt130Ads.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 directlyVARCHAR(20)
bid_modifier_id131ID of the Bid Modifier in BuzzINT8
bid_modifier_multipliers_product132Combined bid modifier multiplier applied to the bidNUMERIC(18.6)
matched_user_groups133Matched user IDs for match tables hosted by AIDEMVARCHAR(255)
ipv6_address134IPv6 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_id135ID of the Line Item Flight in Buzz (if present)INT4
user_id_hashed136GDPR-compliant hashed user_idVARCHAR(255)
ip_address_hashed137GDPR-compliant hashed ipVARCHAR(255)
ipv6_address_hashed138GDPR-compliant hashed ipv6VARCHAR(255)
is_gdpr139When this field is set to true, AIDEM has determined that this request needs to comply with GDPRINT2
gdpr_consent_string140The raw IAB GDPR consent string as provided in the bid requestVARCHAR(255)
targeted_segments141AIDEM segment ID; contains all segments the user qualifies for that were also targeted on the line item that wonVARCHAR(600)
clicks_ip_address142Comma delimited list of all unique IP adresses of all clicks (regular and companion) associated with this impressionVARCHAR(255)
request_id143Unique 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_idVARCHAR(255)
person_linked_ids144Deprecated; will not be populated.VARCHAR(600)
household_linked_ids145Deprecated; will not be populated.VARCHAR(600)
video_protocols146Comma-separated list of video protocols that are accepted by the publisherVARCHAR(255)
clicks_user_id147The user ID captured on the click eventVARCHAR(255)
clicks_user_id_hashed148The user ID (hashed) captured on the click eventVARCHAR(255)
user_time_of_week149Time of week in GPS weekly time during which the impression occurred using the user's timezone; internalINT4
bot_clicks150Set to 1 if a click is suspected to originate from bot trafficINT2
bid_time_utc151Time of bid request sent, in UTC timezoneTIMESTAMPYYYY-MM-DD HH24:MI:SS.MS in UTC
rx_timestamp_utc152Time of receipt of the Impression Event, in UTC timezoneTIMESTAMPYYYY-MM-DD HH24:MI:SS.MS in UTC
test_group_id153ID of the Test Group the user fell into within the test plan. Should match the Test Group assigned to the line itemINT4
experiment_user_index154Random number between 1-1000 assigned to a user. Used for test group assignmentINT4
test_plan_id155ID of the Test Plan associated with the campaignINT4
inventory_source_user_id156Unique consumer ID of the user, as defined by the exchange.VARCHAR(255)
mccmnc157Mobile carrier as defined by the concatenated MCC-MNC code.VARCHAR(255)
us_privacy158US 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)
geo_type159LocationType, how the geographic information was determinedVARCHAR(20)
video_placement160The placement of the video impression (e.g., In-Stream)VARCHAR(255)
publisher_name161Publisher Name as specified on the OpenRTB request.VARCHAR(255)
freq_cap_id_type162Comma-separated list of the ID types that were used to perform frequency capping for the impressionVARCHAR(255)
campaign_alt_id163Alternative ID in Buzz of the CampaignVARCHAR(255)
exchange_imp_id164The ID of the Impression that was won. Relevant for multi-impression auctions. Derived from OpenRTB's Impression ID object.VARCHAR(255)
ua165The Useragent of the impressionVARCHAR(255)
seller_id166The value of the corresponding seller in sellers.json files. Only populated when the exchange uses a different value for this than in Publisher ID.VARCHAR(255)
deal_bid_floors167Bid floor of the winning deal IDVARCHAR(255)
site_referrer168The referrer to the site the auction occurred on.VARCHAR(255)
bid_shade169The 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_shade_reduction_micros170Value the bid was shaded by in micros.INT8
video_mutes171Count of Video muted events.INT8
video_unmutes172Count of Video unmuted events.INT8
video_pauses173Count of Video pause events.INT8
video_resumes174Count of Video resume events.INT8
video_fullscreens175Count of Video fullscreen events.INT8
video_closes176Count of Video close events.INT8
impression_ip_address177The IP address of the impression; contrasted to ip_address, which derives its IP from the bid request.VARCHAR(255)
video_api178List of supported API frameworks for this impression.VARCHAR(255)
bid_shading_fee_type179The Bid Shading Fee Type for the Impression. Will be one of: N/A: No bid shading was used on the impression. VENDOR_FEE: The impression was using a CUSTOMER_BILLABLE seat and the bid shading fee will be charged as a vendor fee. INCLUDED_IN_WIN_PRICE: The impression was using a BEESWAX_BILLABLE seat and the bid shading fee will be added to the media spend.VARCHAR(255)
bid_shading_fee_micros_usd180The bid shading fee charged for the impression expressed in micros, in USD. 1 USD = 1,000,000 microsINT8
bid_shading_fee_micros181The bid shading fee charged for the impression expressed in micros, in local currency of the line item. 1 Unit of Currency = 1,000,000 microsINT8
require_native_video182If 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_consented183Whether the auction is regulated by GDPR AND the customer has been granted consent by the end user.INT2
targeted_lat_long_lists184The names of the lat/long lists specified that were targeted and matched on the given request.VARCHAR(255)
qag_media_rating185If defined, contains the QAG Media Rating of the content as defined by OpenRTB spec.VARCHAR(255)
media_spend_micros186The total cost of media for the impression expressed in micros in the the local currency of the line item. 1 Unit of Currency = 1,000,000 microsINT8
media_spend_micros_usd187The total cost of media for the impression expressed in micros in US dollars. 1 Unit of Currency = 1,000,000 microsINT8
guaranteed188Indicates whether a given line item is a guaranteed line item or not.INT2
creative_alt_id189If set, the alternative ID of the creative that won the auction will populate in this column.VARCHAR(255)
creative_name190The name of the creative as specified in Buzz.VARCHAR(255)
lat_long_list_item_ids191Comma-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 separated by a colon (:). e.g. buzz_key-10:9292VARCHAR(255)
lat_long_list_item_names192Comma-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)
click_rx_timestamp_utc193If a click was joinable to this impression, this column contains the timestamp of receipt of the event.TIMESTAMPYYY-MM-DD HH24:MI:SS.MS in UTC"
bcat194Blocked advertiser categories using the IAB content categories.VARCHAR(255)
platform_device_hwv195The hardware version as specified in the OpenRTB specificationVARCHAR(255)VARCHAR(255)
platform_device_language196Browser language using ISO-639-1-alpha-2 as specified in the OpenRTB specificationVARCHAR(255)VARCHAR(255)
platform_device_w197The physical device's width in pixels as specified in the OpenRTB specificationINT4
platform_device_h198The physical device's height in pixels as specified in the OpenRTB specificationINT4
platform_device_ppi199The device's screen size as express in pixels per inch, as specified in OpenRTB specificationINT4
platform_device_pxratio200The ratio of physical pixels to device independent pixels, as specified in OpenRTB specificationNUMERIC(18,6)
invalid_impression201Specifies whether an impression may be viewed as IVT contingent on vendor rules.INT2
is_invalid_measurable202Specifies whether an impression was measurable for IVT tracking purposes.INT2
invalid_automated_browser203Flags whether an IVT impression was viewed as originating from an automated browser.INT2
invalid_incongruous_browser204Flags whether an IVT impression was viewed as originating from an incongruous browser.INT2
invalid_data_center_traffic205Flags whether an IVT impression was viewed as originating from a data center.INT2
invalid_impression_vendor_name206The name of the vendor from which IVT fields were populated.VARCHAR(10)
experiment_id_type207The ID type used for segregation of impressions for AIDEM's experiment feature.VARCHAR(255)
deal_auction_type208If the impression was purchased via a deal, this logs the auction type for the deal. 1 = First Price, 2 = Second Price, 3 = Fixed Price. Overrides "auction_type
account_level_revenue_share_fee_type209If 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_micros210If using the account-level revenue share feature, this column populates the percentage of the rev share for the given impression in micros.INT8
account_level_revenue_share_micros_usd211As above, but populates the calcualted value of the rev share in USD as expressed in micros.INT8
account_level_revenue_share_micros212As above, but populates the calcualted value of the rev share in the local currency as expressed in micros.INT8
tmax213The required time in milliseconds for the bid to respond to the exchange to be considered in the auctionINT4
video_skippable214If the ad is a video ad, this field indicates whether the creative trafficked could have been skippable.INT2
is_skadnetwork215Flags whether the inventory is SKAdNetwork enabled.INT2
dnt216Do Not TrackINT4
lmt217Limit 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_format218Comma-separated list of banner formats (wxh) that are accepted by the publisherVARCHAR(255)
content_id219ID uniquely identifying the contentVARCHAR(255)
content_episode220Episode numberVARCHAR(255)
content_title221Content titleVARCHAR(255)
content_series222Content seriesVARCHAR(255)
content_season223Content seasonVARCHAR(255)
content_genre224Genre that best describes the contentVARCHAR(255)
content_contentrating225Content rating (e.g., MPAA)VARCHAR(255)
content_keywords226Comma separated list of keywords describing the contentVARCHAR(255)
content_livestream2270 = not live, 1 = content is live (e.g., stream, live blog)INT4
content_len228Length of content in seconds; appropriate for video or audioVARCHAR(255)
content_network_id229ID of the network the content is on. This may not be a unique identifier across all supply sourcesVARCHAR(255)
content_network_name230Network the content is on (e.g., a TV network like “ABC")VARCHAR(255)
content_network_domain231The primary domain of the network (e.g. “abc.com” in the case of the network ABC).VARCHAR(255)
content_channel_id232ID of the channel the content is on. This may not be a unique identifier across all supply sourcesVARCHAR(255)
content_channel_name233Channel the content is on (e.g., a local channel like “WABC-TV")VARCHAR(255)
content_channel_domain234The primary domain of the channel (e.g. “abc7ny.com” in the case of the local channel WABC-TV)VARCHAR(255)
content_cat235Array of IAB content categories that describe the contentVARCHAR(255)