By default, each data export from ChurnIQ includes every row that matches your filters, even rows you have already exported before. If you run scheduled exports, this means re-processing the same data over and over.
An incremental data refresh solves this: each export only includes rows that are new (or newly updated) since your previous export.
This article explains how to configure incremental exports and which date column to filter on for each report type.
How Incremental Exports Work
Incremental refresh is achieved by combining two settings in the data export assistant:
- A relative date filter on the report's timestamp column (for example, "in the last 1 day"), so only recent rows are included.
- A schedule whose frequency matches the filter window (for example, a daily schedule paired with a 1-day filter).
With both in place, every scheduled export delivers only the rows added or updated since the last run.
Before You Start
- Scheduler time is UTC by default, unlike the rest of the platform which uses CET. To change the timezone, go to Advanced options and choose your region. For more details, see Default timezone.
- Match your filter window to your schedule frequency. A daily export should filter for the last 1 day, a weekly export for the last 7 days, and so on. A mismatch will cause gaps (window shorter than the schedule) or duplicates (window longer than the schedule).
- Cleeng workflows run at 13:00, 19:00, 01:00, and 07:00 CEST daily.
Which Column to Filter On Per Report
Each report uses a different column to identify new or updated rows. Find your report in the table below and filter on the column listed for it. For a full reference of every column in each export report, see How to understand exported data?.
| Report | Column to Filter On | Notes |
| Transactions Report | Date Time | Captures all new transactions since the last export. |
| Subscription Report | Latest Timestamp In Subscription History Time | Covers all subscription events, including upgrades, downgrades, and cancellations. A row is included whenever anything changes on the subscription, not only when it is created. |
| User Report | Customer Account Activation or Last Login Date | Depends on your goal: filter on Customer Account Activation to capture recent signups, or on Last Login Date to capture recently active users. |
| Pass Report | Pass Start Date Time | Captures passes that started within the window. A pass should always start immediately after the purchase. |
| Refunds Report | Timestamp Time Date | Captures the exact moment of a refund or chargeback. |
| Gift Report | Created at Date | Captures gift subscriptions created since the last export. A gift is created at the moment of purchase. Its start depends on the redemption, so Gift Start Date would be inaccurate. |
Setting Up an Incremental Export
- In the Cleeng dashboard, go to Analytics > Data Export.
- Use the tabs at the top of the page to select the report you want to export.
- Click the gear icon in the upper right corner and click on Schedule.
- Choose your destination and format, then set the schedule frequency to match your filter window.
- In the Filters section, add a filter on the timestamp column for your report (see the table above) and set it to a relative window that matches your intended schedule, for example, is in the past 1 day for a daily export.
- In Advanced options, select All results
- Save the export. Each scheduled run will now deliver only the rows added or updated since the previous run.