Behavioral Log File

Updated Daily, v1.0.0

Specifications

Release: Sep 1, 2023

Version: 1.0.0

Size: >500G parquet

Update Freq: Daily

Usage: This is a daily file of raw buyer intent, with buyer intent, with both B2B and B2C topic areas. The file contains 2-3 billion daily raw signals from publisher network tag fires and bidstream data. All records in the file have a hashed email and visited URL. UP_ID linkage is included, and bidstream data will have a IAB content category defined, as well.

Schema

FeatureDescriptionSample
up_idUniversal Person ID. This is a unique identifier assigned to a person, linking all business and consumer information to a single individual. The up_id, along with the company_id, are primary keys throughout the co-op data files.5x5-9871b1d8-f821- e603-eb8b-b98bb89c2dce
sha256_lc_hemThe most observed Sha256 lowercase Hashed EMail (HEM) for this person. Used for identity management and file matching.f660ab912ec121d1b1e9 28a0bb4bc61b15f5ad44 d5efdc4e1c92a25e99b8 e44a
bito_idBeeswax User ID.
page_urlThe URL of the page viewed (the event).https://exputer.com/guides/ best-ark-single-player-settings/
categoryAn array of the IAB content categories associated with the page_url, separated by a comma. Link is to the IAB content taxonomy.IAB8,IAB8_8,IAB9
ip_addressIPv4 or IPv6 IP Address.10.2.20.8
zipThe 5-digit zip code of the observed signal within the intent file.92101
latitudeThe latitude associated with the person's personal address.
longitudeThe longitude associated with the person's personal address.
countryThe ISO Alpha-3 country code of the observed intent signal.USA
event_timestampThe UNIX timestamp of the observed event.1632421268