We've updated our documentation with the latest features and updates introduced by Ads Data Hub's two new experiences. Advertisers, agencies, and publishers, refer to the Marketers site. Vendors and partners, refer to the Measurement Partners site.
Stay organized with collections
Save and categorize content based on your preferences.
As a tool to help you operate more effectively amidst privacy checks in Ads Data Hub, the platform includes a synthetic dataset. Unlike normal data, this dataset isn’t subject to privacy checks, and as such should be used for experimentation and query development. The sandbox can improve your query development workflow by:
Running jobs faster. Because queries run on sandbox data aren't subject to privacy checks, your jobs will run faster.
Allowing you to inspect the underlying data. You can use SELECT * on sandbox data, giving you a better understanding of how your results could look.
Avoiding difference checks. Difference checks look at your query history, but aren't impacted by queries run on sandbox data. Learn more about difference checks
These improvements allow you to iterate on draft queries faster and can reduce the frequency of errors due to privacy checks. As such, Ads Data Hub recommends that you use sandbox data to develop queries whenever possible.
Sandbox data and privacy restrictions
Because the sandbox data is synthetic, Ads Data Hub relaxes certain privacy restrictions. For example, the following actions are only possible when querying sandbox data:
Running queries using SELECT *.
Running a series of similar queries. This is a common practice for
developing SQL queries, but doing so without using sandbox data makes it
more likely that your jobs will run into privacy check issues. Jobs run on
sandbox data won't impose data difference checks, allowing you to more
rapidly iterate on SQL. Learn more about privacy checks in
Ads Data Hub
Sandbox query workflow
The workflow for developing queries that use sandbox data is nearly identical to developing queries that use your own data. The only differences are:
When querying sandbox data, you can write queries that use SELECT *.
The date range will be automatically updated to "Aug 17 - Sep 18, 2018" to
match the contents of our sandbox data.
Sandbox jobs won't contribute to the execution history of your report.
To run queries on sandbox data, you must:
Run jobs from within the SQL editor of your report.
Select ADH Sandbox Customer from the Ads data from drop-down.
If you're using the API, you must use the specific sandbox account ID for
your region:
[[["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-11-11 UTC."],[[["Ads Data Hub's sandbox allows for faster query development and experimentation without privacy restrictions, leading to quicker iteration and reduced errors."],["Sandbox data is synthetic and relaxes certain privacy restrictions, enabling actions like using `SELECT *` and running similar queries repeatedly without triggering privacy checks."],["When using sandbox data, queries must be limited to a specific date range (2018-08-18 to 2018-09-17) and require selecting \"ADH Sandbox Customer\" as the data source."],["Sandbox usage involves a nearly identical workflow to regular queries, with the addition of specific date range and data source selections, along with the ability to utilize `SELECT *`."]]],["The Ads Data Hub platform offers a synthetic dataset, or \"sandbox,\" for query development and experimentation. This sandbox data is exempt from privacy checks, allowing for faster job runs and the use of `SELECT *`. It also avoids data difference checks, enabling users to run similar queries repeatedly. Queries on sandbox data don't affect report history. Users can access it within the SQL editor by selecting \"ADH Sandbox Customer\" or via the API using region-specific sandbox account IDs. The sandbox's date range is fixed to \"Aug 17 - Sep 18, 2018\".\n"]]
