We’re honestly having trouble just doing a simple report+export by event because we want each record by UserID + Timestamp. How can create this analysis to then export it please?
| Event | UserID | DateTime |
|---|---|---|
| Click_Journey_Start | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx | dd/mm/yyyy hh:mm |
| Click_Journey_Start | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx | dd/mm/yyyy hh:mm |
| Click_Journey_Start | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx | dd/mm/yyyy hh:mm |
| Click_Journey_Start | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx | dd/mm/yyyy hh:mm |
| . . . | . . . | . . . |
Best answer by Saish Redkar
Afaik, this exact reporting format isn’t available via the existing charts in Amplitude except in Data Tables.
You can try generating a table like this - https://analytics.amplitude.com/demo/chart/new/vciuvtrw and exporting as a csv. There would be additional columns in here since Data Tables isn’t exactly meant to used as a raw extract, but rather for pivot table like use cases.
For the datetime column, you could either get it via a derived property ( if you are on an enterprise plan with govern add on ) or send a custom timestamp property. This is due to the fact that the exact event time isn’t available for chart query dropdowns readily as a default property as of today.
Alternatively, you could export your event data using some APIs and structure your data for the columns as needed
+10Afaik, this exact reporting format isn’t available via the existing charts in Amplitude except in Data Tables.
You can try generating a table like this - https://analytics.amplitude.com/demo/chart/new/vciuvtrw and exporting as a csv. There would be additional columns in here since Data Tables isn’t exactly meant to used as a raw extract, but rather for pivot table like use cases.
For the datetime column, you could either get it via a derived property ( if you are on an enterprise plan with govern add on ) or send a custom timestamp property. This is due to the fact that the exact event time isn’t available for chart query dropdowns readily as a default property as of today.
Alternatively, you could export your event data using some APIs and structure your data for the columns as needed
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
