I have exported all data from Amplitude using Google Big Query. Now i have connected db to Tableau. The problem is replicate Amplitude behavior using raw data.
Can you please help me to re-create Amplitude funnel logic?
The main intent was to conduct analysis with costs, since such option is absent in Amplitude right now.
Best answer by Saish Redkar
Hey
You can get some SQL queries from the internet which can help you build a basic funnel using the exported data. Pretty sure there will be some Tableau templates for funnel analysis as well.
But from what I know, trying to replicate the Amplitude funnel analysis chart with all their clauses will be a tough task ( if not impossible ), given the way Amplitude crunches data on their backend engine.
If you are storing the costs data in GCS, the easier way will be to ingest that in Amplitude and conduct the analysis in Amplitude if that requirement works out.
Would love to hear from the SQL geeks in the Community if they have attempted such a task.
+10Hey
You can get some SQL queries from the internet which can help you build a basic funnel using the exported data. Pretty sure there will be some Tableau templates for funnel analysis as well.
But from what I know, trying to replicate the Amplitude funnel analysis chart with all their clauses will be a tough task ( if not impossible ), given the way Amplitude crunches data on their backend engine.
If you are storing the costs data in GCS, the easier way will be to ingest that in Amplitude and conduct the analysis in Amplitude if that requirement works out.
Would love to hear from the SQL geeks in the Community if they have attempted such a task.
Hi Seish,
Appreciate your thorough reply to my issue. Can you please specify how i could conduct the analysis in Amplitude after data ingestion? I mean what mechanics to use or any other tips that could help in this task.
Islam
+10Hey Islam,
How does your current funnel analysis setup in Amplitude look like?
Hope this helps further.
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.
