...
Column Name | Data Type | Description | URL Parameter Name | Version | Impression | Pixel | Click | User ID Sync | Interaction (example of output) |
|---|---|---|---|---|---|---|---|---|---|
| timestamp | string | YYYY-MM-DD HH:MM:SS in UTC | 1 | 2013-28-11 11:11:11 | 2013-28-11 11:11:11 | 2013-28-11 11:11:11 | 2013-28-11 11:11:11 | 2013-28-11 11:11:11 | |
| date | string | YYYY-MM-DD | 1 | 2013-28-11 | 2013-28-11 | 2013-28-11 | 2013-28-11 | 2013-28-11 | |
| time | string | HH:MM:SS | 1 | 11:11:11 | 11:11:!1 | 11:11:11 | 11:11:11 | 11:11:11 | |
| datacenter | string | The name of the data center the collector is in. | 1 | eu-west1 | eu-west1 | eu-west1 | eu-west1 | eu-west1 | |
| collector_hostname | string | The hostname of the data collector. | 1 | ip-10-228-170-208 | ip-10-228-170-208 | ip-10-228-170-208 | ip-10-228-170-208 | ip-10-228-170-208 | |
| flxone_analysis_latency | int64 | The latency of processing all the required lookups from start to before disk flushing in nanoseconds. | 1 | 255325 | 255325 | 255325 | 255325 | 255325 | |
| flxone_customer_id | int | Customer ID of FLXone. | m | 1 | 123 | 123 | 123 | 123 | 123 |
| uuid | string | Random Unique User ID (128 bits). | uuid | 1 | f6f841f4-311b-4491-7b81-ea9b1848ecd0 | f6f841f4-311b-4491-7b81-ea9b1848ecd0 | f6f841f4-311b-4491-7b81-ea9b1848ecd0 | f6f841f4-311b-4491-7b81-ea9b1848ecd0 | f6f841f4-311b-4491-7b81-ea9b1848ecd0 |
| fingerprint | string | The hash capable of fingerprinting devices (32 bits) only available in js pixels, else it will be 0. | fp | 1 | 0767f74556fea9a2 | 0767f74556fea9a2 | 0767f74556fea9a2 | 0767f74556fea9a2 | 0767f74556fea9a2 |
| event_type | int | 1 = Impression 2 = Pixel 3 = Click 4 = User ID Sync 5 = Interaction 6 = Data Pass 7 = Classifier 8 = Audience Upload 9 = Delayed 10 = Passive interaction | 1 | 1 | 2 | 3 | 4 | 5 | |
| interaction_type | int | 0 = No Interaction 1 = Play 2 = Pause 3 = Finished 4 = Time Spent 5 = Swipe 6 = Ad Closed 7 = Ad Viewed 8 = Scroll 9 = Ad Hover 10 = Conversion 11 = Post View Conversion 12 = Form Field Focus 13 = Form Field Click 14 = Form Field Keydown 15 = User Defined Conversion 16 = Classifier Match 17 = Classifier Non-Match 18 = FLXone testing 19 = FLXone optimization 20 = Already uploaded 21 = Message read 22 = Sendout skip 23 = Message bounce 24 = Feedback 25 = Subscribe 26 = Unsubscribe 27 = Message forward 28 = Soundout response 29 = User identity write data 30 = User identity lookup 31 = User identity matched 32 = Contextual data request 33 = Enriched user ID sync 34 = Add to audience 35 = Audience not rule trigger 36 = Joined user ID sync 37 = Remove from audience 38 = Already removed 39 = Contact Registration Event - Mapp Engage 40 = Transaction Event 41 = Abandoned Cart Add Event 42 = Abandoned Cart Remove Event 43 = Contact Registration Event - Mapp Empower 44 45 = Wishlist Add Event 45 46 = Wishlist Remove Event | it | 1 | 0 | 0 | 0 | 0 | 4 |
| interaction_value | double | E.g. in case of video played, 20.0 (seconds). | iv | 1 | 0 | 0 | 0 | 0 | 20 |
| pixel_id | int | Pixel ID | id | 1 | 0 | 123 | 0 | 0 | 123 |
| user_ip | string | The user's Full IP address. | 1 | 46.243.26.30 | 46.243.26.30 | 46.243.26.30 | 46.243.26.30 | 46.243.26.30 | |
| user_ip_truncated | string | The user's IP address without the last octet. | 1 | 46.243.26.0 | 46.243.26.0 | 46.243.26.0 | 46.243.26.0 | 46.243.26.0 | |
| geo_country | string | Geo country in 3 characters conform ISO 3166-1 alpha-3. | _geo_c | 1 | NLD | NLD | NLD | NLD | NLD |
| geo_state | string | Geo state conform Maxmind Geo IP. | _geo_s | 1 | noord-brabant | noord-brabant | noord-brabant | noord-brabant | noord-brabant |
| geo_city | string | Geo city (e.g. New York City, London, Eindhoven) format in string, lowercase, utf8. | _geo_t | 1 | eindhoven | eindhoven | eindhoven | eindhoven | eindhoven |
| geo_postal_code | string | Postal code (e.g. 1234AB). | _geo_p | 1 | 1234AB | 1234AB | 1234AB | 1234AB | 1234AB |
| geo_dma_code | string | Designated market area code (e.g. 807). | _geo_d | 1 | 0 | 0 | 807 | 0 | 0 |
| geo_lat | double | Geo latitude. | lat | 1 | 4889364 | 4889364 | 4889364 | 4889364 | 4889364 |
| geo_long | double | Geo longitude. | lon | 1 | 233739 | 233739 | 233739 | 233739 | 233739 |
| browser | int | Browser mapped to integer. 0 = Unknown 1 = Chrome 2 = Internet Explorer 3 = Firefox 4 = Safari 5 = Opera 6 = 360se 7 = Sougou 8 = Tencent Traveler 9 = QQ Browser 10 = Maxthon 11 = Playstation | 1 | 1 | 1 | 1 | 1 | 1 | |
| browser_version | string | Full browser version (e.g. 31.0.1650.57). | 1 | 23 | 23 | 23 | 23 | 23 | |
| browser_language | string | Language (2 characters). | 1 | en | en | en | en | en | |
| browser_language_country | string | Language country (2 characters). | 1 | us | us | uk | us | us | |
| browser_datetime | string | YYYY-MM-DD HH:MM:SS | bdt | 1 | 4160631532 | 4160631532 | 4160631532 | 4160631532 | 4160631532 |
| browser_timezone_offset | int | Offset in minutes to UTC (both positive and negative values are valid). | btzo | 1 | 0 | 0 | 0 | 0 | 0 |
| browser_resolution_width | int | Pixel width of the browser. | bresw | 1 | 1024 | 1024 | 1024 | 1024 | 1024 |
| browser_resolution_height | int | Pixel height of the browser. | bresh | 1 | 768 | 768 | 768 | 768 | 768 |
| screen_resolution_width | int | Pixel width of the screen. | bsresw | 1 | 1920 | 1920 | 1920 | 1920 | 1920 |
| screen_resolution_height | int | Pixel height of the screen. | bsresh | 1 | 1080 | 1080 | 1080 | 1080 | 1080 |
| operating_system | int | Operating system mapped to integer. 0 = Unknown 1 = Linux 2 = Mac OS 3 = Windows 4 = Android 5 = iOS 6 = Windows Phone OS 7 = Playstation 8 = Symbian 9 = Blackberry 10 = WebOS | _os | 1 | 1 | 4 | 1 | 1 | 1 |
| operating_system_version | string | Full version of the operating system Windows 8 = 8 Android KitKat = 4.4 iOS 7 = 7 Etc. | _osv | 1 | 8 | 4.4 | 8.1 | 8 | 8 |
| device_type | int | 1 = Desktop 2 = Tablet 3 = Phone 4 = Smart TV 5 = Car | _devt | 1 | 1 | 3 | 1 | 1 | 1 |
| device_brand | string | E.g. Samsung, Windows, Apple, Dell, Blackberry, Huawei, etc. | _devb | 1 | 0 | samsung | Dell | 0 | 0 |
| device_model | string | E.g. Galaxy S4, iPhone 4S, 3310 | _devm | 1 | 0 | galaxy s4 | 0 | 0 | 0 |
| connection_type | int | 1 = Wired 2 = WiFi 3 = Mobile | _ct | 1 | 1 | 3 | 1 | 1 | 1 |
| connection_carrier | string | E.g. Vodafone, AT&T, Verizon, etc. | _car | 1 | ziggo | t-mobile | ziggo | at&t | at&t |
| referer_url | string | Full referer URL of the request, 0 if unknown. | 1 | http://www.thetimes.co.uk/tto/business/ | 0 | 0 | 0 | 0 | |
| event_referer_url | string | Page visited before event_url, must be populated through URL parameter. | r | 1 | http://www.thetimes.co.uk/ | http://www.thetimes.co.uk/ | http://www.thetimes.co.uk/ | http://www.thetimes.co.uk/ | http://www.thetimes.co.uk/ |
| event_url | string | URL of the current event, e.g. impression shown at http://www.thetimes.co.uk/tto/business/ | eurl | 1 | http://www.thetimes.co.uk/tto/business/industries/transport/article4144182.ece | rubicon.nl/ib?t=1234 | 0 | 0 | 0 |
| event_url_source | int | 1 = Detected 2 = Passed | 1 | 1 | 2 | 1 | 1 | 1 | |
| ad_position | int | 1 = Above The Fold 2 = Under The Fold | adp | 1 | 1 | 0 | 0 | 0 | 0 |
| ad_position_offset | int | Pixels offset until top of page. | adpos | 1 | 150 | 150 | 150 | 0 | 0 |
| page_height | int | Pixels height of page where the ad was served. | phegh | 1 | 4800 | 4800 | 4800 | 0 | 0 |
| site_domain | string | Extract hostname of the URL (order: event_url > referer_url). | 1 | http://www.thetimes.co.uk/ | http://www.thetimes.co.uk/ | 0 | 0 | 0 | |
| destination_url | string | In case of a click tracker, this is filled with the destination URL (e.g. landing page). | 1 | 0 | 0 | http://www.thetimes.co.uk/tto/business/industries/transport/article4144182.ece | 0 | 0 | |
| platform | int | 1= FLXone 2 = AppNexus 3 = Google 4 = Rubicon 5 = AdGear 6 = The Trade Desk 7 = Criteo 8 = MediaMath 9 = MailChimp 10 = HubSpot 11 = Google AdX 12 = Marketo 13 = Facebook 14 = Visual DNA 15 = PubMatic 16 = Adzerk 17 = SiteScout 18 = Sizmek 19 = BidTheatre 20 = AdForm | pl | 1 | 2 | 2 | 2 | 1 | 1 |
| platform_exchange | int | In case of buying from Google Adx through AppNexus this will contain the identifier for Google Adx. E.g. 1= FLXone 2 = AppNexus 3 = Google DBM 4 = Rubicon Project 5 = AdGear 6 = The Trade Desk | plx | 1 | 2 | 2 | 2 | 0 | 0 |
| auction_id | string | Platform auction ID | aid | 1 | 1.35887E+23 | 0 | 1.35887E+23 | 0 | 0 |
| buyer_id | string | Buyer ID. If the platform is FLXone, this will be the same as flxone_customer_id. In any other cases it will represent the external platform buyer member ID. | buyid | 1 | 1234 | 0 | 0 | 0 | 0 |
| seller_id | string | Seller ID. If the platform is FLXone, this will be the same as flxone_customer_id. In any other cases it will represent the external platform seller member ID. | selid | 1 | 4312 | 0 | 0 | 0 | 0 |
| publisher_id | string | Platform publisher ID | pubid | 1 | 12345 | 0 | 1a23s452 | 0 | 0 |
| site_id | string | Platform site ID (a unique identifier for a specific site, e.g. youtube.com, or "angry birds") | sitid | 1 | 12345 | 0 | 0 | 0 | 0 |
| site_type | int | 1 = Website 2 = App Etc. | sitt | 1 | 1 | 0 | 0 | 0 | 0 |
| advertiser_id | string | Platform Advertiser ID | advid | 1 | 12345 | 0 | 1a23s452 | 0 | 0 |
| placement_id | string | Platform Placement ID | plid | 1 | 98765434567 | 98765434567 | 987fsd654235aasd34567 | 0 | 0 |
| creative_id | string | Platform Creative ID | cid | 1 | 8765432 | 8765432 | 876asd25432 | 0 | 0 |
| campaign_id | string | Platform Campaign ID | cpid | 1 | 987245 | 987245 | 987245aa | 0 | 0 |
| lineitem_id | string | Platform Line Item ID | liid | 1 | 87543455 | 87543455 | 87asdf543455 | 0 | 0 |
| insertion_order_id | string | Platform Insertion Order ID | ioid | 1 | 123456 | 0 | 0 | 0 | 0 |
| estimated_clear_price | double | The Estimated Clear Price for this impression. | ecp | 1 | 0.76 | 0 | 0 | 0 | 0 |
| floor_price | double | Reserved price for this impression, below this price the impression will not be sold. | flp | 1 | 0.5 | 0 | 0 | 0 | 0 |
| floor_type | int | 0 = Unknown 1 = No Floor 2 = Hard Floor 3 = Soft Floor | flt | 1 | 1 | 0 | 0 | 0 | 0 |
| bid_price | double | Bid Price | bid | 1 | 0.6 | 0 | 0 | 0 | 0 |
| bid_spend | double | The actual spend for an impression, excluding fees. | bidclr | 1 | 0.51 | 0 | 0 | 0 | 0 |
| flxone_fees | double | Fees for usage of the FLXone DMP (if agreed upon by client and FLXone). | 1 | 0.01 | 0 | 0 | 0 | 0 | |
| auction_fees | double | Fees for auctions (either external, or FLXone), excluding the FLXone fees. | 1 | 0.05 | 0 | 0 | 0 | 0 | |
| data_fees | double | Data Provider fees. | dfees | 1 | 0.02 | 0 | 0 | 0 | 0 |
| additional_fees | double | Any additional fees. | afees | 1 | 0.0001 | 0 | 0 | 0 | 0 |
| currency | string | Currency code (e.g. USD, EUR, etc.). | curr | 1 | EUR | 0 | 0 | 0 | 0 |
| auction_result | int | The result of an impression, e.g. 1 = Sold 2 = Unsold Etc. | ares | 1 | 1 | 0 | 0 | 0 | 0 |
| audit_state | int | 1 = Audited 2 = External Platform Audit 3 = Sell Audit 4 = Not Audited | 1 | 1 | 0 | 0 | 0 | 0 | |
| creative_size | string | [width]x[height] (e.g. 300x250). | csiz | 1 | 300x250 | 0 | 300x250 | 0 | 0 |
| external_user_id | string | User ID of the external platform. | euid | 1 | 87543455 | 0 | 87543455 | 87543455 | 0 |
| external_data | string | JSON formatted key-values. | data | 1 | {"likes_us_on_facebook":"1"} | 0 | 0 | 0 | 0 |
| secondary_user_id | string | 3rd party user ID provider. | secid | 1 | 123456 | 123456 | 123456 | 123456 | 123456 |
| secondary_user_id_confidence | double | Number between 0 and 1 in confidence. | seccon | 1 | 0.82 | 0.82 | 0.82 | 0.82 | 0.82 |
| device_id_google_adid | string | Google Ad ID | devid_g | 1 | AEBE52E7-03EE-455A-B3C4-E57283966239 | 0 | 0 | 0 | 0 |
| device_id_apple_ida | string | Apple Advertising identifier | devid_a | 1 | AEBE52E7-03EE-455A-B3C4-E57283966239 | 0 | 0 | 0 | 0 |
| device_id_odin | string | Odin identifier (sha1) | devid_o | 1 | 82a53f1222f8781a5063a773231d4a7ee41bdd6f | 0 | 0 | 0 | 0 |
| device_id_openudid | string | Open UDID identifier | devid_u | 1 | 68753A44-4D6F-1226-9C60-0050E4C00067 | 0 | 0 | 0 | 0 |
| device_id_sha1 | string | SHA-1 hash representing device. | idsha1 | 1 | 3da541559918a808c2402bba5012f6c60b27661c | 0 | 0 | 0 | 0 |
| device_id_md5 | string | MD5 hash representing device. | idmd5 | 1 | 81dc9bdb52d04dc20036dbd8313ed055 | 0 | 0 | 0 | 0 |
| artificial_traffic | int | Identifier for non-human traffic, for example pingdom, trend micro virus scanning, chinese click nets, etc. | 2 | 0 | 0 | 0 | 0 | 0 | |
| user_agent | string | Full user agent of the client. | 3 | 0 | 0 | 0 | Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36 | 0 | |
| external_pixel_id | string | External platform pixel ID | epx | 4 | 1234 | 1234 | 1234 | 1234 | 1234 |
| customer_uuid | string | Customer specific unique user ID | 4 | b260341c19ef9f1bafd80fcd67baaba51e7177e7 | b260341c19ef9f1bafd80fcd67baaba51e7177e7 | b260341c19ef9f1bafd80fcd67baaba51e7177e7 | b260341c19ef9f1bafd80fcd67baaba51e7177e7 | b260341c19ef9f1bafd80fcd67baaba51e7177e7 | |
| audience_id | int | ID of the audience (generated via FLXone) | _audid | 5 | 123 | 123 | 123 | 123 | 123 |
| server_side_fingerprint | string | Fingerprint generated server-side | 5 | 81dc9bdb52d04dc20036dbd8313ed055 | 81dc9bdb52d04dc20036dbd8313ed055 | 81dc9bdb52d04dc20036dbd8313ed055 | 81dc9bdb52d04dc20036dbd8313ed055 | 81dc9bdb52d04dc20036dbd8313ed055 | |
| interaction_user_defined_subtype | int | Subtype of "interaction_type" which can be defined by the user. | itu | 5 | 321 | 321 | 321 | 321 | 321 |
| user_ip_hostname | string | Hostname of the user_ip by reverse DNS lookup. | 5 | ip-80-113-22-2.ip.prioritytelecom.net. | ip-80-113-22-2.ip.prioritytelecom.net. | ip-80-113-22-2.ip.prioritytelecom.net. | ip-80-113-22-2.ip.prioritytelecom.net. | ip-80-113-22-2.ip.prioritytelecom.net. | |
...