Search terms

The following search terms are available for querying Analytics data:

• Exact Match: To search for an exact match, simply type the required text in the query bar. The term must match a complete word within the value of any row or column and the results will highlight where the match was made in the record.

  Example: Searching for 'bread' would return 'Bread', 'Bread Mix', 'Wholemeal Bread' but not 'Breaded Chicken'.

• Combining Search Terms: Combining terms provides a more focused set of results. Combining two or more separate words will return results that only contain every separate word entered.

• Searching Fields: To search within a specific field, type the field name followed by a colon before entering a query. This query is case sensitive and the spaces must be replaced with underscores _. The required search term must be prefixed and suffixed with quotes “ ”. The following format must be used:

  <field_name>:“<value>”

• Wild Card Searches: Wild card searches allow you to query data using fuzzy matching. By replacing a single character with a ? and multiple characters with * , the search will look to replace the wild card characters with a character in the search string. * can only be used at the beginning or end of a search term.

  This is especially useful when not all of the information is known to the user. For example, replacing the last three digits of a postcode with ??? will return results that match the exact string all other possible variations based on the wild card characters.

• Fuzzy Searches: Typing the tilde ~ symbol at the end of a single word term allows you to perform a fuzzy search. This will return matches that are similar to the word typed.

  To specify the level of similarity required, type a value between 0 and 1 after the search. A value closer to 0 will produce fuzzier results and if no value is typed, the default parameter, 0.5, is used.

• Proximity Searches: This allows you to find words that are separated by a specific number of words in a document. Type the tilde ~ symbol at the end of a phrase followed by the number of words that separate the term.

• Range Searches: Range searches allow you to match documents whose field values are between the lower and upper value specified by the search. Range searches can be inclusive or exclusive of the upper and lower bounds and results are sorted automatically.

  Use square brackets [ ] to perform inclusive range searches and use curly brackets {} to perform exclusive range searches. The following format must be used:

  <field>:[“lowervalue” TO “uppervalue”]

  for inclusive range searches or

  <field>:{“lowervalue” TO “uppervalue”}

  for exclusive range searches.