1. Unique visitors:
    SELECT count(host)
  2. Number of visits
    SELECT count(*) where referer notlike '%.<yoursite>.com'
  3. Number of page hits
    SELECT count(*) where path like '%.htm' or path like '%.html'
  4. Daily report of page hits
    SELECT date, count(*) where path like '%.htm' or path like '%.html'
  5. Unique visitors broken on Date
    SELECT date, count(host)
  6. Unique visitors broken on week
    SELECT weekofyear(date), count(host)
  7. Get all the refering URLs
    SELECT referer, count(*)
  8. Get all refering domains
    SELECT strtok(referer, '/', 3), count(*)
  9. Get all the keywords from google search
    SELECT urlattribute(referer, 'q'), count(*) where referer like '%.google.com/%'
  10. Goals
    SELECT count(*) where path = '/buy.html' and host in (select host where referer like '%.google.com/%')