Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

Seller Platform Billing Report 

Suppliers gather transaction information using the Seller Platform Billing Report to invoice buyers or reconcile their internal transaction records.

For instructions on retrieving a report, see the Example below.

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_7_days
  • month_to_yesterday
  • month_to_date
  • quarter_to_date
  • last_month
  • lifetime
  • mtd

Dimensions

Column

Type

Group?

Filter?

Description

month

time

Yes

No

Month.

day

date

Yes

Yes

Day.

hour

date

Yes

Yes

The hour of the auction.

Impressions older than 100 days

For impressions older than 100 days, the day will be returned rather than the hour.

year

date

Yes

Yes

Year.

buyer_member_id

int

Yes

Yes

The internal ID of the buyer member.

seller_member_id

int

Yes

Yes

The internal ID of the seller member.

seller_member_name

string

No

No

The display name of the seller member.

seller_member

string

No

No

Deprecated.

publisher_id

int

Yes

Yes

The internal ID of the publisher.

publisher_name

string

No

No

The display name of the publisher.

publisher

string

No

No

Deprecated.

geo_country

string

No

Yes

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

geo_country_name

string

No

No

Country.

imp_type

string

No

Yes

The type of impression served. Possible values:

  • 1 = blank
  • 2 = PSA
  • 3 = default error
  • 4 = default
  • 5 = kept
  • 6 = resold
  • 7 = RTB
  • 8 = PSA resulting from a default error
  • 9 = external impression
  • 10 = external click

site_id

int

Yes

Yes

The internal ID of the site.

site_name

string

No

No

The display name of the site.

site

string

No

No

Deprecated.

is_dw

boolean

No

Yes

If true, the impression was served by AppNexus.

bidder_id

int

Yes

Yes

The internal ID of the bidder.

bidder_name

string

No

No

The display name of the bidder.

bidder

string

No

No

Deprecated.

is_delivered

boolean

No

Yes

If true, the impression was served successfully.

cleared_direct

int

No

Yes

If this is set to 1, then the impression was successfully served on direct inventory. Possible values:

  • 0 = not direct inventory
  • 1 = direct inventory

seller_currency

string

No

Yes

The seller member's selected currency. For a list of supported currencies, see Supported Currencies.

buyer_currency

string

No

Yes

The buyer member's selected currency. For a list of supported currencies, see Supported Currencies.

publisher_code

string

No

No

The custom code for the publisher, entered to correspond to the publisher code within the external system.

site_code

string

No

No

The custom code for the site, entered to correspond to the site code within the external system.

buyer_member_name

string

No

No

The display name of the buyer member.

buyer_member

string

No

No

Deprecated.

Metrics

Column

Type

Formula

Description

imps

int

imps

The total number of impressions (served and resold).

imps_delivered

int

imps_delivered

The total number of impressions served successfully.

imps_not_delivered

int

imps_not_delivered

The total number of impressions where someone other than AppNexus served the impression.

imps_appnexus_cleared

int

imps_appnexus_cleared

The total number of impressions where AppNexus collects cost of media and pays out seller payment for transactions between this buyer-seller pair.

imps_direct_cleared

int

imps_direct_cleared

The total number of impressions where AppNexus does NOT collect cost of media or pay out seller payment for transactions between this buyer-seller pair.

seller_revenue

money

seller_revenue

The seller's revenue per impression.

seller_revenue_appnexus_cleared

money

seller_revenue for imps_appnexus_cleared

The seller's revenue for impressions where AppNexus pays out the seller payment.

seller_revenue_direct_cleared

money

seller_revenue for imps_direct_cleared

The seller's revenue for impressions where the seller payment is transacted directly between this buyer-seller pair, not through AppNexus.

seller_ecpm

money

seller_revenue x 1000 / imps_delivered

The seller's revenue expressed in eCPM.

seller_revenue_seller_curr

money

seller_revenue, expressed in the seller's currency.

The seller's revenue per impression in their selected currency. For a list of supported currencies, see Supported Currencies.

seller_revenue_appnexus_cleared_seller_curr

money

seller_revenue for imps_appnexus_cleared, expressed in the seller's currency.

The seller's revenue for impressions where AppNexus pays out the seller payment, per impression, in their selected currency. For a list of supported currencies, see Supported Currencies.

seller_revenue_direct_cleared_seller_curr

money

seller_revenue for imps_direct_cleared, expressed in the seller's currency.

The seller's revenue for impressions where the seller payment is transacted directly between this buyer-seller pair and not through AppNexus, per impression, in their selected currency. For a list of supported currencies, see Supported Currencies.

seller_revenue_direct_cleared_buyer_curr

money

seller_revenue for imps_direct_cleared, expressed in the buyer's currency.

The seller's revenue for impressions where the seller payment is transacted directly between this buyer-seller pair and not through AppNexus, per impression, in the buyer's selected currency. For a list of supported currencies, see Supported Currencies.

seller_ecpm_seller_curr

money

(seller_revenue / imps_delivered) * 1000, expressed in the seller's currency

The seller's revenue expressed in eCPM, in the seller's selected currency. For a list of supported currencies, see Supported Currencies.

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

Schedule a frequently run report

You can schedule reports that you would like to pull regularly. See the Saved Report Service for more information.

Related Topics

  • No labels