Stay organized with collections
Save and categorize content based on your preferences.
Sharing insights about advertising campaigns facilitates communication with your team. It allows you to come together to evaluate past performance and use that data to make decisions about future campaigns.
Objectives
In this tutorial, you’ll learn how to:
Write a query using Ads Data Hub.
Share results from that query with stakeholders.
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.
The ability to run queries in that Ads Data Hub account.
Permission to read and write datasets in BigQuery.
Generate results to share
If you already have results that you’d like to share, you can skip this section.
In order to share results, you first need to generate results. This can be accomplished by either running a query that you—or someone on your team—has already written, or by using a templated query from the Ads Data Hub UI.
After your query finishes running, expand the row containing your job.
Click View table. This opens your results in BigQuery.
Share results
Since Ads Data Hub writes your results to a BigQuery table, you may want to process those results into a different format before sharing them with your team.
Navigate to your table in BigQuery.
Write a SQL query to obtain results from your table. This could be a simple SELECT * query if you’re already happy with the granularity of the results you obtained from Ads Data Hub.
Alternatively, you can query your data to drill down further and answer more specific questions.
Click Save results.
Using the dropdown, choose the format you want to receive your results in.
Note that if you choose to share your results via another BigQuery table, the people that you share it with will need viewer permissions to access the results in the table.
[[["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\u003eSharing advertising campaign insights enables improved team communication and data-driven decision-making for future strategies.\u003c/p\u003e\n"],["\u003cp\u003eThis guide teaches you to query data using Ads Data Hub and share the findings with stakeholders for collaborative analysis.\u003c/p\u003e\n"],["\u003cp\u003eTo follow this tutorial, you need access to an Ads Data Hub account with query execution permissions and BigQuery read/write access.\u003c/p\u003e\n"],["\u003cp\u003eSharing involves generating results by running queries, then processing and exporting them from BigQuery into a suitable format for your team.\u003c/p\u003e\n"]]],["To share advertising campaign insights, first, write and run a query in Ads Data Hub. View the results table in BigQuery. Then, refine these results by writing an SQL query to obtain the needed data. Save the refined data in your desired format from BigQuery. If saving to a BigQuery table, ensure recipients have viewer permissions. These shared insights facilitate team collaboration for evaluating past performance and planning future campaigns.\n"],null,["# Share insights about campaigns\n\nSharing insights about advertising campaigns facilitates communication with your team. It allows you to come together to evaluate past performance and use that data to make decisions about future campaigns.\n\nObjectives\n----------\n\nIn this tutorial, you'll learn how to:\n\n- Write a query using Ads Data Hub.\n- Share results from that query with stakeholders.\n\nBefore you begin\n----------------\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- The ability to run queries in that Ads Data Hub account.\n- Permission to read and write datasets in BigQuery.\n\nGenerate results to share\n-------------------------\n\nIf you already have results that you'd like to share, you can skip this section.\n\nIn order to share results, you first need to generate results. This can be accomplished by either running a query that you---or someone on your team---has already written, or by using a templated query from the Ads Data Hub UI.\n\n1. [Write a query](/ads-data-hub/marketers/guides/run-queries#create_a)\n2. [Run the query](/ads-data-hub/marketers/guides/run-queries#run_a)\n3. After your query finishes running, expand the row containing your job.\n4. Click **View table**. This opens your results in BigQuery.\n\nShare results\n-------------\n\nSince Ads Data Hub writes your results to a BigQuery table, you may want to process those results into a different format before sharing them with your team.\n\n1. Navigate to your table in BigQuery.\n2. Write a SQL query to obtain results from your table. This could be a simple `SELECT *` query if you're already happy with the granularity of the results you obtained from Ads Data Hub.\n 1. Alternatively, you can query your data to drill down further and answer more specific questions.\n3. Click **Save results**.\n4. Using the dropdown, choose the format you want to receive your results in.\n 1. Note that if you choose to share your results via another BigQuery table, the people that you share it with will need viewer permissions to access the results in the table.\n\nWhat's next\n-----------\n\n- Learn how to [visualize results using Data Studio](/ads-data-hub/marketers/guides/visualize_results).\n- Learn more about [authorized views](https://cloud.google.com/bigquery/docs/authorized-views) in BigQuery."]]
