If Drew AI responds with "data not available" or cannot find the information you asked about, it is almost always due to one of a few common reasons. Here is how to diagnose and fix the issue.
Reason 1: Asking for today's Shopify data
This is the most common reason. Shopify data in Datadrew (orders, customers, products, revenue) is synced daily and is only available up to yesterday. If you ask "What were my sales today?" or "How many orders did I get today?", Drew AI cannot answer because today's Shopify data has not been processed yet.
What to do:
Ask about yesterday or earlier: "What were my sales yesterday?"
For today's ad platform data (Meta Ads, Google Ads, GA4), Drew AI can pull real-time numbers — just specify the platform: "What is my Google Ads spend today?"
Reason 2: Integration not connected
Drew AI can only access data from platforms you have connected. If you ask about Google Ads but have not connected your Google Ads account, Drew AI will not be able to pull that data.
What to do:
Go to the Integrations page in Datadrew
Connect the platform you want to analyze (Meta Ads, Google Ads, Google Analytics, Klaviyo, or Google Search Console)
Once connected, Drew AI will automatically have access to that data
Reason 3: Data sync still in progress
If you recently connected a new integration, it may take some time for the initial data sync to complete. our data pipeline (our data pipeline) syncs raw data into the warehouse, and then data transformations process it into analytics-ready tables.
What to do:
Check the sync status on the Integrations page
For newly connected integrations, allow up to 24 hours for the initial data to be fully available
Real-time MCP data (Meta Ads, Google Ads, etc.) is available immediately after connecting — historical warehouse data takes longer
Reason 4: No data exists for that query
Sometimes the data simply does not exist. For example, if you ask about repurchase rates for a product that has only been purchased once, or if you ask for data from a time period before you connected the integration.
What to do:
Try broadening your time range
Check if the metric makes sense for your data (e.g., repurchase rates require at least some repeat customers)
Ask Drew AI what data is available: "What Shopify data do you have access to?"
Reason 5: Asking about unsupported data
Drew AI covers a wide range of e-commerce analytics but does not cover everything. For example, it cannot access your Shopify admin settings, fulfillment details, or inventory management data.
What to do:
Check the help center for a list of supported data sources and metrics
If you think the data should be available, contact our support team
Still seeing issues?
If none of the above reasons apply, the issue might be temporary. Try rephrasing your question or starting a new conversation thread. If the problem persists, reach out to support@datadrew.io or use the in-app chat and include your question so we can investigate.
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.