Keyword Reference


Keyword Reference

Use the search bar to ask a question using column names, values and keywords. 

Basic Keywords

top n…ranked by…

top 10 sales rep ranked by revenue

top 25 sales rep ranked by average revenue for each region

top 5 sales rep ranked by count sales for average revenue > 10000

bottom n…ranked by… 

bottom 10 revenue ranked by average revenue by state

bottom 25 customer ranked by revenue for each sales rep

sort by

revenue by state sort by average revenue 

revenue by customer sort by region

Date Keywords

after order date after 10/31/2014
before order date before 03/01/2014
between … and … order date between 01/01/2012 and 01/01/2013
day of week  revenue by day of week last 6 months

revenue by week last quarter

month revenue by month last year
daily shipments by region daily
weekly revenue weekly
monthly commission > 10000 monthly
quarterly sales quarterly for each product
yearly shipments by product yearly
day of week count shipments Monday
month commission January
month year commission by sales rep February 2014
year revenue by product 2013 product name contains snowboard
yesterday sales yesterday for pro-ski200 by store
week to date sales by order date week to date for pro-ski200
month to date sales by product month to date sales > 2400
quarter to date sales by product quarter to date for top 10 products by sales
year to date sales by product year to date








customers last day by referrer

customers last week by store

customers last month by day

customers last quarter sale > 300

top 10 customers last year by sale by store for region west


      n days

      n weeks

      n months

      n quarters

      n years


visitors last 7 days

visitors last 10 weeks by day

visitors last 6 months for homepage visits > 30 by month

visitors last 2 quarters by month by campaign

visitors last 5 years by revenue for sum revenue > 5000

growth of ... by ...






growth of sales by order date

growth of sales by order date daily 

growth of sales by date shipped monthly sales > 24000

growth of sales by receipt date weekly for pro-ski2000

growth of sales by date shipped quarterly 

growth of sales by date closed yearly

daily year-over-year growth of revenue by order date daily year-over-year
weekly year-over-year growth of revenue by date shipped weekly year-over-year
monthly year-over-year growth of revenue by receipt date monthly year-over-year
quarterly year-over-year growth of revenue by date shipped quarterly year-over-year
yearly year-over-year growth of revenue by date closed yearly year-over-year
n days ago sales 2 days ago
n weeks ago sales 4 weeks ago by store
n months ago sales 2 months ago by region
n quarters ago sales 4 quarters ago by product name contains deluxe
n years ago sales 5 years ago by store for region west

Time Keywords



ship time detailed 





count homepage views last minute

count unique visits last hour


    n minutes        

    n hours    


count visitors last 30 minutes

count visitors last 12 hours


visitors by page name hourly

n minutes ago

n hours ago

sum inventory by product 10 minutes ago

sum inventory by product by store 2 hours ago

Text Keywords

begins with

product name begins with pro


product description contains ski contains 'snow shoe'

ends with

product name ends with deluxe

not begins with

product name not begins with basic

not contains    

product color not contains tan product color not contains red

not ends with

product name not ends with trial

Number Keywords


sum revenue


average revenue by store


count visitors by site 


max sales by visitor by site


min revenue by store by campaign for cost > 5000

standard deviation

standard deviation revenue by product by month for date after 10/31/2010

unique count

unique count visitor by product page last week


variance sale amount by visitor by product for last year

Filter Keywords


revenue between 0 and 1000


sum sale amount by visitor by product for last year sale amount > 2000


unique count visitor by product by store for sale amount < 20


count calls by employee lastname >= m


count shipments by city latitude <= 0


unique count visitor by store purchased products = 3 for last 5 days


sum sale amount region != canada region != mexico