Skip to main content

My Metrics Don't Match - Fixing Data Inconsistencies

Fix when Zoë's numbers don't match your spreadsheets. 4-step validation for timezones, definitions, duplicates, and data volume.

Updated over 2 weeks ago

What You're Trying to Do

Zoë's numbers don't match your spreadsheets, dashboards, or what you expect to see.

Quick Solution (5 minutes)

Follow this 4-step validation process:

Step 1: Check Time Zones and Date Ranges

  • Ask Zoë: "Show me [metric] for [specific date range] in [timezone]"

  • Example: "Show me revenue for January 1-31, 2024 in PST"

Step 2: Verify Your Metric Definition

  • Ask Zoë: "How do you calculate [metric_name]?"

  • This shows you the exact SQL and logic Zoë is using.

Step 3: Check for Duplicate Data

  • Ask Zoë: "Are there any duplicate rows in [table_name]?"

  • Duplicates can inflate numbers and cause mismatches.

Step 4: Compare Raw Counts First

  • Ask Zoë: "How many total rows are in [table] for [date range]?"

  • Verify the basic data volume matches your expectations before checking calculated metrics.

Numbers matching now? Great! If not, you've identified whether it's a date, definition, duplicate, or data volume issue.

Still Need Help?

Complete Guide For detailed metric definition and troubleshooting → Measures Documentation and Field Definitions

Ask Zoë Directly Try asking: "Show me the SQL for this query" to see exactly how calculations are done

Contact Support If metrics still don't match after checking these steps → Contact Support with "Metric Validation Issue" and include:

  • The specific metric that's wrong

  • Expected vs. actual numbers

  • Date range you're comparing

  • Where you're getting the "correct" numbers from

Did this answer your question?