Last updated: November 20, 2026
Transfer Schedules
Every transfer runs on a schedule you define. Detrics supports a range of frequencies from hourly to monthly.Available Frequencies
Timezone Handling
Schedules are interpreted in the timezone set on the destination. If your destination’s timezone isAmerica/New_York and you schedule a transfer to run daily at 6:00 AM, it will always run at 6:00 AM Eastern time, even when Daylight Saving Time shifts occur.
Detrics handles DST transitions automatically:
- Spring forward (clock jumps from 2:00 AM to 3:00 AM): If your scheduled time falls in the skipped hour, Detrics runs at the next valid time
- Fall back (clock repeats 1:00-2:00 AM): Detrics runs once at the first occurrence
Choosing a Frequency
Manual Syncs
You can trigger a sync at any time by clicking Sync Now on a transfer’s detail page. Manual syncs don’t affect the regular schedule, the next scheduled run happens at its normal time.Refresh Windows
The refresh window controls how many days of data Detrics re-fetches on each Incremental sync. It only applies to tables assigned the Incremental sync mode on their transfer.Why Refresh Windows Matter
Marketing platform data isn’t final when it first appears. Several factors can cause numbers to change after the initial report:- Attribution delays: A user clicks an ad today but converts 3 days later. The conversion is attributed back to the click date
- Data processing lag: Platforms may take 24-48 hours to finalize metrics
- Billing adjustments: Spend figures may be adjusted after the fact
Recommended Refresh Windows by Platform
How the Refresh Window Interacts with Sync Frequency
The refresh window and sync frequency work together:- Daily sync, 3-day window: Each day, Detrics re-fetches the last 3 days. Data older than 3 days is locked and never touched again
- Hourly sync, 3-day window: Runs during the day re-fetch a short window of 1 to 3 days, depending on the platform and the interval. Once a day, the run re-fetches the full 3-day window. The same applies to every interval schedule (every 1, 2, 3, 6, or 12 hours)
- Weekly sync, 7-day window: Each week, Detrics re-fetches the last 7 days
The refresh window is set per table, not per transfer. This means you can have one table with a 2-day window (for analytics data that finalizes quickly) and another with a 7-day window (for ad data with longer attribution) in the same transfer.
Setting the Refresh Window
When a table is assigned Incremental sync mode on a transfer, you’ll configure a refresh window setting. The value is in days. If you’re not sure, start with the platform’s recommended default, you can always adjust later without losing data.Refresh Windows for Hourly Tables
Hourly tables can sync incrementally on Meta Ads, Google Ads, Google Analytics 4 and Microsoft Ads. Their refresh window is also set in days, and the default for hourly tables is the same as the platform’s daily default:
Each run deletes and reloads only the hours inside the window, for the synced accounts. Hours outside the window stay in the table. On interval schedules, runs during the day re-fetch a short window and the daily run re-fetches the full window, as described above.
Historical Sync Range
The historical sync range determines how far back Detrics fetches data on the first sync of a transfer. This only affects the initial load; subsequent syncs use the refresh window (incremental) or re-fetch the full range (full refresh/append).Available Ranges
Hourly tables accept a historical range of up to 1 month. New hourly tables start with 14 days. Hourly tables that already had a longer range keep it. If you need a longer history, use a daily table.
What Happens After the Initial Sync
After the first sync completes:- Incremental tables: Only the refresh window is re-fetched on each subsequent sync. Historical data outside the window is preserved and never re-fetched
- Full Refresh tables: The full date range is re-fetched every time (historical range determines the extent)
- Full Append tables: The full date range is re-fetched and appended every time