Database Reference
In-Depth Information
This dataset is readable by any BigQuery user, but the contents of the table
depend on the user querying the table. The data made available corresponds
to the AdSense accounts that you are authorized to access. This has the
advantage that there is no special required setup; if you have access to
BigQuery, you have access to your AdSense data in BigQuery. However, it
has the disadvantage that it is not actually possible to share queries because
different users see different data, and you do not have any control over the
lifetime of the data. The result of a query over these tables is a regular (either
anonymous or named) BigQuery table, which you can preserve indefinitely
and share independently of the source data.
Table Structure
The AdSense dataset contains five different tables, as shown in
Figure 14.2
,
which represent the same ad serving data aggregated by different
dimensions.
•
DailyDomainReport
•
DailyReport
•
DailyAdUnitReport
•
DailyUrlChannelReport
•
DailyCustomChannelReport
