Skip to end of metadata
Go to start of metadata

Standard Feed

The Log-Level Standard Feed provides data on your managed publishers' and/or your managed advertisers' transacted impressions and the resulting clicks and conversions. The feed contains one row per transacted impression, click, or conversion. If you use impression and clicktrackers, the feed will also contain one row per impression tracker or clicktracker event.

The AppNexus internal name for this feed is standard_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).

Data Visibility and "NULL" values

All columns are always included, but you can only see data about your own transacted impressions. The "Visibility" column tells you who sees a particular column in any given transaction (e.g., both buyers and sellers, just buyers, or just sellers). Columns that are not visible will be shown as "NULL."

"NULL" may be returned in cases when:

  • You are a buyer in the transaction but the field is a seller-related field (or vice versa).
  • The seller on the impression has visibility settings that hide the value of that field from buyers (assuming you are a buyer in this transaction).
  • The data is not available.

Recommended Precisions / Lengths of Data Types

In the Columns table below, some values in the Type column contain a recommended precision or length in parentheses. For example, string(100) means "this string is probably (but not guaranteed to be) less than or equal to 100 characters in length".

For integers, the sizes are described in the Integer Key section.

For numeric (floating point) data types, we recommend being able to accept a precision of (18,6), meaning that we expect there to be a maximum total of 18 digits: 12 to the left of the decimal point, and 6 to the right.

For string data types, the recommended length of the field varies depending on the field. See the table below.

These are Recommendations, not Guarantees

The data types are meant to be accurate as documented. However, the recommended precision or length for a given data type should not be read as a guarantee. For example, a string or numeric column's value may exceed the suggested length or precision listed on this page.

The recommendations are intended to help you build your system to ingest this data. You may need to do additional processing on the output of the Standard Feed to make it work with your particular integration.

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

Visibility

01

auction_id_64

bigint

The AppNexus unique auction identifier.

Both

02

date_time

timestamp

The time and date of impression in YYYY-MM-DD HH:MM:SS (UTC).

Both

03

user_tz_offset

tinyint

The time zone of user vs. UTC. Useful for daypart targeting.

Both

04

creative_width

smallint

The width of the creative.

Both

05

creative_height

smallint

The height of the creative.

Both

06

media_type

tinyint

The general display style of the creative, classified by media subtype. To map media subtype IDs to their names and parent media types, use the Media Subtype Service.

Both

07

fold_position

tinyint

The placement position relative to fold. Possible values:
0 = Unknown
1 = Above
2 = Below

Both

08

event_type

enum

Possible values:

  • imp = impression
  • click
  • pc_conv = Post-click conversion
  • pv_conv = Post-view conversion

Both

09

imp_type

tinyint

The type of impression. Possible values:
1 = Blank: "200 OK" response (blank) served.
2 = PSA: A public service announcement served because no other creative was eligible.
3 = Default Error: A default creative served due to timeout issue.
4 = Default: A default creative served because no campaigns bid or no other creative was eligible.
5 = Kept: One of your managed advertisers served a creative.
6 = Resold: The impression was sold to a third-party buyer.
7 = RTB: Your creative served on third-party inventory.
8 = PSA Error: A public service announcement served due to timeout issue.
9 = External Impression: An impression from an impression tracker.
10 = External Click: A click from a click tracker.
11 = Insertion: Your creative served on third-party inventory where it persists across page-loads and sessions.

Both

10

payment_type

tinyint

The method by which the buyer is paying for the impression. Possible values:
-1 = No payment
0 = CPM
1 = CPC
2 = CPA
3 = Owner CPM
4 = Owner revshare

Both

11

media_cost_cpm

numeric(18,6)

For buyers, the amount (in USD) * 1000 that a network is paying for an impression . For sellers, the amount (in USD) * 1000 paid to publisher.

Both

12

revenue_type

tinyint

The method by which the buyer network gets paid by the advertiser, or how the method by which the seller network was paid by the buyer network. Possible values:
-1 = No payment
0 = Flat CPM
1 = Cost Plus CPM
2 = Cost Plus Margin
3 = CPC
4 = CPA
5 = Revshare
6 = Flat Fee
7 = Variable CPM (vcpm)
8 = Estimated CPM (est_cpm)

Both

13

media_cost

numeric(18,6)

The gross CPM amount (in USD) paid by the buyer (includes all deductions and price reductions).

Buyer

14

buyer_bid

numeric(18,6)

This column returns different values for buyers and for sellers measured in CPM (in USD).

  • For buyers, this is the raw value submitted to the auction prior to subtraction of fees, commissions, etc. It will be greater than or equal to the total amount paid by the buyer (buyer_spend).
  • For sellers, this value is the bid that was evaluated during the auction, after subtraction of fees, commissions, etc.
  • For managed transactions (imp_type = 5), buyer_bid will equal buyer_spend because bid and price reductions are not applied.

Both

15

ecp

numeric(18,6)

The estimated clear price for placement tag, in dollars unless another advertiser currency is specified.

Both

16

eap

numeric(18,6)

The estimated average price for placement tag, in dollars unless another advertiser currency is specified.

Both

17

is_imp

int

Possible values:
0 = False
1 = True

Both

18

is_learn

tinyint

Possible values:
0 = Base Bid
1 = Learn
2 = Optimized

Both

19

predict_type_rev

tinyint

The optimization phase of the bid. Possible values:
-2 = No predict phase
-1 = Base predict phase
0 = Learn giveup
1 = Learn
2 = Throttled
3 = Optimized
4 = Biased
5 = Optimized 1
8 = Optimized giveup
9 = Base bid below giveup

Both

20

user_id_64

bigint

The AppNexus 64-bit User ID stored in the AppNexus cookie store. This field is 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.

Both

21

ip_address

string(40)

The IP address of user.

Both

22

ip_address_trunc

string(40)

The IP address of user with the last octet removed.

Both

23

country

string(2)

The geographic country of the impression passed in on the ad call. Uses ISO 3166 country codes.

Both
24

region

string(2)

The geographic region of the impression passed in on the ad call. Uses ISO-3166-2 codes for US and Canadian regions, and FIPS codes for regions in all other countries.

Both

25

operating_system

tinyint

The ID of operating system version. To map operating system version IDs to names, use the Operating System Extended Service.

Both

26

browser

tinyint

The ID of the browser. To map browser IDs to names, use the Browser Service.

Both

27

language

tinyint

The ID of the language. To map language IDs to names, use the Language Service.

Both

28

venue_id

int

The venue is a combination of domain, site, tag, and user country which AppNexus' optimization system uses to determine bid valuations.

Both

29

seller_member_id

int

The member ID of the seller.

Seller

30

publisher_id

int

The ID for the publisher of the placement. Buyer member may map the Publisher ID to a name using the Inventory Resold Service if the seller has chosen to expose the publisher. Exposure to buyer depends on the seller's visibility profile.

Both

31

site_id

int

The ID for site associated with placement. Cannot be associated with a name, except by the seller member who owns the site. Exposure to buyer depends on the seller's visibility profile.

Seller

32

site_domain

string(100)

The most granular identifier of the site that we can offer (This may be the domain of a supply partner, ex: doubleclick.com; network who owns resold inventory; or it may just say resold inventory). Exposure to buyer depends on the seller's visibility profile.

Both

33

tag_id

int

The ID of placement tag of the impression. Cannot be associated with a name, except by the seller member who owns the tag. Exposure to buyer depends on the seller's visibility profile.

Both

34

external_inv_id

int

An optional code passed in the query string to further break out inventory. For more details, see External Inventory Code Service.

Seller

35

reserve_price

numeric(18,6)

The reserve price for the placement (in USD), if any.

Seller

36

seller_revenue_cpm

numeric(18,6)

The amount (in USD) the seller is paid for the impression. When revenue_type is 3 (CPC) or 4 (CPA), revenue will appear in this field on the corresponding click or conversion row (as determined by event_type). The revenue value will still be in CPM, so to calculate the revenue for the specific click/conversion event, divide by 1000.

This field is also calculated for imp_type = 5 (managed impressions). If you wish to calculate total revenue from resold impressions, sum seller_revenue_cpm only for imp_type = 6.

Seller

37

media_buy_rev_share_pct

numeric(18,6)

The publisher revenue share or the percent of booked revenue the seller shares with its publisher. This is a fraction between 0 and 1. If you multiply by 100 you get the percentage value.

Seller

38

pub_rule_id

int

The ID for the publisher rule, which is set up in the UI and defines how the publisher is paid.

Seller

39

seller_currency

string(3)

The currency used by the seller.

Seller

40

publisher_currency

string(3)

The currency in which publisher is paid.

Seller

41

publisher_exchange_rate

numeric(18,6)

The exchange rate (publisher currency: USD) on the day of the transaction.

Seller

42

serving_fees_cpm

numeric(18,6)

The serving fees in addition to media costs to when serving an ad (in USD).

Buyer

43

serving_fees_revshare

numeric(18,6)

The revenue share in addition to media costs when serving an ad (in USD).

Buyer

44

buyer_member_id

int

The member ID of the buyer. Possible values:
1 = Blank. The buyer_member_id and creative_id is 0.
2 = PSA. The AppNexus PSA member_id displays.
3 or 4 = Default Error or Default. The seller_member_id displays.

Buyer

45

advertiser_id

int

The ID of the advertiser.

Buyer

46

brand_id

int

The ID for brand of the creative.

Both

47

advertiser_frequency

int

The advertiser-level frequency (times they have seen an ad by this advertiser).

Buyer

48

advertiser_recency

int

The advertiser-level recency in minutes (how long it has been since the user saw an ad from this advertiser).

Buyer

49

insertion_order_id

int

The ID for insertion order if used.

Buyer

50

line_item_id

int

The identifier of line item.

Buyer

51

campaign_id

int

The ID of the campaign.

Buyer

52

creative_id

int

The ID of the creative served.

Both

53

creative_freq

int

The creative-level frequency (times the user has seen this creative by this advertiser).

Buyer

54

creative_rec

int

The creative-level recency in minutes (how long it has been since the user has seen this creative ad).

Buyer

55

cadence_modifier

numeric(18,6)

The cadence modifier for the impression, which is the number by which the bid was multiplied.

Buyer

56

can_convert

tinyint

If impression has conversion pixels associated or not.

Buyer

57

user_group_id

int

Used if advertiser separates users into groups for purposes of A/B testing

Buyer

58

is_control

tinyint

Whether the creative served is a control creative.

  • 0 = test impression
  • 1 = control impression
  • 2 = no cookie user. (AppNexus does not include no cookie users to avoid skewing the size of test and control groups).

Buyer

59

control_pct

numeric(18,6)

The percentage of impressions that are control. This is set by the network.

Buyer

60

control_creative_id

int

The ID of the control creative, if a control creative is served.

Buyer

61

is_click

int

Indicates if the creative was clicked. Possible values:
0 = False
1 = True
NULL = No information available

Buyer

62

pixel_id

int

The ID of conversion pixel.

Buyer

63

is_remarketing

tinyint

Used to indicate that a new segment pixel is remarketing or not.

Buyer

64

post_click_conv

int

Used to identify a row that is a post click conversion. This has a maximum value of 1.

Buyer

65

post_view_conv

int

Used to identify a row that is a post view conversion. This has a maximum value of 1.

Buyer

66

post_click_revenue

numeric(18,6)

The advertiser post click revenue (in USD).

Buyer

67

post_view_revenue

numeric(18,6)

The advertiser post view revenue (in USD).

Buyer

68order_id

string(36)

An optional value passed in by buyer on conversion pixel using the order_id parameter. For more details, see Conversion Pixels Advanced (Customer login required).

Buyer

69

external_data

string(30)

An optional extra data passed in by buyer on conversion pixel using the other parameter. For more details, see Conversion Pixels Advanced (Customer login required).

Buyer

70

pricing_type

string(3)

The line item pricing type, or how the buyer network gets paid by the advertiser (e.g. cpm, cpc).

Buyer

71

booked_revenue

numeric(18,6)

The amount (in USD) earned by network on impression.

Buyer

72

booked_revenue_adv_curr

numeric(18,6)

The same amount as booked revenue dollars, but displayed in that advertiser currency. For example, if your advertiser pays in Euros you can see this here. Use the advertiser_currency field to look up the advertiser's currency.

Buyer

73

commission_cpm

numeric(18,6)

Commission (in USD) if used in the UI or API.

Buyer

74

commission_revshare

numeric(18,6)

Commission (in USD) if used in the UI or API.

Buyer

75

auction_service_deduction

numeric(18,6)

The amount (in USD) deducted from the bid to pay for auction hosting.

Buyer

76

auction_service_fees

numeric(18,6)

The amount (in USD) charged charged for purchasing inventory from a publisher that AppNexus does not have a revshare agreement with.

Buyer

77

creative_overage_fees

numeric(18,6)

The amount (in USD) charged if the creative served is over our size (bandwith) limit, dollar amount.

Buyer

78clear_fees

numeric(18,6)

The amount (in USD) charged for facilitating the auction for the buyer.

Buyer

79

buyer_currency

string(3)

The currency used by the buyer.

Buyer

80

advertiser_currency

string

The currency used by advertiser.

Buyer

81

advertiser_exchange_rate

numeric(18,6)

The exchange rate on day of event. Rate is updated daily at 4 PM GMT. For any currency fields provided in the advertiser currency (i.e., fields with an "adv_curr" suffix), use this rate to convert the value into USD.

Buyer

82

latitude

string

The latitude of the user's location, when GPS data is available from a mobile device. Expressed in the format "snn.ddd,snn.ddd", for example +12.345 or -45.123, where south is represented as negative. There can be a maximum of 5 decimal places of precision.

Both

83longitude

string

The longitude of the user's location, when GPS data is available from a mobile device. Expressed in the format "snn.ddd,snn.ddd", for example +12.345 or -45.123, where west is represented as negative. There can be a maximum of 5 decimal places of precision.

Both

84device_unique_id

string

The unique identifier representing the mobile device. The numeric prefix indicates the type of unique device identifier:
0 = IDFA (Apple ID for Advertising)
1 = SHA1
2 = MD5
3 = ODIN
4 = OPENUDID
5 = AAID (Android Advertising ID)
6 = WINDOWSADID (Microsoft Advertising ID)

Both

85 device_id int

The model ID of the mobile device. To map model IDs to names, use the Device Model Service.

Both
86carrier_idint

The ID of the carrier associated with the mobile device. Top map carrier IDs to names, use the Carrier Service

Both
87deal_idintThe Deal ID associated with this impression.Both
88

view_result

enum

The AppNexus viewability measurement result of the impression. Possible values:
1 = VIEW_MEASURED_VIEWABLE
2 = VIEW_MEASURED_NON_VIEWABLE
3 = VIEW_NON_MEASURED

For more details about viewability, see Introduction to Viewability (Customer login required).

Both
89application_idstringThe ID of the mobile application (if applicable).Seller: Always
Buyer: If allowed by seller's visibility profile
90supply_typeenum

The type of supply. Possible values:
0 = WEB
1 = MOBILE_WEB
2 = MOBILE_APP
5 = TOOLBAR

Both
91sdk_versionstringThe version of the SDK (e.g., "3.3.0", "sdkandroid_4-0-9", "soma_ios_602").Both
92ozone_idintThe ID of the optimization zone.Seller
93billing_period_idint

The ID of the billing period under which the impression was served.

Buyer
94 view_non_measurable_reason int

The reason an impression could not be measured for viewability. Possible values:
0 = N/A. The impression was measured for viewability
1 = SCRIPT_NOT_SERVED. The viewability script was not served with the creative. For example, on mobile-app inventory.
2 = NO_SCRIPT_CALLBACK. The viewability script was served with the creative, but no callback/event was received. For example, the user left the page before the creative was served.
3 = TECHNICAL_LIMITATION. The viewability script was served and loaded, but was unable to measure for a technical reason. For example, a cross-domain iframe with Flash disabled.

For more information regarding viewability, see Introduction to Viewability (Customer login required).

Both
95external_uidstring(100)Specifies the external auction ID for this impression, passed in on the ad call by the seller.Seller
96request_uuidstring(36)

Specifies a unique identifier for the request. For single tag requests (such as /ttj), this is the same as auction_id_64. For multitag requests (such as with AST or some OpenRTB integrations), represents all of the auction_id_64 values.

Both
97dmaintSpecifies the ID of the designated market area for this impression. Use the Designated Market Area Service to look up the area associated with the ID.Both
98cityintThe ID of the city for this impression. Use the City Service to look up the city associated with the ID.Both
99mobile_app_instance_idintSpecifies the ID of the mobile app instance for this impression. Use the Mobile App Instance Service to look up the mobile app instance associated with the ID.Both
100traffic_source_codestring(100)

Specifies the external source of the third party traffic for this impression.

Seller
101external_request_idstring(100)Specifies the seller's own version of request_uuid or auction_id_64 that ties the impression back to their own data feeds.Seller
102deal_typeint

Specifies the type of deal:

  • 1 = open auction
  • 2 = private auction
Both
103ym_floor_idintThe ID of the yield management floor that was applied to the buyer. Use the Yield Management Floor Service to look up the floor associated with the ID.Seller
104ym_bias_idintThe ID of the yield management bias that was applied to the buyer. Use the Yield Management Bias Service to look up the bias associated with the ID.Seller
105
is_filtered_request
int

Specifies whether or not the event was filtered for Inventory Quality reasons
0 = event was not filtered
1 = event was filtered

Seller
106
age
intThe age of the user, if knownBoth
107
gender
string(1)The gender of the user, if known. Possible values are u, m, and f.Both
108
is_exclusive
intSpecifies which types of bids were eligible to win the auction
0 = Both managed and non-managed bids were eligible to win
1 = Only managed bids were eligible to win
Seller
109bid_priorityintSpecifies the campaign or line item's priority from the bidder only when imp_type = 5 (managed impressions). For all other imp_type values, defaults to 0.Seller
110custom_model_idintThe id of the custom model used in the auction. When no custom model is used, this defaults to 0.Buyer
111custom_model_last_modifiedintThe date and time (in Unix Epoch time) since the custom model that was used in the auction was last modified. If no model was used, this defaults to 0.Buyer
112custom_model_leaf_namestringThe leaf_name specified in the leaf that determined the winning bid. If no name is specified, or if a model was not used, this defaults to ---.Buyer
113data_costsnumeric(18,6)Total data costs (in USD) the buyer paid for the given impression.Buyer
114device_typeint

The type of device. Possible values are:

  • 0 = Unknown
  • 1 = PC
  • 2 = Phone
  • 3 = Tablet
  • 4 = TV
  • 5 = Game Console
  • 6 = Media Player
  • 7 = STB
Buyer
115postal_codestringThe postal code of the user's location. For postal codes, see Postal Code Service.Both
116
imps_for_budget_caps_pacing
intThe total number of impressions from the master creative in page-level roadblocking.Buyer