Common AQL Queries

SELECT
  METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, 
     ga:entranceBounceRate ON COLUMNS
  DIMENSIONS ga:pagePath ON ROWS BY ga:pageviews DESC
FROM default
WHERE TIMEFRAME lastMonth, default

SELECT
  METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, 
      ga:entranceBounceRate ON COLUMNS
  DIMENSIONS ga:pageTitle ON ROWS BY ga:pageviews DESC
FROM default
WHERE TIMEFRAME lastMonth, default

SELECT
  METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS
  DIMENSIONS ga:source ON ROWS TOP 16 BY ga:visits DESC
FROM default
WHERE TIMEFRAME yesterday
FILTER ga:source != "(direct)"

SELECT
  METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, 
      ga:entranceBounceRate ON COLUMNS
  DIMENSIONS ga:source ON ROWS BY ga:visits
FROM default
WHERE TIMEFRAME lastMonth, default
FILTER ga:source == "twitter.com" OR ga:source == "facebook.com" 
     OR ga:source == "linkedin.com"

CUSTOMDIM sp:folders LABEL "Folders"
  MEMBER "Commercial" AS FILTER ga:pagePath =@ "/commercial/"
  MEMBER "Government" AS FILTER ga:pagePath =@ "/government/"
  MEMBER "Education" AS FILTER ga:pagePath =@ "/education/"
SELECT
  METRICS ga:pageviews, ga:avgTimeOnSite, ga:pageviewsPerVisit, 
        ga:entranceBounceRate ON COLUMNS
  DIMENSIONS sp:folders ON ROWS
FROM default
WHERE TIMEFRAME lastCalendarWeek

SELECT
  METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS
  DIMENSIONS ga:keyword ON ROWS TOP 10 NOOTHER BY ga:visits DESC
FROM default
WHERE TIMEFRAME lastCalendarWeek
FILTER ga:keyword != "(not set)"

SELECT
  METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS
  DIMENSIONS ga:source ON ROWS TOP 10 NOOTHER BY ga:visits DESC
FROM default
WHERE TIMEFRAME lastCalendarWeek
FILTER ga:visits != "0"
SEGMENT ga:medium == "referral"

SELECT
  METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS
  DIMENSIONS ga:source ON ROWS BY ga:visits DESC
FROM default
WHERE TIMEFRAME lastCalendarWeek
SEGMENT "Search Traffic"