Database Reference
In-Depth Information
explanation of individual fields, refer to the AdSense API documentation
DailyDomainReport
The domain-level report is the least granular, broken down only by the
domain of the web page hosting the ads. It has a single dimension in
addition to the common dimensions.
•
domain_name
Here is a query that extracts page views for all days since January 1, 2014,
for a single domain:
SELECT date, page_views
FROM
[google.com:adsense-reports:Reports.DailyDomainReport]
WHERE domain_name = 'www.asciiflow.com'
AND date >= '2014-01-01'
ORDER BY 1
Note that the date field in these tables is a string field formatted as
YYYY-MM-DD
.
DailyReport
Here are the dimensions available in the
DailyReport
table:
•
ad_format_[
code
,
name
]
•
bid_type_[
code
,
name
]
•
targeting_type_[
code
,
name
]
•
platform_type_[
code
,
name
]
•
country_[
code
,
name
]
You can see that each dimension comes in code and name variants. The
name is a human-friendly representation of the code. It is often nicer to
work with codes because they are more strictly specified. For example, the
specifying countries. You can easily generate a table containing the mapping
from code to human-readable representation.