Get started with the Ads Data Hub web UI

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

Write your query

  1. Navigate to the Queries tab.
  2. Click + Create query to open the query editor.
  3. Click Create blank query
  4. In the query editor:

    1. Give your query a name. (Note: this can't be changed after saving your query).
    2. Paste in the following query:
    SELECT
      COUNT(*) AS impressions
    FROM adh.cm_dt_impressions
    ;
    
  5. Save your query.

Test your query using the sandbox

  1. Navigate to the Queries tab in Ads Data Hub.
  2. Click the name of the query 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 query 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.
  7. Click Start.

After the query 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 query, you're ready to run it on real data.

Run your query in Ads Data Hub

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

  1. Navigate to the Queries tab in Ads Data Hub.
  2. Click the name of the query you want to run.
  3. Click Run () in the upper left corner of the editor.
  4. Select a customer in the Ads data from dropdown. (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 dropdown.
  6. Specify where your query results should be saved in the Destination table field.
  7. Enter start and end dates to determine the date range of your query.
  8. Click Run.