I created an analysis data table and want to export the date regularly (e.g. daily) to, e.g. Google Sheets or alike.
I did only find event data export. How can I automate this kind of export?
Hey kornelius
You can use the Dashboard REST API which now supports Data Tables via existing chart endpoint
https://www.docs.developers.amplitude.com/analytics/apis/dashboard-rest-api/#export-data-tablesLet me know if this helps.
Works great thanks a lot!!
Hi Saish Redkar, how can I use this endpoint? It is not clear to me. Should I use the same endpoint to get results from an existing chart?
Hey Cecilia
The results from an existing chart endpoint will work for a data table too. You will have to use the chart id of your data table in the api call.
Cecilia Definitely check out the article that Saish Redkar linked for you! And it looks like jarren.patao replied via email. Posting his answer here in case it helps other members with the same question:This should be possible to export a Data Table, you can do so with the Results From Existing Chart endpoint and exclude the date parameters. Here is a snippet from our documentation:
You can use the Dashboard REST API to export data from data tables. Just query any Data Table chart type, and don't include start or end dates in the query.
This could look something like
curl --location 'https://amplitude.com/api/3/chart/{CHART_ID}/query' \<br />--header 'Authorization: Basic {REDACTED}'
Otherwise, I hope this helps! Please let me know if you have any questions.
i’ve got data export to bigquery turned on for every 10 minutes, but i notice the upload times are not continuous and so a bunch of data never gets synced
for instance, i’ll see server UTC upload times with gaps between them, like this: how do i fix this?
SERVER TIME UTC
3:00-3:10 pm2:40-2:50 pm2:10-2:20(not looking to use the api, want to keep it synced to bigquery)
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…
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, }, });…
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
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…
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…
