Skip to main content

Understanding data sync and freshness

How often Datadrew syncs data from each platform and when new data becomes available.

Updated today

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:

  1. Extracts data from the source platform's API (Shopify, Facebook Ads, Google Ads, etc.)

  2. Loads the raw data into Datadrew's data warehouse

  3. 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

Did this answer your question?