Estimated reading time: 13 minutes

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 Français (Canada) Keywords Examples
top haut
  • top sales rep by count sales for average revenue > 10000
  • sales rep average revenue for each region top
bottom bas
  • 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 trier par
  • revenue by state sort by average revenue
  • revenue by customer sort by region

Date

English Keywords Français (Canada) Keywords Examples
after après order date after 10/31/2014
before avant order date before 03/01/2014
between … and ... entre … et … order date between 01/30/2012 and 01/30/2014
daily year-over-year quotidien année après année growth of revenue by order date daily year-over-year
daily quotidien shipments by region daily
day jour count monday restaurant
day of week jour de semaine revenue by day of week last 6 months
day of week jour de semaine count shipments Monday
n days for each month n jours pour chaque mois sales last 2 days for each month
n days for each quarter n jours pour chaque trimestre revenue last 15 days for each quarter
n days for each week n jours pour chaque semaine an total sold last 2 days for each week
n days for each year n n jours pour chaque an revenue last 300 days for each year
growth of … by … daily croissance de … par … quotidien growth of sales by order date daily
growth of … by … monthly croissance de … par … mensuel growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly croissance de … par … trimestriel growth of sales by date shipped quarterly
growth of … by … weekly croissance de … par … hebdomadaire growth of sales by receipt date weekly for pro-ski2000
growth of … by … yearly croissance de … par … annuel growth of sales by date closed yearly
growth of … by ... croissance de … par … growth of sales by order date
n hours for each day n heures pour chaque jour sales last 2 hours for each day
last day by dernier jour par customers last day by referrer
last month by dernier mois par customers last month by day
last n days dernier n jours visitors last 7 days
last n quarters dernier n trimestres visitors last 2 quarters by month by campaign
last n weeks dernier n semaines visitors last 10 weeks by day
last quarter dernier trimestre customers last quarter sale >300
last week dernier semaine customers last week by store
last year dernier an top 10 customers last year by sale by store for region west
last n years dernier n années visitors last 5 years by revenue for sum revenue >5000
month to date mois à ce jour sales by product month to date sales > 2400
month year mois an commission by sales rep February 2014
month mois commission January
month mois revenue by month last year
monthly year-over-year mensuel année après année growth of revenue by receipt date monthly year-over-year
monthly mensuel commission > 10000 monthly
n months for each quarter n mois pour chaque trimestre cost last 2 months for each quarter
n months for each year n mois pour chaque an last 8 months for each year
n days ago n jours depuis sales 2 days ago
n months ago n mois depuis sales 2 months ago by region
n months n mois visitors last 6 months for homepage visits > 30 by month
n quarters ago n trimestres depuis sales 4 quarters ago by product name contains "deluxe"
n weeks ago n semaines depuis sales 4 weeks ago by store
n years ago n années depuis sales 5 years ago by store for region west
n years n années opportunities next 5 years by revenue
next day suivant jour shipments next day by order
next month suivant mois appointments next month by day
next n days suivant n jours shipments next 7 days
next n months suivant n mois openings next 6 months location
next n quarters suivant n trimestres opportunities next 2 quarters by campaign
next n weeks suivant n semaines shipments next 10 weeks by day
next quarter suivant trimestres opportunities next quarter amount > 30000
next week suivant semaine shipments next week by store
next year suivant an opportunities next year by sales rep
quarter to date trimestre ce jour sales by product quarter to date for top 10 products by sales
quarterly year-over-year trimestriel année après année growth of revenue by date shipped quarterly year-over-year
quarterly trimestriel sales quarterly for each product
n quarters for each year n trimestres pour chaque an last 2 quarters for each year
today aujourd’hui sales today by store
week to date semaine à ce jour sales by order date week to date for pro-ski200
week semaine revenue by week last quarter
weekly year-over-year hebdomadaire année après année growth of revenue by date shipped weekly year-over-year
weekly hebdomadaire revenue weekly
n weeks for each month n semaines pour chaque mois sales last 3 weeks for each month
n weeks for each quarter n semaines pour chaque trimestre last 2 weeks for each quarter
n weeks for each year n semaines pour chaque an last 3 weeks for each year
year to date an à ce jour sales by product year to date
year an revenue by product 2014 product name contains "snowboard"
yearly annuel shipments by product yearly
yesterday hier sales yesterday for pro-ski200 by store

Time

English Keywords Français (Canada) Keywords Examples
detailed détaillée ship time detailed
last minute dernier minute count homepage views last minute
last hour dernier heure count unique visits last hour
n minutes n minutes count visitors last 30 minutes
n hours n heures count visitors last 12 hours
hourly horaire visitors by page name hourly
n minutes ago n minutes depuis sum inventory by product 10 minutes ago
n hours ago n heures depuis sum inventory by product by store 2 hours ago

Text

English Keywords Français (Canada) Keywords Examples
begins with commence par product name begins with 'pro'
contains contient product name contains "alpine" description contains "snow shoe"
ends with termine par product name ends with 'deluxe'
not begins with ne commence pas par product name not begins with "tom's"
not contains ne contient pas product color not contains 'tan' product color not contains 'red'
not ends with ne termine pas par product name not ends with "trial"
similar to semblable à course name similar to 'hand'
not similar to non semblable à course name not similar to 'hand'

Number

English Keywords Français (Canada) Keywords Examples
sum somme sum revenue
average moyenne average revenue by store
count compteur count visitors by site
max max max sales by visitor by site
min min min revenue by store by campaign for cost > 5000
standard deviation écart type standard deviation revenue by product by month for date after
unique count compte unique unique count visitor by product page last week
variance variance variance sale amount by visitor by product for last year

Comparative

English Keywords Français (Canada) Keywords Examples
all tout all
between... and entre … et revenue between 0 and 1000
vs, versus vs, contre 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 Français (Canada) Keywords Examples
near près de revenue store name county near san francisco
near... within n miles|km|meters près de … dans n milles|km|mètres revenue store name county near alameda within 50 miles
farther than n miles|km|meters from plus loin que n milles|km|mètres depuis average hours worked branch farther than 80 km from scarborough

Period

English Keywords Français (Canada) Keywords Examples
quarter (date) trimestre (date) quarter (purchase date)
quarter of year (date) trimestre de l’année (date) quarter of year (purchase date)
month of quarter (date) mois du trimestre (date) month of quarter (purchase date)
week of year (date) semaine de l’année (date) week of year (ship date)
week of quarter (date) semaine du trimestre (date) week of quarter (ship date)
week of month (date) semaine du mois (date) week of month (ship date)
day of year (date) jour de l’année (date) day of year (ship date)
day of quarter (date) jour du trimestre (date) day of quarter (ship date)
day (date) jour (date) day (ship date)
day of month (date) jour du mois (date) day of month (order date)
day of week (date) jour de semaine (date) day of week (order date)
hour (datetime) heure (datetime) hour (timestamp)