You can use keywords when asking a question to help define your search. This reference lists the various keywords. You can also see this list of keywords and examples from within the help center.

< Back to English Keywords page

General

English Keywords 日本語 Keywords Examples
top トップ
  • top sales rep by count sales for average revenue >10000
  • sales rep average revenue for each region top
bottom ボトム
  • bottom revenue average
  • bottom revenue by state
  • customer by revenue for each sales rep bottom
n n top 10 sales rep revenue
n n bottom 25 customer by revenue for each sales rep
sort by 次で並べ替え
  • revenue by state sort by average revenue
  • revenue by customer sort by region

Date

English Keywords 日本語 Keywords Examples
after 後 order date after 10/31/2014
before 前 order date before 03/01/2014
between … and ... 間 … および … order date between 01/30/2012 and 01/30/2014
daily year-over-year 日単位 前年比 growth of revenue by order date daily year-over-year
daily 日単位 shipments by region daily
day 日 count monday restaurant
day of week 曜日 revenue by day of week last 6 months
day of week 曜日 count shipments Monday
n days for each month 月毎の最後の n 日 sales last 2 days for each month
n days for each quarter 四半期毎の最後の n 日 revenue last 15 days for each quarter
n days for each week 週毎の最後の n 日 total sold last 2 days for each week
n days for each year 年毎の最後の n 日 revenue last 300 days for each year
growth of … by … daily 次の成長 ...により… 日単位 growth of sales by order date daily
growth of … by … monthly 次の成長 ...により… 月単位 growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly 次の成長 ...により… 四半期単位 growth of sales by date shipped quarterly
growth of … by … weekly 次の成長 ...により… 週単位 growth of sales by receipt date weekly for pro-ski2000
growth of … by … yearly 次の成長 ...により… 年単位 growth of sales by date closed yearly
growth of … by ... 次の成長 ...により… growth of sales by order date
n hours for each day 日毎の最後の n 時間 sales last 2 hours for each day
last day by 先日 customers last day by referrer
last month by 先月 customers last month by day
last n days 過去 n 日 visitors last 7 days
last n quarters 過去 n 四半期 visitors last 2 quarters by month by campaign
last n weeks 過去 n 週 visitors last 10 weeks by day
last quarter 前四半期 customers last quarter sale > 300
last week 先週 customers last week by store
last year 去年 top 10 customers last year by sale by store for region west
last n years 過去 n 年 visitors last 5 years by revenue for sum revenue > 5000
month to date 月初から今日まで sales by product month to date sales > 2400
month year 月 年 commission by sales rep February 2014
month 月 commission January
month 月 revenue by month last year
monthly year-over-year 月単位 前年比 growth of revenue by receipt date monthly year-over-year
monthly 月単位 commission > 10000 monthly
n months for each quarter 四半期毎の最後の n か月 cost last 2 months for each quarter
n months for each year 年毎の最後の n か月 last 8 months for each year
n days ago n 日前 sales 2 days ago
n months ago n か月前 sales 2 months ago by region
n months n 月 visitors last 6 months for homepage visits > 30 by month
n quarters ago n 四半期前 sales 4 quarters ago by product name contains "deluxe"
n weeks ago n 週前 sales 4 weeks ago by store
n years ago n 年前 sales 5 years ago by store for region west
n years n 年 opportunities next 5 years by revenue
next day 翌日 shipments next day by order
next month 来月 appointments next month by day
next n days 次の n 日 shipments next 7 days
next n months 次の n か月 openings next 6 months location
next n quarters 次の n 四半期 opportunities next 2 quarters by campaign
next n weeks 次の n 週 shipments next 10 weeks by day
next quarter 来四半期 opportunities next quarter amount > 30000
next week 来週 shipments next week by store
next year 来年 opportunities next year by sales rep
quarter to date 四半期初から今日まで sales by product quarter to date for top 10 products by sales
quarterly year-over-year 四半期単位 前年比 growth of revenue by date shipped quarterly year-over-year
quarterly 四半期単位 sales quarterly for each product
n quarters for each year 年毎の最後の n 四半期 last 2 quarters for each year
today 今日 sales today by store
week to date 週初から今日まで sales by order date week to date for pro-ski200
week 週 revenue by week last quarter
weekly year-over-year 週単位 前年比 growth of revenue by date shipped weekly year-over-year
weekly 週単位 revenue weekly
n weeks for each month 月毎の最後の n 週 sales last 3 weeks for each month
n weeks for each quarter 四半期毎の最後の n 週 last 2 weeks for each quarter
n weeks for each year 年毎の最後の n 週 last 3 weeks for each year
year to date 年初から今日まで sales by product year to date
year 年 revenue by product 2014 product name contains "snowboard"
yearly 年単位 shipments by product yearly
yesterday 昨日 sales yesterday for pro-ski200 by store

Time

English Keywords 日本語 Keywords Examples
detailed 詳細 ship time detailed
last minute 1分前 count homepage views last minute
last hour 1時間前 count unique visits last hour
n minutes n 分 count visitors last 30 minutes
n hours n 時間 count visitors last 12 hours
hourly 時間単位 visitors by page name hourly
n minutes ago n 分前 sum inventory by product 10 minutes ago
n hours ago n 時間前 sum inventory by product by store 2 hours ago

Text

English Keywords 日本語 Keywords Examples
begins with 次で始まる product name begins with 'pro'
contains 次を含む product name contains "alpine" description contains "snow shoe"
ends with 次で終了する product name ends with 'deluxe'
not begins with 次で始まらない product name not begins with "tom's"
not contains 次を含まない product color not contains 'tan' product color not contains 'red'
not ends with 次で終了しない product name not ends with "trial"
similar to 次と類似する course name similar to 'hand'
not similar to 次と類似しない course name not similar to 'hand'

Number

English Keywords 日本語 Keywords Examples
sum 合計 sum revenue
average 平均 average revenue by store
count カウント count visitors by site
max 最大 max sales by visitor by site
min 最小 min revenue by store by campaign for cost > 5000
standard deviation 標準偏差 standard deviation revenue by product by month for date after
unique count 一意のカウント unique count visitor by product page last week
variance 分散 variance sale amount by visitor by product for last year

Comparative

English Keywords 日本語 Keywords Examples
all すべて all
between... and 間 … および revenue between 0 and 1000
vs, versus 対、対 revenue east vs west
> > 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

Location

English Keywords 日本語 Keywords Examples
near 近い revenue store name county near san francisco
near... within n miles|km|meters 近い...以内 n マイル|キロメートル|メートル revenue store name county near alameda within 50 miles
farther than n miles|km|meters from 以上 n マイル|キロメートル|メートル average hours worked branch farther than 80 km from scarborough

Period

English Keywords 日本語 Keywords Examples
quarter (date) 四半期 (date) quarter (purchase date)
quarter of year (date) 年の四半期 (date) quarter of year (purchase date)
month of quarter (date) 四半期の月 (date) month of quarter (purchase date)
week of year (date) 年の週 (date) week of year (ship date)
week of quarter (date) 四半期の週 (date) week of quarter (ship date)
week of month (date) 月の週 (date) week of month (ship date)
day of year (date) 年の日付 (date) day of year (ship date)
day of quarter (date) 四半期の日付 (date) day of quarter (ship date)
day (date) 曜日 (date) day (ship date)
day of month (date) 月の日付 (date) day of month (order date)
day of week (date) 曜日 (date) day of week (order date
hour (datetime) 時間 (datetime) hour (timestamp)