Home Data Freshness & Sync

Data Freshness & Sync

By Vikas Bansal

• 5 articles

Why is today's data not available?

Why Is Today's Data Not Available? If you are looking at your Datadrew dashboards and notice that today's data is missing, this is expected behavior — not a bug. How It Works Datadrew's data pipeline syncs your store and integration data on a scheduled cycle. For most integrations, the sync captures all activity through the end of the previous day (midnight in your store's timezone). This means: - Today's orders, ad spend, and website traffic are not yet reflected in your dashboards. - Yesterday's complete data is the most recent data available. - This is consistent across all data sources — Shopify, Facebook Ads, Google Ads, GA4, Klaviyo, and Google Search Console. Why Not Real-Time? There are several reasons Datadrew processes data on a daily (or hourly) cycle rather than in real-time: 1. Data completeness: Ad platforms like Facebook and Google often adjust metrics retroactively. Waiting until the day is complete ensures you see accurate, final numbers rather than preliminary estimates. 2. Transformation quality: Datadrew calculates complex metrics like LTV cohorts, RFM segments, and blended ad performance. These calculations need complete daily data to be meaningful. 3. API limits: Third-party platforms impose rate limits on their APIs. Scheduled syncs respect these limits while maximizing data freshness. When Will Today's Data Appear? - Daily sync (Free plan): Today's data will appear tomorrow morning after the nightly sync and transformation run completes. - Hourly sync (Essentials and Pro plans): Partial intra-day data becomes available with a 1-2 hour delay. However, some metrics that require a full day of data (like daily cohort calculations) will still show up the following day. What About Drew AI? Drew AI queries the same data warehouse as your dashboards, so it follows the same data freshness rules. If you ask Drew AI about today's performance, it will let you know that data is only available through yesterday. However, Drew AI can also query live data from your ad platforms using its real-time tools, which may provide more current figures for ad spend and campaign metrics. Need help? Contact us at support@datadrew.io. Related articles - Understanding data delays and sync schedules - My data isn't showing up — what to check - Understanding your data timeline - Drew AI data sources — real-time vs. historical 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.

Last updated on Jul 07, 2026

Understanding data delays and sync schedules

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: 1. Data extraction: Raw data is pulled from each connected platform (Shopify, Facebook Ads, Google Ads, GA4, Klaviyo, Google Search Console) via their APIs. 2. Data loading: The raw data is loaded into our data warehouse (Google our data warehouse). 3. 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. 4. 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 - Understanding data sync and freshness - Why is today's data not available? - My data isn't showing up — what to check - Data sync is stuck or failed 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.

Last updated on Jul 07, 2026

Data sync is stuck or failed

Data Sync Is Stuck or Failed If you see a failed or stuck sync status for one of your integrations, here is how to diagnose and fix the issue. Symptoms - The integration status shows red or error in Settings > Integrations. - Data has not updated for an unusually long time (more than 24 hours for daily syncs). - You received an in-app notification about a sync failure. Common Causes 1. Expired or Revoked Credentials If you changed your password, revoked app permissions, or your OAuth token expired, the sync will fail. How to fix: 1. Go to Settings > Integrations. 2. Click Reconnect on the affected integration. 3. Complete the re-authorization flow. 4. The sync will automatically resume. 2. Permissions Changed If someone in your organization changed the permissions on the connected ad account or analytics property, the sync may lose access. How to fix: - For Facebook Ads: Ensure the connected user has admin access to the ad account in Meta Business Manager. - For Google Ads: Ensure the connected Google account still has access to the ad account. - For GA4: Ensure the connected Google account still has at least Viewer access to the property. 3. Platform API Issues Occasionally, third-party platforms (Meta, Google, Klaviyo) experience API outages that prevent data from syncing. How to fix: Wait a few hours and check back. Datadrew automatically retries failed syncs. If the issue persists for more than 24 hours, contact us. 4. Large Data Volume Stores with very high order volumes or many ad campaigns may occasionally experience timeouts during sync. How to fix: This usually resolves on the next automatic retry. If it keeps happening, contact support so we can optimize your sync configuration. How to Force a Re-sync 1. Go to Settings > Integrations. 2. Find the affected integration. 3. Click the Reconnect button. 4. Re-authorize the connection. 5. A fresh sync will begin automatically. Still stuck? Contact us at support@datadrew.io with your store URL and the name of the integration that is failing. We can check the sync logs on our end. Related articles - My data isn't showing up — what to check - Understanding data delays and sync schedules - Integration disconnected — how to reconnect - Understanding data sync and freshness 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.

Last updated on Jul 07, 2026

Why do my numbers differ from Shopify/Facebook/Google?

Why Do My Numbers Differ From Shopify/Facebook/Google? It is common to see slight differences between the numbers in Datadrew and those in Shopify Admin, Facebook Ads Manager, or Google Ads. This does not mean something is wrong — it usually comes down to how each platform counts and attributes data. Common Reasons for Discrepancies 1. Attribution Windows Each advertising platform uses its own attribution model: - Facebook Ads defaults to a 7-day click, 1-day view attribution window. Datadrew imports this as-is from Meta's API. - Google Ads may use last-click or data-driven attribution depending on your account settings. - Shopify uses its own conversion attribution which may differ from ad platform reporting. If you have changed your attribution settings in Facebook or Google after connecting to Datadrew, the historical data imported earlier may reflect the old settings. 2. Timezone Differences Datadrew syncs and reports data based on your store's configured timezone. If your Shopify store timezone differs from the timezone set in your ad accounts, daily totals may not match exactly — orders or ad spend that fall on a day boundary in one timezone may be counted on a different day in another. 3. Refund and Cancellation Handling - Shopify Admin may display net sales (after refunds) in some views and gross sales in others. - Datadrew processes refunds as they appear in the synced data. If a refund was issued after the last sync, it may not yet be reflected in Datadrew. 4. Currency Conversion If your store accepts multiple currencies, Datadrew reports in your store's primary currency. Shopify may show individual transactions in the customer's local currency, which can cause apparent differences when comparing totals. 5. Data Freshness Datadrew syncs data on a daily schedule (or hourly on Essentials and Pro plans). The numbers you see in Datadrew reflect data as of the last completed sync, not real-time. Shopify Admin and ad platforms may show more recent figures. 6. Metric Definitions Datadrew uses specific definitions for metrics like revenue, orders, and customers that may differ slightly from how Shopify Admin calculates them. For example: - Datadrew's LTV cohort analysis uses actual repeat purchase behavior, not a simple formula. - Customer counts may differ if Datadrew deduplicates based on email address while Shopify counts by customer record. What to Do - Compare data over the same date range and same timezone. - Check which metric definition each platform is using (gross vs. net, attributed vs. direct). - If the discrepancy is large (more than 5-10%), contact us at support@datadrew.io with specific examples and we will help you reconcile. Need help? Reach out at support@datadrew.io. Related articles - Understanding metrics and KPI definitions - Understanding Facebook Ads metrics in Datadrew - Understanding Google Ads metrics in Datadrew - Understanding GA4 metrics in Datadrew 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.

Last updated on Jul 07, 2026

My data isn't showing up — what to check

My Data Isn't Showing Up — What to Check If you have connected your Shopify store or an integration but are not seeing data in your Datadrew dashboards, follow these steps to diagnose the issue. Step 1: Check Your Sync Status 1. Open Datadrew and go to Settings > Integrations. 2. Look at the status indicator next to each connected integration. 3. A green status means the integration is synced and up to date. 4. An orange or yellow status means a sync is currently in progress. 5. A red status means the sync has failed — see our article on Data sync is stuck or failed for next steps. Step 2: Allow Time for the Initial Sync After connecting a new integration, the first data sync can take several hours depending on the volume of data in your store. For stores with a large order history, the initial sync may take up to 24 hours. - Shopify: Orders, customers, and products are synced from your store's history. - Facebook Ads / Google Ads: Campaign data is pulled from your ad accounts. - Google Analytics (GA4): Website performance data is imported from your GA4 property. - Klaviyo: Email and flow performance metrics are synced. Step 3: Verify the Integration Is Properly Connected - Make sure the correct ad account, GA4 property, or Klaviyo account was selected during setup. - For Facebook Ads, confirm you have admin access to the ad account in Meta Business Manager. - For Google Ads, confirm you connected the individual ad account (not just the MCC manager account). Step 4: Check Your Plan On the Free plan, data is limited to the last 3 months. If you are looking for older data, you will need to upgrade to Essentials or Pro for unlimited history. Step 5: Check for Date Range Filters Make sure the date range selected in your dashboard includes the period when data should be available. Datadrew shows data up to yesterday — today's data is not yet synced (see Why is today's data not available?). Still Not Working? If data is still not showing after 24 hours and the sync status shows as complete, contact us at support@datadrew.io with your store URL and the integration that is not working. We will investigate right away. Related articles - Data sync is stuck or failed - Understanding data delays and sync schedules - Understanding data sync and freshness - Why is today's data not available? 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.

Last updated on Jul 07, 2026