Search
Clear search
Close search
Google apps
Main menu
true

Create a query

Define the parameters for your report

DoubleClick: Create a Query

How to create a query

  1. Sign in to DoubleClick for Publishers.
  2. Click Reports and then Queries.
  3. Click New query.
  4. Enter a meaningful query name. 
  5. Choose the report type you need:
    • Historical
      View data on clicks, revenue, click-through rate, and total impressions for dates in the past.
    • Ad Exchange historical
      Create and run your Ad Exchange reports from within the DFP reporting tool.
    • Future sell-through
      View data on sell-through rate (STR) and forecasted, available, and reserved impressions for dates in the future.
    • Reach
      View the number of unique visitors exposed to different advertisers, orders, line items, or ad units in your network over a given time period.
    • Business intelligence
      View data on the revenue earned and impressions gained from the buyer or advertiser on both DFP and the Ad Exchange, as well as the aggregate revenue.
    • Data protection
      View data on cookies that are detected for each creative added to DFP, broken down by advertiser, order, line item, creative, and the specific technology vendor from which the cookie originated.
    • Sales
      Run reports for DFP sales management. DFP sales management must be enabled in your network to see this report type.
    • Partner finance
      This report type only applies to Track assignments and reflects host-partner revenue splits based on advanced financial configuration.
  6. Select the appropriate time zone (only applies to some report types).

    If you've chosen the Ad Exchange historical report type, decide whether or not to use the default DFP network time zone for your report output. If deselected, Pacific Standard Time (PST) is used.

  7. Choose a date range from a preset list of options.

    Select whether you want a Dynamic or Fixed date range type. A "day" in a given report is defined as midnight to midnight in the query's selected timezone. The actual dates used are available in the output of the report. If you select "Last 3 years" or a similar dynamic date range, the current day's data is not included in the report.

    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.
  8. (Optional) Click Add new filter to refine your report data and include only items you specify.
  9. Choose which data to display in your report by including report dimensions and metrics.

    There is a hard maximum of 10 dimensions. Use the "Recently Used" category to view those you most frequently select. Mouse over dimension or metric names to see a definition.

  10. (optional) Choose whether to schedule your query and share results.
  11. (optional) Add other users able to edit your query settings. 
  12. Save and run your query.
    • If you want to run the report later, click Save and give the report a meaningful name. If scheduled, your query will run according to the schedule you've defined. Otherwise, you can come back to run or edit this query in the future.
    • If you want to generate it now, click Run. An Estimated completion time displays to advise on the length of time it will take to complete the report. After your report has loaded, you can edit the report inline, send the report, or export the report.

Copy or delete a query

  1. Sign in to DoubleClick for Publishers.
  2. Click Reports and then Queries.
  3. Mark the checkbox next to one or more queries.
  4. Click Copy to copy the query, or click Delete to delete the query.
Was this article helpful?
How can we improve it?