When you ask a question in Act-On Analytics, keywords shape the result. Use this page as a cheat sheet of the keywords that work with the search bar, grouped by what they do.
top, sort by, last week, sum - turns a vague question into a chart you can act on.Quick Reference (Advanced Users) - Click to Expand
Jump to: General | Date and Time | Text | Number | Comparative.
top 10 Message title by Click Rate last 30 days. You'll get a ranked bar chart of your ten best-performing messages from the past month.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 uses 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 combination with top.
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 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 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 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
Use these to narrow numerical results.
- between ... and ...
- = (equals)
- >= (greater than or equal)
- > (greater than)
- <= (less than or equal)
- < (less than)
- != (does not equal)
Example: Sent < 10 by Template title