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 to test and run a query that measures your total Campaign Manager Data Transfer impressions.

Write your query

  1. Navigate to the Queries tab.
  2. Click + Create query to open the query editor.
  3. Click Start from scratch
  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 the play icon 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 saved in the Destination table field.
  6. Enter start and end dates to determine the date range of your query.
  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 + Create query.
  3. Select Choose template or Start from scratch.
    1. Choose template:
      1. Pick an applicable template.
        Preview a template's SQL by clicking the down arrow next to it.
    2. Start from scratch:
      1. Write BigQuery compatible SQL.
  4. Give your query a name.
  5. Optionally, add parameters to your query.
  6. Optionally, add a filtered row summaries to your query.
  7. Click Save.