Simple event reporting+exporting by user ID + timestamp

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
. . .	. . .	. . .

Find more posts tagged with

Reporting

Event

User IDs

Accepted answers

Saish Redkar

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

All comments

Saish Redkar

Hi Andy Wassyng

Afaik, this exact reporting format isn’t available via the existing charts in Amplitude except in Data Tables.

Alternatively, you could export your event data using some APIs and structure your data for the columns as needed

Quick Links

Unanswered Questions

Error in Amplitude React Native SDK - "Cannot set property 'cookie' of undefined"
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…