@Vinutab opened this Issue on May 4th 2018

Hi,

One of our application is integrated with Matomo. We have pulled the report for the visitor log and we can see the timestamp under action(timestamps are 1525255391 and 1525255392).
The report file also contains the values firstActionTimestamp (1525248191) and lastActionTimestamp (1525248192) for the visit.
Comparing firstActionTimestamp to the timestamp of the first action (and lastActionTimestamp to the timestamp of the last action) results in a difference of 7200 seconds, which corresponds to the local time zone offset. below is the code.

[
{
"idSite": "",
"idVisit": "",
"visitIp": "",
"visitorId": "",
"actionDetails": [
{
"type": "action",

    "serverTimePretty": "May 2, 2018 10:03:11",
    "pageId": 
    "timeSpent": "1",
    "timeSpentPretty": "1s",
    "generationTimeMilliseconds": "72",
    "generationTime": "0.07s",
    "interactionPosition": "1",
    "icon": null,
    "timestamp": 1525255391
  },
  {
    "type": "event",
    "--
    "serverTimePretty": "May 2, 2018 10:03:12",
    "pageId": "",
    "eventCategory": "",
    "eventAction": "",
    "interactionPosition": "1",
    "timestamp": 1525255392,
    "icon": ""
  }
],

--
"serverDate": "2018-05-02",
"visitServerHour": "8",
"lastActionTimestamp": 1525248192,
"lastActionDateTime": "2018-05-02 08:03:12",
"serverTimestamp": 1525248192,
"firstActionTimestamp": 1525248191,
"serverTimePretty": "10:03:12",
"serverDatePretty": "Wednesday, May 2, 2018",
"serverDatePrettyFirstAction": "Wednesday, May 2, 2018",
"serverTimePrettyFirstAction": "10:03:11",

}
]

Could you please help with this.

Regards

@sgiehl commented on May 4th 2018 Member

I guess that's caused by timezones. Which timezone did you choose for the website in Matomo? Matomo internally uses UTC, but converts the timestamps to your choosen timezone in some cases...

@Vinutab commented on May 4th 2018

Hi,

We are using the Time zone: Europe/Zurich.

Powered by GitHub Issue Mirror