Skip to end of metadata
Go to start of metadata

Selling Billing Report

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

The Selling Billing Report can be used to view billing data across direct publishers (sold across direct advertisers and other platform buyers).

For instructions on retrieving a report, consult the 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

publisher_id

int

No

Yes

321

Internal ID of the publisher

publisher_name

string

No

No

"Test"

Display name of the publisher

publisher_codeintYesYes123External ID of the publisher.

selling_currency

string

"USD"

Yes

Yes

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

buying_currency

string

Yes

Yes

"USD"

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

deal_idintYesYes123Internal ID of the deal

imp_type_id

int

Yes

Yes

1

The ID for the type of impression. Possible values (associated IDs in parentheses):

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

selling_imp_type

string

Yes

Yes

"Resold"

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.

pricing_media_type_idintYesNo0, 1ID of the video-specific media type classification (for billing only). If you don't have video-specific pricing, this field is irrelevant. Possible values are 0, 1, 2, 3.
pricing_media_type_namestringNoNo"Non Video"

Name of the video-specific media type classification (for billing only). If you don't have video-specific pricing, this field is irrelevant. Possible values are "--", "Non-Video", "Video (Hosted)", "Video (Non-Hosted)".

Metrics

Column

Type

Example

Formula

Description

imps

int

123456

imps

Total number of impressions

imps_filteredint2365imps_filteredThe total number of impressions which have been filtered out by AppNexus' Inventory Quality (e.g., from a blacklisted buyer).

clicks

int

123456

clicks

Total number of clicks across all impressions

convs

int

123456

total_convs

Total number of conversions across all impressions

reseller_revenuemoney123.45seller_revenueThe revenue generated through sales to external (RTB) buyers, in USD.
reseller_revenue_selling_currencymoney123.45reseller_revenue_selling_currencyThe revenue generated through sales to external (RTB) buyers, in the transaction currency the seller used to sell the impression.
seller_media_costmoney123.45seller_media_costThe amount owed to the publisher, in USD.
seller_media_cost_selling_currencymoney123.45seller_media_cost_selling_currencyThe amount owed to the publisher, in the transaction currency the seller used to sell the impression.

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