Network analytics feed

  • Articolo

The Network Analytics Feed offers you extensive data on your network's buy-side and sell-side performance. The report_type for this feed is network_analytics_feed.

Note

How to fetch this feed?

For instructions on how to fetch this feed, see the example on the Bulk Reporting Feeds page.

Data retention period

This report's data is retained for 30 days, and is available at an hourly time granularity.

Dimensions

Column Type Example Description
hour time 2010-02-01 06:00:00 The year, month, day, and hour of the auction.
day time 2010-02-01 The year, month, and day of the auction.
month time 2010-02 The year and month of the auction.
adjustment_id int 890 The ID of the adjustment used to make changes to booked revenue and media cost values.
advertiser_id int 789 The ID of the advertiser. If the value is 0, either the impression was purchased by third-party buyer, or a default or PSA was shown.
advertiser_code int 789 This field returns the same value as advertiser_id. To map the ID to the external code for the advertiser, use the Lookup Service. If the value is 0, the impression was purchased by third-party buyer.
advertiser_currency string "USD" The currency of the advertiser.
bid_type string "Manual" The optimization phase the node was in when it bid for this impression.

Note: 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 What is a Venue? and Give Up in the UI documentation. 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"
buyer_member_id int 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
buyer_type string "Real Time", "Direct" The type of media purchased by the buyer member.
campaign_id int 222 The ID of the campaign.
creative_id int 50 The ID of the creative. For external click or impression trackers, this will be "External Clicks" or "External Imps". For imp_type = 6, no information is available in the creative_id field for this report. See the Seller Brand Review Report instead.
creative_frequency_bucket string "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_recency_bucket string "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.
deal_id int 456 The ID of the deal. For more information about negotiated deals between buyers and sellers, see Deal Service and Deal Buyer Access Service.
entity_member_id int 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.
external_inv_id int 8293 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.
geo_country string "US" The code of the geographic country.
height int 720 The height of the creative/placement.
imp_type string "Blank" 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.
insertion_order_id int 321 The ID of the insertion order. If the value is 0, the impression was purchased by a third-party buyer.
insertion_order_code int 321 This field returns the same value as insertion_order_id. To map the ID to the external code for the insertion order, use the Lookup Service. If the value is 0, the impression was purchased by a third-party buyer.
line_item_id int 111 The ID of the line item. If the value is 0, the impression was purchased by a third-party buyer.
line_item_code int 111 This field returns the same value as line_item_id. To map the ID to the external code for the line item, use the Lookup Service. If the value is 0, the impression was purchased by a third-party buyer.
media_type string "Banner" The general display style of a creative, for example, Banner, or Video. You can use the Media Type Service to view the complete list of media types.
mediatype_id int 4 The ID of the general display style of a creative. Possible values:
1 = Banner
2 = Pop
3 = Interstitial
4 = Video
5 = Test
6 = Expandable
8 = Skin
media_subtype string "Standard Banner" The specific display style of a creative, for example, In-Banner Video, or Standard VAST. You can use the Media Type Service to view the complete list of media subtypes.
media_subtype_id int 7 The ID of the specific display style of a creative.
pixel_id int 543 The ID of the pixel.
placement_id int 432 The ID of the placement.
placement_code string "Placement Code" The external code for the placement.
publisher_id int 772 The ID of the publisher.
publisher_code string 772 This field returns the same value as publisher_id. To map the ID to the external code for the publisher, use the Lookup Service. If the value is 0, the impression was purchased by a third-party buyer.
publisher_currency string "USD" The currency of the publisher.
pub_rule_id int 588 The ID of the publisher rule. This is the same as payment_rule_id.
pub_rule_code string "Pub Rule Code" The external code for the publisher rule.
seller_member_id int 892 The ID of the selling member.
seller_type string "Real Time", "Direct" The type of media sold by the selling member.
site_id int 673 The ID of the site.
site_code string "Site Code" The external code for the site.
size string "720x90" The size of the creative/placement.
width int 90 The width of the creative/placement
revenue_type string "CPA" The basis on which an advertiser pays the member.
payment_type string "com", "revshare" The basis on which the member pays a broker.
split_id int 342 The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_id (if included) will be null.

Metrics

Column Type Example Formula Description
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.
clicks int 1 clicks The total number of clicks across all impression.
commissions money 0 commissions Fees that come out of the booked revenue.
imps int 2340 imps The total number of impressions (served and resold).
media_cost money 16.833378 media_cost The total cost of the inventory purchased.
media_cost_pub_curr money 16.833378 media_cost_pub_curr The total cost of the inventory purchased, in the currency of the publisher.
network_advertiser_rpm money network_advertiser_rpm network_advertiser_rpm
network_advertiser_rpm_adv_curr money network_advertiser_rpm_adv_curr network_advertiser_rpm_adv_curr
network_resold_rpm double network_resold_rpm network_resold_rpm
post_click_convs int 3 post_click_convs The total number of recorded post-click conversions.
post_click_revenue money 12.90 post_click_revenue The total amount of recorded post-click revenue.
post_view_convs int 2 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 revenue.
ppm money 4.14 (profit / imps) x 1000 The profit per thousand impressions.
profit money 970.40 revenue - media_cost The total network revenue minus the network cost.
publisher_rpm_publisher_currency money 200.22 publisher_rpm_publisher_currency
reseller_revenue money 720.10 reseller_revenue The total revenue on resold impressions through direct publishers.
revenue money 1921.23 booked_revenue + reseller_revenue The sum of booked revenue and reseller revenue.
revenue_adv_curr money 1921.23 booked_revenue + reseller_revenue The sum of booked revenue and reseller revenue, in the currency of the advertiser.
rpm_adv_curr double 8.21 (revenue / imps) x 1000 The revenue per thousand impressions, in the currency of the advertiser.
serving_fees money 0.025143 serving_fees Fees that are added to the media cost.
total_convs int 5 total_convs The total number of post-view and post-click conversions.
total_network_rpm money 2.60548314606741 (revenue / imps) x 1000 The revenue per 1000 impressions.
total_publisher_rpm double 1.66051685393258 (media_cost / imps) x 1000 The cost per 1000 impressions.
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)
imps_master_creative int 100 imps_for_budget_caps_pacing The total number of impressions from the master creative in page-level roadblocking.

Example

For an example, see the Example section in Bulk Reporting Feeds.