buzz_key | 1 | AIDEM Buzz key, an identifier for client bidder instances | VARCHAR(255) | |
conversion_id | 2 | Unique ID for every conversion in the system; system set | VARCHAR(255) | |
ord | 3 | Random number used as a cachebuster to track multiple conversions. Set by client | VARCHAR(255) | |
order | 4 | The number of items purchased as part of the conversion. Set by client | VARCHAR(255) | |
rx_timestamp | 5 | Conversion receipt time in ET Timezone | TIMESTAMP | YYYY-MM-DD HH24:MI:SS.MS in ET |
tag_id | 6 | The Event ID for the conversion being reported. This is associated with an Event Name (specific conversion event) in the client bidder, and is set by the client | INT4 | |
user_id | 7 | Device ID for mobile, cookie for desktop. Will populate with cookie on a desktop OR an iOS/Android ID for mobile | VARCHAR(255) | |
value | 8 | The value assigned to the conversion. Set by client | VARCHAR(255) | |
auction_id | 9 | 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. | VARCHAR(255) | |
is_gdpr | 10 | When this field is set to true, AIDEM has determined that this request needs to comply with GDPR | INT2 | |
rx_timestamp_utc | 11 | Conversion receipt time in UTC Timezone | TIMESTAMP | YYYY-MM-DD HH24:MI:SS.MS in UTC |
postback_url | 12 | When the Conversion was sent to AIDEM via Postback, this field will populate the requested URL. | VARCHAR(1024) | |
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) | |
ip_address | 18 | IPv4 or IPv6 address | VARCHAR(255) | |