To get started, create a new Query. To Query by System Creation Time, follow the steps below:
  1. On the Query Builder tab, click the Field Type dropdown menu
  2. Select System
  3. Click the Field dropdown menu > select Creation Time
  4. Click Add Field Clause
Below is an example of the query logic used to identify the age of new constituent records. Below is an example query based on creation time that is used to set up an email audience for a welcome series email.
  • Welcome Series Email #1 
    • System Creation time falls on or after 7 day or days prior to today.
  • Welcome Series Email #2
    • System Creation time falls on or before 9 day or days prior to today
    • AND System Creation Time falls on or after 14 day or days prior to today
  • Welcome Series Email #3
    • System Creation Time falls on or before 15 days prior to today
    • AND System Creation time falls on or after 21 day or days prior to today.