Simple event reporting+exporting by user ID + timestamp

Hi @Andy Wassyng 

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

• https://www.docs.developers.amplitude.com/analytics/apis/dashboard-rest-api/#user-activity
• https://www.docs.developers.amplitude.com/analytics/apis/ccpa-dsar-api/?h=
  
  Hope this helps.