Hi, Few questions,
Hey dakkineni ,As far as I understand, you will be able to get hold of your raw event data irrespective of how you send your events to Amplitude. There are several ways of querying your Amplitude event data with SQL :
Can you elaborate more on your 2nd question? Are you trying to join raw event data in an external warehouse or something you want to do inside Amplitude?
Hi Dakkineni,Thanks for contacting Amplitude Support! Denis here and happy to shed some light on the situation!Can I use sql to query data in Amplitude events, the ones that are HTTP kind of events that are streamed using Segment?At the moment, the only way to perform SQL like queries within Amplitude would be via the Query and Snowflake add-on which is available for purchase to our Growth and Enterprise customers! If you would like me to connect you to our sales team, I'd be happy to assist.You can read a bit about this feature here: https://help.amplitude.com/hc/en-us/articles/115001902492Otherwise, if you're able to export your data via the export API and pass it into a system that can manage SQL queries then that would work as well!I have two events with different columns and want to join these two events into a custom event based on key columns, how can I achieve this. If I don’t do a join the event data is displayed with blanks on each side where the column doesn’t exist in the breakdown tableWould you be so kind as to elaborate on what you mean here? Have you got a few user examples to show me what you mean or a simple mock up in text? I am just not entirely sure of what you mean by joining. We do have custom events where two or more events are put under one event and where you can specify properties for them. Is this what you were looking for? if not, could you please elaborate on what you are trying to achieve? Thank you!
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…
Good day! I am new to Amplitude and still learning. Our organization’s current objective is to track specific webpages that have high exits/drop-offs so we think that the Funnel Chart is the best tool to use for it. However, you see our website uses 2 different domains in completing the buying journey of visitors (from…
