Learn · Strategy · Beginner
Learn to tell a real zero from a gap in the data, check why a figure is missing in Search Console and Google Analytics, and label it so nobody misreads your report.
By Dean Cruddace · 45 minutes to do · Updated · Last reviewed
Every SEO report has gaps. A number can be missing because it was never collected, because the tool could not supply it, or because it is still being counted. A real zero is different: the thing was measured and nothing happened.
If a report shows all of these the same way, readers cannot tell a genuine drop from a gap. This guide shows you how to find out why a figure is missing, using Google's own tools, and how to label it.
Google's reports behave in ways that can look like zeros or sudden changes if you do not know about them. The newest Search Console data can be preliminary, some data is withheld for privacy, and exports turn some blank values into zeros. See the Performance report data notes.
Beside each figure in the report, write where it came from (for example the Search Console Performance report) and the dates it covers. This is a working habit rather than a Google rule.
You will know it worked when Every figure has a named source and a date range. Any figure you cannot source is marked for removal or review.
Open the Performance report in Search Console and look at the most recent days on the chart. Google says the newest data can be preliminary: still being collected and liable to change in the next few hours, and shown with a dotted line. By default the report shows complete days. The report also shows when it was last updated. See About the data.
You will know it worked when Your report's end date is a complete day, not a dotted-line day, and you have noted the last-updated date.
Google says there can be a lag between when numbers are calculated and when they are visible, and that collected data is usually available in 2 to 3 days. It also says daily data in the Performance report is labelled in Pacific Time, so daily figures from other systems may not match exactly. See troubleshooting data discrepancies.
You will know it worked when Your reporting period ends a few days before today, and any comparison with another tool notes the time-zone difference.
In Search Console, values shown as ~ or - mean not available or not a number. Google says these become zeros in the downloaded data. Before pasting an export into a report, find those symbols on screen and mark them as unavailable in your copy, not zero. See the Performance report overview.
You will know it worked when No cell in your report holds a zero that the on-screen report showed as ~ or -.
If chart and table totals differ, check Google's listed reasons: they are aggregated differently, the table shows at most 1,000 rows, and rare anonymised queries are left out of the table but counted in the chart. Search Console can also differ from Analytics because of privacy, processing, lag, time zones and JavaScript. See troubleshooting data discrepancies.
You will know it worked when For each mismatch in your report you can name which of Google's reasons applies, or you have flagged it as unexplained.
In Google Analytics 4, look at the data quality indicator at the top of a report. Google says a data threshold can withhold data, such as search query rows with too few users, and you cannot change the thresholds. Widening the date range can help. See About data thresholds.
You will know it worked when You can see whether thresholding applies to each Analytics figure, and have widened the date range where that is sensible.
For every missing figure, write what is missing, why, and what happens next, for example (hypothetical): "Search Console is not connected for this site, so organic clicks are not shown." Keep three states apart: a measured zero, not collected, and unavailable. Label any estimate as one. This is good practice, not a Google requirement.
You will know it worked when No blank or zero in the report is unexplained, and every estimate is labelled as one.
If a tool or chatbot drafted any commentary, read every sentence against the data before sending. Google's guidance on generative AI content says it is critical to manually fact-check and review all AI-generated content for accuracy and trustworthiness before publishing. See the generative AI guidance.
You will know it worked when A named person has read the commentary against the figures and corrected anything unsupported.
~ and - values, which become zeros.Go deeper
Tell Dean which figures are missing and why. Stating reporting limits plainly is part of how measurement is done.