In Act-On Analytics, when asking a data or business question, use keywords to help define your search. This reference lists recommended keywords.
General
top n, bottom n
Generates the top (or bottom) n items from a sorted result. If your search has more than one measure, it generates the top n items from the first measure in the search.
Example: top 10 Message title by Click Rate
top n ... ranked by
Ranks the top n items by a specified measure. The ranked by keyword only works in conjunction with the top keyword.
Example: top 10 Message title by Click Rate ranked by Send date
sort by
Sorts the result set by an attribute or measure.
Example: Message title by Click Rate sort by Send date
by measure
Treats the measure as an attribute and groups the result set by it.
Example: Message title by Click Rate
Date and Time
Generates results by the following date criteria:
after, before, between
Example: between 01/30/2022 and 01/30/2023
hourly, daily, weekly, monthly, quarterly, yearly
Example: Click Rate weekly
day, week, month, quarter, year
Example: Click Rate January
month year
Example: Delivered January 2022
today, yesterday
Example: Delivered today
by day, week, month, quarter, year
Example: Click Rate by day
growth of … by … daily, weekly, monthly, quarterly, yearly
Example: growth of Click Rate by Sender quarterly
last hour, day, week, month, quarter, year
Example: Delivered last week
last hour, day, week, month, quarter, year by
Example: Delivered last week by Sender
last n days, weeks, months, quarters, years
Example: Delivered last 2 weeks
last n for each
Example: Delivered last 5 days each quarter
n hours, days, weeks, months, quarters, years ago
Example: Total opened 2 weeks ago
week, month, quarter, year to date
Example: Total opened month to date
this hour, day, week, month, quarter, year
Example: Click Rate this month
daily, weekly, monthly, quarterly, yearly year-over-year
Example: Delivered monthly year-over-year
Text
Generates results by the following text criteria:
begins/ends with, contains, similar to
Example: Message title similar to 'holiday'
not begins/ends with, contains, similar to
Example: Message title not contains 'summer offer'
Number
Generates results by the following number criteria:
average, count, max, min
Example: average Sent by month
sum
Example: sum Sent by quarter
unique count
Example: unique count Sent by month
Comparative
between... and...
= (equals)
>= (greater than or equal)
> (greater than)
<= (less than or equal)
< (less than)
!= (does not equal)
Use to narrow numerical results. Example: Sent < 10 by Template title