Database Reference
In-Depth Information
Figure 14.2
AdSense dataset in BigQuery
Each of these tables has a date field so that you can access daily records.
They have a common set of metric fields that measure the performance of
ads:
•
ad_requests
•
matched_ad_requests
•
individual_ad_impressions
•
clicks
•
earnings
•
page_views
(only present in
DailyReport
and
DailyDomainReport
)
In addition, there are a few dimension fields present in all the tables:
•
ad_client_id
•
product_code
•
product_name
The remaining dimension fields vary across the five tables and are described
next in the description of each table. The fields in these tables should be
familiar to users who have managed AdSense accounts. For a full