Overview
Datadrew syncs data from your connected platforms on a regular schedule. Understanding how data sync works helps you know when to expect the latest numbers and how fresh the data is on your dashboards.
How data sync works
When you connect a data source, Datadrew sets up an automated data pipeline that:
Extracts data from the source platform's API (Shopify, Facebook Ads, Google Ads, etc.)
Loads the raw data into Datadrew's data warehouse
Transforms the raw data into analytics-ready tables and metrics
This process runs automatically on a schedule. You do not need to manually trigger syncs.
Sync frequency by platform
Platform | Sync Frequency | Typical Delay |
Shopify | Daily | A few hours |
Facebook/Meta Ads | Daily | A few hours |
Google Ads | Daily | A few hours |
Google Analytics 4 | Daily | 24-48 hours (Google processing delay) |
Klaviyo | Real-time via API | Live (queried on demand by Drew AI) |
Google Search Console | Real-time via API | 2-3 days (Google processing delay) |
Understanding data freshness
There are two factors that affect how fresh your data is:
1. Platform processing delay
Some platforms take time to finalize their data. For example, Google Analytics 4 data can take 24-48 hours to be fully processed on Google's end. Google Search Console data is typically 2-3 days behind. This is not a Datadrew limitation — it is how these platforms work.
2. Sync schedule
Datadrew syncs data on a daily schedule. After a sync completes, it triggers a data transformation step that refreshes your dashboards and reports. The transformation typically takes 15-30 minutes after a sync completes.
Initial sync vs. ongoing syncs
Initial sync: When you first connect a platform, Datadrew pulls your full historical data. This can take longer — anywhere from 30 minutes to several hours depending on the volume of data. You will see a "Syncing" status during this time.
Ongoing syncs: After the initial sync, only new and updated data is pulled (incremental sync). This is much faster, typically completing in minutes.
Checking sync status
You can check the status of your data syncs on the Integrations page:
Synced — data is up to date
Syncing — a sync is currently in progress
Connected — the connection is active and data is being synced on schedule
Disconnected — the connection has been lost (usually due to an expired token)
Hourly performance data
The Hourly Performance dashboard uses a special fast-refresh pipeline that updates more frequently than the standard daily sync. If you have Facebook Ads, Google Ads, and Google Analytics connected, hourly data refreshes throughout the day, giving you near-real-time visibility into your store's performance.
Tip: If you need to see the absolute latest data from Klaviyo or Google Search Console, ask Drew AI. These integrations query the platform APIs in real time, so Drew AI always returns the freshest available data.
Need help?
If your data seems stale or a sync appears stuck, contact us at support@datadrew.io or use the in-app chat. We can check your sync status and trigger a manual refresh if needed.
Related articles
