Conversion Log Fields

Conversion Logs Schema

Name	Type	Is Nullable	Description
request	record	false
request.datetime	string	false
bid_context_wrapper	record	false
bid_context_wrapper.bid	record	false
bid_context_wrapper.bid.id	string	false	The unique bid request ID, generated by the client
bid_context_wrapper.bid.time	integer	false	The bid event timestamp: seconds since epoch
bid_context_wrapper.bid.datetime	string	false	The bid event timestamp, YYYY-MM-DD HH:MM:SS
bid_context_wrapper.bid.ssp	string	false	Supplier identification string, e.g. rubicon
bid_context_wrapper.user	record	false
bid_context_wrapper.user.ip	string	false	Specifies the IPv4 address closest to the device, string 0.0.0.0 is used if unknown
bid_context_wrapper.user.languages	array of strings	false	The Alpha-2/ISO 639-1 code of browser language, e.g. en. Either an empty array or an array containing one value
bid_context_wrapper.user.segments	array of strings	false	A list of pixel segments associated with the user ID
bid_context_wrapper.user.audience_segments	array of strings	false	A list of audience segments associated with the user ID
bid_context_wrapper.user.gender	string	true	Specifies the user gender, e.g. F
bid_context_wrapper.user.yob	integer	true	The year of the user’s birth as a 4-digit integer, e.g. 1977
bid_context_wrapper.user.ifa	string	true	The native identifier for advertisers. An ID assigned by the device or browser for use as an advertising identifier, for example Apple’s IDFA or Android’s Advertising ID
bid_context_wrapper.user.lat	float	true	Latitude from -90 to 90 (South is negative), e.g. 52.35
bid_context_wrapper.user.lon	float	true	Longitude from -180 to 180 (West is negative), e.g. 4.9167
bid_context_wrapper.user.carrier	string	true	A carrier or an ISP derived from the IP address, e.g. WIFI
bid_context_wrapper.user.connectiontype	string	true	A connection type value, one of the following: Unknown, Ethernet, WIFI, Cellular Network - Unknown Generation, Cellular Network - 2G, Cellular Network - 3G, Cellular Network - 4G
bid_context_wrapper.user.dnt	integer	true	Do not track. 1 - true, 0 - false
bid_context_wrapper.user.mccmnc	string	true	A mobile carrier as the concatenated MCC-MNC code, e.g. 310-005
bid_context_wrapper.user.ec_geo	record	false
bid_context_wrapper.user.ec_geo.country	string	false	The ISO code of the country matching the user’s IPv4 address, e.g. GB
bid_context_wrapper.user.ec_geo.region	string	false	The ISO code of the first subdivision of the address matching user’s IPv4 address, e.g. ENG
bid_context_wrapper.user.ec_geo.subregion	string	true	The ISO code of the second subdivision of address matching user’s IPv4 address, e.g. ‘LND’, an empty string if not applicable
bid_context_wrapper.user.ec_geo.city	string	false	The name of the city (in English) matching the user’s IPv4 address, e.g. London
bid_context_wrapper.user.ec_geo.dma	integer	false	The metro code of the address matching the user’s IPv4 address, e.g. 803
bid_context_wrapper.user.ec_geo.zip	string	false	The postal code of the address matching the user’s IPv4 address, e.g. 92509
bid_context_wrapper.user.ec_geo.country_region	string	false	Concatenation of the country, the first subdivsion and the second subdivision of the address, e.g. GB-ENG-LND
bid_context_wrapper.user.ec_geo.geo_isp	string	true	The Internet Service Provider associated with the user’s IPv4 address, e.g. Spectrum
bid_context_wrapper.user.ec_geo.digital_element_country	string	false	The two letter code of the country matching the user’s IPv4 address, e.g. UK
bid_context_wrapper.user.ec_geo.digital_element_region	string	false	The ISO code of the region of the address matching the user’s IPv4 address, e.g. LND
bid_context_wrapper.user.ec_geo.digital_element_city	string	false	The name of the city (in English) matching the user’s IPv4 address, e.g. London
bid_context_wrapper.user.ec_geo.digital_element_postal_code	string	false	The postal code of the address matching the user’s IPv4 address
bid_context_wrapper.user.ec_geo.digital_element_postal_ext	string	false	The postal code ext of the address matching the user’s IPv4 address
bid_context_wrapper.user.ec_geo.digital_element_country_region	string	false	Concatenation of the country and region of the address, e.g. ‘UK-LND’
bid_context_wrapper.user.ec_agent	record	false
bid_context_wrapper.user.ec_agent.device	record	false
bid_context_wrapper.user.ec_agent.device.type	string	false	The device type associated with the device’s user agent string
bid_context_wrapper.user.ec_agent.device.maker	string	false	The device maker associated with the device’s user agent string
bid_context_wrapper.user.ec_agent.device.model	string	false	The device model associated with the device’s user agent string
bid_context_wrapper.user.ec_agent.os	record	false
bid_context_wrapper.user.ec_agent.os.name	string	false	The operating system name associated with the device’s user agent string
bid_context_wrapper.user.ec_agent.os.version	string	false	The operating system version associated with the device’s user agent string
bid_context_wrapper.user.ec_agent.browser	record	false
bid_context_wrapper.user.ec_agent.browser.name	string	false	browser name associated with device’s user agent string
bid_context_wrapper.user.ec_agent.browser.version	string	false	The browser version associated with the device’s user agent string
bid_context_wrapper.supply	record	false
bid_context_wrapper.supply.slot_id	string	false	The ID of the impression being shown, unique within the bid request, e.g. 1
bid_context_wrapper.supply.site_page	string	false	The URL of the site.page, e.g. dailymail.co.uk?kw=153a. This string is empty in in-app requests
bid_context_wrapper.supply.ec_site_domain	string	false	The host part of the URL from either the site.domain or the app.domain field of the request, e.g. aol.com
bid_context_wrapper.supply.ec_page_domain	string	false	The host part of the URL from the site.page, e.g. dailymail.co.uk. This string is empty in in-app requests
bid_context_wrapper.supply.publisher_id	string	false	An exchange specific identifier consisting of the Supplier exchange name, and the publisher ID attached with an underline, e.g. rubicon_25
bid_context_wrapper.supply.site_id	string	false	An exchange specific identifier consisting of the Supplier’s exchange name, and the target site ID (for website requests) or the application ID (for in-app requests) attached with an underline, e.g. rubicon_123
bid_context_wrapper.supply.topframe	string	false	Indicates if the banner is in the top frame as opposed to an iframe. 1 - true, 0 - false. An empty string means that topframe is not applicable
bid_context_wrapper.supply.visibility	string	false	Ad Position as defined in the OpenRTB protocol, one of the following: UNKNOWN, ABOVE_THE_FOLD, ABOVE_OR_BELOW_THE_FOLD, BELOW_THE_FOLD, HEADER, FOOTER, SIDEBAR, FULLSCREEN
bid_context_wrapper.supply.is_secure_request	boolean	false	Specifies if the page is SSL compliant: true if secure, false if insecure (false being the default value)
bid_context_wrapper.supply.blocked_adv_categories	array of strings	false	Blocked Advertiser Categories listed in the IAB taxonomy and extended with additional sensitive categories, e.g. IAB10-1, IAB25, BSW3. Creatives belonging to at least one of the listed categories are banned from bidding on the given request.
bid_context_wrapper.supply.is_app	integer	false	Indicates if the request has an app section. 1 - yes, 0 - no
bid_context_wrapper.supply.content_categories	array of strings	false	An array of IAB content categories for the impression or the publisher site (for in-app), e.g. IAB1, IAB2-3
bid_context_wrapper.supply.pub_categories	array of strings	false	An array of IAB content categories for the publisher, e.g. IAB1, IAB2-3
bid_context_wrapper.supply.s2s_call	boolean	false	Specifies the notification type(s) supported by the supplier: false for only browser (u2s) notifications, true for both browser and server-to-server (s2s) notifications
bid_context_wrapper.supply.requested_sizes	array of strings	false	An array of sizes (wxh) that may be used for bidding on banner creatives
bid_context_wrapper.supply.grapeshot_channels	array of strings	false	Grapeshot channels applicable to the bid request coming either from a site page or an app bundle, e.g. gs_entertain, gv_safe
bid_context_wrapper.supply.source_name	string	true	The site or the application name, e.g. Test application
bid_context_wrapper.supply.app_bundle	string	true	The application bundle or package name, e.g. com.example.mygame. This string is empty in website requests
bid_context_wrapper.supply.content_type	string	false	The creative type, either display (default), video or native (in case a video/native object is present in the request)
bid_context	record	false
bid_context.demand	record	false
bid_context.demand.client_id	integer	true	The numeric ID of the client for whom the request was intended
bid_context.demand.advertiser_id	integer	false	The numeric ID of the advertiser associated with the client and the creative
bid_context.demand.campaign_id	integer	false	The numeric ID of the campaign associated with the client and the creative
bid_context.demand.line_item_id	integer	false	The numeric ID of the line item associated with the client and the creative
bid_context.demand.creative_id	integer	false	The numeric id of the creative
bid_context.demand.strategy_id	integer	true	The ID of the optimization strategy used
bid_context.demand.can_track_clicks	boolean	false	The value of the ‘can_track_clicks’ creative field
bid_context.demand.creative_size	string	false	Concatenation of width, ‘x’ symbol and height creative fields, only ‘x’ with missing width and height
bid_context.demand.creative_viewability_vendors	array of strings	false	An array of viewability vendors
bid_context.demand.bid_amount	double	false	The bid amount value in the bid currency
bid_context.demand.deal_id	string	true	The deal ID, e.g. AA-1234
bid_context.demand.tag_type	string	false	Either iframe (default) or video (if a video object is present in the request)
user_request	record	false
user_request.user_id	string	true
user_request.ip	string	false	The user’s IPv4 address
user_request.useragent	string	false	The user’s browser user agent string
user_request.languages	array of strings	false
user_request.is_secure	boolean	true
uuid	string	true	The unique BidSwitch user ID; idfa or Android ID for in-app traffic
payout	record	false
payout.adv_payout	double	false
is_optimizing	boolean	true
pv_conv	integer	true
pc_conv	integer	true
install_conv	integer	true
landing_conv	integer	true
segments	array of strings	false

Conversion Logs Example

{
  payout:
  {
     adv_payout: 0.0
  }
  landing_conv: None
  pv_conv: None
  uuid: '629abc06-30f5-4204-882f-97aae562fb35'
  bid_context_wrapper:
  {
     bid:
     {
        datetime: '2021-01-28 20:48:02'
        id: 'a1511770-3f77-4227-bc00-98fde9be97a6'
        ssp: 'rmx'
        time: 1611866882
     }
     user:
     {
        ip: '174.45.24.13'
        segments:
        [
        ]
        lon: None
        yob: 0
        connectiontype: 'Unknown'
        mccmnc: None
        languages:
        [
           'en'
        ]
        dnt: None
        carrier: None
        ifa: None
        ec_agent:
        {
           device:
           {
              model: 'Samsung_Galaxy'
              type: 'Phone'
              maker: 'Samsung'
           }
           os:
           {
              version: 'Android_Other'
              name: 'Android'
           }
           browser:
           {
              version: 'Chrome_88'
              name: 'Chrome'
           }
        }
        gender: ''
        lat: None
        ec_geo:
        {
           dma: 764
           digital_element_postal_ext: '8522'
           digital_element_postal_code: '82716'
           zip: '82718'
           city: 'Gillette'
           country: 'US'
           region: 'WY'
           geo_isp: 'Spectrum'
           digital_element_city: 'gillette'
           subregion: ''
           digital_element_country: 'us'
           digital_element_region: 'wy'
           digital_element_country_region: 'us-wy'
           country_region: 'US-WY-'
        }
        audience_segments:
        [
        ]
     }
     supply:
     {
        s2s_call: True
        pub_categories:
        [
        ]
        site_page: ' https://www.site.com/foo/bar?utm_cource=foo&bar=foo'
        grapeshot_channels:
        [
        ]
        blocked_adv_categories:
        [
        ]
        site_id: 'rmx_3746631'
        visibility: 'ABOVE_THE_FOLD'
        ec_site_domain: ''
        requested_sizes:
        [
           '100x500003'
        ]
        content_categories:
        [
        ]
        is_app: 0
        slot_id: '1'
        content_type: 'display'
        ec_page_domain: ''
        topframe: ''
        source_name: None
        is_secure_request: False
        publisher_id: 'rmx_670915'
        app_bundle: None
     }
  }
  request:
  {
     datetime: '2021-01-28 20:48:02'
  }
  bid_context:
  {
     demand:
     {
        deal_id: None
        bid_amount: 0.00512
        creative_id: 500001
        campaign_id: 500002
        can_track_clicks: True
        creative_viewability_vendors:
        [
        ]
        advertiser_id: 500003
        client_id: 500000
        creative_size: '9125x23941'
        line_item_id: 500004
        strategy_id: 1
        tag_type: 'iframe'
     }
  }
  user_request:
  {
     languages:
     [
        'en'
     ]
     useragent: 'Mozilla/5.0'
     user_id: '629abc06-30f5-4204-882f-97aae562fb35'
     is_secure: False
     ip: '149.4.211.0'
  }
  is_optimizing: False
  install_conv: None
  segments:
  [
  ]
  pc_conv: 500003
}