Get started with the Ads Data Hub web UI

Key Term: Queries are now called Reports You may see these terms used interchangeably in the UI and documentation during the transition to Reports.

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 write a report that measures your total Campaign Manager 360 Data Transfer impressions from scratch, test it, and then run it.

Key Point: You can substitute cm_dt_impressions with a different table to see impressions from other datasets, such as google_ads_impressions.

Write your report

1. Navigate to the Queries tab.
2. Click + Create query to open the query editor.
3. Click add_circle.

4. In the report editor:

   1. Give your report a name.
   2. Paste in the following SQL:

   SELECT
     COUNT(*) AS impressions
   FROM adh.cm_dt_impressions
   ;
   

5. Save your report.

Test your report using the sandbox

Note: You should test your reports using the sandbox role before running them on production data. This can help you find problems faster.

1. Navigate to the Queries tab in Ads Data Hub.
2. Click the name of the report you wrote earlier.
3. Click Run in the upper left corner of the editor.
4. Select ADH Sandbox Customer from the Ads data from dropdown.
5. Specify where your report results should be written in the Destination table field.
6. Select start and end dates between 2018-08-18 00:00:00 and 2018-09-17 23:59:59. We recommend using the auto-populated 30-day range.
7. Click Start.

After the report finishes running, open the results in BigQuery. You should see a table that looks something like this:

Row	impressions
1	388204742

Once you're satisfied with the results of your test report, you're ready to run it on real data.

Run your report in Ads Data Hub

After testing your report using the sandbox role, you're ready to run it on real data.

1. Navigate to the Reports tab in Ads Data Hub.
2. Click the name of the report you want to run.
3. Click Run.
   • The expected number of bytes that the report will use shows at the top of the page.
4. Select an ID in the Ads data from field. This should be the account ID associated with the ads data you want to query. (If you would like to query sandbox data, select ADH Sandbox Customer.)
5. If using a match table, select the match table in the Match table from field.
6. Select the privacy mode. Learn more about privacy modes.
7. Specify where your report results should be saved in the Destination table field.
8. Enter start and end dates to determine the date range of your report.
9. Enter a time zone. This should match the time zone of the buying door.
10. Optional: Enter values for any parameters.
11. Click Run.