{"id":7787,"date":"2026-02-01T08:39:00","date_gmt":"2026-02-01T08:39:00","guid":{"rendered":"https:\/\/hishamghanayem.com\/?p=7787"},"modified":"2026-01-18T08:40:47","modified_gmt":"2026-01-18T08:40:47","slug":"dashboard-doesnt-match-raw-data","status":"publish","type":"post","link":"https:\/\/hishamghanayem.com\/en\/data-analysis\/data-visulisation\/dashboard-doesnt-match-raw-data","title":{"rendered":"What to Do When Your Dashboard Doesn\u2019t Match the Raw Data"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Why Data Discrepancies Happen\u2014and What Analysts Should Do About Them<\/h2>\n\nIt\u2019s a common moment of panic: you open your dashboard, pull the raw data from BigQuery or GA4, and realize \u2014 the numbers don\u2019t match. Whether it\u2019s transactions, sessions, or revenue, this misalignment can break trust and kill momentum. But don\u2019t panic. This isn\u2019t failure. It\u2019s your cue to start debugging.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

1. Understand What ‘Raw’ Actually Means<\/h3>\nMany analysts assume their dashboard is pulling from raw, untouched data. In reality, what you\u2019re seeing may be a transformed, filtered, or scoped version of that data. Raw data can include:\n
    \n \t
  • All events regardless of consent or errors<\/li>\n \t
  • Traffic from test environments or internal users<\/li>\n \t
  • Failed transactions or duplicate events<\/li>\n<\/ul>\nYour dashboard might be hiding those for a reason \u2014 but you have to know what was excluded to understand the difference.\n\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
    \n\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    2. Trace the Pipeline: From Source to Dashboard<\/h3>\nVisualize the full path of your data:\n
      \n \t
    1. GA4 \/ GTM Collection \u2192<\/li>\n \t
    2. Export to BigQuery \u2192<\/li>\n \t
    3. SQL transformation logic (filtering, joins, etc.) \u2192<\/li>\n \t
    4. Data model for Looker Studio or Power BI \u2192<\/li>\n \t
    5. Dashboard-level filters or calculated fields<\/li>\n\n<\/ol>\nAt each layer, something might be excluded or renamed. Dashboards often filter by default \u2014 date ranges, traffic type, source \u2014 and these are easy to miss.\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
      \n\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      3. Use Controlled Comparisons<\/h3>\nDon\u2019t compare all sessions. Narrow the scope:\n
        \n \t
      • Choose one day of traffic<\/li>\n \t
      • From one country or campaign<\/li>\n \t
      • Use the same dimensions and filters across dashboard and query<\/li>\n<\/ul>\nStart small and confirm: “Is this number the same here and here?” That\u2019s how you isolate drift.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
        \n\t\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t

        4. Check These Common Culprits<\/h3>\n
          \n \t
        • Time zone misalignment<\/strong> (GA4 vs. BigQuery default UTC)<\/li>\n \t
        • Bot filters or test traffic<\/strong> excluded in dashboard only<\/li>\n \t
        • Event scoping<\/strong>: session-based vs. event-based logic<\/li>\n \t
        • Currency mismatches<\/strong> in revenue reports<\/li>\n \t
        • Consent mode logic<\/strong> filtering some sessions<\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
          \n\t\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t

          5. Document the Differences<\/h3>\nOnce you\u2019ve found the cause, document it. Create a clear table or tab in your dashboard that shows what is included vs. what\u2019s not. This builds long-term trust and helps future you (or the next analyst).\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
          \n\t\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t

          Final Thoughts<\/h3>\nWhen dashboards don\u2019t match raw data, it doesn\u2019t mean someone made a mistake. It means context is missing. Your job is to trace, validate, and communicate what\u2019s happening between the source and the surface. That\u2019s what makes you a strategic analyst \u2014 not just a report builder.\n\n
          \n

          Written with support from AI tools and edited by Hisham Ghanayem. Based on real-world analysis workflows.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

          Why Data Discrepancies Happen\u2014and What Analysts Should Do About Them It\u2019s a common moment of panic: you open your dashboard, pull the raw data from BigQuery or GA4, and realize \u2014 the numbers don\u2019t match. Whether it\u2019s transactions, sessions, or revenue, this misalignment can break trust and kill momentum. But don\u2019t panic. This isn\u2019t failure. […]<\/p>","protected":false},"author":1,"featured_media":7793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"postBodyCss":"","postBodyMargin":[],"postBodyPadding":[],"postBodyBackground":{"backgroundType":"classic","gradient":""},"footnotes":""},"categories":[7,10,6],"tags":[68],"class_list":["post-7787","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analysis","category-data-storytelling","category-data-visulisation","tag-data"],"_links":{"self":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/comments?post=7787"}],"version-history":[{"count":5,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7787\/revisions"}],"predecessor-version":[{"id":7792,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7787\/revisions\/7792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/media\/7793"}],"wp:attachment":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/media?parent=7787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/categories?post=7787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/tags?post=7787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}