新加坡应用事件：Google Analytics Query Explorer的dateHourMinute时区确认

Great question, let's break this down clearly for your Singapore-based app event tracking:

Core Details About dateHourMinute #

The dateHourMinute dimension in the Google Analytics Query Explorer records time in Coordinated Universal Time (UTC)—not Singapore's local time (UTC+8). This field belongs strictly to the standard UTC time category: all native Google Analytics time dimensions (like standalone date, hour, or combined ones such as this) are stored and returned in UTC by default, no matter what timezone you've set for your GA view.

Adjusting to Singapore Local Time #

Since Singapore runs on UTC+8, you will need to add 8 hours to the dateHourMinute value to align it with local time. For example:

• If dateHourMinute returns 202405200915 (UTC 9:15 AM on May 20), adding 8 hours gives you 202405201715—which is 5:15 PM Singapore local time.

A quick heads-up: While you can set your GA view's timezone to Singapore for easier dashboard viewing, the Query Explorer will still return dateHourMinute in UTC. The view timezone only changes how data is displayed in the GA UI, not the raw data exported via tools like the Query Explorer.

内容的提问来源于stack exchange，提问作者iadcialim24