Database Reference
In-Depth Information
SELECT ad_unit_name, ad_unit_size_code
FROM
[google.com:adsense-reports:Reports.DailyAdUnitReport]
WHERE date = '2014-01-04'
GROUP BY 1, 2
Because this table has all the dimensions present in the
DailyReport
table, it may seem like it makes that table redundant. However, note that
the page view metric is only available in the
DailyReport
table. Because a
single page view can contain multiple ad units, it is not possible to associate
a page view with rows in the ad unit table, which is why the metric does not
appear in this table. To use page views (generally to normalize totals by the
number of page views) you must work with the
DailyReport
table.
DailyUrlChannelReport
Just as the
DailyAdUnit
table is a breakdown of daily totals by ad units,
the
DailyUrlChannelReport
table contains the metrics broken down by
the URLs on which the ad unit was served. However, you must explicitly
create URL channels to track the URLs you are interested in before data will
be collected for a channel. The AdSense documentation describes how to set
up a URL channel. The dimensions in this table are:
• All the dimensions available in the
DailyReport
table
•
url_channel_id
•
url_channel_name
Like with the ad unit name, you control the channel name when you
configure it. Here is a sample query over this table that computes
click-through rates by URL channel:
SELECT
url_channel_name,
SUM(clicks)/SUM(individual_ad_impressions) ctr
FROM
[google.com:adsense-reports:Reports.DailyUrlChannelReport]
WHERE date >= '2014-01-01'
GROUP BY 1
