Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table Plus

Column

Type

Group?

Filter?

Description

month

time

Yes

No

Month.

day

date

Yes

Yes

Day.

hour

date

Yes

Yes

The hour of the auction.

Note
title

For impressions older than 100 days, the day will be returned rather than the hour.

year

date

Yes

Yes

Year.

buyer_member_id

int

Yes

Yes

The internal ID of the buying member.

buyer_member_name

string

No

No

The display name of the buying member.

buyer_member

string

No

No

Deprecated.

seller_member_id

int

Yes

Yes

The internal ID of the member.

seller_member_name

string

No

No

The display name of the seller member.

seller_member

string

No

No

Deprecated.

tag_id

int

Yes

No

The ID of the tag.

publisher_id

int

Yes

Yes

The internal ID of the publisher.

publisher_name

string

No

No

The display name of the publisher.

publisher

string

No

No

Deprecated.

size

string

No

No

The size of the creative.

geo_country

string

No

Yes

The display name of the country followed by the ID (AppNexus format).

geo_country_name

string

No

No

Country.

imp_type

string

No

Yes

The type of impression served. Possible values:

  • 1 = blank
  • 2 = PSA
  • 3 = default error
  • 4 = default
  • 5 = kept
  • 6 = resold
  • 7 = RTB
  • 8 = PSA resulting from a default error
  • 9 = external impression
  • 10 = external click

gender

string

No

Yes

The gender of the user.

site_id

int

Yes

Yes

The internal ID of the site.

site_name

string

No

No

The display name of the site.

site

string

No

No

Deprecated.

is_dw

boolean

No

Yes

If true, the impression was served by AppNexus.

bidder_id

int

Yes

Yes

The internal ID of the bidder.

bidder_name

string

No

No

The display name of the bidder.

bidder

string

No

No

Deprecated.

tag_name

string

No

No

The display name of the tag.

tag

string

No

No

Deprecated.

price_bucket_id

int

Yes

No

The ID of the price bucket. For more information about price buckets, see the description of the price_buckets field on the Member Service.

is_delivered

boolean

No

Yes

If true, the impression was served successfully.

cleared_direct

int

No

Yes

If this is set to 1, then the impression was successfully served on direct inventory. Possible values:

  • 0 = not direct inventory
  • 1 = direct inventory

seller_currency

string

No

Yes

The seller member's selected currency. For a list of supported currencies, see Supported Currencies.

supply_type

string

No

YesNo

The type of inventory. Possible values:

  • "web"
  • "mobile_web"
  • "mobile_app"

publisher_code

string

No

No

The custom code for the publisher, entered to correspond to the publisher code within the external system.

site_code

string

No

No

The custom code for the site, entered to correspond to the site code within the external system.

buyer_member_name

string

No

No

The display name of the buyer member.

buyer_member

string

No

No

The display name of the buying member followed by the ID (AppNexus format).

...