Understanding Data Delays and Sync Schedules
Datadrew syncs your data automatically on a regular schedule. Understanding how this works helps set the right expectations for data freshness.
How Data Sync Works
Datadrew uses a multi-step pipeline to process your data:
Data extraction: Raw data is pulled from each connected platform (Shopify, Facebook Ads, Google Ads, GA4, Klaviyo, Google Search Console) via their APIs.
Data loading: The raw data is loaded into our data warehouse (Google our data warehouse).
Data transformation: Our transformation layer (our data transformation layer) processes the raw data into analytics-ready tables — joining orders with customers, calculating LTV, building cohorts, blending ad metrics, and more.
Dashboard refresh: The transformed data becomes available in your dashboards and to Drew AI.
Sync Frequency
Plan | Sync Frequency |
Free | Once daily |
Essentials | Hourly |
Pro | Hourly |
Daily syncs are scheduled based on your store's timezone. Each integration is staggered to spread the load — your Shopify data syncs first, followed by ad platforms, with data transformations running after all extractions complete.
Hourly syncs (Essentials and Pro) provide more frequent data updates, though the full transformation pipeline still runs on a scheduled cycle.
Typical Data Delay
Daily sync stores: Data is typically available by mid-morning in your store's timezone, reflecting all activity through the end of the previous day.
Hourly sync stores: Data is typically 1-2 hours behind real-time.
Initial sync: The first sync after connecting a new integration can take several hours to a full day, depending on data volume.
Why Transformations Add Time
Even after raw data is synced, Datadrew needs to run transformations to calculate metrics like LTV cohorts, RFM segments, blended ad performance, and product analytics. These transformations run in batches after each sync cycle completes.
Checking When Data Was Last Updated
You can see when your data was last synced by visiting Settings > Integrations. Each integration shows its last successful sync time.
Need help? Contact us at support@datadrew.io.
Related articles
Need help?
If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.