Many Klips that use Google Analytics data need a rolling date range that is dynamic (for example, past 30 days). In this section we're going to change a static query from a fixed date range to a dynamic one.

1. Find start-date= in your Query URI.
2. Delete the date that appears right after it. Note: Only delete the data that appears in yyyy-mm-dd format.
3. Replace it with the following: {date.last30Days}
4. Find end-date=and delete the date that follows it.
5. Replace it with the following: {date.today}
6. Click Get data.
7. Save and name your data source.

If your query returned an error, make sure it looks like this:

https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A{ProfileID}&metrics=ga%3Avisitors&start-date={date.last30Days}&end-date={date.today}

Common date range expressions:

• {date.today}
• {date.last30Days}
• {date.startOfQuarter}
• And many more...