Why do my queries return data from different days?
The observation date displayed will be for your local time zone (this is an automatic Snowflake feature). To ensure you’re looking at the correct date, you’ll need to query observation date based off of the UTC (00:00) time stamp. For example, if we want to query results for 2018-01-01 we would use the following:
Why does the Active Users
Revision Date change more often than others?
Sensor Tower's Active User data requires a little longer to finalize than Downloads and Revenue; it takes about seven days to finalize Active User metrics. Sensor Tower will provide estimations within one day of the Observation Date and then subsequently update them each day (with more accurate numbers) until seven days after the Observation Date.