Search
Clear search
Close search
Google apps
Main menu

List of system queries

System queries are templates for your queries. Use system queries to construct reports for your network over a given time period. Learn how to generate a report from a system query.

Here are all of the system queries available for your use along with recommendations for their optimal use.

System queries Description/Recommended use for this query Report type
Currently running campaign report (all under an advertiser) Displays total impressions on all orders and their line items by advertisers which delivered yesterday. Commonly used filters are “Advertiser” to only show the data for one or a given set of advertisers or “Line Item Type” to limit the results for example for Sponsorship or Standard Line Items. Historical
Currently running campaign report (all under an order) View total impressions for all line items and their creatives by orders which delivered yesterday. Commonly used filters are “Advertiser” or “Order” to only show the data for one or a given set of advertisers or orders as well as “Order Start” or “Order End Date”. Historical
Creatives report Displays total impressions for all creatives by advertiser which delivered in the last month. Commonly used filters are “Creative Type” to limit data for example to “Third-party”-creatives only or “Creative Size” to limit data to one or more specific sizes. Historical
Monthly network performance report Shows delivered impressions and revenue by total, as well as split by ad server, in your network for the last month (can apply to Ad Exchange and AdSense). Historical
Daily network performance report Shows delivered impressions and revenue by total, as well as split by ad server, in your network broken down by day (can apply to Ad Exchange and AdSense).  Historical
Network geography report Displays delivered impressions and revenue by total, as well as split by ad server, in your network for the last month but additionally broken down by country. Commonly used filter is “country” to limit results to one or a set of countries. Historical
Monthly ad unit report View delivered impressions against the active top level ad units in your network for last month. Commonly used filter is “ad unit” to limit results to one or a set of ad units. Historical
Monthly placements report View delivered impressions against the active placements in your network for last month. Commonly used filter is “placement” to limit results to one or a set of placements. Learn more about the placements report. Historical
Remnant report Shows impressions in your network broken down by day which delivered in the last month via dynamic allocation to Ad Exchange and/or AdSense. Commonly used filter is “Ad Unit” to limit the results to specific parts of your inventory. Historical
Opportunity report Shows the impressions by ad unit which were not eligible to compete via dynamic allocation in the last week. Business intelligence
Unified yield report Learn about Revenue of DFP and Ad Exchange buyers and advertisers. Business intelligence
Device and browser report View impressions broken out by different targeting criteria such as browser and operating system for the last month. Commonly used filter is targeting. Historical
Inventory sell-through report View data on sell-through rate (STR) and forecasted, available, and reserved impressions for your network broken down by placements and their ad units for the next month. Commonly used filter is placement to limit results for one or more placements. Learn more about Future sell-through reports. Future sell-through
Network sell-through report View data on sell-through rate (STR) and forecasted, available, and reserved impressions for your network broken down by date for the next month. Commonly used filter is ad unit to limit results for certain parts of your inventory. Learn more about Future sell-through reports. Future sell-through
Geography sell-through report View data on sell-through rate (STR) and forecasted, available, and reserved impressions for your network broken down by country for the next month. Commonly used filter is “Country” to limit results for one or more countries. Learn more about Future sell-through reports. Future sell-through
Downloaded impressions View data on downloaded impressions for your network broken down by date, inventory types, device category, and ad unit for the last 7 days.   Historical
Was this article helpful?
How can we improve it?