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 Deutsche Keywords Examples
top oben
  • top sales rep by count sales for average revenue > 10000
  • sales rep average revenue for each region top
bottom unten
  • 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 sortieren nach
  • revenue by state sort by average revenue
  • revenue by customer sort by region

Date

English Keywords Deutsche Keywords Examples
after nach order date after 10/31/2014
before vor order date before 03/01/2014
between … and ... zwischen … und ... order date between 01/30/2012 and 01/30/2014
daily year-over-year täglich vorjahresvergleich growth of revenue by order date daily year-over-year
daily täglich shipments by region daily
day tag count monday restaurant
day of week wochentag revenue by day of week last 6 months
day of week wochentag count shipments Monday
n days for each month n tage für jeden monat sales last 2 days for each month
n days for each quarter n tage für jeden quartal revenue last 15 days for each quarter
n days for each week n tage für jeden woche total sold last 2 days for each week
n days for each year n tage für jeden jahr revenue last 300 days for each year
growth of … by … daily wachstum von … von … täglich growth of sales by order date daily
growth of … by … monthly wachstum von … von … monatlich growth of sales by date shipped monthly sales > 24000
growth of … by … quarterly wachstum von … von … vierteljährlich growth of sales by date shipped quarterly
growth of … by … weekly wachstum von … von … wöchentlich growth of sales by receipt date weekly for pro-ski2000
growth of … by … yearly wachstum von … von … jährlich growth of sales by date closed yearly
growth of … by ... wachstum von … von... growth of sales by order date
n hours for each day n stündlich für jeden tag sales last 2 hours for each day
last day by letzte tag von customers last day by referrer
last month by letzte monat von customers last month by day
last n days letzte n tage visitors last 7 days
last n quarters letzte n quartale visitors last 2 quarters by month by campaign
last n weeks letzte n wochen visitors last 10 weeks by day
last quarter letzte quartal customers last quarter sale >300
last week letzte woche customers last week by store
last year letzte jahr top 10 customers last year by sale by store for region west
last n years letzte n jahre visitors last 5 years by revenue for sum revenue >5000
month to date monat bis jetzt sales by product month to date sales > 2400
month year monat jahr commission by sales rep February 2014
month monat commission January
month monat revenue by month last year
monthly year-over-year monatlich vorjahresvergleich growth of revenue by receipt date monthly year-over-year
monthly monatlich commission > 10000 monthly
n months for each quarter n monate für jeden quartal cost last 2 months for each quarter
n months for each year n monate für jeden jahr last 8 months for each year
n days ago n tage vor sales 2 days ago
n months ago n monate vor sales 2 months ago by region
n months n monate visitors last 6 months for homepage visits > 30 by month
n quarters ago n quartale vor sales 4 quarters ago by product name contains deluxe
n weeks ago n wochen vor sales 4 weeks ago by store
n years ago n jahre vor sales 5 years ago by store for region west
n years n jahre opportunities next 5 years by revenue
next day nächste tag shipments next day by order
next month nächste monat appointments next month by day
next n days nächste n tag shipments next 7 days
next n months nächste n monate openings next 6 months location
next n quarters nächste n quartale opportunities next 2 quarters by campaign
next n weeks nächste n wochen shipments next 10 weeks by day
next quarter nächste quartal opportunities next quarter amount > 30000
next week nächste woche shipments next week by store
next year nächste jahr opportunities next year by sales rep
quarter to date quartal bis jetzt sales by product quarter to date for top 10 products by sales
quarterly year-over-year quartale vorjahresvergleich growth of revenue by date shipped quarterly year-over-year
quarterly quartale sales quarterly for each product
n quarters for each year n quartale für jeden jahr last 2 quarters for each year
today heute sales today by store
week to date woche bis jetzt sales by order date week to date for pro-ski200
week woche revenue by week last quarter
weekly year-over-year wöchentlich vorjahresvergleich growth of revenue by date shipped weekly year-over-year
weekly wöchentlich revenue weekly
n weeks for each month n wochen für jeden monat sales last 3 weeks for each month
n weeks for each quarter n wochen für jeden quartal last 2 weeks for each quarter
n weeks for each year n wochen für jeden jahr last 3 weeks for each year
year to date jahr bis jetzt sales by product year to date
year jahr revenue by product 2014 product name contains snowboard
yearly jährlich shipments by product yearly
yesterday gestern sales yesterday for pro-ski200 by store

Time

English Keywords Deutsche Keywords Examples
detailed detailliert ship time detailed
last minute letzte minute count homepage views last minute
last hour letzte stunde count unique visits last hour
n minutes n minuten count visitors last 30 minutes
n hours n stunden count visitors last 12 hours
hourly stündlich visitors by page name hourly
n minutes ago n minuten vor sum inventory by product 10 minutes ago
n hours ago n stunden vor sum inventory by product by store 2 hours ago

Text

English Keywords Deutsche Keywords Examples
begins with beginnt mit product name begins with 'pro'
contains enthält product name contains "alpine" description contains "snow shoe"
ends with endet mit product name ends with 'deluxe'
not begins with beginnt nicht mit product name not begins with "tom's"
not contains enthält nicht product color not contains 'tan' product color not contains 'red'
not ends with endet nicht mit product name not ends with "trial"
similar to ähnlich zu course name similar to 'hand'
not similar to nicht ähnlich zu course name not similar to 'hand'

Number

English Keywords Deutsche Keywords Examples
sum summe sum revenue
average durchschnitt average revenue by store
count anzahl count visitors by site
max maximum max sales by visitor by site
min minimum min revenue by store by campaign for cost > 5000
standard deviation standardabweichung standard deviation revenue by product by month for date after
unique count eindeutige anzahl unique count visitor by product page last week
variance varianz variance sale amount by visitor by product for last year

Comparative

English Keywords Deutsche Keywords Examples
all alle all
between... and zwischen … und revenue between 0 and 1000
vs, versus 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 Deutsche Keywords Examples
near nahe revenue store name county near san francisco
near... within n miles|km|meters nahe... innerhalb n meilen|km|meter revenue store name county near alameda within 50 miles
farther than n miles|km|meters from entfernter als n meilen|km|meter average hours worked branch farther than 80 km from scarborough

Period

English Keywords Deutsche Keywords Examples
quarter (date) quartal (date) quarter (purchase date)
quarter of year (date) quartal des jahres (date) quarter of year (purchase date)
month of quarter (date) monat des quartals (date) month of quarter (purchase date)
week of year (date) woche des jahres (date) week of year (ship date)
week of quarter (date) woche des quartals (date) week of quarter (ship date)
week of month (date) woche des monats (date) week of month (ship date)
day of year (date) tag des jahres (date) day of year (ship date)
day of quarter (date) tag des quartals (date) day of quarter (ship date)
day (date) tag (date) day (ship date)
day of month (date) tag des monats (date) day of month (order date)
day of week (date) wochentag (date) day of week (order date)
hour (datetime) stunde (datetime) hour (timestamp)