Skip to end of metadata
Go to start of metadata

Buying Billing Report 

This report should only be used for data after September 30, 2015.

The Buying Billing Report can be used to view billing data across direct advertiser impressions (bought across direct publishers and real-time inventory).

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

On This Page

Time Frame

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

  • last_hour
  • today
  • yesterday
  • last_48_hours
  • last_7_days
  • last_30_days
  • month_to_date
  • quarter_to_date
  • last_month
  • lifetime
  • custom

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

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.

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

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

advertiser_id

int

No

Yes

789

Internal ID of the advertiser

advertiser_name

string

No

No

"Verizon"

Display name of the advertiser

advertiser_code    The external code associated with an advertiser.
insertion_order_idintYesYes451Internal ID of the insertion order
insertion_order_namestringNoNo"Q1-2014"Display name for the insertion order
insertion_order_code    The external code associated with an insertion order.

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_code    The external code associated with a line item.

campaign_id

int

Yes

Yes

728

Internal ID of the campaign

campaign_name

string

No

No

"Test"

Display name of the campaign

campaign_code    The external code associated with a campaign.

publisher_id

int

No

Yes

321

Internal ID of the publisher

publisher_name

string

No

No

"Test"

Display name of the publisher

deal_id intNo Yes 123 The internal id of the deal.
deal_namestringNoNo"Deal A"The display name of the deal.

buying_currency

string

Yes

Yes

"USD"

The transaction currency used by the buyer to purchase this impression.

selling_currencystringYesYes"EUR"The transaction currency used by the seller to sell this impression.

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.

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.

marketplace_clearing_eventstringYesYes"Views - Standard Display"The name of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video).  For more information, see Exchange Traded Views. For a list of Clearing Events and their IDs, see the Supported Viewability Standards section of Exchange Traded Views.
split_idintnoyes342The 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_namestringnoyes"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.

Metrics

Column

Type

Example

Formula

Description

imps

int

123456

imps

Total number of impressions

clicks

int

123456

clicks

Total number of clicks across all impressions

convs

int

123456

total_convs

Total number of converstions across all impressions

booked_revenue

money

123.45

booked_revenue

Network revenue booked through direct advertisers.

booked_revenue_dollars_buying_currencymoney123.45booked_revenue_dollars_buying_currency

Network revenue booked through direct advertisers, in the transaction currency the buyer used to buy the impression.

buyer_media_costmoney123.45buyer_media_costThe total cost of the inventory purchased.
buyer_media_cost_buying_currencymoney123.45buyer_media_cost_buying_currencyThe total cost of the inventory purchased, in the transaction currency the buyer used to buy the impression.

auction_service_deduction

money

123.45

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_buying_currencymoney123.45auction_service_deduction_buying_currency

The total deductions charged for impressions bought from  third parties, in the transaction currency the buyer used to buy the impression.

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

net_media_costmoney123.45net_media_costThe total amount to be paid for media purchases, less the Auction Service Deduction.
net_media_cost_buying_currencymoney123.45net_media_cost_buying_currencyThe total amount to be paid for media purchases, less the Auction Service Deduction, in the transaction currency the buyer used to buy the impression.

creative_overage_fees

money

123.45

creative_overage_fees

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

creative_overage_fees_buying_currencymoney123.45creative_overage_fees_buying_currencyTotal fees charged for hosted creatives that exceed the creative size limit, in the transaction currency the buyer used to buy the impression.

auction_service_fees

money

123.45

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_buying_currencymoney123.45auction_service_fees_buying_currency

Total fees charged for impressions bought from third parties, in the transaction currency the buyer used to buy the impression.

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

marketplace_clearing_event_unitsint23 The total number of events purchased (for the associated Clearing Event). When buying a Clearing Event other than impression (e.g., viewable impressions), the number of billed events will be less than the number of impressions. For more information, see Exchange Traded Views.

Example

1. Create the JSON-formatted report request
2. POST the request to the Reporting Service specifying a member ID by replacing INSERT_DESIRED_MEMBER_ID
3. GET the report status from the Report Service
4. GET the report data from the Report Download Service
  • No labels