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