The exact same data table, with the exact same dimensions and metrics, gives different metric numbers for the same month depending on whether I export just that month versus exporting the full year of data including that month.
Why would that be?
Different User and Session metrics when I export the same data and time period in two different ways
Hey,
Hope you’re keeping well.
This is likely due to how Looker applies filters and aggregation at query time. When you export only a single month, the query context limits the dataset before aggregation, but when you export the full year, the monthly totals are derived from a broader result set where session or user counts may be de-duplicated differently. Check whether your measures use COUNT DISTINCT or time-based session logic, as these can vary depending on filter scope. You can confirm by reviewing the SQL generated in the Explore tab to see how the WHERE clause changes between the two exports.
Thanks and regards,
Taz