Skip to end of metadata
Go to start of metadata

Segment Feed

The Log-Level Segment Feed gives you data on the segment pixel loads for all of your network- and advertiser-level segments. Information about your 3rd-party data providers' pixels are not included. The feed contains one row per segment load. Additions (or re-additions) of a user to a segment are included, but removals of a user from a segment are not included in this feed.

The AppNexus internal name for this feed is segment_feed.

On This Page

Sequence

The columns below are listed in the same order in which they appear in the log-level feed file (top to bottom here, left to right in the file).

Integer Key

  • tinyint = 1 byte (8 bit)
  • smallint = 2 byte (16 bit)
  • int = 4 byte (32 bit)
  • bigint = 8 byte (64 bit)

Columns

Column Index

Column Name

Type

Description

1

date_time

UNIX Epoch time

The date and time when the segment pixel fired (e.g., 1526057561 which would need to be translated to Friday, May 11, 2018 4:52:41 PM (UTC)).

2

user_id_64

bigint

The AppNexus 64-bit user ID stored in the AppNexus cookie store. This field will be 0 when AppNexus does not have a match for this user or the user's browser doesn't accept cookies. It will be -1 for opt-out users.

3

member_id

int

The ID of the member that dropped the pixel.

4

segment_id

int

The ID of the segment pixel.

5

is_daily_unique

tinyint

Whether or not the pixel fire is the first for a given user that day.

6

is_monthly_unique

tinyint

Whether or not the pixel fire is the first for a user in the past 30 days.

7

value

int

Optional value passed with pixel.