Skip to end of metadata
Go to start of metadata

Network Billing Report

This report has been deprecated. As a result, it should only be used for billing activity prior to October 1, 2015. For reports after October 1, 2015, consult the Buying Billing Report and the Selling Billing Report.

The Network Billing Analytics report can be used to view billing data across:

  • Direct advertiser impressions (bought across direct publishers and real-time inventory)
  • Direct publishers (sold across direct advertisers and other platform buyers)

For instructions on retrieving a report, please see Report Service.

For impressions older than 100 days, the Network Billing Report now returns default values in some columns:

  • Creatives are aggregated into one row with 0 as the creative_id and a generic creative_name.
  • Placements are aggregated into one row with -1 as the placement_id and a generic placement_name.
  • hour - Hourly data is aggregated into one row with 'YYYY-MM-DD 00:00:00' as the hour ('YYYY-MM-DD' is the UTC day in which the activity happened). This will make it look as though all activity happened at midnight. All daily data older than 100 days will be returned in the UTC time zone.
On This Page

Time Frame

The report_interval field in the JSON request can be set to one of the following:

  • current_hour
  • last_hour
  • today
  • yesterday
  • last_48_hours
  • last_2_days
  • last_7_days
  • last_30_days
  • month_to_date
  • month_to_yesterday
  • quarter_to_date
  • last_month
  • lifetime

To run a report for a custom time frame, set the start_date and end_date fields in your report request. For more details about these fields, see Report Service.

Dimensions

Column

Type

Group?

Filter?

Example

Description

entity_member_id

int

Yes

Yes

123

--

buyer_member_id

int

Yes

Yes

123

Internal ID of the buyer member

buyer_member_name

string

No

No

"My Network"

Display name of the buyer member

buyer_member

string

No

No

"My Network (123)"

Deprecated (as of October 17, 2016).

buyer_type

string

Yes

Yes

"Real Time", "Direct"

The type of buyer

buyer_currency

string

Yes

Yes

"USD"

The currency of the buyer.

seller_member_id

int

Yes

Yes

456

Internal ID of the seller member

seller_member_name

string

No

No

"That Seller"

Display name of the seller member

seller_member

string

No

No

"That Seller (456)"

Deprecated (as of October 17, 2016).

seller_type

string

Yes

Yes

"Real Time", "Direct"

The type of seller

insertion_order_idintYesYes451Internal ID of the insertion order
insertion_order_namestringNoNo"Q1-2014"Display name for the insertion order

campaign_id

int

Yes

Yes

728

Internal ID of the campaign

campaign_name

string

No

No

"Test"

Display name of the campaign

campaign

string

No

No

"Test (728)"

Deprecated (as of October 17, 2016).

creative_id

int

Yes

Yes

554

Internal ID of the creative. Note: For impressions older than 100 days, creatives are aggregated into one row with 0 as the creative_id. For external click or impression trackers, creative_id will be "External Clicks" or "External Imps".

creative_name

string

No

No

"Q1 2010 - 728x90"

Display name of the creative. Note: For impressions older than 100 days, creatives are aggregated into one row with a generic creative_name. For external click or impression trackers, creative_name will be "External Clicks" or "External Imps".

creative

 

string

No

No

"Q1 2010 - 728x90 (554)"

Deprecated (as of October 17, 2016).

placement_id

int

Yes

Yes

567

Internal ID of the placement. Note: For impressions older than 100 days, placements are aggregated into one row with -1 as the placement_id.

placement_name

string

No

No

"Photos 728x90"

Display name of the placement. Note: For impressions older than 100 days, placements are aggregated into one row with a generic placement_name.

placement

string

No

No

"Photos 728x90 (567)"

Deprecated (as of October 17, 2016).

imp_type_id

int

Yes

Yes

1

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

Yes

"Blank"

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

revenue_type

string

Yes

Yes

"CPA"

The basis on which the member gets paid.

revenue_type_id

int

Yes

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.

payment_type

string

Yes

Yes

"com", "revshare"

The type of payment to a broker.

cleared_direct

int

Yes

Yes

0, 1

Whether or not the buyer pays the seller directly for the cost of media. If 0, AppNexus collects the cost of media from the buyer and pays the seller. If 1, the buyer pays the seller directly for the cost of media. Tip: Buyers can match the cost of media on their invoice by filtering out "cleared direct" transactions.

hour

time

Yes

No

"2010-02-01 06:00:00"

The hour of the impression. Note: For impressions older than 100 days, hourly data is aggregated into one row with 'YYYY-MM-DD 00:00:00' as the hour ('YYYY-MM-DD' is the UTC day in which the activity happened). This will make it look as though all activity happened at midnight. All daily data older than 100 days is returned in the UTC time zone.

day

time

Yes

No

"2010-02-01"

The day of the impression.

month

time

Yes

No

"2010-02"

The month of the impression.

advertiser_id

int

No

Yes

789

Internal ID of the advertiser

advertiser_name

string

No

No

"Verizon"

Display name of the advertiser

advertiser

 

string

No

No

"Verizon (789)"

Deprecated (as of October 17, 2016).

advertiser_currency

string

Yes

Yes

"USD"

The currency of the advertiser.

line_item_id

int

No

Yes

932

Internal ID of the line item

line_item_name

string

No

No

"$3 CPM Verizon Remarketing"

Display name of the line item

line_item

 

string

No

No

"$3 CPM Verizon Remarketing (932)"

Deprecated (as of October 17, 2016).

publisher_id

int

No

Yes

123

Internal ID of the publisher

publisher_name

string

No

No

"Microsoft"

Display name of the publisher

publisher

string

No

No

"Microsoft (123)"

Deprecated (as of October 17, 2016).

publisher_currency

string

"USD"

Yes

Yes

The currency of the publisher.

salesperson_for_advertiser

string

Yes

Yes

"Ray Parcino"

The salesperson for the advertiser. See the "labels" field in the Advertiser Service for more details.

salesperson_for_publisher

string

Yes

Yes

"Brian Young"

The salesperson for the publisher. See the "labels" field in the Publisher Service for more details.

account_manager_for_advertiser

string

Yes

Yes

"Rachel Dina"

The account manager for the advertiser. See the "labels" field in the Advertiser Service for more details.

account_manager_for_publisher

string

Yes

Yes

"Ami Fisher"

The account manager for the publisher. See the "labels" field in the Publisher Service for more details.

trafficker_for_line_item

string

Yes

Yes

"Maurice Truman"

The trafficker for the line item. See the "labels" field in the Line Item Service for more details.

salesrep_for_line_item

string

Yes

Yes

"Beverly Heller"

The sales rep for the line item. See the "labels" field in the Line Item Service for more details.

Metrics

Column

Type

Example

Formula

Description

imps

int

234123

imps

Total number of impressions

clicks

int

545

clicks

Total number of clicks across all impressions

convs

int

205

total_convs

Total number of conversions across all impressions

media_cost

money

304.36

media_cost

The total cost of the inventory purchased.

media_cost_pub_curr

money

201.34

media_cost_pub_curr

The total cost of the inventory purchased, in the currency of the publisher.

media_cost_adv_curr

money

201.34

media_cost_adv_curr

The total cost of the inventory purchased, in the currency of the advertiser.

Note: If you are not tracking revenue through AppNexus, this will be 0.

net_media_costmoney211.23media_cost - auction_service_deductionThe total cost of inventory purchased, less the buyer's auction service charge deductions.
net_media_cost_adv_currmoney211.23media_cost_adv_curr - auction_service_deduction_adv_curr

The total cost of inventory purchased, less the buyer's auction service charge deductions, in the currency of the advertiser.

Note: If you are not tracking revenue through AppNexus, this will be 0 .

ecpm

money

1.30

(spend / imps) x 1000

Amount of money spent per 1000 impressions.

ecpm_pub_curr

money

1.30

(spend / imps) x 1000

Amount of money spent per 1000 impressions, in the currency of the publisher.

ctr

double

0.002327

clicks / imps

The rate of clicks to impressions

convs_rate

double

0.000856

total_convs / imps

The rate of conversions to impressions

network_revenue

money

1201.13

network_revenue

Network revenue booked through direct advertisers and resold to real-time buyers

booked_revenue

money

1201.13

booked_revenue

Network revenue booked through direct advertisers.

booked_revenue_adv_curr

money

970.24

booked_revenue_adv_curr

Network revenue booked through direct advertisers, in the currency of the advertiser.

network_profit

money

801.08

network_revenue - media_cost

Network profit booked through direct advertisers and resold to real-time buyers.

network_rpm

money

5.13

(network_revenue / imps) x 1000

Network revenue per Mille (1000 imps)

network_ppm

money

3.42

(network_profit / imps) x 1000

Network profit per Mille (1000 imps)

network_roi

double

2.94

(network_revenue / media_cost) - 1

Network return on investment. Returned as a percentage, e.g., 0.94 = 94%

advertiser_revenue

money

 

advertiser_revenue

The revenue recorded for the advertiser. For more information, see Conversion Pixels: Advanced

advertiser_profit

money

 

advertiser_revenue - media_cost

Advertiser profit

advertiser_rpm

money

 

(advertiser_revenue / imps) x 1000

Advertiser revenue per Mille (1000 imps)

advertiser_ppm

money

 

(advertiser_profit / imps) x 1000

Advertiser profit per Mille (1000 imps)

advertiser_roi

money

 

(advertiser_revenue / media_cost) x 1000

Advertiser return on investment

spend

money

304.36

media_cost

 

creative_overage_fees

money

 

creative_overage_fees

Total fees charged for hosted creatives that exceed the creative size limit.

creative_overage_fees_adv_curr

money

 

creative_overage_fees_adv_curr

Total fees charged for hosted creatives that exceed the creative size limit, in the currency of the advertiser.

Note: If you are not tracking revenue through AppNexus, this will be 0 .

auction_service_fees

money

 

auction_service_fees

Total fees charged for impressions bought from third parties. These fees are charged in addition to the buyer's media cost. For more information, see the Buyer Auction Service Charge documentation (Customer login required).

auction_service_fees_adv_curr

money

 

auction_service_fees_adv_curr

Total fees charged for impressions bought from third parties, in the currency of the advertiser. These fees are charged in addition to the buyer's media cost. For more information, see the Buyer Auction Service Charge documentation (Customer login required).

Note: If you are not tracking revenue through AppNexus, this will be 0 .

auction_service_deduction

money

 

auction_service_deduction

The total deductions charged for impressions bought from third parties . These deductions are included in the buyer's media cost and deducted when calculating the seller's payment. For more information, see the Buyer Auction Service Charge documentation (Customer login required).

auction_service_deduction_adv_curr

money

 

auction_service_deduction_adv_curr

The total deductions charged for impressions bought from third parties, in the currency of the advertiser. These deductions are included in the buyer's media cost and deducted when calculating the seller's payment. For more information, see the Buyer Auction Service Charge documentation (Customer login required).

Note: If you are not tracking revenue through AppNexus, this will be 0 .

reseller_revenuemoney304.23reseller_revenueThe revenue generated through sales to external (RTB) buyers.
reseller_revenue_pub_currmoney304.23reseller_revenue_pub_currThe revenue generated through sales to external (RTB) buyers, in the currency of the publisher.

Example

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