Visualize results using Data Studio

Data visualization tools can help you make sense of the data that you get out of Ads Data Hub. Additionally, reports containing graphs and other such visual representations often communicate trends and insights about your data more effectively than numbers can alone.

Data Studio is a free tool for creating charts and interactive data visualizations. Ads Data Hub integrates natively with Data Studio, making it easy to view your results in Data Studio. After running a query in Ads Data Hub, you can open the results directly into Data Studio.

Objectives

This tutorial will teach you how to:

  • Run a templated query in Ads Data Hub.
  • Open your query results in Data Studio.
  • Create a report using Data Studio.

Before you begin

In order to successfully accomplish all the steps in this tutorial, you’ll need to have:

  • Access to an Ads Data Hub account.
  • Permission to run queries in that Ads Data Hub account.

Generate results to visualize

This section will guide you through running the Google Ads Demographics query. If you choose to use a different query, the steps in “Visualize results” below won’t apply.

  1. Navigate to the Ads Data Hub UI.
  2. Click + Create query.
  3. Under “Analysis”, click Choose template.
  4. Click Run next to “Demographics” in the Google Ads section.
  5. Under “Destination table”, enter information for the dataset that you want to write your results to.
  6. Under “Date range”, select the dates over which you want to query.
  7. Click Run.

Visualize results

  1. Navigate to the Jobs page.
  2. Click the job that you just ran.
  3. Open the Explore dropdown.
    1. Click Explore with Data Studio.

Create a column chart using a calculated field

  1. Optionally, click the title at the top of the page to change the name of your report.
  2. In the “Chart” menu, click Bar.
  3. The gender_id field should already be selected under “Dimension”, but if not, add it.
  4. Under “Breakdown dimension", click Add dimension.
    1. Select age_group_id from the menu.
  5. Under “Metric”, click Record count.
    1. Click Create field.
      1. Give the field a name, such as aggregated_users.
      2. In formula, enter SUM(aggregated_users).
      3. Click Apply.
  6. You should now have a report that resembles the one below:

Bar chart segmenting male/female/unknown gender types by age group.

What’s next