Database Reference
In-Depth Information
DailyCustomChannelReport
You can configure custom channels in your accounts much like you can
define URL channels. However, with custom channels you control the
channel an ad unit is assigned to rather than have it be fixed by the URL
path. Again, this table is a breakdown of the
DailyReport
table with fields
added to identify the custom channel.
• All the dimensions available in the
DailyReport
table
•
custom_channel_id
•
custom_channel_[
code
,
name
]
The coverage of the individual tables concludes with a final example
computing the revenue rate broken down by custom channels.
SELECT
custom_channel_name,
SUM(earnings)/SUM(ad_requests) revenue_rate
FROM
[google.com:adsense-reports:Reports.DailyCustomChannelReport]
WHERE date >= '2014-01-01'
GROUP BY 1
Leveraging BigQuery
As you have seen, all these tables have simple flat schemas, so constructing
queries is straightforward. These kinds of results are accessible in the
AdSense UI, but the advantage of using BigQuery is that you can use your
own reporting and dashboard framework rather than relying on the
AdSense user interface. For example, you could use a tool like Tableau or
the BigQuery Excel Connector to analyze your data. You could also join the
data in these tables with other data you have, but keep in mind that you do
not have much control over the values of the fields, so it may be necessary
to transform your data to have field values suitable for joining against these
tables.
You may also want to save a full copy of your data to your own tables. The
advantage of doing this is that you can manage the lifetime of the data and
share it with other users without granting them access to your AdSense
account. A “SELECT *” query with the
allowLargeResults
flag set and a
