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 Get data.
  5. Ensure this is the data you’re looking for and, optionally, select the checkbox to Model your data. Learn more about modelling your data source here.
  6. Click Continue.
  7. Name, choose refresh settings, and, optionally, share your data source.
  8. Click Save.

Common date range expressions:

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