Search
Clear search
Close search
Google apps
Main menu
true

Build reports from system queries

Create your report from a template

System queries can be thought of as templates for queries, with certain recommended items pre-selected. Use system queries to construct reports for your network over a given time period. Reports can be generated on either a one-time, daily, weekly, or monthly basis.

  1. Sign in to DoubleClick for Publishers.
  2. Click Reports and then Queries
  3. Click System queries at the top menu of the Queries page.
  4. Click on the query you'd like to run from the list of available system queries. Once you've clicked to create a system query, recommended dimensions and metrics will be pre-selected.

Customize report parameters

  • Date range
    Select a date range other than the pre-selected date range. If you want to schedule a weekly report, select "Last week (Mon-Sun)". If you want to schedule a monthly report, select "Last month".
    Limit the date range of your reports
    A broad date range selection, such as the dynamic date range of Last 3 years, may unfavorably impact your report performance. We strongly recommend that you choose a specific date range whenever possible.
  • Query editors
    Enter the DFP username or email address of people who will be allowed to edit the query.
  • Dimensions and metrics
    Select or deselect from the list of dimensions and metrics. If you're scheduling a weekly report, ensure you've selected "Week" and if you're scheduling a monthly report, ensure you've selected "Month and year".

Run and share your report

You can save or share your system queries, like any other query. When you save a system query, you are creating a new query, not editing the system query. The query will be listed on the "Queries" page. Select how often you want to run the report, the file type of the report, and optionally with whom you'd like to share the report.

Available system queries

Below are the system queries available for use as a starting point to build your own reports.

Historical report queries

System queries Description and recommended use
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.
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”.
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.
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).
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).
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.
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.
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.
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.
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.
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.

Future sell-through report queries

System queries Description and recommended use
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.
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.
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.

Business intelligence report queries

System queries Description and recommended use
Opportunity report
                                                  
Shows the impressions by ad unit which were not eligible to compete via dynamic allocation in the last week.
Unified yield report Learn about Revenue of DFP and Ad Exchange buyers and advertisers.
Was this article helpful?
How can we improve it?