Database Reference
In-Depth Information
WITHIN hits.customDimensions Item,
MAX(IF(hits.customDimensions.index = 3,
hits.customDimensions.value, NULL))
WITHIN hits.customDimensions Level
FROM [LondonCycleHelmet.ga_sessions_20130910])
LIMIT 100
In the example, the outer query was a trivial limit query. A realistic query
would use the generated Item and Level fields to do something useful.
Beyond querying, you can also export these tables to GCS if you want to
access the data as JSON. Because the tables have a nested schema you
cannot directly export them as CSV. However, you could run a query and
export the resulting table as CSV. You also need to manage the lifetime of
these tables because they count toward your storage usage in BigQuery.
Google AdSense
Google AdSense is a publisher product that allows content owners to use
advertisements from Google's inventory, collected from its network of
advertisers, to generate revenue from their sites. The Google AdSense
interface allows publishers to monitor the performance of ads on their sites
and discover the ad units that work well with their sites. For large publishers
it is more useful to have programmatic access to this data and AdSense
provides an API to access this data and now also provides access to this
data through BigQuery. The data accessible through either method does
not provide details of individual impressions or clicks. Instead it provides
daily rollups along important dimensions (ad unit, domain, channel, and
others). The amount of data can still be substantial because a large site
might display thousands of distinct ads each day, so it is still important to
filter and aggregate the data, which is simple in BigQuery.
The data is made available differently from Google Analytics. All users
access the same dataset:
google.com
:adsense-reports:Reports
Once again you can display this dataset in the BigQuery UI by navigating to
the dataset URL
https://bigquery.cloud.google.com/project/
