Here is an example of what your query would look like when using Date, Number and Text fields in your filters. If you wanted to add multiple values to one of your Filters, there is what you query would look like:


  • Multiple Options on one filter:  (LeadSource = 'Email' OR LeadSource = 'Phone')
  • Based on email domain: Email LIKE '%crmguidance.com'
  • Phone ='(312) 555-1212'
  • Blank value = 'null'
  • URL='http://www.cnn.com'
  • Percentage Field Type (divide your value by 100, then insert the result to the value field)
    • 25% = .25
    • 33% = .33
    • 225% = 2.25