I want to export all last logins from each user this year in csv by using the api. We have an event which is fired when the user logged in successfully.
EventName: User logged in
When I request the following url:
I got all the visits from the user which have the eventName=User logged in in it. More or less that’s what I want. It should be only more filtered so that I only see the above event for each visit. So it should look like this:
idSite | idVisit | serverTimePretty | eventCategory | eventAction | eventName
1 | 12023 | 30.7.2018 10:21:13 | Login | login | User logged in
1 | 512 | 29.7.2018 10:27:13 | Login | login | User logged in
1 | 2522 | 28.7.2018 10:51:13 | Login | login | User logged in
1 | 1252 | 27.7.2018 10:41:13 | Login | login | User logged in
Is that somehow possible with the standard API? I also read about the CustomReports. As I understand correctly it has this functionality just with a nice UI. Can someone confirm this?