Network analytics

The Network Analytics report can be used to view both buy and sell-side data for a network member:

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

To drill down into more granular analytics for a specific advertiser or publisher, see the Network Advertiser Analytics and Network Publisher Analytics reports.

For instructions on retrieving a report, see Report Service or the example below.

Time frame

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

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

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 statistics shown elsewhere in Invest or Monetize 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. For more information, see Dates and Times in Reporting in the UI documentation.

Note

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.

Time ranges including dates occurring greater than 45 days ago

If you create network analytics reports with the report_interval set to "lifetime" or "quarter_to_date" (where the end date is greater than 45 days from today), your report (regardless of metrics included) will be added to a special queue for "resource-intensive" reports. As a result, the report may take longer than usual to complete. In addition, these resource-intensive reports may, due to the amount of data being requested, fail before being completed. If your report fails to complete, you will receive a notification. If your report request fails or is deleted, you can:

• re-run the report at a later time.
• use a report type other than network_analytics.
• alter the way you structure your reports (if possible) so they do not include dates greater than 45 days ago.

If you are frequently requesting network analytics reports via the API which include dates longer than 45 days ago, you may need to consider caching data and using Bulk Reporting Feeds or Log-Level Data (LLD) Feeds.

Dimensions

Note

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	Filter?	Example	Description
hour	time	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	time	No	"2010-02-01"	The day of the auction.
month	time	No	"2010-02"	The month of the auction.
entity_member_id	int	Yes	123	If imp_type is 1, 2, 3, 4, 6, or 8, the ID of the buying member; otherwise, the ID of the selling member.
buyer_member_id	int	Yes	123	The ID of the buying member. If the impression was not purchased, this field shows one of the following values: 229 = PSA 0 = Blank 319 = Default. This dimension also has an attribute, called bidder, that identifies the ID of the bidder for the impression. The attribute's data type is int.
buyer_member_name	string	No	"My Network"	The name of the buying member. Note: The name might be "Default" or "Default Error", which means that there was no buyer for the impression, and a default creative was served.
external_inv_id	int	Yes	123	The ID of the external inventory code passed in the ad call and predefined by the publisher. For more details, see External Inventory Code Service.
external_inv_name	string	No	"My external inventory"	The name of the external inventory code passed in the ad call and predefined by the publisher. For more details, see External Inventory Code Service.
external_inv	string	No	"My external inventory(123)"	Deprecated.
deal_type	string	Yes	"programmatic_guaranteed"	The name for the type of deal. Possible values are: - "open_auction" - "private_auction" - "first_look" - "programmatic_guaranteed" - "curated"
deal_type_id	int	Yes	4	The ID for the type of deal. Possible values are (associated types in parentheses): - 1 ("open_auction") - 2 ("private_auction") - 3 ("first_look") - 4 ("programmatic_guaranteed") - 5 ("curated")
seller_member_id	int	Yes	456	The ID of the selling member.
seller_member_name	string	No	"That Seller"	The name of the selling member.
advertiser_id	int	Yes	789	The ID of the advertiser. If the value is 0, either the impression was purchased by an external buyer, or a default or PSA was shown.
advertiser_name	string	No	"Verizon Wireless"	The name of the advertiser.
advertiser_code	string	No	"Verizon Wireless Code"	The custom code for the advertiser.
advertiser_currency	string	Yes	"USD"	The currency of the advertiser.
adjustment_id	int	Yes	890	The ID of the adjustment used to make changes to booked revenue and media cost values.
adjustment_day	time	Yes	"2010-02-01"	The day of the adjustment.
adjustment_hour	time	Yes	"2010-02-01 06:00:00"	The hour of the adjustment.
publisher_id	int	Yes	321	The ID of the publisher.
publisher_name	string	No	"Newscorp"	The name of the publisher.
publisher_code	string	No	"Newscorp Code"	The custom code for the publisher.
pub_rule_id	int	Yes	555	The ID of the publisher rule.
pub_rule_name	string	No	"Publisher Rule Name"	The name of the publisher rule.
pub_rule_code	string	No	"Publisher Rule Code"	The custom code for the publisher rule.
publisher_currency	string	Yes	"USD"	The currency of the publisher.
site_id	int	Yes	194	The ID of the site. Note: For impressions older than 14 months, the site_id will be 0.
site_name	string	No	"Site Name"	The name of the site.
site_code	string	No	"Site Code"	The custom code for the site.
pixel_id	int	Yes	3141	The ID of the pixel used to track the conversion. For more information, see the Conversion Pixel Service.
pixel_name	string	No	"My Pixel"	The name of the pixel used to track the conversion.
flight	int	Yes	124785	The line item flight ID.
flight.start_date	datetime	No	2017-02-06 00:00:00 EST5EDT	The start date of the line item's flight.
flight.end_date	datetime	No	2017-02-09 23:00:00 EST5EDT	The end date of the line item's flight.
flight.booked_impressions_budget_daily	int	No	2000	The daily impression budget for the line item's flight.
flight.booked_impressions_budget_lifetime	int	No	200000	The lifetime impression budget for the line item's flight.
flight.booked_revenue_budget_daily_advertiser_currency	money	No	50.00	The daily budget in revenue for the line item's flight.
flight.booked_revenue_budget_lifetime_advertiser_currency	money	No	20000.00	The lifetime budget in revenue for the line item's flight.
placement_id	int	Yes	456	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	"Ivillage 160x600"	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_code	string	No	"Ivillage Code"	The custom code for the placement.
insertion_order_id	int	Yes	321	The ID of the insertion order.
insertion_order_name	string	No	"Insertion Order"	The name of the insertion order.
insertion_order_code	string	No	"Insertion Order Code"	The custom code for the insertion order.
insertion_order.type	string	No	"Legacy IO"	The type of insertion order associated with the impression (e.g. Legacy, Seamless).
insertion_order.state	string	No	"active"	The state of the insertion order (e.g., active, inactive).
insertion_order.start_date	timestamp	No	2017-02-06 00:00:00 EST5EDT	The start date of the non-seamless insertion order associated with the impression. For seamless orders, see billing_period.start_date.
insertion_order.end_date	timestamp	No	2017-02-09 23:00:00 EST5EDT	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	int	No	2000	The daily impression budget for the insertion order.
insertion_order.booked_impressions_budget_lifetime	int	No	200000	The lifetime impression budget for the insertion order.
insertion_order.booked_revenue_budget_daily	money	No	200.00	The daily budget in revenue for the insertion order.
insertion_order.booked_revenue_budget_lifetime	money	No	10000.00	The lifetime budget in revenue for the insertion order.
insertion_order.billing_code	string	No	"E4567"	The billing code associated with the insertion order.
type_for_insertion_order	string	Yes	"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_order	string	Yes	"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_order	string	Yes	"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.
external_code	string	No	"external code"	An external custom code associated with the placement (by the Publisher).
line_item_id	int	Yes	111	The ID of the line item.
line_item_name	string	No	"Default Line Item"	The name of the line item.
line_item_code	string	No	"Default Line Item Code"	The custom code for the line item.
line_item.type	string	No	"standard"	The line item type (e.g., standard, augmented).
line_item.true_line_item_type	string	No	"augmented"	The new line item type that includes augmented line item (ALI), standard etc.
line_item.status	string	No	"active"	The state of the line item (e.g., active, inactive).
line_item.start_date	datetime	No	2017-02-06 00:00:00 EST5EDT	The start date of the non-augmented line item. For augmented line Items (ALIs), see flight.start_date.
line_item.end_date	datetime	No	2017-02-09 23:00:00 EST5EDT	The end date of the non-augmented line item. For augmented line Items (ALIs), see flight.end_date.
line_item.booked_impressions_budget_daily	int	No	2000	The daily impression budget for the line item.
line_item.booked_impressions_budget_lifetime	int	No	20000	The lifetime impression budget for the line item.
line_item.booked_revenue_budget_daily_adv_curr	money	No	1200.00	The daily budget in revenue for the line item.
line_item.booked_revenue_budget_lifetime_adv_curr	money	No	23000.00	The lifetime budget in revenue for the line item.
line_item.comments	string	No	"extension of Feb spend"	Any comments related to this line item.
type_for_line_item	string	Yes	"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_item	string	Yes	"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_item	string	Yes	"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.
campaign_id	int	Yes	222	The ID of the campaign.
campaign_name	string	No	"Default Campaign"	The name of the campaign.
campaign_code	string	No	"Default Campaign Code"	The custom code for the campaign.
campaign_priority	int	No	5	The bidding priority for a campaign that targets direct inventory. For more information, see Bidding Priority in the UI Documentation. Possible values: 1 - 10, where 10 is the highest priority.
campaign_type	string	Yes	"House Ad Campaign"	The type of campaigns under the line item. See the labels field in the Line Item Service for more information.
creative_id	int	Yes	554	The ID of the creative. Note: - For impressions older than 100 days, 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	"Q1 2010 728x90"	The name of 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_name will be "External Clicks" or "External Imps".
creative_code	string	No	"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".
size	string	Yes	"728x90"	The size of the placement/creative served.
brand_id	int	Yes	3	The ID of the brand associated with a creative. For imp_type_id = 6, no information is available in the brand_id field for this report. See the Seller Brand Review Report instead.
brand_name	string	No	"Ace Hardware"	The name of the brand associated with a creative. For imp_type_id = 6, no information is available in the brand_name field for this report. See the Seller Brand Review Report instead.
billing_period.start_date	datetime	No	"2015-05-25 19:19:53"	The earliest date of the insertion order's billing period. Note: 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_date	datetime	No	"2015-05-30 19:19:53"	The last date of the insertion order's billing period. Note: 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_daily	int	No	3500	The daily impression budget of the insertion order's billing period.
billing_period.booked_imps_budget_lifetime	int	No	300000	The lifetime impression budget of the insertion order's billing period.
billing_period.booked_revenue_budget_daily_buying_currency	money	No	250.00	The daily revenue budget of the insertion order's billing period.
billing_period.booked_revenue_budget_lifetime_buying_currency	money	No	2500.00	The lifetime revenue budget of the insertion order's billing period.
billing_period.external_code	string	No	"houseware245"	The custom code for the billing period (budget_interval).
geo_country	string	Yes	"US"	The code for the geographic country. For impression requests for which we received no indication that the ad was rendered (i.e., non-transacted), country information is not provided.
geo_country_name	string	No	"United States"	The name of the geographic country. For impression requests for which we received no indication that the ad was rendered (i.e., non-transacted), country information may not be provided.
inventory_class	string	Yes	"class_1", "class_2", "class_3", "unaudited", "black"	The class of the inventory.
bid_type	string	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". 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"
imp_type_id	int	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	"Blank"	The type of impression. For possible values, see imp_type_id.
buyer_type	string	Yes	"Real Time"	The type of impression purchased by the buyer member. Possible values: "Real Time" or "Direct".
seller_type	string	Yes	"Real Time"	The type of impression sold by the seller member. Possible values: "Real Time" or "Direct".
revenue_type	string	Yes	"CPA"	The basis on which the member gets paid.
revenue_type_id	int	Yes	4	Possible values: -1 = No Payment 0 = Flat CPM 1 = Cost Plus CPM 2 = Cost Plus Margin 3 = CPC 4 = CPA 5 = Revshare 6 = Flat Fee 7 = Variable CPM 8 = Estimated CPM 9 = CPVM.
supply_type	string	No	"web"	The type of inventory. Possible values: - "web" - "mobile_web" - "mobile_app" - "facebook_sidebar".
payment_type	string	Yes	"cpm"	The type of payment to a broker. Possible values: - "cpm" - "revshare" - "cpvm".
deal_id	int	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	"Private deal for buyer 1085 with floor of $2.50"	The name of the deal.
deal_code	string	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.
media_type	string	No	"Standard Banner"	The specific display style of a creative. You can use the Media Subtype Service to view all possible media subtypes.
media_type_id	int	Yes	1	The ID of the specific display style of a creative. You can use the Media Subtype Service to view all possible media subtypes.
salesperson_for_advertiser	string	Yes	"Michael Sellers"	The salesperson for the advertiser. See the "labels" field in the Advertiser Service for more details.
account_manager_for_advertiser	string	Yes	"Yvonne Summers"	The account manager for the advertiser. See the "labels" field in the Advertiser Service for more details.
advertiser_type	string	Yes	"Local"	The type of advertiser. See the "labels" field in the Advertiser Service for more details.
salesperson_for_publisher	string	Yes	"Brian Young"	The salesperson for the publisher. See the "labels" field in the Publisher Service for more details.
account_manager_for_publisher	string	Yes	"Ami Fisher"	The account manager for the publisher. See the "labels" field in the Publisher Service for more details.
user_group_for_campaign	string	Yes	"Test"	The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.
line_item_type	string	Yes	"Performance"	A field describing the line item, provided by the user. See Line Item Service for more information.
insertion_order_type	string	Yes	"Client A Insertion Order"	A field describing the insertion order, provided by the user. See Insertion Order Service for more information.
buying_currency	string	Yes	"EUR"	The transaction currency used by the buyer to purchase this impression.
selling_currency	string	Yes	"EUR"	The transaction currency used by the seller to sell this impression.
imps_filtered_reason_id	int	Yes	"3"	The numeric ID associated with the reason why the impression request was filtered out by Xandr inventory quality controls and the auction was not held. See imps_filtered_reason below for more information.
imps_filtered_reason	string	Yes	"Invalid Domain"	The reason why the impression request was filtered out by Xandr's inventory quality controls and the auction was not held. Possible reasons are: - "Invalid Domain" (1) - "Invalid IP" (2) - "Suspected Domain Detection Tampering" (3, 4, 5) - "Unknown" (6, 7) - “White Ops: General IVT” (17) - consists of traffic identified through routine means of filtration, executed through application of lists or with other standardized parameter checks. - “White Ops: Sophisticated IVT” (18) - consists of more difficult to detect situations that require advanced analytics, multi-point corroboration/coordination, significant human intervention, etc., to analyze and identify. - "Valid Impression" (0) is also a valid filtered request reason, but in that case, an auction was held and it was not filtered.
marketplace_clearing_event_id	int	Yes	2	The ID of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For a list of Clearing Events and their IDs, see Supported Viewability Standards in the UI documentation.
marketplace_clearing_event_name	string	Yes	"Views - Standard Display"	The name of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Guaranteed Outcomes and Supported Viewability Standards in the UI documentation.
marketplace_clearing_event	string	No	"Views - Standard Display (2)"	The concatenated value of the name and ID of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Guaranteed Outcomes and Supported Viewability Standards in the UI documentation.
line_item.trafficker_label	string	Yes	"My trafficker"	A customer reporting label field used to list the trafficker associated with the line item.
line_item.salesrep_label	string	Yes	"My salesrep"	A customer reporting label field used to list the sales representative associated with the line item.
insertion_order.trafficker_label	string	Yes	"My trafficker"	A customer reporting label field used to list the trafficker associated with the insertion order.
insertion_order.sales_rep_label	string	Yes	"My salesrep"	A customer reporting label field used to list the sales representative associated with the insertion order.
insertion_order.lifetime_pacing	int	No	11	The lifetime pacing budget for the insertion order.
line_item.type_label	string	Yes	"My LI"	A custom reporting label field used to list the line item type (e.g., Retargeting LI). This is not the same as the line_item_type attribute.
insertion_order.type_label	string	Yes	"My IO"	A custom reporting label field used to list the insertion order type (e.g., Branding IO). This is not the same as the insertion_order_type attribute.
payment_type_id	int	Yes	5	The ID for the payment type i.e. how the buyer is paying for the impression (Flat CPM, CPC, CPA etc.).
bid_type_id	int	Yes	7	The ID for the bid type (Manual, Learn, Optimize etc.).
billing_period_id	int	Yes	9	The ID of the billing period for the insertion order.
viewdef_definition_id	int	Yes	11	The definition id for the custom viewability.
mediatype_id	int	Yes	23	The ID of the media type associated with the creative that served on an impression.
bidder_id/filtered_bidder	int	Yes	123	The bidder ID extracted from the member ID. Note: The filtered_bidder is not a dimension, it is only a filter.
bidder	string	No	"My bidder(123)"	The name and ID of the bidder extracted from the member ID.
bidder_name	string	No	"My bidder"	The name of the bidder extracted from the member ID.
buyer_payment_event_type_id	int	Yes	123	The ID of the market place clearing event that the buyer paid on.
buyer_payment_event_type_name	string	No	"My event"	The name of the market place clearing event that the buyer paid on.
buyer_payment_event_type	string	No	"My event(123)"	The name and ID of the market place clearing event that the buyer paid on.
buyer_payment_event_units	int	Yes	133	The number of the marketplace clearing event units that the buyer paid on.
seller_revenue_event_type_id	int	Yes	123	The ID of the market place clearing event that the seller paid on.
seller_revenue_event_type_name	string	No	"My event"	The name of the market place clearing event that the seller paid on.
seller_revenue_event_type	string	No	"My event(123)"	The name and ID of the market place clearing event that the seller paid on.
seller_revenue_event_units	int	Yes	123	The number of the marketplace clearing event units that the seller paid on.
_realtime_status_batch	string	No	"Batch"	The static batch value for the real time status.
billing_period_external_code	int	No	89	The optional external code supplied for the insertion order's billing period.
flight_id	int	Yes	67	The ID of the line item flight under which the impression was purchased.
line_item.lifetime_pacing	int	No	800	The lifetime pacing budget for the line item.
buyer_seat_code	string	No	"My buyer seat(123)"	The custom buyer seat ID (submitted by DSP) that was used to bid on the impression
buyer_seat_name	string	No	"My buyer seat"	The display name for the buyer seat code
is_curated	boolean	Yes	"Yes"	Boolean value to specify if a deal is curated.
curator_member_id	int	Yes	23	The member ID of the deal curator.
split_id	int	Yes	13	The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.
split_name	string	No	"My split"	The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.
split	string	No	"My split(123)"	The ID and name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.
buyer_seat_id	int	Yes	11	The ID of the buyer seat.
campaign_group_type_id	int	Yes	12	The ID of the campaign group type which purchased this impression.
content_category_id	int	No	11	Deprecated.
fold_position_id	int	No	10	Deprecated.
fold_position	string	No	"My fold"	Deprecated.
inventory_source_id	int	No	3	Deprecated.
inventory_source	string	No	"My inv source(3)"	Deprecated.
inventory_source_name	string	No	"My inv source"	Deprecated.
content_category	string	No	"My category(11)"	Deprecated.
content_category_name	string	No	"My category"	Deprecated.
buyer_member	string	No	"My Network (123)"	Deprecated.
seller_member	string	No	"That Seller (456)"	Deprecated.	``
advertiser	string	No	"Verizon Wireless (789)"	Deprecated.
publisher	string	No	"Newscorp (321)"	Deprecated.
deal	string	No	"Private deal for buyer 1085 with floor of $2.50 (45)"	Deprecated.
brand	string	No	"Ace Hardware (3)"	Deprecated.
creative	string	No	"Q1 2010 728x90 (554)"	Deprecated.
campaign	string	No	"Default Campaign (222)"	Deprecated.
line_item	string	No	"Default Line Item (111)"	Deprecated.
insertion_order	string	No	"Insertion Order (321)"	Deprecated.
site	string	No	"Site Name (194)"	Deprecated.
placement	string	No	"Ivillage 160x600 (456)"	Deprecated.
pub_rule	string	No	"Publisher Rule Name (555)"	Deprecated.
code_1	string	No	"Code A"	An alias added to the placement object that is reportable as a sub-dimension of Placement. The report shows the current value of the alias and does not reflect historical values. This information is only reportable to Sellers.
code_2	string	No	"Code B"	An alias added to the placement object that is reportable as a sub-dimension of Placement. The report shows the current value of the alias and does not reflect historical values. This information is only reportable to Sellers.
code_3	string	No	"Code C"	An alias added to the placement object that is reportable as a sub-dimension of Placement. The report shows the current value of the alias and does not reflect historical values. This information is only reportable to Sellers.

Metrics

Column	Type	Example	Formula	Description
imps	int	2340	imps	The total number of impressions (served and resold).
imps_blank	int	3	imps_blank	The number of impressions served with a blank.
imps_psa	int	5	imps_psa	The number of impressions served a PSA.
imps_psa_error	int	0	imps_psa_error	The number of impressions served a PSA due to a timeout issue or lack of a default creative.
imps_default_error	int	0	imps_default_error	The number of impressions that defaulted due to a timeout issue.
imps_default_bidder	int	0	imps_default_bidder	The number of impressions that defaulted because there were no valid bids.
imps_kept	int	0	imps_kept	The number of impressions your advertiser purchased from your publisher.
imps_resold	int	0	imps_resold	The number of impressions your publisher sold to a third party.
imps_rtb	int	2332	imps_rtb	The number of impressions your advertiser bought from a third party.
imp_requests	int	10	imps_requests	The total number of ad calls (impression requests). Warning: This metric is typically inaccurate for video inventory due to occasional delays in receiving video events, which can lead to inflated request totals based on the assumption that the video has expired. For a better video request metric, you should use Ad Requests in the Seller Fill and Delivery Network Report or the Network Video Analytics Report.
imps_insertion	int	10	imps_insertion	The total number of impressions bought from the insertion order perspective.
external_impression	int	0	external_impression	The number of impressions from an impression tracker.
viewdef_viewed_imps	int	2350	viewdef_viewed_imps	Viewable impressions with a different viewability definition (i.e., different from the viewability definition of IAB). It is equivalent to custom viewability.
viewdef_view_rate	double	67%	viewdef_view_rate	The rate for impressions with a different viewability definition (i.e., different from the viewability definition of IAB). It is equivalent to custom viewability.
clicks	int	1	clicks	The total number of clicks across all impressions. For Microsoft Invest, clicks from all media types are supported. For external DSPs, only clicks from Native and Video media types are supported.
include_adjustments_in_reported_data	boolean	Yes	NA	Check to include adjustments in the report while generating
click_thru_pct	double	1.12359550561797%	(clicks / imps) x 100	The rate of clicks to impressions as a percentage.
external_click	int	0	external_click	The number of external clicks.
cost	money	16.833378	cost	The total amount of media cost for direct publisher and purchased real-time inventory.
cost_including_fees	money	19.281633	cost + serving_fees	Deprecated.
third_party_costs	money	19.281633	third_party_costs	The cost incurred for purchasing of third party inventory.
revenue	money	25.767257	booked_revenue + reseller_revenue	The sum of booked revenue and reseller revenue.
revenue_including_fees	money	25.767257	revenue - commissions	Deprecated.
booked_revenue	money	25.767257	booked_revenue	The total revenue booked through direct advertisers (line item).
booked_revenue_adv_curr	money	25.767257	booked_revenue_adv_curr	The total revenue booked through a direct advertiser, in the currency of the advertiser.
booked_revenue_vcpm_adv_curr	money	25.767257	booked_revenue_vcpm_adv_curr	The total vcpm revenue booked through a direct advertiser, in the currency of the advertiser.
booked_revenue_ecpc	money	25.767257	booked_revenue_ecpc	Booked revenue per click.
booked_revenue_ecpa	money	25.767257	booked_revenue_ecpa	Booked revenue per acquisition.
booked_revenue_ecpa_buying_currency	money	25.767257	booked_revenue_ecpa_buying_currency	Booked revenue per acquisition in buying currency.
booked_revenue_ecpm	money	25.767257	booked_revenue_ecpm	Booked revenue per thousand impressions.
booked_revenue_ecpm_buying_currency	money	25.767257	booked_revenue_ecpm_buying_currency	Booked revenue per thousand impressions in buying currency.
booked_revenue_vcpm_adv_curr	money	25.767257	booked_revenue_vcpm_adv_curr	Booked revenue per thousand viewable impressions in advertiser currency.
booked_revenue_vcpm	money	25.767257	booked_revenue_vcpm	Booked revenue per thousand viewable impressions.
booked_revenue_ecpc_buying_currency	money	25.767257	booked_revenue_ecpc_buying_currency	Booked revenue per click in buying currency.
media_cost_advertiser_currency	money	25.767257	media_cost_advertiser_currency	The total amount to be paid for media purchases in advertiser currency.
media_cost_vcpm_advertiser_currency	money	25.767257	media_cost_vcpm_advertiser_currency	The total amount to be paid for media purchases of per thousand viewable impressions in advertiser currency.
media_cost_vcpm	money	25.767257	media_cost_vcpm	The total amount to be paid for media purchases of per thousand viewable impressions.
cost_ecpm_advertiser_currency	money	25.767257	cost_ecpm_advertiser_currency	The cost per 1,000 impressions in advertiser currency.
cost_ecpc_advertiser_currency	money	25.767257	cost_ecpc_advertiser_currency	The cost per click in advertiser currency.
cost_ecpa_advertiser_currency	money	25.767257	cost_ecpa_advertiser_currency	The cost per conversion in advertiser currency.
clearing_event_booked_revenue_per_event_buying_currency	money	25.767257	clearing_event_booked_revenue_per_event_buying_currency	Per event booked revenue of clearing events in buying currency.
clearing_event_booked_revenue_per_event	money	25.767257	clearing_event_booked_revenue_per_event	Per event booked revenue of clearing events.
clearing_event_buyer_media_cost_per_event	money	25.767257	clearing_event_buyer_media_cost_per_event	Per event buyer media cost of clearing events.
post_view_convs_pixel	int	23		Post view conversions for the pixel. For more information on how we attribute post-view (and other) conversions, see Conversion Attribution (Monetize) or Conversion Attribution (Invest).
post_clicks_convs_pixel	int	15		Post click conversions for the pixel. Post view conversions for the pixel. For more information on how we attribute post-view (and other) conversions, see Conversion Attribution (Monetize) or Conversion Attribution (Invest).
post_view_convs_cross_device	int	123	post_view_convs_cross_device	The number of the total post view conversion events that occurred as a result of having cross device enabled.
post_click_convs_cross_device	int	123	post_click_convs_cross_device	The number of the total post click conversion events that occurred as a result of having cross device enabled.
post_view_convs_ip	int	123	post_view_convs_ip	The number of the total post view conversion events that occurred as a result of having IPs enabled.
post_clicks_convs_ip	int	123	post_clicks_convs_ip	The number of the total post click conversion events that occurred as a result of having IPs enabled.
reseller_revenue	money	0	reseller_revenue	The total revenue on resold impressions through direct publishers.
profit	money	0.084102	booked_revenue - total_cost	Booked revenue minus total cost.
profit_including_fees	money	0.058959	revenue_including_fees - cost - serving_fees	Deprecated.
profit (net commissions/gross serving fees)	money	0.058959	revenue - serving_fees - commissions	Deprecated.
commissions	money	0	Commissions for standard line items, $0 for ALIs.	Fees that come out of the booked revenue.
cpm	money	1.66051685393258	(cost / imps) x 1000	The cost per 1000 impressions.
vcpm	money	1.66051685393258	(media_cost / imps_viewable) x 1000	The media cost per thousand viewable impressions.
cpm_including_fees	money	1.94302247191011	(cost_including_fees / imps) x 1000	Deprecated.
post_click_convs	int	3	post_click_convs	The total number of recorded post-click conversions. For more information on how we attribute post-view (and other) conversions, see Conversion Attribution (Monetize) or Conversion Attribution (Invest).
post_click_revenue	money	24.84	post_click_revenue	The revenue from post-click conversions.
post_view_convs	int	2	post_view_convs	The total number of recorded post-view conversions. For more information on how we attribute post-view (and other) conversions, see Conversion Attribution (Monetize) or Conversion Attribution (Invest).
post_view_revenue	money	12.42	post_view_revenue	The revenue from post-view conversions.
post_view_cross_device	int	5	post_view_cross_device	The number of post-view Cross Device conversions.
post_click_cross_device	int	5	post_click_ cross_device	The number of post-click Cross Device conversions.
total_convs	int	5	total_convs	The total number of post-view and post-click conversions.
convs_per_mm	double	221.877080097625	(total_convs / imps) x 1,000,000	The number of conversions per million impressions.
convs_rate	double	0.000221877080097626	total_convs / imps	The rate of conversions to impressions.
convs_bought	int	100	convs_bought	The number of conversions according to Xandr and the buyer.
clicks_bought	int	100	clicks_bought	The total number of clicks across all impressions according to Xandr and the buyer.
imps_bought	int	100	imps_bought	The total number of impressions (served and resold) according to Xandr and the buyer.
ctr	double	0.000221877080097626	clicks / imps	The rate of clicks to impressions.
total_rpm	money	2.60548314606741	(revenue / imps) x 1000	The revenue per 1000 impressions, including defaults, PSAs, and errors.
rpm	money	2.60548314606741	(revenue / imps) x 1000	The revenue per 1000 impressions.
rpm_including_fees	money	2.60548314606741	(revenue_including_fees / imps) x 1000	Deprecated.
total_network_rpm	money	2.60548314606741	(revenue / imps) x 1000	The revenue per 1000 impressions.
total_publisher_rpm	money	1.66051685393258	(cost / imps) x 1000	The cost per 1000 impressions.
sold_network_rpm	double	231.888	(revenue / imps) x 1000 ----- no errors	The revenue per 1000 impressions that were not defaults or errors.
sold_publisher_rpm	double	147.786	(cost / imps) x 1000 ----- no errors	The cost per 1000 impressions that were not defaults or errors.
media_cost_pub_curr	money	123.45	cost	The media cost, expressed in the currency of the publisher. Note: You must group by publisher or publisher_currency when pulling this report if you are reporting across publishers who use different currencies.
ppm	money	0.944966292134831	(profit / imps) x 1000	Deprecated.
ppm_including_fees	money	0.662460674157303	(profit_including_fees / imps) x 1000	Deprecated.
serving_fees	money	0.025143	Serving fees for standard line items, $0 for ALIs.	Fees that are added to the media cost. Serving fees for standard line items, $0 for ALIs.
imps_viewed	int	30,450	imps_viewed	The number of measured impressions that were viewable, per the IAB Viewability definition, which states that an impression is viewable if 50% of the pixels are in-view during 1 consecutive second.
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)
cpvm	money	2.25	(cost / imps_viewable) x 1000	The cost per 1000 viewable impressions. Note: This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.
imps_master_creative	int	1276	imps_master_creative	The total number of impressions from the master creative in page-level roadblocking. Note: This metric is in alpha testing and not available to all customers.
imps_filtered	int	2024	imps_filtered	The total number of bid requests for which Xandr did not hold an auction due to inventory quality concerns. See imps_filtered_reason_id and imps_filtered_reason (under Dimensions) for a list of the possible reasons.
avg_bid_reduction	double	18%	avg_bid_reduction	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 .
partner_fees	money	123.45	partner_fees	The total amount of third-party costs, budgeted using the Partner Fee Service, that have accrued on an augmented line item over the reported period of time.
partner_fees_buying_currency	money	123.45	partner_fees_buying_currency	The total amount of third-party costs, budgeted using the Partner Fee Service, that have accrued on an augmented line item over the reported period of time in buying (advertiser) currency.
total_cost_buying_currency	money	123.45	total_cost_buying_currency	The sum of media costs, total_feature_costs, total_segment_data_costs and partner fees in buying (advertiser) currency.
total_cost_selling_currency	money	123.45	total_cost_selling_currency	The sum of media costs, total_feature_costs, total_segment_data_costs and partner fees in selling (publisher) currency.
total_segment_data_costs	money	123.45	total_segment_data_costs	This includes all costs related to usage of segments in the data marketplace. Applicable when specific segments are applied in line items and associated pricing is displayed in the platform.
total_feature_costs	money	123.45	total_feature_costs	These are costs incurred when using a platform feature such as cross-device.
total_cost	money	123.45	total_cost = media_cost + total_feature_costs + total_segment_data_costs + partner_fees + commissions + serving_fees + publisher_revenue	The total amount of costs accrued over the reported period of time. This generally includes two types of costs, budgeted costs (media cost, data cost, partner fees, serving fees, commissions) and publisher revenue if you track publisher payouts on the platform. Note: We have added logic to prevent double counting third-party fees during the breaking change period.
total_cost_ecpm	money	123.45	(total_cost/imps) * 1,000	The total cost per 1,000 imps.
total_cost_ecpc	money	123.45	total_cost/clicks	The total cost per click.
total_cost_ecpa	money	123.45	total_cost/conversions	The total cost per conversion.
buyer_media_cost	money	123.45	media_cost	The amount of money paid by the buyer to Xandr, in dollars.
buyer_media_cost_ecpm	money	123.45	(media_cost/imps) * 1,000	The effective cost per thousand impressions (eCPM) based on media cost.
buyer_media_cost_ecpc	money	123.45	media_cost/clicks	The effective cost per click (eCPC) based on media cost.
buyer_media_cost_ecpa	money	123.45	media_cost/conversions	The effective cost per acquisition (eCPA) based on media cost.
network_profit	money	123.45	(booked_revenue + reseller_revenue) - total_cost	The sum of booked revenue and reseller revenue minus total cost.
network_profit_ecpm	money	123.45	(network_profit/imps) * 1,000	Network profit per 1,000 imps.
network_profit_ecpc	money	123.45	network_profit/clicks	Network profit per click.
network_profit_ecpa	money	123.45	network_profit/conversions	Network profit per conversion.
network_profit_margin	money	123.45	network_profit/(booked_revenue + reseller_revenue)	Network profit margin.
network_profit_buying_currency	money	123.45	(booked_revenue + reseller_revenue) - total_cost	The sum of booked revenue and reseller revenue minus total cost in buying (advertiser) currency.
network_profit_selling_currency	money	123.45	(booked_revenue + reseller_revenue) - total_cost	The sum of booked revenue and reseller revenue minus total cost in selling (publisher) currency.
profit_ecpm	money	123.45	((booked_revenue - total_cost)/imps) * 1,000	Profit per 1,000 imps. Note: This field defines "profit" as booked revenue minus total cost.
profit_ecpc	money	123.45	(booked_revenue - total_cost)/clicks	Profit per click. Note: This field defines "profit" as booked revenue minus total cost.
profit_ecpa	money	123.45	(booked_revenue - total_cost)/conversions	Profit per conversion. Note: This field defines "profit" as booked revenue minus total cost.
profit_margin	money	123.45	(booked_revenue - total_cost)/booked_revenue	Buyer profit margin. Note: This field defines "profit" as booked revenue minus total cost.
profit_advertiser_currency	money	123.45	booked_revenue - total_cost	Profit in buying (advertiser) currency.
video_skips	int	10	video_skips	The total number of times a user skipped the video. Use this metric for reporting when buying skippable inventory.
video_starts	int	11	video_starts	The total number of times the first segment of the video creative was downloaded and started.
video_25_pcts	int	10	video_25_pcts	The total number of times the video creatives completed 25% of the entire duration.
video_50_pcts	int	7	video_50_pcts	The total number of times the video creatives completed 50% of the entire duration.
video_75_pcts	int	10	video_75_pcts	The total number of times the video creatives completed 75% of the entire duration.
video_completions	int	12	video_completions	The total number of times the video creatives played for the entire duration.
video_served	int	10	video_served	The total number of video responses served to the player. An ad response occurs when the VAST document (XML) is served in response to a request. An ad response doesn't necessarily indicate a successful impression. For an impression, the first frame of the video must be served.
video_errors	int	2	video_errors	The total number of times a video error occurred.
revenue_per_video_complete	money	25.76	revenue/video_completions	The revenue per video completion.
cost_per_video_complete	money	22.76	cost/video_completions	The cost per video completion.
video_completion_rate	double	1.12359550561797%	(video completions/total impressions) x 100	The ratio of video completions to impressions, expressed as a percentage.
video_start_rate	double	1.12359550561797%	video_start_rate	The percentage of times the first segment of the video creative was downloaded and started.
video_skip_rate	double	1.12359550561797%	video_skip_rate	The percentage of times the user opted to skip the video.
buying_currency_total_segment_data_costs	money	123.45	total_segment_data_costs * advertiser_exchange_rate	All costs related to usage of segments in the data marketplace. It is applicable when specific segments are applied in line items and associated pricing is displayed in the platform. It is in the currency the buyer used to purchase the inventory.
selling_currency_total_segment_data_costs	money	123.45	total_segment_data_costs * publisher_exchange_rate	All costs related to usage of segments in the data marketplace. It is applicable when specific segments are applied in line items and associated pricing is displayed in the platform. It is in the currency the seller used to sell the inventory.
Metrics with local currency support
revenue_buying_currency	money	123.45	(booked_revenue + reseller_revenue) * [buying exchange rate]	The sum of booked revenue and reseller revenue in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
revenue_selling_currency	money	123.45	(booked_revenue + reseller_revenue) * [selling exchange rate]	The sum of booked revenue and reseller revenue in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
booked_revenue_buying_currency	money	123.45	booked_revenue * [buying exchange rate]	The total revenue booked through direct advertisers (line item) in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
booked_revenue_selling_currency	money	123.45	booked_revenue * [selling exchange rate]	The total revenue booked through direct advertisers (line item) in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
reseller_revenue_buying_currency	money	123.45	reseller_revenue * [buying exchange rate]	The total revenue on resold impressions through direct publishers in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
reseller_revenue_selling_currency	money	123.45	reseller_revenue * [selling exchange rate]	The total revenue on resold impressions through direct publishers in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
cost_buying_currency	money	123.45	cost * [buying exchange rate]	The total amount of media cost for direct publisher and purchased real-time inventory in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
cost_selling_currency	money	123.45	cost * [selling exchange rate]	The total amount of media cost for direct publisher and purchased real-time inventory in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
profit_buying_currency	money	123.45	profit * [buying exchange rate]	Profit (defined as booked revenue minus total cost) in the currency the buyer used to purchase inventory. Note: Exchange rates are not yet available in reporting.
profit_selling_currency	money	123.45	profit * [selling exchange rate]	Profit (defined as booked revenue minus total cost) in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
total_network_rpm_buying_currency	money	123.45	(revenue / imps) x 1000 * [buying exchange rate]	The revenue per 1000 impressions in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
total_network_rpm_selling_currency	money	123.45	(revenue / imps) x 1000 * [selling exchange rate]	The revenue per 1000 impressions in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
cpm_buying_currency	money	123.45	(cost / imps) x 1000 * [buying exchange rate]	The cost per 1000 impressions in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
cpm_selling_currency	money	123.45	(cost / imps) x 1000 * [selling exchange rate]	The cost per 1000 impressions in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
rpm_buying_currency	money	123.45	(revenue / imps) x 1000 * [buying exchange rate]	The revenue per 1000 impressions in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
rpm_selling_currency	money	123.45	(revenue / imps) x 1000 * [selling exchange rate]	The revenue per 1000 impressions in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
ppm_buying_currency	money	123.45	(profit / imps) x 1000 * [buying exchange rate]	To be deprecated. The profit per 1000 impressions in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
ppm_selling_currency	money	123.45	(profit / imps) x 1000 * [selling exchange rate]	To be deprecated. The profit per 1000 impressions in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
sold_network_rpm_buying_currency	money	123.45	(revenue / imps) x 1000 * [buying exchange rate] ----- no errors	The revenue per 1000 impressions that were not defaults or errors in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
sold_network_rpm_selling_currency	money	123.45	(revenue / imps) x 1000 * [selling exchange rate] ----- no errors	The revenue per 1000 impressions that were not defaults or errors in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
commissions_buying_currency	money	123.45	commissions * [buying exchange rate]	Fees that come out of the booked revenue in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
commissions_selling_currency	money	123.45	commissions * [selling exchange rate]	Fees that come out of the booked revenue in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
serving_fees_buying_currency	money	123.45	serving_fees * [buying exchange rate]	Fees that are added to the media cost in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
serving_fees_selling_currency	money	123.45	serving_fees * [selling exchange rate]	Fees that are added to the media cost in the currency the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
data_costs_buying_currency	money	123.45	data_costs * [buying exchange rate]	The total cost of 3rd party data used on the campaign in the currency the buyer used to purchase the inventory. Note: Exchange rates are not yet available in reporting.
data_costs_selling_currency	money	123.45	data_costs * [selling exchange rate]	The total cost of 3rd party data used on the campaign the seller used to sell the impression. Note: Exchange rates are not yet available in reporting.
marketplace_clearing_event_units	int	23	marketplace_clearing_event_units	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.
marketplace_clearing_event_units_cpm	double	11.2	CPM/marketplace_clearing_event_units	CPM by marketplace clearing event units
marketplace_clearing_events_booked_revenue_cpm	double	2.45	total revenue/1000 events	The total revenue per 1000 events (for the associated Clearing Event).
marketplace_clearing_event_buyer_media_cost_ecpm	double	2.37	total media cost/1000 events	The total media cost per 1000 events (for the associated Clearing Event).

Custom viewable definition metrics

Column	Type	Example	Formula	Description
viewdef_viewed_imps	int	4399	viewdef_viewed_imps	The number of measured impressions that were viewable, per the member-level custom definition configuration (for more details, contact your Xandr account representative).
viewdef_viewed_rate	double	96%	viewdef_viewed_imps / view_measured_imps	The percentage of impressions that were viewable, per the member-level custom definition configuration, out of the total number of impressions measured for viewability.

Example

Create a JSON formatted report request

The JSON file should include the report_type "network_analytics", as well as the columns (dimensions and metrics) and report_interval that you want to retrieve. You can also filter for specific dimensions, define granularity (year, month, day), and specify the format in which the data should be returned (csv, excel, or html). For a full explanation of fields that can be included in the JSON file, see the Report Service.

{code}$ cat network_analytics

{
    "report":
    {
        "report_type":"network_analytics",
        "columns":[
            "hour",
            "seller_member_name",
            "buyer_member_name",
            "advertiser_name",
            "publisher_name",
            "imps",
            "clicks",
            "total_convs",
            "ctr",
            "convs_rate"
        ],
        "report_interval":"last_48_hours",
        "format":"csv"
    }
}
{code}

POST the request to the reporting service

{code}$ curl -b cookies -X POST -d @network_analytics 'https://api.appnexus.com/report'
{
   "response":{
      "status":"OK",
      "report_id":"097f59fc3ab7d02c5d60db42081d9b69"
   }
}
{code}

GET the report status from the report service

Make a GET call with the report ID to retrieve the status of the report. Continue making this call until the execution_status is "ready". Then use the report-download service to save the reporting data to a file (described in the next step).

{code}$ curl -b cookies 'https://api.appnexus.com/report?id=097f59fc3ab7d02c5d60db42081d9b69'
{
   "response":{
      "status":"OK",
      "report":{
         "name":null,
         "created_on":"2010-05-25 19:19:53",
         "json_request":"{\"report\":{\"report_type\":\"network_analytics\",\"columns\":[\"hour\",\"seller_member_name\",
            \"buyer_member_name\",\"advertiser_name\",\"publisher_name\",\"imps\",\"clicks\",\"total_convs\",\"ctr\",\"convs_rate\"],
            \"row_per\":[\"hour\",\"seller_member_id\",\"buyer_member_id\",\"advertiser_id\",\"publisher_id\"],
            \"report_interval\":\"last_48_hours\"}}",
         "url": "report-download?id=b97897a7864dd8f34e7457226c7af592"
      },
      "execution_status":"ready"
   }
}
{code}

GET the report data from the report download service

To download the report data to a file, make another GET call with the report ID, but this time to the report-download service. You can find the service and report ID in the url field of the previous GET response. When identifying the file that you want to save to, be sure to use the file extension of the "format" that you specified in your initial POST.

Tip

If an error occurs during download, the response header will include an HTTP error code and message. Use -i or -v in your call to expose the response header.

{code}$ curl -b cookies 'https://api.appnexus.com/report-download?id=b97897a7864dd8f34e7457226c7af592' > /tmp/network_analytics.csv{code}

Note

There is a limit of 100,000 rows per report when you download them as XLSX and Excel file.