Get started with the Ads Data Hub web UI

  • Reports are composed of multiple elements, including a query, input and output configurations, a schedule, and execution data.

  • You can create and run reports in the Ads Data Hub web UI, similar to using the API, but ensure you have linked advertising accounts beforehand.

  • It is recommended to test your SQL queries using the sandbox before running them on production data to identify issues more quickly.

  • After testing your SQL, you can run it on real data by configuring input/output settings like data source, date range, time zone, and where to save the results in BigQuery.

  • Save and run your report after configuring all the necessary details.

You can use the web UI in Ads Data Hub to do many of the same tasks as you would using the API. This guide shows how to create a report and then run it. To get the most out of this tutorial, be sure you have linked at least one advertising account before beginning. To learn how to link your advertising accounts, see Link accounts to Ads Data Hub.

Create your report with a template

  1. In Ads Data Hub, open the Home page.
  2. Click Create a new report. The template library shows all available templates for the platforms you have linked. In this tutorial, you will create a report using a template.
  3. Choose a template and click Use template to create a report using this template. The SQL text of the template is displayed in the report definition section. You can click Edit query to modify the query at any time.
  4. Enter a name for the report.
  5. Configure the input and output for jobs run on this report:
    1. Select a data source in the Ads data from field. This should be the Ads Data Hub account ID associated with the ads data you want to query.
    2. Select a date range and time zone for the report. The report time zone should match the time zone of the linked ads account, such as a Google Ads account.
    3. Under Privacy noise settings, we recommend to set the toggle to the Use noise position. Learn more about privacy modes.
    4. Choose the BigQuery project, dataset, and table where your report results should be saved.
  6. Click + Set schedule to configure the report to run on a schedule.
  7. Toggle the schedule setting to the on position and select Day for the schedule interval. This setting schedules the report to be run every day at the designated time.
  8. Click Done to save the schedule and return to the report details page.
  9. Click Save to make your changes persist and let the report run on the schedule you defined, or click Run to run the report immediately.
    1. The results section shows information about the latest execution of the report. To view past results, select them from the Execution history list.

To learn more about advanced features of creating reports, such as parameters and schedules, see the detailed documentation in Create and run reports.

Previous
Use the API