Versions Compared

Key

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

...

Table Plus

Column

Type

Filter?

Example

Description

month

time

Yes

"2010-02"

The month of the auction.

day

time

Yes

"2010-02-01"

The day of the auction.

carrier_id

int

Yes

20

The ID of the carrier for the device on which the impression was served. To retrieve a complete list of carrier IDs and names, use the Carrier Service.

carrier_name

string

No

"Sprint - FR"

The name of the carrier for the device on which the impression was served.

carrier

string

No

"Sprint - FR (20)"

Deprecated (as of October 17, 2016).

device_type

string

Yes

"tablets"

The type of device on which the impression was served. Possible values are:

  • "desktops & laptops"
  • "tablets"
  • "mobile phones"
  • "tv"
  • "game consoles"
  • "set top box"
  • "media players"
  • "other devices"

connection_type

string

Yes

"Carrier-based"

The type of internet connection at the time of the impression. Possible values: "Carrier-based" or "Wifi or Static".

entity_member_id

int

Yes

123

If imp_type is 1 (Blank), 2 (PSA), 3 (Default Error), 4 (Default), 6 (Resold), or 8 (PSA Resulting from Default Error), the ID of the buying member; otherwise, the ID of the selling member.

buyer_member_id

int

Yes

123

The ID of the buying member. If the impression was not purchased, this field shows one of the following values: 229 = PSA, 0 = Blank, or 319 = Default.

buyer_member_name

string

No

"My Network"

The name of the buying member.

buyer_member

string

No

"My Network (123)"

Deprecated (as of October 17, 2016).

seller_member_id

int

Yes

456

The ID of the selling member.

seller_member_name

string

No

"That Seller"

The name of the selling member.

seller_member

string

No

"That Seller (456)"

Deprecated (as of October 17, 2016).

buyer_type

string

Yes

"Real Time"

The type of media purchased by the buyer member. Possible values: "Real Time" or "Direct".

seller_type

string

Yes

"Real Time"

The type of media sold by the seller member. Possible values: "Real Time" or "Direct".

advertiser_id

int

Yes

789

The ID of the advertiser. If the value is 0, either the impression was purchased by an external buyer or a default or PSA was shown.

advertiser_name

string

No

"Mobile Zombies"

The name of the advertiser.

advertiser

string

No

"Mobile Zombies (789)"

Deprecated (as of October 17, 2016).

advertiser_code

string

No

"MZB1010"

The custom code for the advertiser.

insertion_order_id

int

Yes

321

The ID of the insertion order.

insertion_order_name

string

No

"Mobile Insertion Order"

The name of the insertion order.

insertion_order

string

No

"Mobile Insertion Order (321)"

Deprecated (as of October 17, 2016).

insertion_order_code

string

No

"Mobile Insertion Order Code"

The custom code for the insertion order.

line_item_id

int

Yes

111

The ID of the line item.

line_item_name

string

No

"Mobile Line Item"

The name of the line item.

line_item

string

No

"Mobile Line Item (111)"

Deprecated (as of October 17, 2016).

line_item_code

string

No

"Mobile Line Item Code"

The custom code for the line item.

campaign_id

int

Yes

222

The ID of the campaign.

campaign_name

string

No

"Mobile Campaign"

The name of the campaign.

campaign

string

No

"Mobile Campaign (222)"

Deprecated (as of October 17, 2016).

campaign_code

string

No

"Mobile Campaign Code"

The custom code for the campaign.

split_idintYes342The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any arrays reports that contain campaigns, the split_id (if included) will be null.
split_namestringYes"Mobile Split 2"The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any arrays reports that contain campaigns, the split_name (if included) will be null.

pixel_id

int

Yes

3849

The ID of the conversion pixel.

media_type

string

Yes

"Banner"

The media type of the creative. Possible values: "Banner", "Pop", "Interstitial", "Video", "Text", "Expandable", or "Skin". To retrieve a complete list of media types, use the Media Type Service.

mediatype_id

int

Yes

1

The ID of the media type of the creative.

size

string

Yes

"728x90"

The size of the placement/creative served.

geo_country

string

Yes

"US"

The code for the country.

geo_country_name

string

No

"United States"

The name of the country.

payment_type

string

Yes

"com", "revshare"

The type of payment to a broker.

revenue_type

string

No

"CPA"

The basis on which the advertiser pays the member.

revenue_type_id

int

Yes

4

The ID of the revenue type. Possible values: -1 = No Payment, 0 = Flat CPM, 1 = Cost Plus CPM, 2 = Cost Plus Margin, 3 = CPC, 4 = CPA, 5 = Revshare, or 6 = Flat Fee, 7 = Variable CPM, 8 = Estimated CPM.

publisher

string

Yes

"AppSite (123)"

Deprecated (as of October 17, 2016).

publisher_code

string

No

"Publisher Code"

The custom code for the publisher.

pub_rule_name

string

No

"Publisher Rule Name"

The name of the publisher rule.

pub_rule

string

No

"Publisher Rule Name (555)"

Deprecated (as of October 17, 2016).

pub_rule_code

string

No

"AppSitePR123"

The custom code for the publisher rule.

bid_type

string

Yes

"Manual"

The optimization phase the node was in when it bid for the impression. Note that the term "give up" is appended to the bid types below if the valuation for that impression falls below the venue's "give up price". For more information, see Venues and Give Up (Customer login required). Allowed values:

  • "Manual": Applies when you are bidding with a CPM goal, whether it's Base, EAP, or ECP.
  • "Learn": Applies when you are bidding with optimization (CPA, CPC, or margin) and we do not yet have enough data to bid optimized.
  • "Optimized": Applies when you are bidding with optimization (CPA, CPC, or margin) and we have enough data to bid optimized.
  • "Unknown": The node was in an unknown optimization phase.
  • "Optimized give up"
  • "Learn give up"
  • "Manual give up"

imp_type_id

int

Yes

6

Include Page
_imp_type_id
_imp_type_id

imp_type

string

Yes

"Resold"

The type of impression. For possible values, see imp_type_id.

venue

string

Yes

"Venue Name"

The name of the cluster of domain, site, tag, and user country that AppNexus' optimization system uses to determine bid valuations. A campaign cannot targeted a venue explicitly.

...