Versions Compared

Key

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

...

Column

Type

Group?

Filter?

Example

Description

month

time

no

no

"2010-02"

The month of the auction.

day

time

yes

no

"2010-02-01"

The day of the auction.

buyer_member_id

int

yes

yes

643

The ID of the member that won the auction.

placement_id

int

no

yes

546

The ID of the placement.

placement_name

string

no

no

"300x250 Business"

The name of the placement.

placement

string

no

no

"300x250 Business (546)"

Deprecated (as of October 17, 2016).

publisher_id

int

yes

yes

6787

The ID of the publisher.

geo_country

string

yes

yes

"US"

The code of the geographical country.

geo_country_name

string

no

no

"United States"

The name of the geographical country.

imp_type

string

yes

yes

"Kept"

Deprecated (as of October 17, 2016).

imp_type_id

int

no

yes

1

Cache
refresh10s

creative_id

int

yes

yes

654

The ID of the creative.

site_id

int

yes

yes

555The ID of the site. For more information, see the Site Service.

site_name

string

no

no

"My Site"The name of the site. For more information, see the Site Service.

brand_id

int

yes

yes

3

The ID of the brand associated with a creative served on the publisher's inventory.

brand_name

string

no

no

"Ace Hardware"

The name of the brand associated with a creative served on the publisher's inventory.

brand

string

no

no

"Ace Hardware (3)"

Deprecated (as of October 17, 2016).

payment_type

string

yes

yes

"cpm"

The type of payment to the broker.

revenue_type

string

yes

no

"cpm"

The way the advertiser has agreed to pay you.

width

int

yes

yes

250

The width of the creative.

height

int

yes

yes

300

The height of the creative.

site

string

no

no

"My Site (555)"

Deprecated (as of October 17, 2016).

publisher_code

string

no

no

"My Publisher Code"

The custom code for the publisher.

site_code

string

no

no

"Site Name Code"

The custom code for the site.

placement_code

string

no

no

"Photos Code"

The custom code for the placement.

buyer_member_name

string

no

no

"Network"

The ID of the buying member.

buyer_member

string

no

no

"Network (567)"

Deprecated (as of October 17, 2016).

media_type

string

yes

yes

"Banner", "Pop", "Interstitial", "Video", "Text"

The general display style of a creative served on the publisher's inventory. You can use the Media Type Service to view the complete list of media types.

mediamediatype_type_id

int

no

yes

444The ID of the media type associated with the creative that was served. For more information, see the Media Type Service.

publisher_name

string

no

no

"LOL - US"

The name of the publisher on whose site the impression occurred.

publisher

string

no

yes

"LOL - US (44389)"

Deprecated (as of October 17, 2016).

deal_id

int

yes

yes

2345

The ID of the deal. For more information about deals you have negotiated with buyers, see Deal Service.

deal_name

string

nono"Private deal for buyer 1085 with floor of $2.50"

The name of the deal.

deal

string

no

no

"Private deal for buyer 1085 with floor of $2.50 (45)"

Deprecated (as of October 17, 2016).

deal_code

string

 

no

"Custom code"The custom code for the deal.

brand_offer_category_id

int

yes

yes

1256The ID of the brand offer category associated with the impression. See category_id in the Brand Service page.

brand_offer_category_name

string

no

no

"Luxury Cars"

The name of the brand offer category associated with the impression. See category_id in the Brand Service page.

creative_audit_status_id

int

no

yes

0

The ID of the audit status of the creative associated with the impression:

  • 0 = unaudited
  • 1 = seller audited only
  • 2 = appnexus audited

creative_audit_status

string

yes

no

"Unaudited"

The audit status of the creative associated with the impression:

  • "Unaudited"
  • "Self Audit Only"
  • "AppNexus Audited"
sizestringyesyes"728x90"The width and height of the creative associated with the impression.

...