Export line item data to a spreadsheet

You can export data about line items to a spreadsheet in XLSX or XLS format. The data can either be for the line items in a particular order, or for a filtered list of line items. Note that selecting line items in a table does not limit the line items that will be exported.

Don't export too many line items at one time
This feature is designed to export a single order or a small filtered list of line items. Attempts to export data for a large number of line items or for all of the line items in your network are likely to take a long time or be canceled. If you need to export large amounts of data, use the Ad Manager API.

How to export line items

Export an order's line items

1. Sign in to Google Ad Manager.
2. Click Delivery Orders.
3. Use filters to find your order and click its name to open the settings.
4. Click Export order .xlsx (Excel 2007+) or .xls (Excel 2003).

Export a filtered list of line items

1. Sign in to Google Ad Manager.
2. Click Delivery Line items.
3. Use filters to find the line items you want to export and select the checkboxes next to them.
4. Click Export line items .xlsx (Excel 2007+) or .xls (Excel 2003).

What's included in the exported file

If you export an entire order from the order summary page, the downloaded file contains information about the advertiser, budget, and other summary information.

All line item exports contain the following information:

Column	Description
Order	The name of the order that contains this line item.
Line item	The name of the line item.
Line item type	The name of the line item type assigned.
Order ID	The ID of the order that contains this line item.
Line item ID	The ID of the line item.
Line item start time	The start date and time of the line item. For example, "September 27, 2016 11:31:00 AM".
Line item end time	The end date and time of the line item. For example, "June 30, 2016 11:59:00 PM". if a line item doesn't have an end date, this field is blank.
Automatic extension days	The number of days, if the line item has a grace period configured. Only available in Google Ad Manager 360.
Duration	The time span used to measure goals and pacing: "Lifetime" for goal-based line items, such as Standard or Bulk. "Daily" for weight-based line items, such as Sponsorship or Network. "None" for Ad Exchange or click-tracking line items.
Status	The line item delivery status, such as "Ready" or "Delivering".
Reservation status	Whether the line item is considered in Ad Manager inventory forecasts. "Reserved" for line items that have been activated. "Unreserved" for non-guaranteed line items, or guaranteed line items that haven't been activated.
Unit type	The line item's primary reporting metric, either "Impressions" or "Clicks".
Cost type	The line item's cost type, such as "CPM" or "CPD".
Rate	The line item's rate as a decimal value, such as "2.75" or "4".
Value cost per unit	The line item's eCPM rate.
Goal quantity	The line item's quantity value.
Contracted quantity	The line item's contracted quantity, or minimum quantity, if defined. Only available in Google Ad Manager 360.
Budget	The total calculated budget for the line item as a decimal value, based on the Goal quantity and Rate values.
Line item lifetime impressions	The total number of impressions delivered.
Line item lifetime clicks	The total number of clicks recorded.
Line item priority	The numeric priority value assigned to the line item.
Frequency cap	The frequency caps applied to the line item. For example, "2 impressions per 1 day".
Delivery pacing	The "Deliver impressions" setting value for a line item.
Companion delivery option	The "Display creatives" setting value, if multiple sizes are defined for the line item. Use the "Number of creatives" column in this export to see the number of creative sizes targeted by a line item.
Placement targeting	A comma-separated list of placements targeted by the line item. If no placements are targeted, this column contains "-".
Ad unit targeting	A comma-separated list of ad units included in the line item's targeting. If no ad units are targeted, this column contains "Run of network". Ad unit hierarchy is portrayed using ">". For example, "Sports > Baseball".
Excluded ad units	A comma-separated list of ad units explicitly excluded from the line item's targeting. If no ad units are excluded, this column contains "-". Ad unit hierarchy is portrayed using ">". For example, "Sports > Baseball".
Custom targeting	A textual representation of the key-values and CMS metadata included in the line item's targeting. For example, "(color = "blue" OR shape = "circle")".
Targeted locations	A comma-separated list of geographical locations included in the line item's targeting. For example, ""Paris", "Germany"".
Excluded locations	A comma-separated list of geographical locations explicitly excluded from the line item's targeting. For example, ""Paris", "Germany"". If no geographic locations are included in targeting, this column is blank. If geographic locations are included, but no locations are explicitly excluded, this column contains "-".
Targeted sizes	A comma-separated list of creative sizes targeted by the line item. For example, "160x600, 728x90".
Number of creatives	The number of sizes included in the "Targeted sizes" column. This is the number of creative sizes targeted by a line item, not the number of creatives associated with the line item.
Creative rotation type	The "Rotate creatives" setting value for a line item.
Line item lifetime viewable impressions	The total number of viewable impressions recorded.
External Line Item ID	The user-defined External ID value assigned to the line item. Only available in Google Ad Manager 360.
Non-delivery causes	Information about why a line item didn't deliver, even though it was eligible for an ad request.