Skip to end of metadata
Go to start of metadata

Network Advertiser Analytics Report

The Network Advertiser Analytics report is used to view performance data for a specific advertiser that is more detailed than the data provided in the Network Analytics report. This report is available to network users only. Advertiser users can use the Advertiser Analytics report.

For usage instructions, see the Example below. Note that this report requires that an advertiser ID be specified as part of the URL, for example:

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.

Data Retention Period

Most data in this report is maintained permanently (exceptions noted below). After:

  • 100 days, you are no longer able to report on hourly data (however, daily, monthly and cumulative intervals are still available) 
  • 14 months, you are no longer able to report on individual:
    • Creatives
    • Placements
    • Brands

In some cases Analytics reports can show delivery that does not match Lifetime QuickStats for a given advertiser or publisher. This is due to the way that Analytics reporting data older than 100 days and 14 months are aggregated. The data from Billing reports are kept in non-aggregated form indefinitely. 

Dimensions

Some dimensions have attributes. Dimension attributes are a more granular element of data about the parent dimension. If a dimension has attributes, the name of its attributes will appear below it using the following syntax: dimension_name.attribute_name.

Column

Type

Group?

Filter?

Example

Description

hour

date

Yes

No

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

The hour of the auction. Note: For impressions older than 100 days, the day will be returned rather than the hour.

day

date

Yes

No

2010-02-01

Day of the month.

month

date

Yes

No

2010-02

Month of the year.

advertiser_code

string

No

No

"Advertiser Code"

The custom code for the advertiser.

buyer_member_id

int

Yes

Yes

123

The internal ID of the buying member in the impression.

bidder_idintNoNo436537The ID of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.
bidder_namestringNoNo"Bidder's name"The name of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.

seller_member_id

int

Yes

Yes

567

The internal ID of the selling member.

seller_member_name

string

No

No

"AdMeld"

The display name of the selling member.

seller_member

string

No

No

"AdMeld (567)"

Deprecated (as of October 17, 2016).

advertiser_id

int

Yes

Yes

344

The internal ID of the advertiser whose campaign and creative served in the impression.

campaign_id

int

Yes

Yes

728

Number to identify the campaign.

campaign_name

string

No

No

"Test"

Display name of the campaign

campaign

string

No

No

"Test (123)"

Deprecated (as of October 17, 2016).

campaign_code

string

No

No

"Campaign Code"

The custom code for the campaign

campaign_priority

int

No

No

5

The bidding priority (customer login required) for a campaign that targets direct inventory.
Possible values: 1 - 10, where 10 is the highest priority.

creative_id

int

Yes

Yes

554

The ID of the creative. Note:

  • For impressions older than 14 months, creatives will be 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"

The name of the creative. Note:

  • For impressions older than 14 months, creatives will be aggregated into one row with "All creative data older than 100 days" as the creative_name.
  • For external click or impression trackers, creative_name will be "External Clicks" or "External Imps".
creative_codestringNoNo"12655"The code for the creative. Note:
  • For impressions older than 100 days, creatives will be aggregated into one row with "All creative data older than 100 days" as the creative_name.
  • For external click or impression trackers, creative_code will be "External Clicks" or "External Imps".

creative

string

No

No

"Q1 2010 728x90 (554)"

Deprecated (as of October 17, 2016).

site_id

int

Yes

Yes

194

The ID of the site. Note: For impressions older than 14 months, the site_id will be 0.

site_name

string

No

No

"Site Name"

The name of the site.

site

string

No

No

"Site Name (593)"

Deprecated (as of October 17, 2016).

placement_id

int

Yes

Yes

567

The ID of the placement. Note: For impressions older than 14 months, placements will be aggregated into one row with -1 as the placement_id.

placement_name

string

No

No

"Photos 728x90"

The name of the placement. Note: For impressions older than 14 months, placements will be aggregated into one row with "All placement data older than 14 months" as the placement_name.

placement

 

string

No

No

"Photos 728x90 (123)"

Deprecated (as of October 17, 2016).

placement_code

string

No

No

"Placement Code"

The custom code for the placement.

deal_id

int

Yes

Yes

2345

The ID of the deal. For more information about negotiated deals between buyers and sellers, see Deal Service and Deal Buyer Access Service.

deal_name

string

No

No

"Private deal for buyer 1085 with floor of $2.50"

The name of the deal.

deal

 

string

No

No

"Private deal for buyer 1085 with floor of $2.50 (45)"

Deprecated (as of October 17, 2016).

deal_codestringNo No"External seller deal code"The custom code for the deal. For deals with external supply partners, this is generally the string that you use to identify the deal.

size

string

Yes

Yes

"728x90"

Size of the creative/placement

geo_country

string

Yes

Yes

"US"

Geographic country code

geo_country_name

string

No

No

"Unites States"

Name of the country

creative_recency_bucket

string

Yes

Yes

"11-20"

Deprecated. If you request this dimension, only a default value will be returned. Please use the Network Creative Frequency & Recency report to view creative recency data.

creative_recency_bucket_id

string

No

No

"4"

Deprecated. If you request this dimension, only a default value will be returned. Please use the Network Creative Frequency & Recency report to view creative recency data.

creative_frequency_bucket

string

Yes

Yes

"15-30 minutes"

Deprecated. If you request this dimension, only a default value will be returned. Please use the Network Creative Frequency & Recency report to view creative frequency data.

creative_frequency_bucket_id

string

No

No

"3"

Deprecated. If you request this dimension, only a default value will be returned. Please use the Network Creative Frequency & Recency report to view creative frequency data.

insertion_order_id

int

Yes

Yes

654

The ID of the insertion order

insertion_order_name

string

No

No

"Insertion Order Name"

The name of the insertion order

insertion_order

string

No

No

"Insertion Order Name (654)"

Deprecated (as of October 17, 2016).

insertion_order_code

string

No

No

"Insertion Order Code"

The custom code for the insertion order

insertion_order.typestringNoNo"Legacy IO"The type of insertion order associated with the impression (e.g. Legacy, Seamless).
insertion_order.statestringNoNo"active"The state of the insertion order associated wih the impression.
insertion_order.start_datedateNoNo The start date of the non-seamless insertion order associated with the impression. For seamless orders, see billing_period.start_date.
insertion_order.end_datedateNoNo The end date of the non-seamless insertion order associated with the impression. For seamless orders, see billing_period.end_date.
insertion_order.booked_impressions_budget_daily intNoNo2000The daily impression budget for the insertion order.
insertion_order.booked_impressions_budget_lifetime intNoNo20000The lifetime impression budget for the insertion order.
insertion_order.booked_revenue_budget_daily moneyNoNo200.00The daily budget in revenue for the insertion order.
insertion_order.booked_revenue_budget_lifetime moneyNoNo10000.00The lifetime budget in revenu for the insertion order.
insertion_order.billing_codestringNoNo"E4567"The billing code associated with the insertion order.
type_for_insertion_orderstringYesYes"Retargeting IO"

A custom reporting field describing the type of insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.

salesrep_for_insertion_orderstringYesYes"Patricia Martin"A custom reporting field containing the sales representative for the insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.
trafficker_for_insertion_orderstringYesYes"George Martin"A custom reporting field containing the trafficker for the insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.
billing_period.start_datedatetimeNoNo"2015-05-25 19:19:53"

The earliest date of the insertion order's billing period.

Alpha-Beta Notice

This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

billing_period.end_datedatetimeNoNo"2015-05-30 19:19:53"

The last date of the insertion order's billing period.

Alpha-Beta Notice

This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

billing_period.booked_imps_budget_dailyintNoNo3500The daily impression budget of the insertion order's billing period.
billing_period.booked_imps_budget_lifetimeintNoNo30000The lifetime impression budget of the insertion order's billing period.
billing_period.booked_revenue_budget_daily_buying_currencymoneyNoNo250.00The daily revenue budget of the insertion order's billing period.
billing_period.booked_revenue_budget_lifetime_buying_currencymoneyNoNo2500.00The lifetime revenue budget of the insertion order's billing period.
billing_period.external_codestringNoNo"houseware245"The custom code for the billing period (budget_interval).

payment_type

string

Yes

Yes

"CPM"

How the buyer is paying for the impression. Possible values:

  • "No payment"
  • "CPM"
  • "CPC"
  • "CPA"
  • "Owner CPM"
  • "Owner revshare"

supply_type

string

Yes

No

"web"

The type of supply in the impression. Possible values:

  • "web": A site viewed on a desktop browser.
  • "mobile_web": A site viewed on a mobile browser.
  • "mobile_app": An app running on a mobile device.

line_item_id

int

Yes

Yes

932

Number to identify 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).

line_item_code

string

No

No

"Line Item Code"

The custom code for the line item

line_item.typestringNoNo"standard"The line item type (e.g., standard, augmented)
line_item.statusstringNoNo"active"The state of the line item (e.g., active, inactive)
line_item.start_datedatetimeNoNo2017-02-06 00:00:00 EST5EDTThe start date of the non-augmented line item. For augmented line Items (ALIs), see flight.start_date.
line_item.end_datedatetimeNoNo2017-02-09 23:00:00 EST5EDTThe end date of the non-augmented line item. For augmented line Items (ALIs), see flight.end_date.
line_item.booked_impressions_budget_daily intNoNo2000The daily impression budget for the line item.
line_item. booked_impressions_budget_lifetimeintNoNo20000The lifetime impression budget for the line item.

line_item.booked_revenue_budget_daily_adv_curr

moneyNoNo1200.00The daily budget in revenue for the line item.

line_item.booked_revenue_budget_lifetime_adv_curr

moneyNoNo23000.00The lifetime budget in revenue for the line item.
line_item.commentsstringNoNo"extension of Feb spend"Any comments related to this line item.
type_for_line_itemstringYesYes"Branding IO"

A custom reporting field describing the type of line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.

salesrep_for_line_itemstringYesYes"Patricia Martin"A custom reporting field containing the sales representative for the line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.
trafficker_for_line_itemstringYesYes"George Martin"A custom reporting field containing the trafficker for the line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.

pixel_id

int

Yes

Yes

1942

The ID of the conversion pixel. Note: This dimension will return a maximum of 10 conversion pixels. Also, you can filter by No more than 10 conversion pixels.

flightintYesYes123475The line item flight ID.
flight.start_datedatetimeNoNo2017-02-06 00:00:00 EST5EDTThe start date of the line item's flight.
flight.end_datedatetimeNoNo2017-02-09 23:00:00 EST5EDTThe end date of the line item's flight.
flight.booked_impressions_budget_dailyintNoNo20000The daily impression budget for the line item's flight.
flight.booked_impressions_budget_lifetimeintNoNo200000The lifetime impression budget for the line item's flight.

flight.booked_revenue_budget_daily_advertiser_currency

moneyNoNo200.00The daily budget in revenue for the line item's flight.
flight.booked_revenue_budget_lifetime_advertiser_currencymoneyNoNo20000.00The lifetime budget in revenue for the line item's flight.

publisher_id

int

Yes

Yes

321

Number to identify the publisher

publisher_name

string

No

No

"Test"

Display name of the publisher

publisher

string

Yes

No

"Test (123)"

Deprecated (as of October 17, 2016).

publisher_code

string

No

No

"Publisher Code"

The custom code for the publisher

imp_type_id

int

Yes

Yes

1

The type of impression. Integer value which translates as follows: 1 = Blank, 2 = PSA, 3 = Default Error, 4 = Default, 5 = Kept, 6 = Resold, 7 = RTB, 8 = PSA Error, 9 = External Impression, or 10 = External Click.

imp_type

string

Yes

Yes

"Kept"

The type of impression. See imp_type_id above for the correspondence between descriptions and numeric values.

bid_type

string

Yes

Yes

"Manual"

The optimization phase the node was in when it bid for this 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"

seller_type

string

Yes

Yes

"Real Time", "Direct"

The type of media sold by the seller

media_type

string

No

Yes

"Banner", "Pop", "Interstitial", "Video", "Text", "Expandable", "Skin"

The general display style of the creative. You can use the Media Type Service to view the complete list of media types.

media_type_id

int

yes

yes

2

Read-only. The ID of the media type to which the subtype belongs.

venue_id

int

Yes

Yes

1805

The ID of the cluster of domain, site, tag, and user country that AppNexus' optimization system uses to determine bid valuations.

venue

string

Yes

Yes

"Venue Name"

The name of the cluster of domain, site, tag, and user country that AppNexus' optimization system uses to determine bid valuations.

predict_type_rev

int

Yes

Yes

2

The optimization phase of the campaign. Possible values:
-2 = No predict phase
-1 = Base predict phase
0 = Learn giveup
1 = Learn
2 = Throttled
3 = Optimized
4 = Biased
5 = Optimized 1
8 = Optimized giveup
9 = Base bid below giveup

advertiser_type

string

Yes

Yes

"Local"

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

user_group_for_campaign

string

Yes

Yes

"Test"

The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.

line_item_typestringYesYes"Performance"A field describing the line item, provided by the user. See the the "labels" field in the Line Item Service for more information.
insertion_order_typestringYesYes"Client A Insertion Order" A field describing the insertion order, provided by the user. See the "labels" field in the Insertion Order Service for more information.

adjustment_id

int

Yes 

Yes 

890

The ID of the adjustment used to make changes to the media cost and/or impressions, clicks, and conversions you see in reporting for a advertiser.

revenue_type

string

Yes 

No  

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

Metrics

Column

Type

Example

Formula

Description

imps

int

234123

imps

The total number of impressions served.

clicks

int

545

clicks

The the total number of clicks across all impressions.

post_view_convs

int

75

post_view_convs

The total number of recorded post-view conversions.

post_view_revenue

money

150.00

post_view_revenue

The total amount of recorded post-view conversion revenue.

post_click_convs

int

15

post_click_convs

The total number of recorded post-click conversions.

post_click_revenue

money

300.00

post_click_revenue

The total amount of recorded post-click conversion revenue.

total_revenue

money

450.00

booked_revenue

The total revenue.

total_revenue_adv_curr

money

300.00

total_revenue_adv_curr

The total revenue in the advertiser's currency

total_convs

int

90

post_click_convs + post_view_convs

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

convs_rate

double

0.0003844

total_convs / imps

The rate of conversions to impressions.

post_view_convs_rate

double

0.000320

post_view_convs / imps

The rate of post-view conversions to impressions.

post_click_convs_rate

double

0.000064

post_click_convs / imps

The rate of post-click conversions to impressions.

ctr

double

0.2327836

clicks / imps

The rate of clicks to impressions.

profit

money

350.00

booked_revenue - media_cost

The total net profit.

click_convs_rate

double

0.1651376

total_convs / clicks

The rate of conversions to clicks.

advertiser_currency

string

Yes

advertiser_currency

The advertiser's preferred currency. This preference can be set using the Advertiser Service.

revenue_ecpm

money

1.9221

booked_revenue / clicks

The total revenue per 1000 impressions.

revenue_ecpm_adv_curr

money

1.50

revenue_ecpm_adv_curr

The total revenue per 1000 impressions in the advertiser's currency.

cost_ecpm

money

0.4271259

media_cost / imps * 1000

The cost per 1000 impressions.

profit_ecpm

money

0.4949

(booked_revenue - media_cost) / imps * 1000

The profit per 1000 impressions.

revenue_ecpc

money

0.8256

booked_revenue / clicks

The total revenue per click.

revenue_ecpc_adv_curr

money

0.50

revenue_ecpc_adv_curr

The total revenue per click in the advertiser's currency.

revenue_ecpa

money

5.00

booked_revenue / total_convs

The total revenue per conversion.

revenue_ecpa_adv_curr

money

3.00

revenue_ecpa_adv_curr

The total revenue per conversion in the advertiser's currency.

cost_ecpc

money

0.1834

media_cost / clicks

The cost per click.

cost_ecpa

money

1.1111

media_cost / total_convs

The cost per acquisition/conversion.

profit_margin

money

0.7778

(booked_revenue - media_cost) / booked_revenue

The profit as a percentage of revenue.

media_cost

money

100.00

media_cost

The total amount spent.

convs_per_mm

double

384.4

(total_convs / imps) * 1,000,000

The number of conversions per million impressions.

click_thru_pct

double

2.756%

(clicks / imps) * 100

The rate of clicks to impressions, expressed as a percentage. In other words, the percentage of impressions that resulted in clicks.

commissions

money

0

commissions

Fees that come out of the booked revenue.

serving_fees

money

0.025143

serving_fees

Fees that are added to the media cost.

profit_including_fees

money

250.00

booked_revenue_dollars - commissions - media_cost_dollars - serving fees

Profit minus commissions and serving fees.

total_revenue_including_fees

money

450.00

booked_revenue_dollars - commissions

Total revenue after commissions.

total_revenue_including_fees_adv_currency

money

370.00

booked_revenue_adv_curr - commissions_adv_curr

Total revenue after commissions, in the advertiser's currency.

revenue_ecpa_including_fees

money

2.50

If (post_click_convs + post_view_convs) > 0, then (booked_revenue_dollars - commissions) / (post_click_convs + post_view_convs)

If (post_click_convs + post_view_convs) = 0, then (booked_revenue_dollars - commissions) / 1

Revenue per conversion after commissions.

revenue_ecpa_including_fees_adv_currency

money

3.25

If (post_view_convs + post_click_convs) > 0, then (booked_revenue_adv_cur - commissions_adv_revenue) / (post_view_convs + post_click_convs)

If (post_view_convs + post_click_convs) = 0, then (booked_revenue_adv_cur - commissions_adv_revenue) / 1

Revenue per conversion after commissions, in the advertiser's currency.

revenue_ecpc_including_fees

money

0.7256

If clicks > 0, then (booked_revenue_dollars - commissions / clicks

If clicks = 0, then (booked_revenue_dollars - commissions / 1

Revenue per click after commissions.

revenue_ecpc_including_fees_adv_currency

money

0.7256

If clicks > 0, then (booked_revenue_adv_curr - commissions_adv_curr) / clicks

If clicks = 0, then (booked_revenue_adv_curr - commissions_adv_curr) / 1

Revenue per click after commissions, in the advertiser's currency.

revenue_ecpm_including_fees

money

1.3131

If imps > 0, then (booked_revenue_dollars - commissions) / (imps) * 1000

If imps = 0, then (booked_revenue_dollars - commissions) / 1000

Revenue per thousand impressions after commissions.

revenue_ecpm_including_fees_adv_currency

money

1.3456

If imps > 0, then (booked_revenue_dollars_adv_curr - commissions_adv_curr) / (imps) * 1000

If imps = 0, then (booked_revenue_dollars_adv_curr - commissions_adv_curr) / 1000

Revenue per thousand impressions after commissions, in the advertiser's currency.

cost_ecpa_including_fees

money

1.1111

If (post_click_convs + post_view_convs) > 0, then (media_cost_dollars + serving_fees) / (post_click_convs + post_view_convs)

If (post_click_convs + post_view_convs) = 0, then (media_cost_dollars + serving_fees) / 1

Cost per conversion including serving fees.

cost_ecpc_including_fees

money

0.7925

If clicks > 0, then (media_cost_dollars + serving fees) / clicks

If clicks = 0, then (media_cost_dollars + serving fees) / 1

Cost per click including serving fees.

cost_ecpm_including_fees

money

 0.4271259

If imps > 0, then (media_cost_dollars + serving_fees) / imps

If imps = 0, then (media_cost_dollars + serving_fees) / 1

Gross serving fees per thousand impressions.

profit_net_including_fees

money

200.00

booked_revenue_dollars - commissions - media_cost_dollars - serving fees

Net profit after commissions and serving fees.

profit_ecpm_including_fees

money

0.4141

If imps > 0, then (booked_revenue_dollars - commissions - media_cost_dollars - serving_fees) / imps * 1000

If imps = 0, then (booked_revenue_dollars - commissions - media_cost_dollars - serving_fees) / 1000

Profit per thousand impressions after commissions and serving fees.

profit_margin_including_fees

money

0.7778

If (booked_revenue_dollars - commissions) > 0, then (booked_revenue_dollars - commissions - media_cost_dollars - serving_fees) / (booked_revenue_dollars - commissions)

If (booked_revenue_dollars - commissions) = 0, then (booked_revenue_dollars - commissions - media_cost_dollars - serving_fees) / 1

Profit margin after commissions and serving fees.

post_view_convs_pixel

int

23

 

Post view conversions for the pixel.

post_clicks_convs_pixel

int

15

 

Post click conversions for the pixel.

total_revenue_pixel

money

118.50

 

Total revenue for the pixel.

total_revenue_including_fees_pixel

money

94.80

 

Total revenue for the pixel after commissions

imps_viewed

int

30,450

imps_viewed

The number of measured impressions that were viewable per the IAB Viewability definition.

view_measured_imps

int

10,120

view_measured_imps

The total number of impressions that were measured for viewability.

view_rate

double

58%

view_rate

The percentage of impressions that were viewable out of the total number of impressions measured for viewability. (Viewed Imps / View Measured Imps)

view_measurement_rate

double

45%

view_measurement_rate

The percentage of impressions measured for viewability out of the total number of impressions. (View Measured Imps / Imps)

cost_ecpvmmoney2.25(media_cost / imps_viewed) * 1000The cost per 1000 viewable impressions.
avg_bid_reductiondouble18% The average bid reduction you gained on the line item or campaign. This value represents the difference (as a percentage) between your bid and the actual media cost you paid for the impression you won (e.g., due to bid reduction). This value is only valid for RTB bidding (i.e., not Managed). Currently, this value is not accurately calculated for line items for which the payment_auction_event_type field has been set to 2.

Example

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

Related Topics

Report Service

  • No labels