Skip to end of metadata
Go to start of metadata

Network Device Analytics Report

The Network Device Analytics report enables you to retrieve buy-side and sell-side performance data based on devices where impressions were served. This is especially important for networks working with in-app advertisers who traffic creatives that encourage app installation and who therefore want confirmation that their creatives are targeting devices compatible with their apps. It also helps you answer the following questions:

  • How many impressions have you seen for specific device makes and models?
  • How many impressions have you seen for specific connection types (i.e., Wifi/Static or Carrier-based)?
  • How do certain types of devices perform relative to others (i.e., tablets vs. phones)?
  • How do certain makes and models of devices perform relative to others (i.e., Android vs. Apple)?
  • How do certain types of connections perform relative to others (i.e., Wifi/Static vs. Carrier-based)

Time Frame and Time Zone

All times are given in UTC. The report_interval field in the JSON request can be set to one of the following:

  • today
  • yesterday
  • last_2_days
  • last_7_days
  • last_14_days
  • last_30_days
  • month_to_date
  • month_to_yesterday

Alternately, the start_date and end_date fields can be set to a range within the last 14 months. However, since hourly data is not available for this report, the start_date and end_date cannot be identical and must be formatted as "YYYY-MM-DD" rather than "YYYY-MM-DD HH:MM:SS". The timezone field in the JSON request can be set only to "UTC", but this is not necessary, as the timezone defaults to "UTC" if not specified.

Data Retention Period

Data in this report is retained for 14 months.

Dimensions

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.

device_make_id

int

Yes

1

The ID of the device make on which the impression was served. The make is generally the manufacturer of the device (i.e., Apple). To retrieve a complete list of device make IDs and names, use the Device Make Service.

device_make_name

string

No

"4G Systems"

The name of the device make on which the impression was served. The make is generally the manufacturer of the device (i.e., Apple).

device_make

string

No

"4G Systems (1)"

Deprecated (as of October 17, 2016).

device_model_id

int

Yes

15

The ID of the device model on which the impression was served. The model is generally the specific product (i.e., iPhone). To retrieve a complete list of device model IDs and names, use the Device Model Service.

device_model_name

string

No

"DX650"

The name of the device model on which the impression was served. The model is generally the specific product (i.e., IPhone).

device_model

string

No

"DX650 (15)"

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".

operating_system_id

int

Yes

24

The ID of the operating system of the device.

operating_system_name

string

Yes

"Android 2.3.5 Gingerbread"

The name of the operating system of the device.

operating_system_family_idintYes2

The ID of the operating system family associated with the device the impression was served on.

operating_system_family_namestringYes"Android"

The name of the operating system family associated with the device the impression was served on.

browser_id

int

Yes

 

The ID of the browser in which the impression was served. To retrieve a complete list of browser IDs and names, use the Browser Service.

browser_name

string

Yes

 

The ID of the browser in which the impression was served.

browser

string

Yes

 

Deprecated (as of October 17, 2016).

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.

deal_namestringYes"My New Deal"The name of the deal associated with the transaction for the impression.
split_idintYes342The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_id (if included) will be null.
split_namestringYes"Mobile split A"The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_name (if included) will be null.
deal_idintYes123The ID of the deal associated with the transaction for the impression.

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

"cpm", "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_name

string

No

"AppSite"

The name of the publisher.

publisher

string

Yes

"AppSite (123)

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

publisher_code

string

No

"AS123"

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)"

The name of the publisher rule followed by the ID (AppNexus format).

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

The ID for the type of impression. Possible values (associated types in parentheses):
  • 1 ("Blank"): No creative served.
  • 2 ("PSA"): A public service announcement served because there were no valid bids and no default creative was available.
  • 3 ("Default Error"): A default creative served due to a timeout issue.
  • 4 ("Default"): A default creative served because there were no valid bids.
  • 5 ("Kept"): Your advertiser's creative served on your publisher's site.
  • 6 ("Resold"): Your publisher's impression was sold to a third-party buyer.
  • 7 ("RTB"): Your advertiser's creative served on third-party inventory.
  • 8 ("PSA Error"): A public service announcement served due to a timeout issue or lack of a default creative.
  • 9 ("External Impression"): An impression from an impression tracker.
  • 10 ("External Click"): A click from a click tracker.

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.

operating_system_family_idintYes2

The ID of the operating system family associated with the device the impression was served on.

operating_system_family_namestringYes"Android"

The name of the operating system family associated with the device the impression was served on.

Metrics

Column

Type

Example

Formula

Description

imps

int

2340

imps

The total number of impressions (served and resold).

imps_blank

int

3

imps_blank

The number of impressions served with a blank.

imps_psa

int

5

imps_psa

The number of impressions that served a PSA.

imps_default_error

int

0

imps_default_error

The number of impressions that defaulted due to a timeout issue.

imps_default_bidder

int

0

imps_default_bidder

The number of impressions that defaulted because there were no valid bids.

imps_kept

int

0

imps_kept

The number of impressions your advertiser purchased from your publisher .

imps_resold

int

0

imps_resold

The number of impressions your publisher sold to a third party .

imps_rtb

int

2332

imps_rtb

The number of impressions your advertiser bought from a third party .

clicks

int

1

clicks

The total number of clicks across all impressions.

click_thru_pct

double

1.12359550
561797%

(clicks / imps) x 100

The rate of clicks to impressions as a percentage.

ctr

double

0.00022187
7080097626

clicks / imps

The rate of clicks to impressions.

total_convs

int

1

total_convs

The total number of post-view and post-click conversions.

post_view_convs

int

15

post_view_convs

The total number of recorded post-view conversions.

post_click_convs

int

15

post_click_convs

The total number of recorded post-click conversions.

convs_per_mm

double

221.877080
097625

(total_convs / imps) x 1,000,000

The number of conversions per million impressions.

convs_rate

double

0.00022187
7080097626

total_convs / imps

The rate of conversions to impressions.

cost

money

16.833378

cost

The total amount of media cost for direct publisher and purchased third-party inventory.

cpm

money

1.66051685
393258

(cost / imps) x 1000

The media cost per 1000 impressions.

revenue

money

25.767257

booked_revenue + reseller_revenue

The total revenue booked through direct advertisers (line item) and direct publishers (resold impressions).

booked_revenue

money

25.767257

booked_revenue

The total revenue booked through direct advertisers (line item).

reseller_revenue

money

0

reseller_revenue

The total revenue on resold impressions through direct publishers.

rpm

money

2.60548314
606741

(revenue / imps) x 1000

The revenue per 1000 impressions.

profit

money

0.084102

revenue - cost

The total network revenue minus network cost.

ppm

money

0.94496629
2134831

(profit / imps) x 1000

The profit per 1000 impressions.

total_publisher_rpm

money

1.6605168
5393258

(cost / imps) x 1000

The cost per 1000 impressions paid to direct and third-party publishers, including errors.

sold_publisher_rpm

double

147.786

(cost / imps) x 1000 ----- no errors

The cost per 1000 impressions paid to direct and third-party publishers, not including errors.

sold_network_rpm

double

231.888

(revenue / imps) x 1000 ----- no errors

The revenue per 1000 impressions that were not errors.

Example

1. Create the JSON-formatted report request
2. POST the request to the Report Service
3. GET the report status from the Report Service
4. GET the report data from the Report Download Service

Related Topics