This is legacy documentation, and may not be complete. To see the latest documentation, if you are a marketer, refer to the Marketers site. If you are a measurement partner, refer to the Measurement Partners site.
Stay organized with collections
Save and categorize content based on your preferences.
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.
Navigate to the Ads Data Hub UI.
Click + Create query.
Under “Analysis”, click Choose template.
Click Run next to “Demographics” in the Google Ads section.
Under “Destination table”, enter information for the dataset that you want to write your results to.
Under “Date range”, select the dates over which you want to query.
Click Run.
Visualize results
Navigate to the Jobs page.
Click the job that you just ran.
Open the Explore dropdown.
Click Explore with Data Studio.
Create a column chart using a calculated field
Optionally, click the title at the top of the page to change the name of your report.
In the “Chart” menu, click Bar.
The gender_id field should already be selected under “Dimension”, but if not, add it.
Under “Breakdown dimension", click Add dimension.
Select age_group_id from the menu.
Under “Metric”, click Record count.
Click Create field.
Give the field a name, such as aggregated_users.
In formula, enter SUM(aggregated_users).
Click Apply.
You should now have a report that resembles the one below:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-18 UTC."],[[["\u003cp\u003eAds Data Hub integrates with Data Studio, a free tool to visualize data with charts and interactive dashboards, for enhanced data analysis.\u003c/p\u003e\n"],["\u003cp\u003eThis guide explains how to run a query in Ads Data Hub and visualize the results in Data Studio, including creating a column chart.\u003c/p\u003e\n"],["\u003cp\u003eBefore starting, ensure you have access to an Ads Data Hub account and necessary permissions.\u003c/p\u003e\n"],["\u003cp\u003eThis tutorial uses a Google Ads Demographics query as an example but allows for user-defined queries.\u003c/p\u003e\n"],["\u003cp\u003eUsers can learn to share created Data Studio reports via a provided support link.\u003c/p\u003e\n"]]],["Data visualization tools, like the free Data Studio, enhance the understanding of Ads Data Hub data by using graphs. The tutorial guides users to run a templated query, such as the \"Demographics\" query, in Ads Data Hub, then open the results in Data Studio. Users then create a column chart using calculated fields, specifically by adding the gender_id and age_group_id, as well as the aggregated_users to their report. Finally, they should share the data studio reports.\n"],null,["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.\n\nData 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.\n\nObjectives\n\nThis tutorial will teach you how to:\n\n- Run a templated query in Ads Data Hub.\n- Open your query results in Data Studio.\n- Create a report using Data Studio.\n\nBefore you begin\n\nIn order to successfully accomplish all the steps in this tutorial, you'll need to have:\n\n- Access to an Ads Data Hub account.\n- Permission to run queries in that Ads Data Hub account.\n\nGenerate results to visualize\n\nThis 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.\n\n1. Navigate to the Ads Data Hub UI.\n2. Click **+ Create query**.\n3. Under \"Analysis\", click **Choose template**.\n4. Click **Run** next to \"Demographics\" in the Google Ads section.\n5. Under \"Destination table\", enter information for the dataset that you want to write your results to.\n6. Under \"Date range\", select the dates over which you want to query.\n7. Click **Run**.\n\nVisualize results\n\n1. Navigate to the Jobs page.\n2. Click the job that you just ran.\n3. Open the **Explore** dropdown.\n 1. Click **Explore with Data Studio**.\n\nCreate a column chart using a calculated field\n\n1. Optionally, click the title at the top of the page to change the name of your report.\n2. In the \"Chart\" menu, click **Bar**.\n3. The `gender_id` field should already be selected under \"Dimension\", but if not, add it.\n4. Under \"Breakdown dimension\", click **Add dimension** .\n 1. Select `age_group_id` from the menu.\n5. Under \"Metric\", click **Record count** .\n 1. Click **Create field** .\n 1. Give the field a name, such as `aggregated_users`.\n 2. In formula, enter `SUM(aggregated_users)`.\n 3. Click **Apply**.\n6. You should now have a report that resembles the one below:\n\nWhat's next\n\n- Learn how to [share Data Studio reports](https://support.google.com/datastudio/answer/7459147)."]]