Why is google analytics query builder timestamp and date are different?

Kenn Blvnp

unread,

Jul 22, 2018, 7:00:30 PM7/22/18

to AdWords API and Google Ads API Forum

Query builder reference: https://ga-dev-tools.appspot.com/query-explorer/

Metrics: ga:entrances
Dimensions: ga:dimension3, ga:dimension4, ga:dimension5, ga:date, ga:channelGrouping

My timestamp is dimension3. I got this timestamp 2017-05-31T00:02:24-06:00 and then my date is May 30, 2017

I already tried doing UNIX_TIMESTAMP() in mysql and strtotime in php and then do date('M d, Y - H:i:s', $timestamp) i thought the time will be deducted by -6 hours but the result is the same. I think there is something going on with T00:02:24-06:00.

Why is there 1 day difference of timestamp and date dimension? Why is this happening?

Luis Xander Talag (AdWords API Team)

unread,

Jul 23, 2018, 1:46:15 AM7/23/18

to AdWords API and Google Ads API Forum

Hi Kenn,

Our team only provide support on issues/concerns related to AdWords API. Your concern seems to be related to Google Analytics. I would recommend that you get in touch with their team via this link instead, as this is already out of scope for us.

Thanks and regards,

Luis

AdWords API Team

Kenn Blvnp

unread,

Jul 23, 2018, 4:09:04 AM7/23/18

to AdWords API and Google Ads API Forum

Its leading to stackoverflow.

Luis Xander Talag (AdWords API Team)

unread,

Jul 23, 2018, 5:14:43 AM7/23/18

to AdWords API and Google Ads API Forum

Hi Kenn,

That is indeed the support channel for Google Analytics.

Regards,

Luis

AdWords API Team

Kenn Blvnp

unread,

Jul 23, 2018, 10:44:04 AM7/23/18

to AdWords API and Google Ads API Forum

Okay thanks! I just wanna make sure if there is a version of Analytics forums like this.

Reply all

Reply to author

Forward