How do I convert my Campaign Monitor static date ranges to dynamic date ranges?

Many Klips that use Campaign Monitor data need a date range that is dynamic (for example, past 30 days).

To change the query from a fixed range to a dynamic one:

  1. Enter a ? at the end of your Query URL.
  2. Enter start-date={date.last30Days} at the end of your Query URL (after the ?).
  3. Enter &end-date={date.today} at the end of your Query URL (after the start-date parameter).
  4. Click Submit.
  5. Click Continue once you verify you have retrieved the correct data.
  6. Save and name your data source.

Common date range expressions:

  • {date.today}
  • {date.last30Days}
  • {date.startOfQuarter}
Have more questions? Submit a request