Database Reference
In-Depth Information
SELECT ad_format_code, ad_format_name
FROM [google.com:adsense-reports:Reports.DailyReport]
GROUP BY 1, 2
The results of this query are shown in
Table 14.1
.
Table 14.1
Ad Format Code to Name Mapping
ad_format_code ad_format_name
dynamic_image
Animated image
Flash
Flash
Image
Html
Text
text
You can save the resulting table permanently for use in joins to map from
codes to readable values. If you do this, you would want to periodically
regenerate the map because it can grow over time depending on the ads
served on your site.
DailyAdUnitReport
This table contains metrics for each of the ad units that you have defined
across the sites in your account. Because you control the definition of ad
units, the amount of data in this table depends on how many separate ad
units you define. The following dimensions are available in the table:
• All the dimensions available in the
DailyReport
table
•
ad_unit_id
•
ad_unit_[
code
,
name
]
•
ad_unit_size_[
code
,
name
]
Three separate fields, the
id
,
code
, and
name
, identify an
ad_unit
.
AdSense assigns the
id
and
code
, and the account manager chooses the
name for the unit. Because you can control the name, it is the simplest field
to use for joining against other data you might have describing the ad unit.
Here is a query that shows the sizes of ad units served on a given day: