Schedule and share query results

Generate reports on specified intervals and share the results

Queries can be set to generate reports on specified intervals on a recurring basis. You can schedule them to run automatically, and share them with different users without having to manually intervene each time the data from a given query is generated.

Scheduling is not supported for queries with fixed date ranges.

View related Skillshop training course

Schedule your query

  1. Sign in to Google Ad Manager.
  2. While creating a query or editing an existing query, go to the Scheduling and permissions section.
  3. Click edit in the "Generate report" section to change the value from "Once" to Daily, Weekly, or Monthly. Only queries with a date range less than 1 year can be scheduled.

    This selection determines how frequently a report will be generated from your query. After Ad Manager has processed data for the scheduled time period, scheduled reports run as early as possible in the next calendar day.

  4. Click Apply.
  5. (optional) Choose whether to share query results.
  6. Choose a file type for the shared report, such as CSV, XLSX, or Google Drive.
  7. Check Include header to display the following information in shared reports:
    • Unique, system-defined report ID
    • Timestamp of when the report was generated
    • Name of the network for which you ran the report
    • Name of the user who generated the report
    • Report date range
    • List of included metrics that are accredited by the MRC for Display, Video, and Rich Media including Mobile Web
  8. Check Include IDs to include separate ID columns, such as "Line item ID", in addition to the name columns.
  9. Check Notify creator if you want Ad Manager to email you with scheduled query results.
  10. Click Save and give the report a meaningful name. This query will run according to schedule you've defined.

Share query results

You can share reports generated from a query with your team, whether the query is scheduled or not. To find queries and reports you've run, click Reports and then Queries. Open the query to share, then follow the steps, below.

Share a scheduled query

  1. Sign in to Google Ad Manager.
  2. After scheduling your query, enter the name or email address of a person to Share results with. The list populates with your Ad Manager network's users and contacts as you type.

    For each person with whom you share results, you can decide whether to send them the report as an attachment only, link only, or both a link and attachment. Only send a link to users who have access to your Ad Manager network. Scheduled reports that are larger than 10.49MB are sent in a zip file.

    Share reports with people outside of your Ad Manager network
    You can share reports with people who are not registered users or contacts in Ad Manager. Enter their email address, then click the address when it displays in the drop-down.

    People not registered as a user or contact in your Ad Manager network won't have access to the Ad Manager user interface.

  3. Click Save and give the report a meaningful name. This query will run and be shared according to schedule you've defined.

Share a one-time query

  1. Sign in to Google Ad Manager.
  2. Create and run your query.
  3. Click Send and configure recipients after your report has loaded.
Was this helpful?
How can we improve it?