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.

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?